Using Aspose.Cells for Java with ColdFusion

Aspose.Cells: The Real Product

With Aspose.Cells developers can export data, format spreadsheets in every detail and at every level, import images, import charts, create charts, manipulate charts, stream Microsoft Excel data, save in various formats including XLS, CSV, SpreadsheetML, TabDelimited, TXT, XML (Aspose.Pdf integrated) and many more.

To find out more about the product information, features and for a programmer’s guide, refer to the Aspose.Cells documentation and online featured demos. You can download and evaluate it for free.

Prerequisites

To use Aspose.Cells for Java in ColdFusion applications, copy the Aspose.Cells.jar file to the {InstallationFolder\}\wwwroot\WEB-INF\lib folder.

Do not forget to restart the ColdFusion application server after putting new JARs in the lib folder.

Using Aspose.Cells for Java & ColdFusion to Create an Excel file

Below, we create a simple application that generates an empty Microsoft Excel file, inserts some content and saves it as an XLS file.

Following is the actual code (ColdFusion & Aspose.Cells for Java). After executing the code, an Excel file, output.xls, is generated.

Generated output.xls

todo:image_alt_text

Java

 <html>

<head><title>Hello World!</title></head>

<body>

    <b>This example shows how to create a simple MS Excel Workbook using Aspose.Cells</b>

    <cfset workbook=CreateObject("java", "com.aspose.cells.Workbook").init()>

    <cfset worksheets = workbook.getWorksheets()>

    <cfset sheet= worksheets.get("Sheet1")>

    <cfset cells= sheet.getCells()>

    <cfset cell= cells.getCell(0,0)>

    <cfset cell.setValue("Hello World!")>

    <cfset workbook.save("C:\output.xls")>

</body>

</html>

Summary