Can't open excel file generated with excelLibrary
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?
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
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 .
Since the sheet name is not given properly, it was throwing that error.
Once we give the sheet a name, it will work properly.
链接地址: http://www.djcxy.com/p/61236.html