when reading an excel file with more than 255 cols only the first 255 get read.
this is a limitation of the select statement used to read the data from the
file.
i tried to use the WorksheetRange selector, but this gives me some strange
error.
the code is used:
var excel = new ExcelQueryFactory(excelFilePath);
var result = from c in excel.WorksheetRange("A1", "KG1000",0)
select c;
foreach (Row row in result)
{
}
this gives me the following exception:
'xxx' is not a valid worksheet name. Valid worksheet names are: 'xxx',
'xxxPrint_Titles'
Original issue reported on code.google.com by gelo...@gmail.com on 29 Nov 2013 at 3:28
Original issue reported on code.google.com by
gelo...@gmail.com
on 29 Nov 2013 at 3:28