Zoumaho / excellibrary

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

Error when opening created (or updated) excel file. #145

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

  string file = "D:\\Test\\newdoc.xls";
  Workbook workbook = new Workbook();
  Worksheet worksheet = new Worksheet("First Sheet");
  worksheet.Cells[1, 1] = new Cell("Text string");
  workbook.Worksheets.Add(worksheet);
  workbook.Save(file);

What is the expected output? What do you see instead?

Excel complains there is unreadable content an gives an option to recover. 
However, once recovered, the content is there. 

Excel's error: 
  <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 
- <recoveryLog 
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <logFileName>error044240_01.xml</logFileName> 
  <summary>Errors were detected in file 'D:\Test\newdoc.xls'</summary> 
- <additionalInfo>
  <info>Excel recovered your formulas and cell values, but some data may have been lost.</info> 
  </additionalInfo>
  </recoveryLog>

What version of the product are you using? On what operating system?

Windows 7 32bit, Excel 2007

Original issue reported on code.google.com by cic.le...@gmail.com on 2 Apr 2013 at 3:22

Attachments:

GoogleCodeExporter commented 9 years ago
Sorry forgot ot mention, I'm using ExcelLibrary_20110730

Original comment by cic.le...@gmail.com on 2 Apr 2013 at 3:26

GoogleCodeExporter commented 9 years ago
got the same issue :(

Original comment by michaelt...@gmail.com on 7 May 2013 at 1:13

GoogleCodeExporter commented 9 years ago
I have also same issue, just like the gentlemen 

Original comment by abdai...@gmail.com on 14 May 2013 at 10:38

GoogleCodeExporter commented 9 years ago
I have also same issue,
win7,office2010,VS2012

Original comment by yangi...@gmail.com on 1 Aug 2013 at 6:40

GoogleCodeExporter commented 9 years ago
As suggested by aleroot here:

http://stackoverflow.com/questions/8107610/cant-open-excel-file-generated-with-e
xcellibrary

Adding 100 cells helps to open the file in Excel 2010

Original comment by zho...@gmail.com on 2 Dec 2013 at 8:40