how to write c++ code to work with excel

[semsemdiver]

Hi guys,
i saw a piece of code in excel written in V.B or V.B.A i'm not sure to apply operation like coping text from excel to Autocad with respective of a specific coordinates, the question is how to do that in C++, i finished 2 courses in c++ and couldn't create this macro.
thank you
semsemdiver

[AbstractionAnon]

A quick google gives this article:
https://www.codeproject.com/Articles/15837/Accessing-Excel-Spreadsheets-via-C

[Thomas1965]

Other options:
For .xls format
https://www.codeproject.com/Articles/13852/BasicExcel-A-Class-to-Read-and-Write-to-Microsoft
or
https://www.codeproject.com/Articles/42504/ExcelFormat-Library

For .xlsx have a look at github there are quite a few libraries

[jonnin]

if you want to get FROM or TO excel in c++ for *simple* data then I highly recommend just writing (from c++ to excel) or reading (from excel to C++) a simple .CSV file.

You can get a little snarky on the excel side, eg a 'normal' xls whatever file that has formulae and macros and all that does the 'work' and writes to a new sheet that you save in csv file for the c++.

there are other ways, but this is very often 'enough' for a lot of projects.

I do not know what autocad will accept, but you can change the delimiter from comma to something else and otherwise tweak the format if you want to bypass the c++ step (if that is possible).

[semsemdiver]

thank you guys "AbstractionAnon", "Thomas1965" , "jonnin" for replying me, i will check and try what you sent me and will tell you because i don't have any experience with such operation " connecting excel with autocad with c++ code or any other language hahaha :) and was wondering why not to make it with c++ at least i will feel i have learned some thing useful, because i feel a little bit frustrated because i don't know how to use what i have learned in c++ after finishing 2 courses in C++ fundamental :( !!.

anyway thank you guys, i appreciate your help.
see you soon, bye :)