Stack Overflow
Stack Overflow

Questions tagged [libxl]

LibXL is a C++ library that can read and write Excel files. It includes C/C++ headers, Delphi unit and .NET assembly for including in your project.

LibXL is a library that can read and write Excel files. It doesn't require Microsoft Excel and .NET framework, combines an easy to use and powerful features.

Library can be used to:

  • Generate a new spreadsheet from scratch

  • Extract data from an existing spreadsheet

  • Edit an existing spreadsheet

42 questions
0
votes
0 answers

How to read a CELLTYPE_NUMBER type cell as a string by using the LibXL, so that the string is the same as what is displayed?

The readStr function returns an empty string, and there are multiple types of numbers, such as NUMFORMAT_GENERAL, NUMFORMAT_NUMBER, NUMFORMAT_NUMBER_D2, NUMFORMAT_NUMBER_SEP, etc. I just want to get a string that looks the same as what is…
1573mz mz
  • 1
  • 1
0
votes
1 answer

how to integrate libxl functions in c++

Im trying to read excel sheets of xlsx file and convert each sheet to a csv file using libxl i downloaded libxl 4.1.0 and followed this steps to integrate libxl in my code: https://www.libxl.com/codeblocks.html this is my code: #include…
Hela Mdaini
  • 1
  • 2
0
votes
1 answer

undefined reference to `xlCreateBookW'

While using the libxl library in QT(c++) I got this error undefined reference to `xlCreateBookW' I have tried the setup in their website, https://www.libxl.com/setup.html I added : INCLUDEPATH = C:\libxl-4.0.4.0\include_cpp LIBS +=…
Abdellah DIDI
  • 1
  • 2
0
votes
0 answers

libxl Library VS Code Setup

I've tried to use libxl library but there is no installation document for vs code even if I try to add header files there is an error message "no such file or directory" I also set settings include path to libxl include directory Vs Code (code and…
Pegasuss
  • 1
  • 1
0
votes
1 answer

What are these commands used in the following section when using the libxl library?

It's from the readme section on how to use libxl when I downloaded it and started using it in mingw-w64 What is the use of -I in this command? What is the use of -L in this command? What is the use of -lxl in this command? I can't figure out what…
Anonyman
  • 1
  • 1
0
votes
1 answer

What is the difference between the libraries libxl and libxls? (I am trying to use them in c)

I recently wanted to read an excel file in c using libxl. While doing some searches I came with a term libxls. What is the difference between libxl and libxls?
Anonyman
  • 1
  • 1
0
votes
1 answer

LibXL : how to force formulas to recalculate when MS excel file is opened?

In MS excel file user has set that formulas are manually recalculated. I would like to force auto recalculate with LibXL, after I write data to the file. Is this possible somehow ? I have searched documentation, and I couldn't find anything…
user11951115
  • 1
  • 1
0
votes
1 answer

How can I cast this char* into a String optional? Using xlSheetReadStrA from LibXL, checking for empty cells

Here is the signature declared in the framework header: const char* XLAPIENTRY xlSheetReadStrA(SheetHandle handle, int row, int col, FormatHandle* format); here is the documentation for ReadStr: http://www.libxl.com/spreadsheet.html here is how we…
A O
  • 5,516
  • 3
  • 33
  • 68
0
votes
1 answer

How to get PHP_excel working on windows wamp stack (ampps)

I am trying to add this extension to my php 5.3 running under Ampps localhost on windows: https://github.com/iliaal/php_excel I have downloaded the pre-built windows packages which contains: libxl.dll php_excel.dll php_excel.pdb I have put…
user794846
  • 1,881
  • 5
  • 29
  • 72
0
votes
1 answer

Can't pass wchar_t to LibXL writeStr

I'm tring to write Cyrillic characters into a spreadsheet that's being generated in an OSX app: sheet = xlBookAddSheet(book, "Output", 0); detailFormat = xlBookAddFormat(book, 0); wchar_t *w_user = (wchar_t*)malloc(max_chars *…
Todd
  • 1,770
  • 1
  • 17
  • 42
0
votes
0 answers

Cell Formatting Issue with *.xlsx file in PHP + libxl

I'm having 2 different issues here. Formatting is working fine with filename.xls format but not working with filename.xlsx (Microsoft office 2007) file format I tried to switch to filename.xls version but with this version our formulas like…
Pankaj
  • 571
  • 5
  • 20
0
votes
0 answers

Create and Send Out an Array of const wchar_t* in libxl.h

I am very new to programming, Thank you for bearing with me. I am in need of kind help to solve the issue I am facing, I need to read strings from an excel file (I am using the famous libxl.h library), store it in memory, and rearrange (with some…
Prietess
  • 1
0
votes
4 answers

Libxl background colors

I am trying to get custom colors working in libXL, I noticed there are like 80 basic colors or so in the library, does anyone know how to set a custom color for a cell using this library since in the documentation there is not any kind of…
DiegoCoderPlus
  • 760
  • 6
  • 14
0
votes
1 answer

Libxl readNum() crashes after a short time

Okay. So I'm using libXL to parse .xlsx files. I've experienced a strange bug, because when I call sheet->readNum(row, col) function it does its job, but only for like 45-47 times. I checked in many files. Checked both .xls and .xlsx. Done multiple…
minecraftplayer1234
  • 2,127
  • 4
  • 27
  • 57
0
votes
2 answers

libxl library setup in C++ on Windows

I am trying to use the library libxl in C++/VS2012. However, I got the error message the program can't start because libxl.dll is missing from your computer I have well followed the instructions for the setup of this library such as adding…
rado
  • 401
  • 3
  • 8
  • 16
1
2
3