topic Re: Excel in Archicad C++ API

Excel

Anonymous — Tue, 24 Sep 2024 07:51:54 GMT

Is it possible to make data connection with excel ? For importing and exporting data ?
If not what are other ways doing so ?

Re: Excel

Anonymous — Wed, 08 Jul 2015 06:52:25 GMT

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..

Re: Excel

ReignBough — Mon, 13 Jul 2015 04:15:04 GMT

I am currently generating reports to spreadsheet. I found a basic code here. But I never tried reading from the file.

Re: Excel

Anonymous — Tue, 14 Jul 2015 07:06:09 GMT

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.