protected override void Execute(CodeActivityContext context)
{
var excelpath = ExcelPath.Get(context);
var pageindex = SheetIndex.Get(context);
var txtpath = TxtPath.Get(context);
var splitchar = SplitChar.Get(context);
var addheaders = AddHeaders.GetType();
Workbook wb = new Workbook();
wb.LoadFromFile(@excelpath);
Worksheet ws = wb.Worksheets[pageindex];
DataTable dt = ws.ExportDataTable();
//TXT VARSA İÇİNİ TEMİZLE
if (File.Exists(txtpath))
{
File.WriteAllText(txtpath, "");
}
//BAŞLIK
if (AddHeaders)
{
string[] columnNames = dt.Columns.Cast <DataColumn>().Select(x => x.ColumnName).ToArray();
File.AppendAllText(@txtpath, string.Join(splitchar, columnNames) + Environment.NewLine);
}
//SATIRLAR
foreach (DataRow dtR in dt.Rows)
{
File.AppendAllText(@txtpath, string.Join(splitchar, dtR.ItemArray) + Environment.NewLine);
}
}
public AddCorrelationHeaderTests()
{
middleware = new AddHeaders(next: (innerHttpContext) => Task.FromResult(0));
}
