How to export data to XML Spreadsheet file in C++

/* ----------------------------------------------------------------------
 * Tutorial 32
 * 
 * This tutorial shows how to export data to XML Spreadsheet file in C++.
 * ---------------------------------------------------------------------- */

#include "EasyXLS.h"
#include <conio.h>

int main()
{
    printf("Tutorial 32\n----------\n");

    HRESULT hr;

    // Initialize COM
    hr = CoInitialize(0);

    // Use the SUCCEEDED macro and get a pointer to the interface
    if (SUCCEEDED(hr))
    {
        // Create a pointer to the interface that exports Excel files
        EasyXLS::IExcelDocumentPtr workbook;
        hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
                              NULL,
                              CLSCTX_ALL,
                              __uuidof(EasyXLS::IExcelDocument),
                              (void**) &workbook) ;

        if (SUCCEEDED(hr)){

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

            // Get the table of data for the first 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_s(cellValue, 8, "Column ");
                _itoa_s(column+ 1, columnNumber, 2, 10);
                strcat_s(cellValue, 10, columnNumber);
                xlsFirstTable->easy_getCell(0,column)->setValue(cellValue);
                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_s(cellValue, 6, "Data ");
                    _itoa_s(column+ 1, columnNumber, 2, 10);
                    _itoa_s(row + 1, rowNumber, 4, 10);

                    strcat_s(cellValue, 10, rowNumber);
                    strcat_s(cellValue, 12, ", ");
                    strcat_s(cellValue, 13, 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 the predefined format to the cells
            xlsFirstTable->easy_setRangeAutoFormat_2("A1:E101", _variant_t((IDispatch*)xlsAutoFormat,true));

            // Export XML Spreadsheet file
            printf("Writing file C:\\Samples\\Tutorial32 - export XML spreadsheet file.xml.");
            workbook->easy_WriteXMLFile_2("C:\\Samples\\Tutorial32 - export XML spreadsheet file.xml");

            // Confirm export of XML file
            _bstr_t sError = workbook->easy_getError();
            if (strcmp(sError, "") == 0){
                printf("\nFile successfully created. Press Enter to Exit...");
            }
            else{
                printf("\nError encountered: %s", (LPCSTR)sError);
            }

            // Dispose memory
            workbook->Dispose();
        }
        else{
            printf("Object is not available!");
        }
    }
    else{
        printf("COM can't be initialized!");
    }

    // Uninitialize COM
    CoUninitialize();

    _getch();
    return 0;
}

/*---------------------------------------------------------------------------
 | Tutorial 32
 |
 | This tutorial shows how to export data to XML Spreadsheet file in C++.NET.
 ----------------------------------------------------------------------------*/

using namespace System;
using namespace EasyXLS;
using namespace EasyXLS::Constants;

int main()
{
    Console::WriteLine("Tutorial 32\n----------\n");

    // Create an instance of the class that exports Excel files, having two 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 data for the first worksheet
    ExcelWorksheet ^xlsFirstTab = safe_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 cells
    xlsFirstTable->easy_setRangeAutoFormat("A1:E101", gcnew ExcelAutoFormat(Styles::AUTOFORMAT_EASYXLS1));

    // Export XML Spreadsheet file
    Console::WriteLine("Writing file C:\\Samples\\Tutorial32 - export XML spreadsheet file.xml.");
    workbook->easy_WriteXMLFile("C:\\Samples\\Tutorial32 - export XML spreadsheet file.xml");

    // Confirm export of XML file
    String ^sError = workbook->easy_getError();
    if (sError->Equals(""))
        Console::Write("\nFile successfully created. Press Enter to Exit...");
    else
        Console::Write(String::Concat("\nError encountered: ", sError, "\nPress Enter to Exit..."));

    // Dispose memory
    delete workbook;

    Console::ReadLine();

    return 0;
}