Wed Nov 24, 2010 11:14 am
fugees wrote:use this code read xls file to datatable has errors
- Code: Select all
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
string ext = Path.GetExtension(FileName);
if (ext == ".xls")
{
workbook.LoadFromFile(FileName, ExcelVersion.Version97to2003);
}
else if (ext == ".xlsx")
{
workbook.LoadFromFile(FileName, ExcelVersion.Version2007);
}
Spire.Xls.Worksheet sheet = workbook.Worksheets[0];
DataTable excelData = sheet.ExportDataTable();
Sorry for that, it is a bug and we have fixed it.
We need more time to test it and will release it before the next Monday.
Harry
Technical Support / Developer,
e-iceblue Support Team