github-starred/libxlsxwriter
2
0
Fork 0
mirror of https://github.com/jmcnamara/libxlsxwriter.git synced 2026-05-15 14:15:54 -06:00
Code Issues 16 Projects Packages Wiki Activity Actions

[GH-ISSUE #79] Building 32-bit version of libxlsxwriter with MSYS2 and Mingw-w64 #66

New issue
Closed
opened 2026-05-05 11:35:30 -06:00 by gitea-mirror · 13 comments
gitea-mirror commented 2026-05-05 11:35:30 -06:00
Owner
Copy link

Originally created by @Z3ROQL on GitHub (Nov 20, 2016).
Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/79

Originally assigned to: @jmcnamara on GitHub.

Hello. I successfully built my first application using MSYS2 and Mingw-64. Now I want to build a 32-bit version of it, so I installed the 32-bit version of gcc from MSYS2, opened up the MINGW32 shell and ran the usual command: gcc example.cpp -o example -lxlsxwriter -lz. The problem is that the linker cannot find the library. Here's the error:

C:/msys64/mingw32/bin/../lib/gcc/i686-w64-mingw32/6.2.0/../../../../i686-w64-mingw32/bin/ld.exe: cannot find -lxlsxwriter
collect2.exe: error: ld returned 1 exit status

So I thought: "Should I remove my already existing library and make it again?". So I did it: I ran make and make install, but nothing changed.

UPDATE: I also tried to use CFLAGS='-m32' make and CFLAGS='-m32' make install, but nothing changed.

Originally created by @Z3ROQL on GitHub (Nov 20, 2016). Original GitHub issue: https://github.com/jmcnamara/libxlsxwriter/issues/79 Originally assigned to: @jmcnamara on GitHub. Hello. I successfully built my first application using MSYS2 and Mingw-64. Now I want to build a 32-bit version of it, so I installed the 32-bit version of gcc from MSYS2, opened up the MINGW32 shell and ran the usual command: `gcc example.cpp -o example -lxlsxwriter -lz`. The problem is that the linker cannot find the library. Here's the error: ``` C:/msys64/mingw32/bin/../lib/gcc/i686-w64-mingw32/6.2.0/../../../../i686-w64-mingw32/bin/ld.exe: cannot find -lxlsxwriter collect2.exe: error: ld returned 1 exit status ``` So I thought: "Should I remove my already existing library and `make` it again?". So I did it: I ran `make` and `make install`, but nothing changed. **UPDATE**: I also tried to use `CFLAGS='-m32' make` and `CFLAGS='-m32' make install`, but nothing changed.
gitea-mirror 2026-05-05 11:35:30 -06:00
gitea-mirror commented 2026-05-05 11:35:39 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Nov 20, 2016):

Hi @Z3ROQL,

Did make install work correctly?

Either way you can try this fallback from the Libxlsxwriter installation guide :

If the installation didn't work for you then you can link against the static library you created in the "Build the source code" step:

cc myexcel.c -o myexcel -I /path/to/libxlsxwriter/include \
                           /path/to/libxlsxwriter/lib/libxlsxwriter.a -lz

See also this online documentation on HOWTO Specify the Location of Libraries for use with MinGW.

