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
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/Development/Extension_Development
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 Information that is applicable to LibreOffice as well. Some more pointers at Links: OpenSource - LibreOffice - OpenOffice.org