The below example shows how to export data to HTML 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);
}
}
// 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");
' Create an instance of the class that exports Excel files, having a sheetDim workbook As New ExcelDocument(2)
' 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
xlsFirstTable.easy_getRowAt(0).setHeight(30)
' 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' 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")
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) ;
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 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);
}
}
// 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 ListingC++.NET// Create an instance of the class that exports Excel files, having a sheet
ExcelDocument ^workbook = gcnew ExcelDocument(2);
// 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);
}
}
// Apply a predefined format to the report values
xlsFirstTable->easy_setRangeAutoFormat("A1:E101",
gcnew 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 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);
}
}
// 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");
.NET:// 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 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);
}
}
// 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 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);
}
}
// Create an instance of the class used to format the cells
$xlsAutoFormat = new java("EasyXLS.ExcelAutoFormat");
$xlsAutoFormat->InitAs($AUTOFORMAT_EASYXLS1);
// Apply the predefined format to the cells
$xlsFirstTable->easy_setRangeAutoFormat("A1:E101", $xlsAutoFormat);
// 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 filesSet workbook = Server.CreateObject("EasyXLS.ExcelDocument")
' Create a 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' Create an instance of the class used to format the cellsDim 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"
' Create an instance of the class that exports Excel filesSet workbook = CreateObject("EasyXLS.ExcelDocument")
' Create a 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' Create an instance of the class used to format the cellsDim 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"
' Create an instance of the class that exports Excel filesSet workbook = CreateObject("EasyXLS.ExcelDocument")
' Create a 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' Create an instance of the class used to format the cellsDim 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"
<!-- 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")>
.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)
# Apply a predefined format to the cells
xlsFirstTable.easy_setRangeAutoFormat("A1:E101", ExcelAutoFormat(Styles.AUTOFORMAT_EASYXLS1))
# Export HTML file
workbook.easy_WriteHTMLFile( "C:\\Samples\\Export to HTML.html", "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)
# Apply a predefined format to the cells
xlsFirstTable.easy_setRangeAutoFormat("A1:E101",
gateway.jvm.ExcelAutoFormat(gateway.jvm.Styles.AUTOFORMAT_EASYXLS1))
# Export HTML file
workbook.easy_WriteHTMLFile("C:\\Samples\\Export to HTML.html", "First tab")
Click here to see Continuous Code Listing
The screen shot below represents the exported data to HTML file generated by the code sample above.
Export to HTML with encoding
EasyXLS allows you to export HTML files with specific encoding using System.IO.StreamWriter class in .NET and java.io.OutputStreamWriter class in Java with ExcelDocument.easy_WriteHTMLFile method.