Exceldatareader is not supporting .XLSB file

Error message "Invalid Signature " throwing up when tried to read .xlsb file. Could you please help me out to for any approach which can be used to read data from .xlsb file using exceldatareader.

Id #14123 | Release: None | Updated: Jul 28 at 5:10 PM by PrashanthJain | Created: Jul 28 at 5:08 PM by PrashanthJain

Error for Excel Data Reader

I am doing a project in C# and I have downloaded excel data reader from codeplex and added it to my project reference. There is no error in namespace 'using excel;' but 'm getting error where I ha...

Id #14122 | Release: None | Updated: Jul 28 at 7:08 AM by Rituja | Created: Jul 28 at 6:59 AM by Rituja

FillWeight values cannot exceed 65535

Hi, I have read excel xlsx file. one of the dataset shows FillWeight values cannot exceed 65535. System.InvalidOperationException: Sum of the columns' FillWeight values cannot exceed 65535. a...

Id #14095 | Release: None | Updated: Apr 26 at 6:50 AM by kumarmageshr | Created: Apr 26 at 6:50 AM by kumarmageshr

e+15 in my values

My value in my row cell 7885266361743930 but it comes to my gridview like this => 7,88526636174393E+15

Id #14084 | Release: None | Updated: Apr 6 at 7:03 AM by alicankablan | Created: Apr 6 at 7:03 AM by alicankablan

issue with some hidden chars

hi, i found some problems reading excel with some hidden chars. i can t understand which are. attached the excel i used. the problem is about Label SST, that after this wrong encoding, the dll can ...

Id #14042 | Release: None | Updated: Jan 13 at 2:36 PM by manu0087 | Created: Jan 13 at 2:36 PM by manu0087

issue with some hidden chars

hi, i found some problem reading excel with some hidden chars. i can t understand which are. attached the excel example. the problem is about Label SST, that after this wrong encoding, the dll can ...

Id #14041 | Release: None | Updated: Jan 13 at 2:36 PM by manu0087 | Created: Jan 13 at 2:36 PM by manu0087

How to Add New Header Names?

I am using below code to get all excelsheel sheet data. IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream); excelReader.IsFirstRowAsColumnNames = true; ...

Id #14026 | Release: None | Updated: Jan 2 at 7:20 AM by shashi07 | Created: Jan 2 at 7:19 AM by shashi07

Import with formula issue.

Hi Support, The spreadsheet cell has a formula to extract a piece of a string and the resulting string is a FormulaField name. I have to retrieve the actual string that is the result in Excel. (...

Id #13989 | Release: None | Updated: Sep 28, 2016 at 10:28 AM by shuklauk111 | Created: Sep 28, 2016 at 10:28 AM by shuklauk111

Converting a text field to datetime incorrectly

The spreadsheet has a TEXT value of "11:54:00" in a cell. When populating a DataSet and reading the value from the Datatable it is returned as "31/12/1899 11:54:00"

Id #13921 | Release: None | Updated: Aug 4 at 5:46 AM by charland | Created: Jun 14, 2016 at 1:00 PM by trevorjdaniel

SeekErrormmemoryStream.cs

i download the last version of the sources and i coulnt compile because of lack of SeekErrorMemoryStream.cs. coul someone give me this file please ? thank you

Id #13835 | Release: None | Updated: Feb 10, 2016 at 7:59 AM by wasquel | Created: Feb 10, 2016 at 7:59 AM by wasquel