VBA and SimpleXlsx
C++ library for creating XLSX files for MS Excel 2007 and above.
Brought to you by:
oxod,
programmeralex
Hello,
Thanks for the good work.
I would like to ask you some questions, I’m also a beginner in C++.
Context:
I’m using SimpleXlsx with another library to acquire data frames from the serial port and use these data frames to fill an Excel SpreadSheet (using C++).
1st question:
Is it possible to save data (such as random generated numbers like in the examples in the WIKI section) into an existing excel file (that you have created before separately) ; and not create a new file every time ? If possible, how ?
In my program, I receive the data frame(which is a string of characters) into the A column of my spreadsheet and I would like to split my data frame into several columns using a separator (such as a space or a comma). To do that I would like to use VBA (Virtual Basic for applications) with Excel.
2nd question:
Is there any way to enable VBA for your SimpleXlsx spreadsheet / Is it possible to save the data into an existing file containing macros ?
Sorry for my English. Have a nice day !
Best Regards,