NPOI generated Excel file with multiple columns -- showing only 1

Feb 2, 2015 at 5:30 PM

We are currently using NPOI to generate/update Excel files. However, we have come across an issue where the NPOI generated excel file cannot be read by other Excel readers correctly.

Summary of issue/steps
  1. Generate an Excel file with the first row populated with data (first 10 cells)
  2. Next, open up the file using ExcelDataReader to read contents of first row
    (At this point ExcelDataReader is detecting only 1 column and is only able to read the first cell)
If we manually open the generated Excel file with Office Excel, the contents looks good. When we close the file, the "Save dialog" pops up and requires us to "save" even no updates were made. If you save it and open it with ExcelDataReader ... all the columns are now visible/readable.

Can show code if needed.
Mar 1, 2015 at 8:52 AM
What's ExcelDataReader?