My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 23: Excel Export Results Unreadable
1 person starred this issue and may be notified of changes. Back to list
Status:  Invalid
Owner:  ----
Closed:  Sep 2007


 
Reported by jackcoll...@wallquest.com, Sep 2, 2007
What is the expected output? What do you see instead?
Excel spreadsheet is mostly gibberish...for example first cell shows:
��ࡱ�;��


What version of the product are you using? On what operating system?
2.1, 2.2rc1

Please provide any additional information below.
Using spring AbstractCommandController (similar to examples). Export code
is very simple: 
Limit limit = tableFacade.getLimit();
		if (limit.isExportable()) {
			tableFacade.render();
			return null;
		}

Sep 3, 2007
#1 extremec...@gmail.com
What servlet container are you using? Also what is the Locale?
Status: Accepted
Sep 4, 2007
#2 jackcoll...@wallquest.com
tomcat 5.5, I am using the install default which I assume locale is en_US. how can i
verify?
Sep 4, 2007
#3 extremec...@gmail.com
I am wondering if it is having a hard time reading out to the response. We should
first check to see if the excel document is being created correctly. Could you try
the following code versus the tableFacade.render(). What this is doing is writing the
excel file out to a local file instead of the response stream. The FileUtils comes
from the jakarta commons io package so if you do not use that just output the file
however you are used to.

            View view = tableFacade.getView();
            HSSFWorkbook workbook = (HSSFWorkbook)view.render();
            FileUtils.writeByteArrayToFile(new
File("/home/jeff/workspace/output.xls"), workbook.getBytes());

Sep 15, 2007
#4 extremec...@gmail.com
I am going to close this issue for now. If it happens again let me know and I will
add this back to the issue report.
Status: Invalid

Powered by Google Project Hosting