One of our ArchiCAD clients (not an AMT user) asked a question that might be of interest to others, so I'm posting his question and my reply here.
Wayne Chevalier asks:
I'm not sure if you are the one I should be asking or if I should be directed to someone in your office....
I'm trying to find out what is the best way to import an Excel file?...merge? copy & paste?....
Thanks for the help!
You’ll need to create a PDF from the Excel file (using Print or Save commands, depending on your setup). Then in ArchiCAD you’ll use the Drawing tool (or File menu > External Content > Place External Drawing) and choose the PDF. You’ll then see the contents of the PDF in the current working view (floor plan, detail window, Layout sheet, etc.) which will be linked to the PDF file (it will be updatable if the PDF is changed).
Note that the drawing is not linked to the Excel file directly – it is linked to the PDF that is created from the Excel file.
ARCHICAD still cannot import and place an Excel file directly.
We now have the ability to export an interactive schedule from ARCHICAD, open it in Excel, fill in info or update field values, then reimport into the schedule. This is primarily used for getting information into the project from consultants. For example, you can export a schedule with equipment or fixtures and have the costs filled in by a consultant, then reimport to be able to tally up costs within ARCHICAD.
What type of table are you trying to create? What information do you need to display?
Most Users Ever Online: 150
Currently Browsing this Page:
Guest Posters: 1
Moderators: Eric Bobrow: 383