github-starred/libxlsxwriter

Fork 0

mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-15 14:15:54 -06:00

[GH-ISSUE #124] Guide: How to build under Qt-Creator / Windows (MinGW) #104

New issue

Closed

opened 2026-05-05 11:41:03 -06:00 by gitea-mirror · 5 comments

gitea-mirror commented

2026-05-05 11:41:03 -06:00

Owner

Originally created by @petricf on GitHub (Sep 4, 2017).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/124

Originally assigned to: @jmcnamara on GitHub.

Qt-Creator (http://qt.io) is a multi-platform/-compiler IDE. Platform here: Windows 7
Under Windows (if you want to avoid MS VisualStudio) you can use the MingGW compiler bundled with it. mingw32_make.exe is also included.
This guide is to build libxlsxwriter w/o installing MSYS (how i did it). Reason: Minimize packages to be installed and use the MinGW-compiler bundled with Qt-Creator.

Get CMake (https://cmake.org/download/) - 64 or 32Bit should be irrelevant - and install it
Get Zlib (http://gnuwin32.sourceforge.net/packages/zlib.htm) - both binaries and developer files *.zip
Unpack developer files to (in my case) C:/Qt/Tools/zlib/*
3.a. Unpack contents bin directory from binary files to C:/Qt/Tools/zlib/lib/*
Clone or unpack release to a project dir
Start Qt-Creator
5.a. Menu "Extras" -> Settings
5.b. Select "Build and Execution"
5.c. Select Tab "CMake" and define the Location of cmake.exe (from Step 1)
5.d. Select Tab "Kits" and choose the Kit (here: Desktop Qt 5.9.0 MinGW 5.3.0)
5.e. In the lines appearing below labeled "CMake-Tool" select the CMake defined in 5.c.
5.e. At the last line labeled "CMake-Configuration" push the button "Change"
5.f. In the dialog box appearing then add the lines (path value given at Step 3):

ZLIB_INCLUDE_DIR:FILEPATH=C:/Qt/Tools/zlib/include
ZLIB_LIBRARY:FILEPATH=C:/Qt/Tools/zlib/lib/zlib.lib

Remark: ZLIB_ROOT setting does not work (at least not here)

Create a new session/project and open CMakeLists.txt (CMake analysis step starts immediately)
Press the compile button (or menu item).
Option: Copy the resulting libxlslibwriter.a and the includes to C:/Qt/Tools/xlsxlib/[include|lib]

One problem i have currently is that it only creates a static library but no shared library (aka *.dll).

In a project using libxlsxwriter the qmake *.pro file requires two lines:

INLCLUDEPATH += [directory of libxlsxwriter includes]
LIBS += -L[directory of libxlsxwriter.a] -lxlsxwriter.a -lz

The zlib used to build xlsxwriter above is no more required - Qt comes with a own version but misses zlib.lib required for linking libxlsxwriter.

Hope that helps.

Originally created by @petricf on GitHub (Sep 4, 2017). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/124 Originally assigned to: @jmcnamara on GitHub. Qt-Creator (http://qt.io) is a multi-platform/-compiler IDE. Platform here: Windows 7 Under Windows (if you want to avoid MS VisualStudio) you can use the MingGW compiler bundled with it. mingw32_make.exe is also included. This guide is to build libxlsxwriter w/o installing MSYS (how i did it). Reason: Minimize packages to be installed and use the MinGW-compiler bundled with Qt-Creator. 1. Get CMake (https://cmake.org/download/) - 64 or 32Bit should be irrelevant - and install it 2. Get Zlib (http://gnuwin32.sourceforge.net/packages/zlib.htm) - both binaries and developer files *.zip 3. Unpack developer files to (in my case) C:/Qt/Tools/zlib/* 3.a. Unpack contents bin directory from binary files to C:/Qt/Tools/zlib/lib/* 4. Clone or unpack release to a project dir 5. Start Qt-Creator 5.a. Menu "Extras" -> Settings 5.b. Select "Build and Execution" 5.c. Select Tab "CMake" and define the Location of cmake.exe (from Step 1) 5.d. Select Tab "Kits" and choose the Kit (here: Desktop Qt 5.9.0 MinGW 5.3.0) 5.e. In the lines appearing below labeled "CMake-Tool" select the CMake defined in 5.c. 5.e. At the last line labeled "CMake-Configuration" push the button "Change" 5.f. In the dialog box appearing then add the lines (path value given at Step 3): > ZLIB_INCLUDE_DIR:FILEPATH=C:/Qt/Tools/zlib/include > ZLIB_LIBRARY:FILEPATH=C:/Qt/Tools/zlib/lib/zlib.lib Remark: ZLIB_ROOT setting does not work (at least not here) 6. Create a new session/project and open CMakeLists.txt (CMake analysis step starts immediately) 7. Press the compile button (or menu item). 8. Option: Copy the resulting libxlslibwriter.a and the includes to C:/Qt/Tools/xlsxlib/[include|lib] One problem i have currently is that it only creates a static library but no shared library (aka *.dll). In a project using libxlsxwriter the qmake *.pro file requires two lines: > INLCLUDEPATH += [directory of libxlsxwriter includes] > LIBS += -L[directory of libxlsxwriter.a] -lxlsxwriter.a -lz The zlib used to build xlsxwriter above is no more required - Qt comes with a own version but misses zlib.lib required for linking libxlsxwriter. Hope that helps.

gitea-mirror

2026-05-05 11:41:04 -06:00

closed this issue
added the
docs

medium term
labels

gitea-mirror commented

2026-05-05 11:41:10 -06:00

Author

Owner

@jmcnamara commented on GitHub (Sep 5, 2017):

Thanks. Those are useful instructions. When I get a chance I'll try it out and maybe add it to the docs.

It would probably be useful would be if you uploaded a sample QT project to Github.

@jmcnamara commented on GitHub (Sep 5, 2017): Thanks. Those are useful instructions. When I get a chance I'll try it out and maybe add it to the docs. It would probably be useful would be if you uploaded a sample QT project to Github.

gitea-mirror commented

2026-05-05 11:41:15 -06:00

Author

Owner

@petricf commented on GitHub (Sep 22, 2017):

Attached a sample Qt GUI application designed like the minimal test in your package.

Simply open the *.pro file inside the Qt-Creator IDE (downloaded/installed from http://qt.io).

The *.pro file contains the reference to the includes and libs created in the steps above. I copied them to C:\Qt\Tools\xlsxwriter\include and C:\Qt\Tools\xlsxwriter\libs.

Hope it helps. Sorry i am currently not good in using git.

xlsxwriter-test.zip

@petricf commented on GitHub (Sep 22, 2017): Attached a sample Qt GUI application designed like the minimal test in your package. Simply open the *.pro file inside the Qt-Creator IDE (downloaded/installed from http://qt.io). The *.pro file contains the reference to the includes and libs created in the steps above. I copied them to C:\Qt\Tools\xlsxwriter\include and C:\Qt\Tools\xlsxwriter\libs. Hope it helps. Sorry i am currently not good in using git. [xlsxwriter-test.zip](https://github.com/jmcnamara/libxlsxwriter/files/1325769/xlsxwriter-test.zip)

gitea-mirror commented

2026-05-05 11:41:19 -06:00

Author

Owner

@petricf commented on GitHub (Sep 22, 2017):

Oh, i forgot - sure this is an application simply using the C-interface of libxlsxwriter directly.

Currently i am designing Qt classes inspired by https://github.com/Alexhuszagh/libxlsxwriterpp.

@petricf commented on GitHub (Sep 22, 2017): Oh, i forgot - sure this is an application simply using the C-interface of libxlsxwriter directly. Currently i am designing Qt classes inspired by https://github.com/Alexhuszagh/libxlsxwriterpp.

gitea-mirror commented

2026-05-05 11:41:24 -06:00

Author

Owner

@jmcnamara commented on GitHub (Sep 23, 2017):

Thanks for the contribution. I'm sure someone will find it useful.

@jmcnamara commented on GitHub (Sep 23, 2017): Thanks for the contribution. I'm sure someone will find it useful.

gitea-mirror commented

2026-05-05 11:41:26 -06:00

Author

Owner

@petricf commented on GitHub (Jan 21, 2020):