Hi all,
I try to load .xls (Excel 2003) file into Infragistics ( version Infragistics.Excel.v8.3) in NETAdvantage of ASP.net. It works for most of the .xls file but when if the Excelsheet have Filter columns then it throws an exception that 'The maximum number of columns in an excel worksheet with the current format is: 256 '
can anybody please help me why some excel files are not loaded by infragistics? I am using V8.3 for Web.
Thank you,
Priya
Hi Priya,
The MaxColumnCount in Excel2003 is 256 so you cannot have more columns than that in Excel2003. I would advise you to use Excel2007 which supports more than 256 columns. This is an error due MS Excel limitations and not Infragistics.Excel.
Thanks.
Hi dinesh,
Thank you for reply.
I use the version which doesnt support Excel2007.but I am having the file in Excel 2003 format with 256 columns.But when i remove the filters from the columns it work fine with 256 column excel sheet.when i add filter to all the columns it gives error.I temporary found solution by removing filter from excel and then upload excel 2003 file. Do you know how we can work with 2007 format with Ipackage Factory class in CLR 2.0 with any third party dll.? or how can we load excel 2007 file with infragistics 8.3 and .NET framework 2.0?
priya
You should be able to get 3rd party packing assemblies to package the Excel 2007 files and use it for CLR2.0 or my advice is to upgrade to CLR3.5 which makes the whole process easier as CLR3.5 has assemblies that will do this for you. Please refer to the following post for more details on it. Although it is using Windows Forms, you should be able to implement the same for ASP.NET.
http://forums.infragistics.com/forums/p/22453/82301.aspx#82301