xlnt is a modern C++ library for manipulating spreadsheets in memory and reading/writing them from/to XLSX files as described in ECMA 376 4th edition. The first public release of xlnt version 1.0 was on May 10th, 2017. Current work is focused on increasing compatibility, improving performance, and brainstorming future development goals. For a high-level summary of what you can do with this library, see the feature list. Contributions are welcome in the form of pull requests or discussions on the repository's Issues page.
Including xlnt in your project, creating a new spreadsheet, and saving it as "example.xlsx"
#include <xlnt/xlnt.hpp>
int main()
{
xlnt::workbook wb;
xlnt::worksheet ws = wb.active_sheet();
ws.cell("A1").value(5);
ws.cell("B2").value("string data");
ws.cell("C3").formula("=RAND()");
ws.merge_cells("C3:C4");
ws.freeze_panes("B2");
wb.save("example.xlsx");
return 0;
}
// compile with -std=c++14 -Ixlnt/include -lxlntDocumentation for the current release of xlnt is available here.
xlnt is released to the public for free under the terms of the MIT License. See LICENSE.md for the full text of the license and the licenses of xlnt's third-party dependencies. LICENSE.md should be distributed alongside any assemblies that use xlnt in source or compiled form.
This respository is fork from https://github.com/tfussell/xlnt
"menglei" is my working dictionary
I build this respository by CMake Mingw and Code::Blocks, it's quite simple and easy
After build all, there would be a libxlnt.dll in build/source/, copy it to menglei/ for run your exe program
Set Code::Blocks
- Build -> Select target
- select menglei
- build and run
For more infomation, see menglei/README.md
2018.9.29 add bin/