Export to XML Spreadsheet in C#, VB.NET, Java, C++, PHP, VB6

Export XML Spreadsheet file

EasyXLS™ library allows you to export data to XML Spreadsheet Excel file format. The data in cells can be formatted using predefined formats or user-defined formats.

An XML Spreadsheet file is an XML file in a format designed by Microsoft specifically for Excel worksheets.

For more technical information about XML spreadsheets you can check XML Spreadsheet Reference web page.

The entire workbook can be saved as an XML Spreadsheet file (with some limitation applied to visual objects such as images, charts or drawings) and after that it can be processed as any other XML file or you can open it with Microsoft Excel.

Source code sample
Formatting cells
Export DataTable to XML in C# and VB.NET
Export GridView to XML in C# and VB.NET from ASP.NET
Export DataGridView to XML in C# and VB.NET
Export DataSet to XML in C# and VB.NET
Export ResultSet to XML in Java
Export list to XML
Export DataGrid to XML in C# and VB.NET

Source code sample

The below example is a common code about how to export to XML Spreadsheet Excel file.

C++

// Create an instance of the class that exports Excel file
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
                      NULL,
                      CLSCTX_ALL,
                      __uuidof(EasyXLS::IExcelDocument),
                      (void**) &workbook);

// Create the worksheets
workbook->easy_addWorksheet_2("First tab");
workbook->easy_addWorksheet_2("Second tab");

// Get the table of the first worksheet that will keep the data
EasyXLS::IExcelWorksheetPtr xlsFirstTab = 
        (EasyXLS::IExcelWorksheetPtr)workbook->easy_getSheetAt(0);
EasyXLS::IExcelTablePtr xlsFirstTable = xlsFirstTab->easy_getExcelTable();

// Add data to 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 to cells
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 formatting style on a range of cells
xlsFirstTable->easy_setRangeAutoFormat_2("A1:E101", 
                _variant_t((IDispatch*)xlsAutoFormat,true));

// Export XML Spreadsheet Excel file
workbook->easy_WriteXMLFile_2("C:\\Samples\\Export to XML Spreadsheet.xml");

Click here to see Continuous Code Listing


C++.NET

// Create an instance of the class that exports Excel file, having multiple sheets
ExcelDocument ^workbook = gcnew ExcelDocument(2);

// Set the sheet names
workbook->easy_getSheetAt(0)->setSheetName("First tab");
workbook->easy_getSheetAt(1)->setSheetName("Second tab");

// Get the table of the first worksheet that will keep the data
ExcelWorksheet ^xlsFirstTab = 
        safe_cast<ExcelWorksheet^>(workbook->easy_getSheetAt(0));
ExcelTable xlsFirstTable = xlsFirstTab->easy_getExcelTable();

// Add data to 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 to cells
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 formatting style on a range of cells
xlsFirstTable->easy_setRangeAutoFormat("A1:E101", 
        gcnew ExcelAutoFormat(Styles::AUTOFORMAT_EASYXLS1));

// Export XML Spreadsheet Excel file
workbook->easy_WriteXMLFile("C:\\Samples\\Export to XML Spreadsheet.xml");

Click here to see Continuous Code Listing

.NET:

// Create an instance of the class that exports Excel file
$workbook = new COM("EasyXLS.ExcelDocument");

// Create the worksheets
$workbook->easy_addWorksheet_2("First tab");
$workbook->easy_addWorksheet_2("Second tab");

// Get the table of the first worksheet that will keep the data
$xlsFirstTable = $workbook->easy_getSheetAt(0)->easy_getExcelTable();

// Add data to 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 to cells
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 formatting style on a range of cells
$xlsFirstTable->easy_setRangeAutoFormat_2("A1:E101", $xlsAutoFormat);

// Export XML Spreadsheet Excel file
$workbook->easy_WriteXMLFile_2("C:\Samples\Export to XML Spreadsheet.xml");

Click here to see Continuous Code Listing


