The column names of the DataTable are A, B, C... AA, AB... and so on. It's similar to Excel column names
The names of the DataTable in the dataset are exactly the sheet names

Code

ParserContext c=new ParserContext(@"c:\employee.xls");
var parser=ParserFactory.CreateSpreadsheet(c);
var spreadsheet= parser.Parse();
DataSet ds = spreadsheet.ToDataSet();



Options
GenerateColumnHeader - generate a new row in DataTable as column header
ExtractSheetHeader - extract first row of the excel as header
ExtractSheetFooter - extract footer of the sheet
FillBlankCells - fill in blank cells, don't ignore them in DataTable
IncludeComments - include cell comments during extraction

Last edited Apr 19, 2014 at 11:53 PM by tonyqus, version 3