<!-- gh-comment-id:261793977 --> @jmcnamara commented on GitHub (Nov 20, 2016): Hi @Z3ROQL, Did `make install` work correctly? Either way you can try this fallback from the Libxlsxwriter [installation guide](http://libxlsxwriter.github.io/getting_started.html#gsg_using) : > If the installation didn't work for you then you can link against the static library you created in the "[Build the source code](http://libxlsxwriter.github.io/getting_started.html#gsg_build)" step: > > ``` > cc myexcel.c -o myexcel -I /path/to/libxlsxwriter/include \ > /path/to/libxlsxwriter/lib/libxlsxwriter.a -lz > ``` See also this online documentation on [HOWTO Specify the Location of Libraries for use with MinGW](http://www.mingw.org/wiki/LibraryPathHOWTO).
gitea-mirror commented 2026-05-05 11:35:42 -06:00
Author
Owner
Copy link

@Z3ROQL commented on GitHub (Nov 20, 2016):

make install worked correctly. I executed this command ---> cc main.cpp -o main -I c:/msys64/home/z3roql/libxlsxwriter/include \c:/msys64/home/z3roql/libxlsxwriter/lib/libxlsxwriter.a -lz and now it gives me this error ---> C:\msys64\tmp\ccUeeXG4.o:main.cpp:(.text+0x16): undefined reference to 'workbook_new' (for every function in main.cpp).

<!-- gh-comment-id:261797492 --> @Z3ROQL commented on GitHub (Nov 20, 2016): `make install` worked correctly. I executed this command ---> `cc main.cpp -o main -I c:/msys64/home/z3roql/libxlsxwriter/include \c:/msys64/home/z3roql/libxlsxwriter/lib/libxlsxwriter.a -lz` and now it gives me this error ---> `C:\msys64\tmp\ccUeeXG4.o:main.cpp:(.text+0x16): undefined reference to 'workbook_new'` (for every function in `main.cpp`).
gitea-mirror commented 2026-05-05 11:35:46 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Nov 21, 2016):

What happen if you do make examples?

<!-- gh-comment-id:261867411 --> @jmcnamara commented on GitHub (Nov 21, 2016): What happen if you do `make examples`?
gitea-mirror commented 2026-05-05 11:35:49 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Nov 21, 2016):

Also is it correct that the lib path is escaped: \c:/msys64/home/...

<!-- gh-comment-id:261867984 --> @jmcnamara commented on GitHub (Nov 21, 2016): Also is it correct that the lib path is escaped: ` \c:/msys64/home/...`
gitea-mirror commented 2026-05-05 11:35:49 -06:00
Author
Owner
Copy link

@Z3ROQL commented on GitHub (Nov 21, 2016):

What happen if you do make examples?

If I do make examples it gives me a bunch of undefined reference to [...] errors ---> make[1]: entering directory "/home/z3roql/libxlsxwriter/examples" C:\msys64\tmp\ccSMi9UL.o: In function 'write_worksheet_data': C:\msys64\home\z3roql\libxlsxwriter\examples/chart_scatter.c:26: undefined reference to 'lxw_name_to_col' [...]

Also is it correct that the lib path is escaped: \c:/msys64/home/...

Yes, I think it's correct since it doesn't output any syntax error.

<!-- gh-comment-id:262041396 --> @Z3ROQL commented on GitHub (Nov 21, 2016): > What happen if you do `make examples`? If I do `make examples` it gives me a bunch of `undefined reference to [...]` errors ---> ```make[1]: entering directory "/home/z3roql/libxlsxwriter/examples" C:\msys64\tmp\ccSMi9UL.o: In function 'write_worksheet_data': C:\msys64\home\z3roql\libxlsxwriter\examples/chart_scatter.c:26: undefined reference to 'lxw_name_to_col' [...]``` > Also is it correct that the lib path is escaped: `\c:/msys64/home/...` Yes, I think it's correct since it doesn't output any syntax error.
gitea-mirror commented 2026-05-05 11:35:51 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Nov 22, 2016):

I'm afraid I can't help you with this. I retested with MSYS2 32bit using the latest installer: http://repo.msys2.org/distrib/i686/msys2-i686-20161025.exe

Then I ran the installation instructions from the docs:

# Install MSYS2 64 or 32 bit from http://msys2.github.io/

# Install the dev tools for libxlsxwriter.
pacman -S git gcc make zlib-devel

# Clone and build libxlsxwriter.
git clone https://github.com/jmcnamara/libxlsxwriter.git
cd libxlsxwriter/
make

Everything worked fine as did make examples and make test_unit.

