Ask Your Question
0

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

emp1953

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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 https://api.libreoffice.org/ and https://wiki.documentfoundation.org/D...

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 OpenOffice.org Macro Informationthat is applicable to LibreOffice as well. Some more pointers at https://erack.de/bookmarks/O.html#Lib...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 118 times

Last updated: Oct 22 '18