A simple library for creating XML based Excel documents programatically
#include "Excel.h"<br>
int main(int argc, const char * argv[]) {
//Create an Excel Document
Excel spreadsheet("/Users/deisterhold/Desktop/Test.xml");
//Get the main workbook (Excel only has a single workbook)
Workbook *workbook = spreadsheet.getWorkbook();
//Set Author and Company (Optional)
workbook->setAuthor("Name Here");
workbook->setCompany("Company Name");
//Add a worksheet to the workbook
workbook->addWorksheet(Worksheet("Sheet 1"));
//Get the newly created worksheet
Worksheet *worksheet = workbook->getWorksheet(0);
//Add a table to the worksheet
worksheet->addTable(Table());
//Get the newly created table
Table *table = worksheet->getTable(0);
//Add a row to the table
table->addRow(Row());
//Get the newly create row
Row *row = table->getRow(0);
//Add a cell to the row
row->addCell(Cell());
//Get the newly created cell
Cell *cell = row->getCell(0);
//Put a data item in the cell (In this example we create a cell to hold a string)
//There are currently three data types DATATYPE_STRING, DATATYPE_NUMBER, DATATYPE_DATETIME
//All data is given as a string even if a number or time
cell->setContents(Data("Hello", DATATYPE_STRING)); //If no data type is given the data is assumed to be a string
//Equivalent to above "cell->setContents(Data("Hello"));"
//Saves the data in xml to the file
spreadsheet.save();
//Closes the file
spreadsheet.close();
return 0;
}