BIM Coordinator Program (INT) April 22, 2024
Find the next step in your career as a Graphisoft Certified BIM Coordinator!
Archicad C++ API
About Archicad add-on development using the C++ API.

Excel

Anonymous
Not applicable
Is it possible to make data connection with excel ? For importing and exporting data ?
If not what are other ways doing so ?
3 REPLIES 3
Anonymous
Not applicable
Main function would be to export schedules with button on tollbar. Or do it automatically, maybe when project is being saved or closed.

How could i make it to work ?

EDIT
Best way would be to use ODBC?

Could make xml which export the way i want, but couldn't get excel to properly open xml. Best i could come up with so far..
ReignBough
Enthusiast
I am currently generating reports to spreadsheet. I found a basic code here. But I never tried reading from the file.
~ReignBough~
ARCHICAD 26 INT (from AC18)
Windows 11 Pro, AMD Ryzen 7, 3.20GHz, 32.0GB RAM, 64-bit OS
Anonymous
Not applicable
Thanks ReignBough.
Tried to implement your given code, couldn't get it to work.

But could make to properly export xml.
Now i have problem excel have problem recognizing xml data. Some numbers ar recognized as date.
How can i fix this ? With xsl file ? Or i can't ?

EDIT
Soo, i got numbers to show properly on excel.
Learn and get certified!