Qxlnt

Read this in other languages: English, :kr: 한국어

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

Why did you make it?

• xlnt is a excellent library for using xlsx Excel files. :+1:
• 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)

:one: Writing a excel(xlsx) file

#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;
}

:two: Reading from an existing xlsx spread sheet.

// https://tfussell.gitbooks.io/xlnt/content/docs/introduction/Examples.html

xlnt::workbook wb;
wb.load("/home/timothymccallum/test.xlsx");
auto ws = wb.active_sheet();
std::clog << "Processing spread sheet" << std::endl;
for (auto row : ws.rows(false)) 
{ 
    for (auto cell : row) 
    { 
        std::clog << cell.to_string() << std::endl;
    }
}
std::clog << "Processing complete" << std::endl;

Notice

Test

Travis CI

• See tested environments

To Do

• Testing in various Qt environments. :cloud:
• Unicode Test (filename, file path, data value) :umbrella:

License and links

• Qxlnt is under MIT License. https://github.com/QtExcel/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

:mailbox: Contact

• Please leave an issue to me. https://github.com/QtExcel/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

:star: QXlsx https://github.com/QtExcel/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)
• You don't need to use static library or dynamic shared object using QXlsx.

:star: Qlibxlsxwriter https://github.com/QtExcel/Qlibxlsxwriter

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

:star: QSimpleXlsxWriter https://github.com/QtExcel/QSimpleXlsxWriter

• Use SimpleXlsxWriter in Qt.
• SimpleXlsxWriter is C++ library for creating XLSX files for MS Excel 2007 and above.