I think that you should verify that all of that works for you first.

<!-- gh-comment-id:262211556 --> @jmcnamara commented on GitHub (Nov 22, 2016): I'm afraid I can't help you with this. I retested with MSYS2 32bit using the latest installer: http://repo.msys2.org/distrib/i686/msys2-i686-20161025.exe Then I ran the installation instructions from the docs: ``` # Install MSYS2 64 or 32 bit from http://msys2.github.io/ # Install the dev tools for libxlsxwriter. pacman -S git gcc make zlib-devel # Clone and build libxlsxwriter. git clone https://github.com/jmcnamara/libxlsxwriter.git cd libxlsxwriter/ make ``` Everything worked fine as did `make examples` and `make test_unit`. I think that you should verify that all of that works for you first.
gitea-mirror commented 2026-05-05 11:35:52 -06:00
Author
Owner
Copy link

@Z3ROQL commented on GitHub (Nov 22, 2016):

I'll try to download and install again MSYS2. Thank you for answering. I'll post a comment here when I'm done.

<!-- gh-comment-id:262234768 --> @Z3ROQL commented on GitHub (Nov 22, 2016): I'll try to download and install again MSYS2. Thank you for answering. I'll post a comment here when I'm done.
gitea-mirror commented 2026-05-05 11:35:56 -06:00
Author
Owner
Copy link

@Z3ROQL commented on GitHub (Nov 22, 2016):

Ok. I downloaded and installed everything again. Now it compiles without any problem, but it gives me this error code when I try to execute it: 0xc000007b.

<!-- gh-comment-id:262301226 --> @Z3ROQL commented on GitHub (Nov 22, 2016): Ok. I downloaded and installed everything again. Now it compiles without any problem, but it gives me this error code when I try to execute it: `0xc000007b`.
gitea-mirror commented 2026-05-05 11:35:59 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Nov 22, 2016):

but it gives me this error code when I try to execute it: 0xc000007b.

What gives an error code? What are you running?

Do you get the same error if you run the following from the shell after the commands above:

 ./examples/hello.exe

The issue may be that you don't have admin rights to write to the Windows TEMP. You can try run in Admin mode or use a different TEMP folder as explained here in the docs: http://libxlsxwriter.github.io/getting_started.html#gsg_tmpdir

Make sure the dir in .tmpdir = "C:\\Temp" is writable by you/your application.

<!-- gh-comment-id:262306795 --> @jmcnamara commented on GitHub (Nov 22, 2016): > but it gives me this error code when I try to execute it: 0xc000007b. What gives an error code? What are you running? Do you get the same error if you run the following from the shell after the commands above: ./examples/hello.exe The issue may be that you don't have admin rights to write to the Windows TEMP. You can try run in Admin mode or use a different TEMP folder as explained here in the docs: http://libxlsxwriter.github.io/getting_started.html#gsg_tmpdir Make sure the dir in `.tmpdir = "C:\\Temp"` is writable by you/your application.
gitea-mirror commented 2026-05-05 11:36:01 -06:00
Author
Owner
Copy link

@Z3ROQL commented on GitHub (Nov 22, 2016):

What gives an error code? What are you running?

I'm running my test program.

Do you get the same error if you run the following from the shell after the commands above:

./examples/hello.exe

EDIT: I don't get any error, but I also don't get any .xlsx file. If I try to double-click on the binary, it gives me the 0xc000007b error.

I tried running my program as Administrator but with same results. Also, I don't think that the TEMP directory is a problem since it works perfectly with the other 64-bit program I made before.

UPDATE: Ok... This is REALLY strange. For some reason if I run the program from the MSYS2 shell using this command ---> ./main.exe everything works. However, if I try to double-click on the binary to execute it, it gives me the aforementioned error. I'm confused...

