Ask Your Question

Extract data from spreadsheet using c++ code

asked 2018-10-22 17:17:43 +0100

emp1953 gravatar image

I have a large number of MS Excel spreadsheets that contain data that I need to import into a c++ application to perform analysis. Are there any instructions / tutorials for doing this using c++.

Open the spreadsheet, extract certain sets of cells... etc

I have ancient code that does this using Visual Basic. I was hoping similar capabilities were available for LibreCalc.

Thanks for any info


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-22 17:59:02 +0100

erAck gravatar image

To interface with LibreOffice using C++ (via the UNO API) you'll need the SDK, see and

There's limited built-in support for VBA macros, for larger scale projects you'll probably have to rewrite in StarBASIC for the different document model and API of LibreOffice. One of the most extensive resources on this is Andrew Pitonyak's Macro Informationthat is applicable to LibreOffice as well. Some more pointers at

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-22 17:17:43 +0100

Seen: 118 times

Last updated: Oct 22 '18