search

lamquanthanh999 / excellibrary

Automatically exported from code.google.com/p/excellibrary
1 stars 0 forks source link

Can't open generated excel file with Office Excel 2010 #78

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
I've generated a sample excel file with excellibrary on my Windows 7 machine, 
and when i try to open the generated with Excel 2010 i get an error that says : 
"Can't open file invalid file format"

Original issue reported on code.google.com by Alessio....@gmail.com on 23 Dec 2010 at 10:30

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
because currently the support is for xls files prior to excel 2007 xlsx format.
we plan to support them in the future

Original comment by regisbsb...@gmail.com on 27 Jun 2011 at 11:10

GoogleCodeExporter commented 9 years ago 
ok,
but Excel 2010 correctly open up every legacy file format like xls, while it 
doesn't open only the xls file generated with excellibrary ...

I think that there's something wrong in the generated xls file by excel library.

Original comment by Alessio....@gmail.com on 27 Jun 2011 at 1:29

GoogleCodeExporter commented 9 years ago 
This should not have been closed...I have the same issue - I can open every 
other old .XLS file except the ones generated by the dll.

2010 can open 97-2003 version .XLS files, so why do the ones generated by the 
dll fail to open?

To reiterate - this is not an XLSX problem....

Steve

Original comment by stevenma...@gmail.com on 7 Sep 2011 at 10:52

GoogleCodeExporter commented 9 years ago 
I have the same issue, I can´t open files created by this dll.

Original comment by luispeix...@gmail.com on 8 Sep 2011 at 4:40

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Me neither! Why hasn't this issue been resolved yet?

Original comment by somru...@gmail.com on 21 Oct 2011 at 2:31

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
I'm having the same problem

Original comment by mmuti...@gmail.com on 12 Nov 2011 at 8:59

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
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.  

VB.Net

Dim filename As String = "c:\MyNewFile.xls"
Dim workbook = New Workbook()
Dim FakeWS = New Worksheet("FakeWorkSheet")

workbook.worksheets.Add(FakeWS)

For i As Integer = 0 To 100
    FakeWS.Cells(i, 0) = New Cell("")
Next

workbook.save(filename)

Cheers^^

Original comment by zet...@gmail.com on 14 Nov 2011 at 8:17