<!-- gh-comment-id:262329831 --> @Z3ROQL commented on GitHub (Nov 22, 2016): > What gives an error code? What are you running? I'm running my test program. > Do you get the same error if you run the following from the shell after the commands above: > > ` ./examples/hello.exe` **EDIT**: I don't get any error, but I also don't get any `.xlsx` file. If I try to double-click on the binary, it gives me the `0xc000007b ` error. I tried running my program as Administrator but with same results. Also, I don't think that the TEMP directory is a problem since it works perfectly with the other 64-bit program I made before. **UPDATE**: Ok... This is REALLY strange. For some reason if I run the program from the MSYS2 shell using this command ---> `./main.exe` everything works. However, if I try to double-click on the binary to execute it, it gives me the aforementioned error. I'm confused...
gitea-mirror commented 2026-05-05 11:36:03 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Nov 23, 2016):

Maybe the issue is that you are trying to run a 32bit application in a 64bit version of Windows.

There are some suggestion here on fixing the 0xc000007b error code: http://www.techcrises.com/how-to/how-to-fix-error-code-0xc000007b-in-windows-7-8-8-1/

I'd suggest "Method 4 : Fix Compatibility Issue Between System and Application".

<!-- gh-comment-id:262483211 --> @jmcnamara commented on GitHub (Nov 23, 2016): Maybe the issue is that you are trying to run a 32bit application in a 64bit version of Windows. There are some suggestion here on fixing the 0xc000007b error code: http://www.techcrises.com/how-to/how-to-fix-error-code-0xc000007b-in-windows-7-8-8-1/ I'd suggest "Method 4 : Fix Compatibility Issue Between System and Application".
gitea-mirror commented 2026-05-05 11:36:05 -06:00
Author
Owner
Copy link

@jmcnamara commented on GitHub (Nov 23, 2016):

Here is another link that suggests the issue is mixing 32bit code and 64bit dlls (or vice versa): https://msoos.wordpress.com/2010/09/11/0xc000007b-error-solution/

<!-- gh-comment-id:262484157 --> @jmcnamara commented on GitHub (Nov 23, 2016): Here is another link that suggests the issue is mixing 32bit code and 64bit dlls (or vice versa): https://msoos.wordpress.com/2010/09/11/0xc000007b-error-solution/
gitea-mirror commented 2026-05-05 11:36:06 -06:00
Author
Owner
Copy link

@Z3ROQL commented on GitHub (Nov 23, 2016):

YES! Finally! I love you! I used Dependency Walker as you suggested and replaced msys-2.0.dll, msys-gcc_s-1.dll and msys-z.dll from my project folder (they were 64-bit instead of 32-bit) and now everything works again! 💃

