codeice / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel
0 stars 0 forks source link

Reading more then 255 collums fails #100

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
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