Excel
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2015-07-07
09:12 AM
- last edited on
‎2024-09-24
09:51 AM
by
Doreena Deng
‎2015-07-07
09:12 AM
Is it possible to make data connection with excel ? For importing and exporting data ?
If not what are other ways doing so ?
If not what are other ways doing so ?
3 REPLIES 3
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2015-07-08 08:52 AM
‎2015-07-08
08:52 AM
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..
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..
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2015-07-13 06:15 AM
‎2015-07-13
06:15 AM
I am currently generating reports to spreadsheet. I found a basic code here. But I never tried reading from the file.
~ReignBough~
ARCHICAD 27 INT (since AC18)
Windows 11 Pro, AMD Ryzen 7, 3.20GHz, 32.0GB RAM, 64-bit OS
ARCHICAD 27 INT (since AC18)
Windows 11 Pro, AMD Ryzen 7, 3.20GHz, 32.0GB RAM, 64-bit OS
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2015-07-14 09:06 AM
‎2015-07-14
09:06 AM
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.
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.