Here is the complete code:
<html>
<head><title>Hello World!</title></head>
<body>
<b>This example shows how to create a simple MS Excel Workbook using Aspose.Cells</b>
<cfobject action="create" type="java" class="java.io.FileInputStream" name="LicFile">
<cfset LicfileI = LicFile.init(JavaCast("string","D:\Inetpub\wwwroot\Intranet\Aspose.Cells.lic"))>
<cfobject action="create" type="java" class="com.aspose.cells.License" name="license">
<cfset license.setLicense(LicfileI)>
<cfset workbook=CreateObject("java", "com.aspose.cells.Workbook").init()>
<cfset worksheets = workbook.getWorksheets()>
<cfset sheet= worksheets.getSheet("Sheet1")>
<cfset cells= sheet.getCells()>
<cfset cell= cells.getCell(0,0)>
<cfset cell.setValue("Hello World!")>
<cfset workbook.save("D:\Inetpub\wwwroot\Intranet\testtwg\sales_reports\engr\temp\out2.xls")>
<a href="temp/out2.xls">Download</a>
<!--- Tell the browser to expect an Excel file attachment.
<cfheader
name="content-disposition"
value="attachment; filename=out.xls"
/>
<!---
Tell browser the length of the byte array output stream.
This will help the browser provide download duration to
the user.
--->
<cfheader
name="content-length"
value="#REQUEST.ExcelData.Size()#"
/>
<!--- Stream the binary data to the user. --->
<cfcontent
type="application/excel"
variable="#REQUEST.ExcelData.ToByteArray()#"
/>
--->
</body>
</html>
The OS is Windows Server 2003,
ColdFusion version 8.0
- ColdFusion is installed on the C drive, however, it loads InetPub on the D. Cells is working without the license (just getting the register notification).
Aspose.Cells (I believe I have installed JDK 1.4). Let me know if I need to install JDK 5.0 instead.
