Can't open excel file generated with excelLibr

问题:

I'm using excelLibrary to programatically create excel files but I get a file format error when I try to open the generated files in Microsoft Office Excel.

I've seen this has been reported but there's still no answer about it.

I use Office 2010 and I'm able to open any other .xls (97-2003 file format) but the ones generated with excelLibrary. I've also tried Open Office and still can't open the generated file. I haven't tried to open them in Office 97-2003.

Just try the sample code to reproduce the error.

Have anybody found how to use the library and not run into this problem?

回答1:

Found a solution :

string filename = "c:\Test.xls";
Workbook workbook = new Workbook();
Worksheet sheet = new Worksheet("Test")
workbook.Worksheets.Add(sheet)

for(int i = 0;i < 100; i++)
      sheet.Cells[i,0] = new Cell("");

workbook.save(filename);

The problem is that Office 2010 doesn't support it unless there are 100 or more Cells Filled.

My work around was to have it fill 100 cells in a for loop with "". That way it gets it's 100 cell count in and then it works just fine.

Reference : here

回答2:

Unfortunately excel file exported with excelLibrary are not compatible with office 2010 Excel, this is an already reported issue but seems that the library development is no longer active .

I've switched to NPOI .

回答3:

Since the sheet name is not given properly, it was throwing that error.

Once we give the sheet a name, it will work properly.