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
1 answer

LibXL load file failure

Here is the code to load the xls/xlsx file: int main() { BookHandle book = xlCreateBook(); if(book) { if(xlBookLoad(book, L"Slice.xlsx")) { SheetHandle sheet = xlBookGetSheet(book, 0); …
Nick X Tsui
  • 2,737
  • 6
  • 39
  • 73
0
votes
1 answer

Eclipse debugging error with 64 bits libXL

When trying to debug this Eclipse CDT Project compiled with Mingw-w64 (build-info.txt) and clicked Debug as Local C/C++ Application, the following error is shown: Reinstalling Mingw-w64 didn't fix the problem. A sample Hello World C++ Project…
Prophet Daniel
  • 327
  • 2
  • 15
0
votes
1 answer

LibXL randomly (but consistantly) fails to read a string or number from a .XLS

Okay, here's the thing: I've been developing this program for quite a while now. Its function is to search, read, and organize data from various xls files. Everything compiles and works for the most part except for one thing: For some reason,…
HumbleWebDev
  • 555
  • 4
  • 20
0
votes
1 answer

erlang c-node passing binary objects

I was following Erlang C Nodes tutorial and was trying to make a wrapper call for libXl C library. In my C node a create a BookHandle and pass it as a response for one message call. BookHandle book = xlCreateBook(); resp = erl_format("{ok, ~w}",…
SubK24
  • 63
  • 5
0
votes
1 answer

Passing const char to incompatible type double

Whenever i define this string as a number, it gives me the error 'Passing const char to incompatible type double'. When i define the string as xlSheetWriteStr there are no issues but when i define it as a number it gives me the error. Here is the…
0
votes
1 answer

Extract Data LibXL C++

I downloaded LibXL to help modify a C++ program I've created. I have a bunch of global variables in my C++ file that I'd like to link to values in an excel spreadsheet. Can someone please explain how I'd do this if the excel sheet I'm linking to is…
0
votes
1 answer

Qt: Open csv files with libxl-compatible interface

In my app I use libxl library for read xls[x] files. Data taken from the files and shown into the table QTableWidget. But now I need to add support for read csv files. How I can do it compatible with current code (with libxl methods load(),…
vanchester
  • 277
  • 1
  • 4
  • 14
0
votes
1 answer

How to export excel file (xlsm format) with libXL library

In my iOS application, I want to generate the excel(.xlsm) file. I used the libXl library.(http://www.libxl.com/) This library can support Excel 97 -2003 formats (xls) and Excel 2007-2013 xml formats (xlsx/xlsm) by referencing in the home page. Now…
ammoe
  • 365
  • 5
  • 20
-1
votes
2 answers

How i free memory after const char* malloc?

I have problem with memory leaks I have loop which read data on EXCEL with LibXL library. Book* book3 = xlCreateXMLBook(); if (book3->load("Výmera Územia, využitie pôdy.xlsx")) { CellType cellType; Sheet* sheet =…
Hajducak Marek
  • 11
  • 1
  • 10
-1
votes
1 answer

Writing data using libxl library

I am calling the xlCreateBook() function. Before that my program holds more memory because i am reading a huge file. After called the xlCreateBook() it returns the null pointr to the Sheet variable. But once i loaded the less size file it…
Prakash
  • 11
  • 3
-1
votes
1 answer

incompatible pointer types passing nsstring to parameter of type const char (error)

I am using core data and libxl. Whenever i implement a Core Data string into libxl it gives me the error "incompatible pointer types passing nsstring to parameter of type const char" Dont know why... Here is my code, namelabel.text is the core data…
-3
votes
1 answer

How to fix 'Unhandled exception at in . Access violation writing location .' in visual studio 2017

I am writing code to make an invoice in excel by using the library libxl. My code creates a file, writes in it and then saves the file in the project folder. However, as I progress to debug it, I see an 'Unhandled exception', with access violation…
A_Singh7
  • 648
  • 7
  • 15
1 2
3