Geek Answers Handbook

ColdFusion memory issue

I use ColdFusion to export a fairly small number of rows (about 1000), but a large number of columns (about 300) in Excel. This is a multi-page Excel file with at least two sheets with a large number of columns. Using cfspreadsheet causes a Java heap error. Updating the value of JVM parameters does not improve. What is the best way to export to Excel without throwing a Java heap error?

Edit: I tried several ways to fix the problem inside the program. I use the xml Workbook in cfsavecontent to create multiple sheets and render the result using cfcontent. In this case, cfcontent can use a large amount of memory, which leads to an error in the heap area.

 <cfsavecontent variables="REQUEST.xmlData"> <cfoutput> <xml version="1.0"?> <?mso-application progid="Excel.sheet"?> <Workbook> ...other contents </Workbook> </cfoutput> </cfsavecontent>

In the second workaround, I use querynew to create content and upload the final result to excel using <Cfspreadsheet action="write"> . For subsequent sheets, I use <cfspreadsheet action="update"> . The ultimate goal is to use excel using <cflocation url="excelPath"> , but in this case, updating cfspreadsheet permanently eliminates a memory error.

If updating jvm is not an option, what other methods do you propose to implement to fix memory problems.

+7
coldfusion excel coldfusion-9
source share

No one has answered this question yet.

See similar questions:

2
creating multiple sheets using Coldfusion SpreadsheetWrite and cfscript

or similar:

5
Import an Excel spreadsheet into an SQL database (Coldfusion 9)
4
Using JVM and memory - does the JRun server not use the full PSPermGen distribution?
3
Unable to create proper Excel spreadsheet with ColdFusion
3
CFSpreadSheet functions using memory for large data sets
2
Formatting a Spreadsheet Cell
2
How to get a list of named ranges, sheet name and link forms using XSSF and SAX (Event API) for a large excel file
one
Problem reading a table from ColdFusion
one
ColdFusion flash memory while reading csv file to import database
one
Export data from an Excel worksheet to an XML file
one
Simple Coldfusion Spreadsheet Cells

More articles:


All Articles