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
33
votes
0 answers

LibXL: excel cross-sheet formulas not updated

I'm dealing with a problem with libXL and Office365. I created an Excel file with Office 365: a simple formula which shows the content of a cell from another sheet. Then I proceeded to write something in that source cell through libXl. When I open…
Davide
  • 439
  • 3
  • 8
4
votes
1 answer

How can I correctly use libXL from Perl 6 using NativeCall?

I try to use libXL from Perl 6 (latest version) with NativeCall. I can't get utf-8 to correctly save the created xlsx file. Only CArray[uint16] seems to work nor Str is encoded('utf8') nor CArray[uint8]. Best result is saved workbook, sheet name and…
HanTyr
  • 43
  • 1
  • 4
3
votes
1 answer

C++ QT libXL Error: "During Startup program exited with code 0xc0000135"

I am trying to write a QT application that uses libXL, but when I try to compile, I get a pop up box saying "During Startup program exited with code 0xc0000135". I have figured out exactly which line causes the problem, it is the "Book* book =…
atomiczap
  • 91
  • 2
  • 3
2
votes
1 answer

libxl library use in c++

When I create a project visual studio 2015 I can work this libxl library hovewer I could not be able to work that library on visual studio qt gui application project. I try everything whatever I know. #include "stdafx.h" #include…
Osman
  • 21
  • 2
2
votes
3 answers

Libxl + windows + QT

I installed libxl package file from offcial website. It contains header files in include_cpp folder and libxl.lib in libs folder. I am using QT(cpp) to run my project. I was able to link libxl package to QT in linux (by editing its .pro file by…
user1496071
  • 25
  • 5
1
vote
1 answer

how to read xlsx files using C

Part of my school project I need to work with LabWindows/CVI. I need to read a xlsx file and analize it. I download this libxl library. I amported the h files and the lib files. this is my code ( I coppied it from here): #include …
Kenny Smith
  • 729
  • 3
  • 9
  • 23
1
vote
1 answer

Error in executing code of C++ (CodeBlocks) when using LibXL

I am trying to execute this code for my Mini project using a third party library called LibXL[for C++] on CodeBlocks. #include "libxl.h" #include #include #include #ifdef _UNICODE typedef WCHAR TCHAR; #else typedef char…
Priyank
  • 341
  • 2
  • 11
1
vote
1 answer

Convert Swift String to wchar_t

For context: I'm trying to use the very handy LibXL. I've used it with success in Obj-C and C++ but am now trying to port over to Swift. In order to better support Unicode, I need to sent all strings to the LibXL api as wchar_t*. So, for this…
Todd
  • 1,770
  • 1
  • 17
  • 42
1
vote
1 answer

php_excel / libxl : How to make part of the cell text bold

With PHPExcel library with RichText objects, it's possible to set specific styles to some parts of cell text. An example is given on this post : PHPExcel - How to make part of the text bold How to do this with php extension php_excel based on libxl…
Koryonik
  • 2,728
  • 3
  • 22
  • 27
1
vote
2 answers

How to embed formulas in libxl for ios

I want to be able to add some simple formulas to libxl like addition and subtraction, just dont know how to do it. Just wondering how to add simple addition and subtraction formulas. Here is my code : - (IBAction)createExcel:(id)sender { …
Flare gun
  • 13
  • 5
1
vote
1 answer

Fatal Error: Call to a member function write() on a non-object occurs when memory usage is very high

I've been working on a web-based application to export database information through PHP. The original version of the application originally generated a single OpenXML worksheet, but ran into the issue that beyond a certain number of rows…
user2985939
  • 19
  • 1
  • 3
1
vote
1 answer

const char* not being interpreted correctly by C++ to Excel library

I am trying to use libXl to output text from a C++ program to an Excel file. The problem is coming with this library function: bool writeStr(int row, int col, const wchar_t* value, Format* format = 0) Writes a string into cell with specified…
Abhishek Bansal
  • 12,589
  • 4
  • 31
  • 46
1
vote
1 answer

libXL with php_excel Read Performance

I have to read large Excel Files in PHP (>2M Cell). I have tried the PHP Class phpExcel, but the Performance is worse. Now, i found the libXL Libary (http://www.libxl.com/) und the PHP Wrapper php_excel for…
rouven
  • 13
  • 1
  • 6
1
vote
1 answer

Excel Formula Calculations

I'm trying to add a spreadsheet editing function in my iOS app. I am using a gridview to display (not relevant to the question) and I am using LibXL to load the data into the view. That part all works very well but I have no way to calculate the…
mkral
  • 4,065
  • 4
  • 28
  • 53
1
vote
1 answer

Can't get LibXL xlSheetGetNamedRange to work

I am trying to work with LibXL. I can extract data from sheets, but need a function to transform a string with Excel row and column indices into startRow, endRow, startCol, endCol i.e. "A1:B3" into startRow = 0, endRow = 2, startCol = 0, endCol = 1…
JJ3
  • 133
  • 1
  • 5
1
2 3