// Create an instance of the class that exports Excel files, having a sheet ExcelDocument workbook = new ExcelDocument(1); // Set the sheet name workbook.easy_getSheetAt(0).setSheetName("First tab"); // Get the table of data for the worksheet ExcelTable xlsFirstTable = ((ExcelWorksheet)workbook.easy_getSheetAt(0)).easy_getExcelTable(); // Add data in cells for report header for (int column=0; column<5; column++) { xlsFirstTable.easy_getCell(0,column).setValue("Column " + (column + 1)); xlsFirstTable.easy_getCell(0,column).setDataType(DataType.STRING); } // Add data in cells for report values for (int row=0; row<100; row++) { for (int column=0; column<5; column++) { xlsFirstTable.easy_getCell(row+1,column).setValue( "Data " + (row + 1) + ", " + (column + 1)); xlsFirstTable.easy_getCell(row+1,column).setDataType(DataType.STRING); } } // Apply a predefined format to the report values xlsFirstTable.easy_setRangeAutoFormat("A1:E101", new ExcelAutoFormat(Styles.AUTOFORMAT_EASYXLS1)); // Export HTML file workbook.easy_WriteHTMLFile("C:\\Samples\\Export to HTML.html", "First tab");

Click here to see Continuous Code Listing

' Create an instance of the class that exports Excel files, having a sheet Dim workbook As New ExcelDocument(2) ' Set the sheet name workbook.easy_getSheetAt(0).setSheetName("First tab") ' Get the table of data for the worksheet Dim xlsFirstTab As ExcelWorksheet = workbook.easy_getSheetAt(0) Dim xlsFirstTable = xlsFirstTab.easy_getExcelTable() ' Add data in cells for report header For column As Integer = 0 To 4 xlsFirstTable.easy_getCell(0, column).setValue("Column " & (column + 1)) xlsFirstTable.easy_getCell(0, column).setDataType(DataType.STRING) Next xlsFirstTable.easy_getRowAt(0).setHeight(30) ' Add data in cells for report values For row As Integer = 0 To 99 For column As Integer = 0 To 4 xlsFirstTable.easy_getCell(row + 1, column).setValue( _ "Data " & (row + 1) & ", " & (column + 1)) xlsFirstTable.easy_getCell(row + 1, column).setDataType(DataType.STRING) Next Next ' Apply a predefined format to the report values xlsFirstTable.easy_setRangeAutoFormat("A1:E101", _ New ExcelAutoFormat(Styles.AUTOFORMAT_EASYXLS1)) ' Export HTML file workbook.easy_WriteHTMLFile("C:\Samples\Export to HTML.html", "First tab")

Click here to see Continuous Code Listing

// Create an instance of the class that exports Excel files, having a sheet ExcelDocument *workbook = new ExcelDocument(2); // Set the sheet name workbook->easy_getSheetAt(0)->setSheetName("First tab"); // Get the table of data for the worksheet ExcelWorksheet *xlsFirstTab = __try_cast<ExcelWorksheet*>(workbook->easy_getSheetAt(0)); ExcelTable *xlsFirstTable = xlsFirstTab->easy_getExcelTable(); // Add data in cells for report header for (int column=0; column<5; column++) { xlsFirstTable->easy_getCell(0,column)->setValue( String::Concat("Column ",(column + 1).ToString())); xlsFirstTable->easy_getCell(0,column)->setDataType(DataType::STRING); } // Add data in cells for report values for (int row=0; row<100; row++) { for (int column=0; column<5; column++) { xlsFirstTable->easy_getCell(row+1,column)->setValue(String::Concat( "Data ", (row + 1).ToString(), ", ", (column + 1).ToString())); xlsFirstTable->easy_getCell(row+1,column)->setDataType(DataType::STRING); } } // Apply a predefined format to the report values xlsFirstTable->easy_setRangeAutoFormat("A1:E101", new ExcelAutoFormat(Styles::AUTOFORMAT_EASYXLS1)); // Export HTML file workbook->easy_WriteHTMLFile("C:\\Samples\\Export to HTML.html", "First tab");

Click here to see Continuous Code Listing

// Create an instance of the class that exports Excel files, having a sheet ExcelDocument workbook = new ExcelDocument(1); // Set the sheet name workbook.easy_getSheetAt(0).setSheetName("First tab"); // Get the table of data for the worksheet ExcelTable xlsFirstTable = ((ExcelWorksheet)workbook.easy_getSheetAt(0)).easy_getExcelTable(); // Add data in cells for report header for (int column=0; column<5; column++) { xlsFirstTable.easy_getCell(0,column).setValue("Column " + (column + 1)); xlsFirstTable.easy_getCell(0,column).setDataType(DataType.STRING); } // Add data in cells for report values for (int row=0; row<100; row++) { for (int column=0; column<5; column++) { xlsFirstTable.easy_getCell(row+1,column).setValue( "Data " + (row + 1) + ", " + (column + 1)); xlsFirstTable.easy_getCell(row+1,column).setDataType(DataType.STRING); } } // Apply a predefined format to the report values xlsFirstTable.easy_setRangeAutoFormat("A1:E101", new ExcelAutoFormat(Styles.AUTOFORMAT_EASYXLS1)); // Export HTML file workbook.easy_WriteHTMLFile("C:\\Samples\\Export to HTML.html", "First tab");

Click here to see Continuous Code Listing

// Create an instance of the class that exports Excel files, having a sheet ExcelDocument workbook = new ExcelDocument(1); // Set the sheet name workbook.easy_getSheetAt(0).setSheetName("First tab"); // Get the table of data for the worksheet ExcelTable xlsFirstTable = ((ExcelWorksheet)workbook.easy_getSheetAt(0)).easy_getExcelTable(); // Add data in cells for report header for (int column=0; column<5; column++) { xlsFirstTable.easy_getCell(0,column).setValue("Column " + (column + 1)); xlsFirstTable.easy_getCell(0,column).setDataType(DataType.STRING); } // Add data in cells for report values for (int row=0; row<100; row++) { for (int column=0; column<5; column++) { xlsFirstTable.easy_getCell(row+1,column).setValue( "Data " + (row + 1) + ", " + (column + 1)); xlsFirstTable.easy_getCell(row+1,column).setDataType(DataType.STRING); } } // Apply a predefined format to the report values xlsFirstTable.easy_setRangeAutoFormat("A1:E101", new ExcelAutoFormat(Styles.AUTOFORMAT_EASYXLS1)); // Export HTML file workbook.easy_WriteHTMLFile("C:\\Samples\\Export to HTML.html", "First tab");

Click here to see Continuous Code Listing

// Create an instance of the class that exports Excel files $workbook = new COM("EasyXLS.ExcelDocument"); // Create a worksheet $workbook->easy_addWorksheet_2("First tab"); // Get the table of data for the worksheet $xlsFirstTable = $workbook->easy_getSheetAt(0)->easy_getExcelTable(); // Add data in cells for report header for ($column=0; $column<5; $column++) { $xlsFirstTable->easy_getCell(0,$column)->setValue("Column " . ($column + 1)); $xlsFirstTable->easy_getCell(0,$column)->setDataType($DATATYPE_STRING); } // Add data in cells for report values for ($row=0; $row<100; $row++) { for ($column=0; $column<5; $column++) { $xlsFirstTable->easy_getCell($row+1,$column)->setValue( "Data ".($row + 1).", ".($column + 1)); $xlsFirstTable->easy_getCell($row+1,$column)->setDataType($DATATYPE_STRING); } } // Create an instance of the class used to format the cells $xlsAutoFormat = new COM("EasyXLS.ExcelAutoFormat"); $xlsAutoFormat->InitAs($AUTOFORMAT_EASYXLS1); // Apply a predefined format to the report values $xlsFirstTable->easy_setRangeAutoFormat_2("A1:E101", $xlsAutoFormat); // Export HTML file $workbook->easy_WriteHTMLFile_2("C:\Samples\Export to HTML.html","First tab");

Click here to see Continuous Code Listing

' Create an instance of the class that exports Excel files Set workbook = Server.CreateObject("EasyXLS.ExcelDocument") ' Create a worksheet workbook.easy_addWorksheet_2("First tab") ' Get the table of data for the worksheet Set xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable() ' Add data in cells for report header for column = 0 to 4 xlsFirstTable.easy_getCell(0,column).setValue("Column " & (column + 1)) xlsFirstTable.easy_getCell(0,column).setDataType(DATATYPE_STRING) next ' Add data in cells for report values for row = 0 to 99 for column = 0 to 4 xlsFirstTable.easy_getCell(row+1,column).setValue( _ "Data " & (row + 1) & ", " & (column + 1)) xlsFirstTable.easy_getCell(row+1,column).setDataType(DATATYPE_STRING) next next ' Create an instance of the class used to format the cells Dim xlsAutoFormat Set xlsAutoFormat = Server.CreateObject("EasyXLS.ExcelAutoFormat") xlsAutoFormat.InitAs(AUTOFORMAT_EASYXLS1) ' Apply a predefined format to the report values xlsFirstTable.easy_setRangeAutoFormat_2 "A1:E101", xlsAutoFormat ' Export HTML file workbook.easy_WriteHTMLFile_2 "C:\Samples\Export to HTML.html", "First tab"

Click here to see Continuous Code Listing

// Create an instance of the class that exports Excel files EasyXLS::IExcelDocumentPtr workbook; hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument), NULL, CLSCTX_ALL, __uuidof(EasyXLS::IExcelDocument), (void**) &workbook) ; if (SUCCEEDED(hr)){ // Create a worksheet workbook->easy_addWorksheet_2("First tab"); // Get the table of data for the worksheet EasyXLS::IExcelWorksheetPtr xlsFirstTab = (EasyXLS::IExcelWorksheetPtr)workbook->easy_getSheetAt(0); EasyXLS::IExcelTablePtr xlsFirstTable = xlsFirstTab->easy_getExcelTable(); // Add data in cells for report header char* cellValue = (char*)malloc(11*sizeof(char)); char* columnNumber = (char*)malloc(sizeof(char)); for (int column=0; column<5; column++) { strcpy(cellValue, "Column "); _itoa(column + 1, columnNumber, 10); xlsFirstTable->easy_getCell(0,column)->setValue(strcat(cellValue, columnNumber)); xlsFirstTable->easy_getCell(0,column)->setDataType(DATATYPE_STRING); } // Add data in cells for report values char* rowNumber = (char*)malloc(sizeof(char)); for (int row=0; row<100; row++) { for (int column=0; column<5; column++) { strcpy(cellValue, "Data "); _itoa(column+ 1, columnNumber, 10); _itoa(row + 1, rowNumber, 10); strcat(cellValue, rowNumber); strcat(cellValue, ", "); strcat(cellValue, columnNumber); xlsFirstTable->easy_getCell(row+1,column)->setValue(cellValue); xlsFirstTable->easy_getCell(row+1,column)->setDataType(DATATYPE_STRING); } } // Create an instance of the class used to format the cells EasyXLS::IExcelAutoFormatPtr xlsAutoFormat; CoCreateInstance(__uuidof(EasyXLS::ExcelAutoFormat), NULL, CLSCTX_ALL, __uuidof(EasyXLS::IExcelAutoFormat), (void**) &xlsAutoFormat); xlsAutoFormat->InitAs(AUTOFORMAT_EASYXLS1); // Apply a predefined format to the report values xlsFirstTable->easy_setRangeAutoFormat_2("A1:E101", _variant_t((IDispatch*)xlsAutoFormat,true)); // Export HTML file workbook->easy_WriteHTMLFile_2("C:\\Samples\\Export to HTML.html", "First tab");

Click here to see Continuous Code Listing

' Create an instance of the class that exports Excel files Set workbook = CreateObject("EasyXLS.ExcelDocument") ' Create a worksheet workbook.easy_addWorksheet_2 ("First tab") ' Get the table of data for the worksheet Set xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable() ' Add data in cells for report header For Column = 0 To 4 xlsFirstTable.easy_getCell(0, Column).setValue ("Column " & (Column + 1)) xlsFirstTable.easy_getCell(0, Column).setDataType (DataType.DATATYPE_STRING) Next ' Add data in cells for report values For row = 0 To 99 For Column = 0 To 4 xlsFirstTable.easy_getCell(row + 1, Column).setValue ( _ "Data " & (row + 1) & ", " & (Column + 1)) xlsFirstTable.easy_getCell(row + 1, Column).setDataType ( _ DataType.DATATYPE_STRING) Next Next ' Create an instance of the class used to format the cells Dim xlsAutoFormat Set xlsAutoFormat = CreateObject("EasyXLS.ExcelAutoFormat") xlsAutoFormat.InitAs (Styles.AUTOFORMAT_EASYXLS1) ' Apply a predefined format to the report values xlsFirstTable.easy_setRangeAutoFormat_2 "A1:E101", xlsAutoFormat ' Export HTML file workbook.easy_WriteHTMLFile_2 "C:\Samples\Export to HTML.html", "First tab"

Click here to see Continuous Code Listing

' Create an instance of the class that exports Excel files Set workbook = CreateObject("EasyXLS.ExcelDocument") ' Create a worksheet workbook.easy_addWorksheet_2("First tab") ' Get the table of data for the worksheet Set xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable() ' Add data in cells for report header For Column = 0 To 4 xlsFirstTable.easy_getCell(0,column).setValue("Column " & (Column + 1)) xlsFirstTable.easy_getCell(0,column).setDataType(DATATYPE_STRING) Next ' Add data in cells for report values For row = 0 To 99 For column = 0 To 4 xlsFirstTable.easy_getCell(row+1,column).setValue( _ "Data " & (row + 1) & ", " & (column + 1)) xlsFirstTable.easy_getCell(row+1,column).setDataType(DATATYPE_STRING) Next Next ' Create an instance of the class used to format the cells Dim xlsAutoFormat Set xlsAutoFormat = CreateObject("EasyXLS.ExcelAutoFormat") xlsAutoFormat.InitAs(AUTOFORMAT_EASYXLS1) ' Apply a predefined format to the report values xlsFirstTable.easy_setRangeAutoFormat_2 "A1:E101", xlsAutoFormat ' Export HTML file workbook.easy_WriteHTMLFile_2 "C:\Samples\Export to HTML.html", "First tab"

Click here to see Continuous Code Listing

<!-- Create an instance of the class that exports Excel files --> <cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE"> <!-- Create a worksheet --> <cfset ret = workbook.easy_addWorksheet("First tab")> <!-- Get the table of data for the worksheet --> <cfset xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable()> <!-- Add data in cells for report header --> <cfloop from="0" to="4" index="column"> <cfset xlsFirstTable.easy_getCell(0,evaluate(column)).setValue( "Column " & evaluate(column + 1))> <cfset xlsFirstTable.easy_getCell(0,evaluate(column)).setDataType( DataType.STRING)> </cfloop> <!-- Add data in cells for report values --> <cfloop from="0" to="99" index="row"> <cfloop from="0" to="4" index="column"> <cfset xlsFirstTable.easy_getCell( evaluate(row + 1), evaluate(column)).setValue( "Data " & evaluate(row + 1) & ", " & evaluate(column + 1))> <cfset xlsFirstTable.easy_getCell( evaluate(row + 1),evaluate(column)).setDataType( DataType.STRING)> </cfloop> </cfloop> <!-- Create an instance of the class used to format the cells --> <cfobject type="java" class="EasyXLS.ExcelAutoFormat" name="xlsAutoFormat" action="CREATE"> <cfset xlsAutoFormat.InitAs(Styles.AUTOFORMAT_EASyXLS1)> <!-- Apply a predefined format to the report values --> <cfset xlsFirstTable.easy_setRangeAutoFormat("A1:E101", xlsAutoFormat)> <!-- Export HTML file --> <cfset ret = workbook.easy_WriteHTMLFile("C:\Samples\Export to HTML.htm", "First tab")>

Click here to see Continuous Code Listing

