This project has moved and is read-only. For the latest updates, please go here.

Problems reading excel files until Excel opens and saves those source files

Feb 10, 2015 at 11:20 PM
Hello,

I'm using EPP 4.0.2. I have an excel spreadsheet that was generated using another piece of code that is using spreadsheet gear 7.1.2.102. My process is to create the empty file using SSG - return out a byte array of the xlsx file then open that byte array with EPP. There is no disk involved.

For some reason these files all return null for the cell values when accessing the data from EPP. If one of these excel files is saved to disk, opened in Excel and saved then processed throughthis code, EPP has no problem reading the data.

Any suggestions would be greatly appreciated.

thanks
darrin
Feb 11, 2015 at 4:37 AM
Hi, Does your file have formulas ? if so then formulas cells will not have values. until they are calculated. Once you open file with excel ,it calculates all the values and save formulas as well as formulas.
Feb 11, 2015 at 4:26 PM
Aha. It does indeed and these are the fields that are coming in null. I'll investigate the calculate call.
thanks!
darrin