Java:

// Create an instance of the class that exports Excel files
$workbook = new java("EasyXLS.ExcelDocument");
	
// Create two worksheets
$workbook->easy_addWorksheet("First tab");
$workbook->easy_addWorksheet("Second tab");

// Get the table of data for the first 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 java("EasyXLS.ExcelAutoFormat");
$xlsAutoFormat->InitAs($AUTOFORMAT_EASYXLS1);

// Apply the predefined format to the cells
$xlsFirstTable->easy_setRangeAutoFormat("A1:E101", $xlsAutoFormat);
	
// Export XML Spreadsheet file
$workbook->easy_WriteXMLFile("C:\Samples\Tutorial32 - export XML spreadsheet file.xml");

Click here to see Continuous Code Listing

.NET:

# Create an instance of the class that exports Excel files, having two sheets
workbook = ExcelDocument(2)

# Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab")
workbook.easy_getSheetAt(1).setSheetName("Second tab")

# Get the table of data for the first worksheet
xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable()

# Add data in cells for report header
for 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 values
for 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 XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\\Samples\\Tutorial32 - export XML spreadsheet file.xml")

Click here to see Continuous Code Listing


Java:

# Create an instance of the class that exports Excel files, having two sheets
workbook = gateway.jvm.ExcelDocument(2)

# Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab")
workbook.easy_getSheetAt(1).setSheetName("Second tab")


# Get the table of data for the first worksheet
xlsFirstTable = workbook.easy_getSheetAt(0).easy_getExcelTable()

# Add data in cells for report header
for 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 values
for 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 XML Spreadsheet file
workbook.easy_WriteXMLFile("C:\\Samples\\Tutorial32 - export XML spreadsheet file.xml")

Click here to see Continuous Code Listing

The screen shot below represents the exported data to XML Spreadsheet file generated by the code sample above. The file has two worksheets (First Tab and Second Tab). The values and the data type of the cells from the first worksheet are set.

Formatting cells

EasyXLS™ enables you to format cells, rows and columns in order to set the fonts and colors.

Export DataTable to XML in C# and VB.NET

EasyXLS allows exporting DataTable to XML file. The DataTable can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_WriteXMLFile method.

Export GridView to XML in C# and VB.NET from ASP.NET

EasyXLS allows exporting GridView to XML file. The DataTable of the GridView can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_ WriteXMLFile method.

Export DataGridView to XML in C# and VB.NET

EasyXLS allows exporting DataGridView to XML file. The DataTable of the DataGridView can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_ WriteXMLFile method.

Export DataSet to XML in C# and VB.NET

EasyXLS allows exporting DataSet to XML file. The DataSet can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_ WriteXMLFile method.

Export ResultSet to XML in Java

EasyXLS allows exporting ResultSet to XML file. The ResultSet can be inserted using ExcelWorksheet.easy_insertResultSet method and the XML file must be exported using ExcelDocument.easy_WriteXMLFile method.

Export list to XML

EasyXLS allows exporting list to XML file. The list can be inserted using ExcelWorksheet.easy_insertList method and the XML file must be exported using ExcelDocument.easy_WriteXMLFile method.

Export DataGrid to XML in C# and VB.NET

EasyXLS allows exporting DataGrid to XML file. The DataTable of the DataGrid can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_WriteXMLFile method.

Getting started with EasyXLS Excel library

To download the trial version of EasyXLS Excel Library, press the below button:

If you already own a license key, you may login and download EasyXLS from your account.

Available for: Professional, Excel Writer

EasyXLS Excel libraries:
.NET Excel Library
full .NET version to import, export or convert Excel files
.NET Excel Writer
.NET version to create and export Excel files
COM+ Excel Library
full COM+ version to import, export or convert Excel files
COM+ Excel Writer
COM+ version to create and export Excel files


Java Excel Library
full Java version to import, export or convert Excel files
Java Excel Writer
Java version to create and export Excel files