AutoSize columns in excel sheet

Feb 7, 2014 at 12:33 PM

I am using ExcelDataReader nuget. It works pretty fine. But causes a problem if i have the first column displaying data such as '####'. This is because the column size is shrink-ed. If i resize it or double click the row reader and save that excel file, it reads the data properly.

Please help me out as I don't want to use any Interop libraries.

Appreciating your time and response.
Feb 7, 2014 at 4:40 PM
That sounds a bit strange because as far as I know displaying ### is just a ui thing and is not actually reflected in the data value. I tried it myself with a spreadsheet and it worked ok.

Are you able to provide an example file?

Feb 11, 2014 at 12:33 PM

I was mistaken. It does reads the data when present in ### format.
I am attaching an Excel sheet. Without editing or saving , try reading the file. ExcelDataReader will return no data.
Now just open the file and save it..ExcelDataReader works absolutely fine without any issues.
I know this seems to be a lot more weird but i am unable to find the reason for this issue.

Thank you for your time.

P.S How do I upload an excel file for this tread on Codeplex?