Library for easy writing Excel Spreadsheets
Your application with this library can easy and simple writes xls-files without using Microsoft Excel. Text, numbers, formulas, hyperlinks and images can be written to cells. Also various formatting can be applied.Key features
- creating richly formatted spreadsheets
- write xls-files directly and lets you bypass OLE Automation
- supports Excel 97, 2000, XP, 2003 and OpenOffice (BIFF format)
- static link with Visual Studio 2003, 2005, 2008 and Linux/Mac gcc
- unicode support
Example
Workbook* xls = new Workbook("example.xls");
Worksheet* sheet = xls->addWorksheet(L"Simple");
sheet->write(0, 0, L"Welcome!");
sheet->write(L"A3", 65.0083);
sheet->write(L"A4", 21.0024);
sheet->write(L"A5", 10.0015);
Format* format = xls->addFormat();
format->setBold();
format->setTextColor(Format::COLOR_RED);
sheet->write(L"A6", L"=A3+A4+A5", format);
sheet->write(7, 0, L"http://libexcel.com");
xls->close();
delete xls;
Worksheet* sheet = xls->addWorksheet(L"Simple");
sheet->write(0, 0, L"Welcome!");
sheet->write(L"A3", 65.0083);
sheet->write(L"A4", 21.0024);
sheet->write(L"A5", 10.0015);
Format* format = xls->addFormat();
format->setBold();
format->setTextColor(Format::COLOR_RED);
sheet->write(L"A6", L"=A3+A4+A5", format);
sheet->write(7, 0, L"http://libexcel.com");
xls->close();
delete xls;
Result of example
Demo