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: Wed at 6:50 AM by kumarmageshr | Created: Wed 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: Jun 14, 2016 at 1:00 PM by trevorjdaniel | 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

Reading 2 excel files simultaneously gives an exception

I am reading two excel files simultaneously. Here is my Code Parallel.Invoke( ()=> { FileStream stream = File.Open(@"C:\Projects\TPD.xlsx", File...

Id #13775 | Release: None | Updated: Nov 18, 2015 at 5:25 AM by MustafaMuhammad | Created: Nov 18, 2015 at 5:24 AM by MustafaMuhammad

Can i read xls file from given url?.. Help me

i can read the xls and xlsx file by using fileupload control in my aspx page. but i can't read the file from the server(given xls file url). please help me

Id #13767 | Release: None | Updated: Nov 13, 2015 at 10:45 AM by ssriram30 | Created: Nov 13, 2015 at 10:45 AM by ssriram30