Export to GitHub

excellibrary - issue #96

Error to export file in excel


Posted on Jun 17, 2011 by Quick Bear

What steps will reproduce the problem? 1.When trying to export excel file to a folder

What is the expected output? What do you see instead? Expected : When I will open the excel file I wont get any error. Actual : My page using paging. If I export the whole table, I am not getting any error to open the file.But if I export 10 records out of 20, I am getting error while opening the excel file. The error is :

"Excel found unreadable content in ‘filename.xls’; do you want to recover the contents of the workbook? If you trust the source of this workbook, click yes"

What version of the product are you using? On what operating system? I have downloaded ExcelLibrary_20110414.zip file

Please provide any additional information below.

The page that we are using to export as an excel file is having a facility where you can choose to see 10 or 25 or 50 or 100 records at a time.....I mean if you choose 10...and if you have 20 records it will show next/previous button to see the rest of the records but if you choose 25...it will display all records in one page....I think it’s a pretty simple paging concept, now when I am displaying all records and exporting it to a folder, I am not getting any error, I am only getting error when I am displaying 10 records out of 20 on a page and trying to export the file

Comment #1

Posted on Jun 27, 2011 by Massive Dog

If you can show some code because it seems like it is not a bug with excellibrary.

Comment #2

Posted on Jun 27, 2011 by Massive Dog

Please provide us more details or post some sample code that causes issue.

Comment #3

Posted on Jul 4, 2011 by Grumpy Cat

I have the same problem, even whan using the demo code at the site home page (http://code.google.com/p/excellibrary/)

Comment #4

Posted on Sep 20, 2012 by Swift Kangaroo

I have exactly the same problem and I'm only using the following very small sample of the demo code,

ExcelLibrary.SpreadSheet.Workbook workbook = new ExcelLibrary.SpreadSheet.Workbook(); ExcelLibrary.SpreadSheet.Worksheet worksheet = new ExcelLibrary.SpreadSheet.Worksheet("Log"); worksheet.Cells[0, 1] = new ExcelLibrary.SpreadSheet.Cell("Test"); workbook.Worksheets.Add(worksheet); workbook.Save(logFile); Console.WriteLine("Saved");

I'm running Windows 7 (64-bit) and Office 2010

Comment #5

Posted on Dec 19, 2012 by Happy Rhino

same problem at win7 and MSOffice 2010. But file opens OK with OpenOffice.

Status: New

Labels:
Type-Defect Priority-Medium