<!-- gh-comment-id:262485791 --> @Z3ROQL commented on GitHub (Nov 23, 2016): YES! Finally! I love you! I used Dependency Walker as you suggested and replaced `msys-2.0.dll`, `msys-gcc_s-1.dll` and `msys-z.dll` from my project folder (they were 64-bit instead of 32-bit) and now everything works again! 💃
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
coverity
cmake-improvements
cmake_pkgconfig_fix
ctest
button
tables
autofilter
dtoa
iwyu
openssl
gentoo
gh310
condition_format
rich_string_html
header_footer_images
custom_data_labels
object_position
gh265
constant_mode_comments2
constant_mode_comments
vml
md5
vcpkg
hyperlinks
api_refactor
win_fopen
gh203
rich_strings
chartsheet
in_mem_image
gh192
revert-162-master
data_validation
meson
charts
scan_build
utf8_strlen
tmpfileplus
custom_properties
insert_image
default_row
control_chars
worksheet_protect
dev
red_black
panes
mkstemp
defined_names
optimise
wip
v1.2.4
v1.2.3
v1.2.2
v1.2.1
v1.2.0
v1.1.9
v1.1.8
RELEASE_1.1.7
RELEASE_1.1.6
RELEASE_1.1.5
RELEASE_1.1.4
RELEASE_1.1.3
RELEASE_1.1.2
RELEASE_1.1.1
RELEASE_1.1.0
RELEASE_1.0.9
RELEASE_1.0.8
RELEASE_1.0.7
RELEASE_1.0.6
RELEASE_1.0.5
RELEASE_1.0.4
RELEASE_1.0.3
RELEASE_1.0.2
RELEASE_1.0.1
RELEASE_1.0.0
RELEASE_0.9.9
RELEASE_0.9.8
RELEASE_0.9.7
RELEASE_0.9.6
RELEASE_0.9.5
RELEASE_0.9.4
RELEASE_0.9.3
RELEASE_0.9.2
RELEASE_0.9.1
RELEASE_0.9.0
RELEASE_0.8.9
RELEASE_0.8.8
RELEASE_0.8.7
RELEASE_0.8.6
RELEASE_0.8.5
RELEASE_0.8.4
RELEASE_0.8.3
RELEASE_0.8.2
RELEASE_0.8.1
RELEASE_0.8.0
RELEASE_0.7.9
RELEASE_0.7.8
RELEASE_0.7.7
RELEASE_0.7.6
RELEASE_0.7.5
RELEASE_0.7.4
RELEASE_0.7.3
RELEASE_0.7.2
RELEASE_0.7.1
RELEASE_0.7.0
RELEASE_0.6.9
RELEASE_0.6.8
RELEASE_0.6.7
RELEASE_0.6.6
RELEASE_0.6.5
RELEASE_0.6.4
RELEASE_0.6.3
RELEASE_0.6.2
RELEASE_0.6.1
RELEASE_0.6.0
RELEASE_0.5.9
RELEASE_0.5.8
RELEASE_0.5.7
RELEASE_0.5.6
RELEASE_0.5.5
RELEASE_0.5.4
RELEASE_0.5.3
RELEASE_0.5.2
RELEASE_0.5.1
RELEASE_0.5.0
RELEASE_0.4.9
RELEASE_0.4.8
RELEASE_0.4.7
RELEASE_0.4.6
RELEASE_0.4.5
RELEASE_0.4.4
RELEASE_0.4.3
RELEASE_0.4.2
RELEASE_0.4.1
RELEASE_0.4.0
RELEASE_0.3.9
RELEASE_0.3.8
RELEASE_0.3.7
RELEASE_0.3.6
RELEASE_0.3.5
RELEASE_0.3.4
RELEASE_0.3.3
RELEASE_0.3.2
RELEASE_0.3.1
RELEASE_0.3.0
RELEASE_0.2.9
RELEASE_0.2.8
RELEASE_0.2.7
RELEASE_0.2.6
RELEASE_0.2.5
RELEASE_0.2.4
RELEASE_0.2.3
RELEASE_0.2.2
RELEASE_0.2.1
RELEASE_0.2.0
RELEASE_0.1.9
RELEASE_0.1.8
RELEASE_0.1.7
RELEASE_0.1.6
RELEASE_0.1.5
RELEASE_0.1.4
RELEASE_0.1.3
RELEASE_0.1.2
RELEASE_0.1.1
RELEASE_0.1.0
RELEASE_0.0.9
RELEASE_0.0.8
RELEASE_0.0.7
RELEASE_0.0.6
RELEASE_0.0.5
RELEASE_0.0.4
RELEASE_0.0.3
RELEASE_0.0.2
RELEASE_0.0.1
Labels
Clear labels   
awaiting user feedback

   
bug

   
cmake

   
cmake

   
docs

   
feature request

   
in progress

   
long term

   
medium term

   
medium term

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
question

   
ready to close

   
short term

   
under investigation

   
wontfix
No labels
awaiting user feedback
bug
cmake
cmake
docs
feature request
in progress
long term
medium term
medium term
pull-request
question
question
ready to close
short term
under investigation
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github-starred/libxlsxwriter#66
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?