EasyXLS
http://forum.easyxls.com/

Spreadsheets over 1Mb
http://forum.easyxls.com/viewtopic.php?f=4&t=132
Page 1 of 1

Author:  mark johnson [ Fri Dec 21, 2007 4:23 am ]
Post subject:  Spreadsheets over 1Mb

Hi, I tried the demo version of EasyXLS and since it looked like it did what we wanted purchased a Developer version (v6.0) in order to create a few spreadsheets to show my managers to prove that purchasing the server version would be beneficial to our business.

After a few problems getting dates working in UK format (many dates were returned as 1900) I've now got it working as we need.

My question is that the main report I'm trying to demonstrate has quite alot of data. It appears that when the spreadsheet size gets to around 1Mb the file gets written as 0 bytes. If I do a slightly smaller recordset selection then it works fine (around 900k).

Please can you advise.

Many thanks.

Author:  oana [ Fri Dec 21, 2007 12:01 pm ]
Post subject: 

Java is slow so you might need to increase the java used memory using ?mx option when running your application.

Author:  mark johnson [ Fri Dec 21, 2007 12:17 pm ]
Post subject: 

Sorry, should have been more specific. The code is in VBScript (ASP) and loads a template file eg:

set xls=Server.CreateObject("EasyXLS.ExcelDocument")
if xls.easy_LoadTemplateFile(Server.MapPath("template.xls")) then
set worksheet= xls.easy_getSheet("Sheet1").easy_getExcelTable()
...... etc

When a larger number of recordsets is returned, the file writes as 0 bytes.

Thanks.

Author:  oana [ Thu Dec 27, 2007 10:58 am ]
Post subject: 

Please send me the documents you are trying to load and generate to support@EasyXLS.com and any other details that might help in solving your issue.

Author:  teniel [ Tue Sep 02, 2008 9:21 am ]
Post subject:  Did you resolve this issue?

Did you have any success resolving this issue?
I seem to have something similar.
If you did, can you describe what you did?

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/