topic Re: Exporting from Archicad to Excel in Collaboration with other software

Exporting from Archicad to Excel

Anonymous — Tue, 16 Feb 2010 08:54:00 GMT

This is quite an obscure request, however does V13 have a facility to export to MIcrosoft Excel?

Re: Exporting from Archicad to Excel

Barry Kelly — Tue, 16 Feb 2010 09:35:38 GMT

In GDL you can use the Text and Data I/O add-ins to write and read values to/from an Excel workbook.
Is this what you mean or were you meaning images of the plan?
Barry.

Re: Exporting from Archicad to Excel

Laszlo Nagy — Tue, 16 Feb 2010 10:29:48 GMT

If you generate an Interactive Schedule you can save that as an Excel file.
At least on Windows.
I don't know if Office installed has something to do with it or not because I have Office installed and the save option is there.
I don't know if it is still there if you don't have Office installed.

Re: Exporting from Archicad to Excel

Anonymous — Wed, 17 Feb 2010 14:12:19 GMT

Thanks for the replies. Specifically I have a client that wants to be able to generate document transmittals that are generated in AC into Excel. Document transmittal being a list of drawings, current revision, issue type eg:issued for construction. I intended to set the majority of this info using project info and then dedicate a layout to it. The question is.. can this layout be exported as Excel or does it have to be an interactive schedule exported to excel?

Re: Exporting from Archicad to Excel

Laszlo Nagy — Thu, 18 Feb 2010 12:06:19 GMT

I don't think a Layout can be exported to Excel.
The Interactive Schedule can be because it is a tabular arrangement like Excel.
Maybe your should create a View Index or Drawing Index or Layout Index, not an Interactive Schedule.

Re: Exporting from Archicad to Excel

Anonymous — Mon, 22 Feb 2010 04:56:47 GMT

Hi
Yes a sheet index will be good. The default sheet index in the project map has fields for revision and date that are, I assume, only capable of being completed one by one. Is there a way of introducing Autotext here so that the info can be linked to the Project Info?

Re: Exporting from Archicad to Excel

Laszlo Nagy — Mon, 22 Feb 2010 13:58:28 GMT

I don't think that is possible.
You will be able to list only those fields that are available in the Sheet Index Settings Dialog. Some of these are custom fields but these cannot be filled with AutoText items.

Re: Exporting from Archicad to Excel

Anonymous — Mon, 22 Feb 2010 14:08:14 GMT

Thanks Lazlo. If that is the case then its probably best to work around this by using the layout index and to insert autotext 'over' it to fill in the cells. This way the revision and date can be updated automatically in accordance with Project info. Perhaps its worth a wish to GS as many architects would like automated document transmittals?

Re: Exporting from Archicad to Excel

Laszlo Nagy — Tue, 23 Feb 2010 09:46:20 GMT

Yes, you can make a wish so you can find out how much others would like such a feature implemented.