Could you have any suggestions for me about this problem.
I try to write sourcecode and use for loop but it's very slow performance than method ExportDataTable.
This is my code
- Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"D:\MasterData.xlsx");
Worksheet ws = workbook.Worksheets["Product"];
DataTable table = new DataTable();
object[] param = new object[4];
for (int i = 3; i <= ws.Rows.Count(); i++)
{
CellRange cellrange = ws.Rows[i];
for (int j = 1; j <= 4; j++)
{
param[j] = cellrange[i, j].DisplayedText;
}
table.Rows.Add(param);
}
Thank you.