Qxlnt

Read this in other languages: English, 🇰🇷 한국어

• Qxlnt is a helper project that allows xlnt to be used in Qt.
• xlnt is xlsx library that using C++14. See 'License and links' for more information.

Why did you make it?

• xlnt is a excellent library for using xlsx Excel files. 👍
• I was looking for a way to make it easy to use in Qt. Of course, cmake is compatible with Qt, but it is not convenient to use. So I created Qxlnt.

Hello World (HelloQXlnt)

#include <iostream>
#include <xlnt/xlnt.hpp>
#include <QCoreApplication>

int main(int argc, char **argv)
{     
    QCoreApplication a(argc, argv); // It is a Qt code.

    xlnt::workbook wb; // It is a xlnt code. Mix it together!
    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;
}

Notice ⚡

• C++14 or higher version is required.
  • gcc 4.x(4.8 or below) is not supported. Current(2018) gcc version is 7.x.
  • If you use Visual C++, then use VS 2017 or higher version.

Test

• Currently in testing now.
• See Tested Environments

To Do

• Testing in various Qt environments. ☁️
• Unicode Test (filename, file path, data value) ☔

License and links

• Qxlnt is under MIT License. https://github.com/j2doll/Qxlnt
• xlnt is under MIT License. https://github.com/tfussell/xlnt
• libstudxml is under MIT License. https://www.codesynthesis.com/projects/libstudxml/
• utfcpp is under Boost Software License. http://utfcpp.sourceforge.net

📫 Contact

• Please leave an issue to me. https://github.com/j2doll/Qxlnt/issues
• Hi! I'm j2doll (aka Jay Two). My native language is not English and my English is not fluent. Please, use EASY English. :-)

Similar projects going on

⭐ QXlsx https://github.com/j2doll/QXlsx

• QXlsx is excel file(*.xlsx) reader/writer library.
• Because QtXlsx is no longer supported(2014), I created a new project that is based on QtXlsx. (2017-)
• Development language of QXlsx is C++. (with Qt 5.x)
• You don't need to use static library or dynamic shared object using QXlsx.

⭐ Qlibxlsxwriter https://github.com/j2doll/Qlibxlsxwriter

• Qlibxlsxwriter is a helper project that allows libxlsxwriter to be used in Qt.
• libxlsxwriter is a C library for creating Excel XLSX files.