xlsgen::IXlsWorkbookPtr workbook;
workbook = engine->New( L"output.xlsx" );

xlsgen::IXlsWorksheetPtr worksheet = workbook->AddWorksheet("SheetX");

xlsgen::IXlsTablePtr table = worksheet->NewTable[3][2];

table->DataSource->CommandTimeout = 40;
table->DataSource->ConnectionTimeout = 120;
#ifndef _WIN64
  table->DataSource->ConnectionString = L"Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\\datasource\\db1.mdb;uid=;pwd=;";
#else
  table->DataSource->ConnectionString = L"Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=c:\\datasource\\db1.mdb;uid=;pwd=;";
#endif

table->DataSource->SQLStatement = L"select * from Table1";

int nbrows = table->DataResults->RowCount;
int nbcolumns = table->DataResults->Columns->Count;

_bstr_t column1 = table->DataResults->Columns->Item[1]->Name;
_bstr_t column2 = table->DataResults->Columns->Item[2]->Name;
_bstr_t column3 = table->DataResults->Columns->Item[3]->Name;
_bstr_t column4 = table->DataResults->Columns->Item[4]->Name;
_bstr_t column5 = table->DataResults->Columns->Item[5]->Name;

_bstr_t definedName = table->DataResults->Name;

xlsgen::IXlsStylePtr styleDate = worksheet->NewStyle();
styleDate->Format = L"dd/mm/yyyy";

xlsgen::IXlsStylePtr styleBackground = worksheet->NewStyle();
styleBackground->Pattern->BackgroundColor = 0xFF0000;

table->DataResults->Columns->Item[4]->DataStyle = styleBackground;

table->DataResults->Insert();

workbook->Close();

xlsgen::IXlsTablePtr table = worksheet->Tables->Add();

table->DataSource->Range = L"R3C2:R6C6";

table->DataResults->Style->BuiltinStyle = xlsgen::tablestyle_light03;

// we have an "age" column in the table

xlsgen::IXlsTableBreaksPtr br = wksht->Tables->Item[1]->DataResults->Columns->ItemByName[L"age"]->Breaks;

// compute the average of "age"

br->Subtotals->Add( wksht->Tables->Item[1]->DataResults->Columns->ItemByName[L"age"] )->BuiltinFunction = xlsgen::subtotalfunc_average;

• native PDF generation (vectors) [default engine]
  
  

  C/C++ code

  // worksheet level workbook->PDFEngine = xlsgen::pdfengine_text; worksheet->Export->ExportAsPDF(L"output.pdf"); // workbook level workbook = engine->Open(L"input.xlsm", L"outputAllWorksheets.pdf"); workbook->PDFEngine = xlsgen::pdfengine_text; workbook->Close();

  
  
  
• GDI-based PDF generation (screen DPI resolution, usually 96 DPI)
  
  
  

  C/C++ code

  // worksheet level workbook->PDFEngine = xlsgen::pdfengine_bitmap; worksheet->Export->ExportAsPDF(L"output.pdf"); // workbook level workbook = engine->Open(L"input.xlsm", L"outputAllWorksheets.pdf"); workbook->PDFEngine = xlsgen::pdfengine_bitmap; workbook->Close();

  
  
  
• GDI-based virtual PDF printing (printer DPI resolution, usually 600 DPI)
  
  
  

  C/C++ code

  // worksheet level worksheet->PrintWith(L"PDFCreator", L""); // PDFCreator is a popular (and free) virtual PDF printer // workbook level workbook = engine->Open(L"input.xlsm", L""); workbook->PrintWith(L"PDFCreator", L""); workbook->Close();

typedef enum
{
   [helpstring("Formula parsing error, no error")]                     parseformula_noerror             = 0,
   [helpstring("Formula parsing error, syntax error")]                 parseformula_syntaxerror         = 1,
   [helpstring("Formula parsing error, out of memory")]                parseformula_outofmemory         = 2,
   [helpstring("Formula parsing error, not enough parameters")]        parseformula_notenoughparams     = 3,
   [helpstring("Formula parsing error, too many parameters")]          parseformula_toomanyparams       = 4,
   [helpstring("Formula parsing error, impaired parenthesis")]         parseformula_impairedparenthesis = 5,
   [helpstring("Formula parsing error, impaired brace")]               parseformula_impairedbrace       = 6,
   [helpstring("Formula parsing error, division by zero")]             parseformula_divisionbyzero      = 7,
   [helpstring("Formula parsing error, function does not exist")]      parseformula_functionnotexist    = 8,
   [helpstring("Formula parsing error, wrong argument separator")]     parseformula_wrongargumentseparator = 9

} enumParseFormulaError;

xlsgen::enumParseFormulaError error = workbook->TryParseFormula(L"=SUMXYZ(5;3;A2)"); // returns parseformula_functionnotexist because SUMXYZ() does not exist