The below example shows how to export data to CSV file.
The source code samples can be integrated in:
- ASP.NET web pages - Windows applications - Windows Forms (WinForms) - Console applications - Windows service applications - ASP.NET MVC web applications - PHP and ASP web pages - Java applications
// 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 headerfor (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 valuesfor (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");
' Create an instance of the class that exports Excel files, having a sheetDim workbook As New ExcelDocument(1)
' Set the sheet name
workbook.easy_getSheetAt(0).setSheetName("First tab")
' Get the table of data for the worksheetDim xlsFirstTab As ExcelWorksheet = workbook.easy_getSheetAt(0)
Dim xlsFirstTable = xlsFirstTab.easy_getExcelTable()
' Add data in cells for report headerFor 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 valuesFor 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)
NextNext' Export CSV file
workbook.easy_WriteCSVFile("C:\Samples\Export to CSV.csv", "First tab")
C++// 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 headerchar* 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 valueschar* 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 ListingC++.NET// Create an instance of the class that exports Excel files, having a sheet
ExcelDocument ^workbook = gcnew ExcelDocument(1);
// Set the sheet name
workbook->easy_getSheetAt(0)->setSheetName("First tab");
// Get the table of data for the worksheet
ExcelWorksheet ^xlsFirstTab =
safe_cast<ExcelWorksheet^>(workbook->easy_getSheetAt(0));
ExcelTable ^xlsFirstTable = xlsFirstTab->easy_getExcelTable();
// Add data in cells for report headerfor (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 valuesfor (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 headerfor (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 valuesfor (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");
.NET:// 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 headerfor ($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 valuesfor ($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 ListingJava:// Create an instance of the class that exports Excel files
$workbook = new java("EasyXLS.ExcelDocument");
// Create a worksheet
$workbook->easy_addWorksheet("First tab");
// Get the table of data for the worksheet
$xlsFirstTable = $workbook->easy_getSheetAt(0)->easy_getExcelTable();
// Add data in cells for report headerfor ($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 valuesfor ($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 file.csv", "First tab");
Click here to see Continuous Code Listing
' Create an instance of the class that exports Excel filesSet workbook = Server.CreateObject("EasyXLS.ExcelDocument")
' Create the worksheet
workbook.easy_addWorksheet_2("First tab")
' Get the table of data for the worksheetSet xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable()
' Add data in cells for report headerfor 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 valuesfor 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)
nextnext' Export CSV file
workbook.easy_WriteCSVFile "C:\Samples\Export to CSV.csv", "First tab"
' Create an instance of the class that exports Excel filesSet workbook = CreateObject("EasyXLS.ExcelDocument")
' Create the worksheet
workbook.easy_addWorksheet_2 ("First tab")
' Get the table of data for the worksheetSet xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable()
' Add data in cells for report headerFor 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 valuesFor 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)
NextNext' Export CSV file
workbook.easy_WriteCSVFile "C:\Samples\Export to CSV.csv", "First tab"
' Create an instance of the class that exports Excel filesSet workbook = CreateObject("EasyXLS.ExcelDocument")
' Create the worksheet
workbook.easy_addWorksheet_2("First tab")
' Get the table of data for the worksheetSet xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable()
' Add data in cells for report headerFor 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 valuesFor 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)
NextNext' Export CSV file
workbook.easy_WriteCSVFile "C:\Samples\Export to CSV.csv", "First tab"
<!-- Create an instance of the class that exports Excel files --><cfobject type="java"class="EasyXLS.ExcelDocument"name="workbook"action="CREATE"><!-- Create the 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><!-- Export CSV file --><cfset ret = workbook.easy_WriteCSVFile("C:\Samples\Export to CSV.csv", "First tab")>
.NET:# Create an instance of the class that exports Excel files, having a sheet
workbook = ExcelDocument(1)
# Set the sheet name
workbook.easy_getSheetAt(0).setSheetName("First tab")
# Get the table of data for the worksheet
xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable()
# Add data in cells for report headerfor column in range(5):
xlsFirstTable.easy_getCell(0,column).setValue("Column " + str(column + 1))
xlsFirstTable.easy_getCell(0,column).setDataType(DataType.STRING)
# Add data in cells for report valuesfor row in range(100):
for column in range(5):
xlsFirstTable.easy_getCell(row+1,column).setValue("Data " + str(row + 1) + ", " + str(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 ListingJava:# Create an instance of the class that exports Excel files, having a sheet
workbook = gateway.jvm.ExcelDocument(1)
# Set the sheet name
workbook.easy_getSheetAt(0).setSheetName("First tab")
# Get the table of data for the worksheet
xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable()
# Add data in cells for report headerfor column in range(5):
xlsFirstTable.easy_getCell(0,column).setValue("Column " + str(column + 1))
xlsFirstTable.easy_getCell(0,column).setDataType(gateway.jvm.DataType.STRING)
# Add data in cells for report valuesfor row in range(100):
for column in range(5):
xlsFirstTable.easy_getCell(row+1,column).setValue("Data " + str(row + 1) + ", " + str(column + 1))
xlsFirstTable.easy_getCell(row+1,column).setDataType(gateway.jvm.DataType.STRING)
# Export CSV file
workbook.easy_WriteCSVFile("C:\\Samples\\Export to CSV.csv", "First tab")
Click here to see Continuous Code Listing
The screen shot below represents the exported data to CSV file generated by the code sample above.
Export to CSV with encoding
EasyXLS allows you to export CSV files with specific encoding using System.IO.StreamWriter class in .NET and java.io.OutputStreamWriter class in Java with ExcelDocument.easy_WriteCSVFile method.