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.

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

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.

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.

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