Reply to topic  [ 5 posts ] 
Spreadsheets over 1Mb 
Author Message

Joined: Fri Dec 21, 2007 4:15 am
Posts: 2
Reply with quote
Post 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.


Fri Dec 21, 2007 4:23 am
Profile

Joined: Wed Nov 07, 2007 4:42 am
Posts: 59
Reply with quote
Post 
Java is slow so you might need to increase the java used memory using ?mx option when running your application.


Fri Dec 21, 2007 12:01 pm
Profile WWW

Joined: Fri Dec 21, 2007 4:15 am
Posts: 2
Reply with quote
Post 
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.


Fri Dec 21, 2007 12:17 pm
Profile

Joined: Wed Nov 07, 2007 4:42 am
Posts: 59
Reply with quote
Post 
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.


Thu Dec 27, 2007 10:58 am
Profile WWW

Joined: Wed May 09, 2007 8:36 am
Posts: 14
Location: Israel
Reply with quote
Post 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?


Tue Sep 02, 2008 9:21 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 5 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.