Skip to content

Instantly share code, notes, and snippets.

@rip747
Created April 23, 2010 17:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rip747/376892 to your computer and use it in GitHub Desktop.
Save rip747/376892 to your computer and use it in GitHub Desktop.
using java to create an excel spreadsheet
<cfscript>
workBook = createObject("java", "org.apache.poi.hssf.usermodel.HSSFWorkbook").init();
newSheet = workBook.createSheet();
workBook.setSheetName(0, "1");
count = 0;
</cfscript>
<cfloop array="#headers#" index="i">
<cfscript>
row = newSheet.createRow(0);
cell = row.createCell(count);
cell.setCellValue(i);
count = count + 1;
</cfscript>
</cfloop>
<cfloop from="1" to="#arrayLen(data)#" index="i">
<cfscript>
row = newSheet.createRow(i);
count = 0;
</cfscript>
<cfloop array="#data[i]#" index="d">
<cfscript>
cell = row.createCell(count);
cell.setCellValue(d);
count = count + 1;
</cfscript>
</cfloop>
</cfloop>
<cfscript>
fileOutStream = createObject("java", "java.io.FileOutputStream").init(spreadsheetfilename);
workBook.write(fileOutStream);
fileOutStream.close();
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment