// 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); } } // Export CSV file workbook.easy_WriteCSVFile("C:\\Samples\\Export to CSV.csv", "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(1) ' 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 ' 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 ' Export CSV file workbook.easy_WriteCSVFile("C:\Samples\Export to CSV.csv", "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 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); } } // Export CSV file workbook->easy_WriteCSVFile("C:\\Samples\\Export to CSV.csv", "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); } } // Export CSV file workbook.easy_WriteCSVFile("C:\\Samples\\Export to CSV.csv", "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); } } // Export CSV file workbook.easy_WriteCSVFile("C:\\Samples\\Export to CSV.csv", "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 the 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); } } // Export CSV file $workbook->easy_WriteCSVFile("C:\Samples\Export to CSV.csv","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 the 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 ' Export CSV file workbook.easy_WriteCSVFile "C:\Samples\Export to CSV.csv", "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) ; // Create the 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); } } // Export CSV file workbook->easy_WriteCSVFile("C:\\Samples\\Export to CSV.csv", "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 the 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 ' Export CSV file workbook.easy_WriteCSVFile "C:\Samples\Export to CSV.csv", "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 the 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 ' Export CSV file workbook.easy_WriteCSVFile "C:\Samples\Export to CSV.csv", "First tab"

Click here to see Continuous Code Listing

