How to apply auto-filter in C++

/* ------------------------------------------------------
 * Tutorial 20
 * 
 * This tutorial shows how to create an Excel file in C++
 * and apply an auto-filter to a range of cells.
 * ------------------------------------------------------ */

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

int main()
{
    printf("Tutorial 20\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 a sheet
            workbook->easy_addWorksheet_2("Sheet1");

            // Get the table of data for the worksheet
            EasyXLS::IExcelWorksheetPtr xlsTab = (EasyXLS::IExcelWorksheetPtr)workbook->easy_getSheet("Sheet1");
            EasyXLS::IExcelTablePtr xlsTable = xlsTab->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);
                xlsTable->easy_getCell(0,column)->setValue(cellValue);
                xlsTable->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);

                    xlsTable->easy_getCell(row+1,column)->setValue(cellValue);
                    xlsTable->easy_getCell(row+1,column)->setDataType(DATATYPE_STRING);
                }
            }

            // Apply auto-filter on cell range A1:E1
            EasyXLS::IExcelFilterPtr xlsFilter = (EasyXLS::IExcelFilterPtr)xlsTab->easy_getFilter();
            xlsFilter->setAutoFilter_2("A1:E1");

            // Export Excel file
            printf("Writing file C:\\Samples\\Tutorial20 - autofilter in Excel sheet.xlsx.");
            workbook->easy_WriteXLSXFile("C:\\Samples\\Tutorial20 - autofilter in Excel sheet.xlsx");

            // Confirm export of Excel 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 20
 |
 | This tutorial shows how to create an Excel file in C++.NET
 | and apply an auto-filter to a range of cells.
 ------------------------------------------------------------*/

#include <conio.h>
#include <stdio.h>

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

int main()
{
    Console::WriteLine("Tutorial 20\n----------\n");
    
    // Create an instance of the class that exports Excel files having one sheet
    ExcelDocument ^workbook = gcnew ExcelDocument(1);

    // Get the table of data for the worksheet
    ExcelWorksheet ^xlsTab = safe_cast<ExcelWorksheet^>(workbook->easy_getSheet("Sheet1"));
    ExcelTable ^xlsTable = xlsTab->easy_getExcelTable();

    // Add data in cells for report header
    for (int column=0; column<5; column++)
    {
        xlsTable->easy_getCell(0,column)->setValue(String::Concat("Column ",(column + 1).ToString())); 
        xlsTable->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++)
        {
            xlsTable->easy_getCell(row+1,column)->setValue(
                String::Concat("Data ", (row + 1).ToString(), ", ", (column + 1).ToString()));
            xlsTable->easy_getCell(row+1,column)->setDataType(DataType::STRING);
        }
    }

    // Apply auto-filter on cell range A1:E1
    ExcelFilter ^xlsFilter = xlsTab->easy_getFilter();
    xlsFilter->setAutoFilter("A1:E1");

    // Export Excel file
    Console::WriteLine("Writing file C:\\Samples\\Tutorial20 - autofilter in Excel sheet.xlsx.");
    workbook->easy_WriteXLSXFile("C:\\Samples\\Tutorial20 - autofilter in Excel sheet.xlsx");

    // Confirm export of Excel 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;
}