Stack Overflow
Stack Overflow

Questions tagged [libxlsxwriter]

Libxlsxwriter is a C library for creating Excel XLSX files

Libxlsxwriter is a C library that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file.

It is a port of the Python XlsxWriter and Perl Excel::Writer::XLSX modules.

20 questions
2
votes
1 answer

Problem with the libxlsxwriter libary (MSYS2)

I installed the libxlsxwriter library in MSYS2 MinGW 64-bit with the pacman -S mingw-w64-x86_64-libxlsxwriter command. Now I can't compile the standard test file from https://libxlsxwriter.github.io/getting_started.html on Visual Studio Code. The…
Bob19
  • 41
  • 2
2
votes
1 answer

XSLXWriter Insert multiple images at center of cell in a column

I am trying to use libxlsxwriter to insert images in a column row by row but the images are out of cell bound and on top of each other. Edit: I found that this line of code might be causing some issues…
mj1261829
  • 1,200
  • 3
  • 26
  • 53
2
votes
1 answer

Use libxlsxwriter without CocoaPods in a macOS project

My project (Objective C, macOS, Xcode 11) does not use CocoaPods and I'd like to keep it that way. I want to use libxlsxwriter to export data in Excel format. I cloned libxlsxwriter from GitHub and built it. Now I have libxlsxwriter.a and…
Dirk
  • 2,335
  • 24
  • 36
2
votes
1 answer

chartcheet on libxlsxwriter

I'm trying to use the libxlsxwriter C library but I'm struggling to make chartsheets on a new excel sheet (and not a basic chart on a sheet between formulas). Any Ideas ? Even on how-to hardcode this ? Edit This is what I've done so far…
Wired
  • 23
  • 5
2
votes
1 answer

undefined reference to [...] when building program with libxlsxwriter

I'm trying to make a program that interacts with MS Excel using libxlsxwriter. I'm using MSYS2 with Mingw-w64 to build my application. Whenever I try to compile my code with the 64-bit version of gcc, everything works flawlessly; however, If I try…
sgrontflix
  • 91
  • 1
  • 9
2
votes
1 answer

Linking C library to R

I recently found this C library (http://libxlsxwriter.github.io/), and attempted to use it with R. Getting the C library to work by itself was not difficult. I downloaded zlib and libxlsxwriter using msys2, and ran make in the libxlsxwriter…
Carl
  • 5,569
  • 6
  • 39
  • 74
2
votes
1 answer

Running libxlsxwriter on Windows

I am trying to use libxlsxwriter, but I can seem to get things to compile or run correctly. I followed the directions for Windows using Mingw-w64 and msys2 available here: http://libxlsxwriter.github.io/getting_started.html. I installed msys2 from…
Carl
  • 5,569
  • 6
  • 39
  • 74
2
votes
1 answer

Setting path to shared library inside a makefile for compile

I want to compile a program using makefile which is linked against the zlib shared libraries which it is different from the one installed on my system. But I don't want them to be permanently added to the library pool of my system. The path of…
famedoro
  • 1,223
  • 2
  • 17
  • 41
1
vote
0 answers

How to change the output location of the excel file in Libxlsxwriter library in c++

I'm trying to output some data from MySQL to an excel file using libxlsxwriter library in c++. I have a problem in changing the output directory of the excel file. from this code, it saves to the original folder where the .cpp file located. Can…
Dilshan Madulanka
  • 25
  • 5
1
vote
2 answers

Error when trying to export data frame using write_xlsx

Been using R for around two years now and this is the first time i've encountered this issue. I have a data.frame with approx 31,000 rows and 400 cols and I want to export to an excel sheet using write_xlsx When I try this I get the following…
pdunbar
  • 33
  • 1
  • 5
1
vote
2 answers

libxlsxwriter multiple formats on a cell

First time poster, long time reader! I am using libxlsxwriter in C. I want to color rows either green or red and give the columns a different format each (which is either a date, a 2 decimal number or a 7 decimal number, or default. the problem is…
ApA
  • 11
  • 1
1
vote
1 answer

libxlsxwriter with MinGW

For two days I have spent several hours trying to get libxlsxwriter to work with mingw on Windows. I followed the instructions to install and build the library, but every time I attempt to include the header files in one of my projects and use one…
user11963593
1
vote
1 answer

Reading Cell Value in Excel using Libxlsxwriter?

I want to read the result of the cell value into a variable. The cell which was used as an array formula to calculate the XIRR value. can I do this using libxlsxwriter?
Robert
  • 67
  • 5
1
vote
1 answer

Libxlsxwriter build error on HP-UX

I'm trying to compile a library libxlsxwriter by following instruction available on https://libxlsxwriter.github.io/getting_started.html I'm on HP-UX dev B.11.31 U ia64 unlimited-user license. Getting error Make: Must be a separator on rules line…
Vishwanath Dalvi
  • 35,388
  • 41
  • 123
  • 155
1
vote
2 answers

How do I print image on their original size in Excel using libxlsxwriter?

I just started to use libxlsxwriter to create excel sheet. My problem is I don't know how to centralized the picture and how to print pictures on their original size. Just consider the set having only 3 columns and each column having different size…
Robert
  • 67
  • 5
1
2