topic Re: Import excel file into archicad file in Collaboration with other software

Import excel file into archicad file

Anonymous — Sat, 20 Mar 2010 02:21:10 GMT

Hi, anyone know how to import an excel file into Archicad?
Thanks.

Re: Import excel file into archicad file

Karl Ottenstein — Sat, 20 Mar 2010 03:53:40 GMT

It depends on what you want to do with it. Please explain exactly what you want to do with the Excel data?

If you just want to place the spreadsheet contents on a layout, then you need to save it as PDF and place the PDF instead.

Re: Import excel file into archicad file

Erich — Sat, 20 Mar 2010 03:54:00 GMT

Save it as a PDF file and place that as an external drawing.

Re: Import excel file into archicad file

Erich — Sat, 20 Mar 2010 03:54:47 GMT

Karl,

You are not only faster than me but more complete as usual...

Re: Import excel file into archicad file

Erika Epstein — Sat, 20 Mar 2010 16:04:20 GMT

You can also copy and paste the text into AC if you mightwant to edit it.

Please add your operating system and version of Archicad to your signature.

Re: Import excel file into archicad file

Anonymous — Tue, 23 Mar 2010 05:15:10 GMT

Hi, regarding the import of excel file.
Exactly i need to do some calculation on the cabinet material, i just wonder how to import a excel file into archicad, so that i can input the different material to use in the excel file for calculation & easy refer to the data.
Thanks.

Re: Import excel file into archicad file

Erika Epstein — Tue, 23 Mar 2010 05:24:44 GMT

Hazel,
I'm not sure I understand what you are asking.
You can set up schedules to do many claculations automatically. You cannot import information from an excel file to include in archicad.

Are you trying to add information from outside archicad into archicad?

Or are you trying to get some information in archicad out to excel?

Or ___?

Re: Import excel file into archicad file

Anonymous — Thu, 20 May 2010 17:31:23 GMT

Does GS know what year it is? AC13 can not import a .xls? BRILLIANT!

Re: Import excel file into archicad file

Karl Ottenstein — Fri, 21 May 2010 20:59:14 GMT

Robert wrote:
Does GS know what year it is? AC13 can not import a .xls? BRILLIANT!

WHY would you import an Excel file into a BIM model? Where would you have that data appear and how? You can freely extract data FROM ArchiCAD and INTO Excel, which is the appropriate flow of data...

If you want the Excel data on a layout, Excel has the tools to select what to display and how to display it... which is why saving as a PDF from there and placing the PDF is the sensible way to get quality results.

Karl

Re: Import excel file into archicad file

Karl Ottenstein — Fri, 21 May 2010 21:04:08 GMT

Hazel wrote:
Hi, regarding the import of excel file.
Exactly i need to do some calculation on the cabinet material, i just wonder how to import a excel file into archicad, so that i can input the different material to use in the excel file for calculation & easy refer to the data.
Thanks.

Hi Hazel,

It works the opposite way: you export your cabinet schedule (or whatever) from ArchiCAD to Excel and do the computations there.

Karl

Re: Import excel file into archicad file

Anonymous — Wed, 26 May 2010 18:50:39 GMT

Karl wrote:
Robert wrote:
Does GS know what year it is? AC13 can not import a .xls? BRILLIANT!
WHY would you import an Excel file into a BIM model? Where would you have that data appear and how? You can freely extract data FROM ArchiCAD and INTO Excel, which is the appropriate flow of data...

If you want the Excel data on a layout, Excel has the tools to select what to display and how to display it... which is why saving as a PDF from there and placing the PDF is the sensible way to get quality results.

Karl

1) Because AC's schedules are horrendous to use, setup, and edit.
2) I could have the live data on a sheet and it would appear just as it reads in excel. The data comes from equipment suppliers, Owners, Consultants, you name it.

PDF's, really? I could also print the spreadsheet out, scan it to a jpg, convert it to a gif, print it to a pdf and insert it into a drawing. How many steps do you want to use?

Re: Import excel file into archicad file

Achille Pavlidis — Thu, 27 May 2010 09:02:10 GMT

I to want to import excel files to Archicad!

This is a feature of Minicad/Vectoworks that i always miss on Archicad. It was extremely useful when we worked with Minicad and had the ability to incorporate large spreadsheets that were given to us by mech. engineers on large industrial projects.

Re: Import excel file into archicad file

Erika Epstein — Thu, 27 May 2010 16:44:36 GMT

Achille wrote:
I to want to import excel files to Archicad!

This is a feature of Minicad/Vectoworks that i always miss on Archicad. It was extremely useful when we worked with Minicad and had the ability to incorporate large spreadsheets that were given to us by mech. engineers on large industrial projects.

Achille,
When you say "incorporate" do you mean something other than just placing the spreadsheet in your drawings?
Are your consultants not embedding their equipment specifications in their models?

As Karl explained, architect or consultant this data should be extruded from the model, not the other way around.

I agree, it would be nice to be able to just put the spreadsheet back on the layout without having to first convert it to a pdf, but once done it is a matter of updating the links.

Re: Import excel file into archicad file

Anonymous — Thu, 27 May 2010 17:48:18 GMT

Erika wrote:
Achille wrote:
I to want to import excel files to Archicad!

This is a feature of Minicad/Vectoworks that i always miss on Archicad. It was extremely useful when we worked with Minicad and had the ability to incorporate large spreadsheets that were given to us by mech. engineers on large industrial projects.
Achille,
When you say "incorporate" do you mean something other than just placing the spreadsheet in your drawings?
Are your consultants not embedding their equipment specifications in their models?

As Karl explained, architect or consultant this data should be extruded from the model, not the other way around.

I agree, it would be nice to be able to just put the spreadsheet back on the layout without having to first convert it to a pdf, but once done it is a matter of updating the links.

If the information was "in" the model we wouldn't need the consultants, would we? Or are you are you suggesting we get the information from the consultant, put it in our model, and then extract the information?

Not everyone uses AC (for good reason). open workflow. live data. For God sake it is just lines and text!

Re: Import excel file into archicad file

Anonymous — Thu, 27 May 2010 18:45:54 GMT

... people! No reason to get all "het up." Sure, it would be real nice if AC were smart enough to know what those lines and text in a spreadsheet meant - whether it is crane data or cabinet data - so that it could be linked through parameters to model parts. But AC would have to read minds to do that.
So, the next best thing would be to have a spreadsheet built into AC. Maybe a translator could be written to import spreadsheets to a "dumb" schedule viewpoint.
Maybe its contents don't interact with the model at all except through the view and layout, but at least updates to that data would not require stepping out of the model, editing another file, saving another pdf, and returning to the model (layout) to update the inserted drawing.
I suspect that is the closest GS could possibly come to what these folks are asking for. They get data and periodic updates to it from clients, consultants, etc. in excel form, and would like to get it onto sheets and keep it current with a minimum of fuss. So would I.
Maybe they can tell me if I have reinterpreted their wishes correctly or not?
There is risk here. If the schedules are generated by the model (yes, they are more trouble to set up and to edit), there is some built-in assurance that the two representations (schedule and other views) will agree with each other. With an independent schedule, coordination of the two sets of data is entirely up to the operator.

Re: Import excel file into archicad file

Achille Pavlidis — Fri, 28 May 2010 07:22:42 GMT

Erika wrote:
Achille wrote:
I to want to import excel files to Archicad!

This is a feature of Minicad/Vectoworks that i always miss on Archicad. It was extremely useful when we worked with Minicad and had the ability to incorporate large spreadsheets that were given to us by mech. engineers on large industrial projects.
Achille,
When you say "incorporate" do you mean something other than just placing the spreadsheet in your drawings?
Are your consultants not embedding their equipment specifications in their models?

As Karl explained, architect or consultant this data should be extruded from the model, not the other way around.

I agree, it would be nice to be able to just put the spreadsheet back on the layout without having to first convert it to a pdf, but once done it is a matter of updating the links.

It would be nice to extract the data from the model, but not always possible.
When i say incorporate i mean, that in huge oversize A0 drawings there is the need to place spreadsheets with 10 columns per 100-150 rows. It would be nice to have the ability to adjust alignments, spacing, column width, row height etc, without having to go back and forth to excel and pdf.

Re: Import excel file into archicad file

Erika Epstein — Fri, 28 May 2010 07:43:58 GMT

Thanks for clarifying.
I agree; it would be nice to be able to place a spreadsheet directly and adjust its layout as you describe. We once were able to import word documents which made specs easy to hotlink and update. I don't recall if spreadsheets were also importable. They were replaced with the current pdf import.

Re: Import excel file into archicad file

Anonymous — Fri, 28 May 2010 10:44:58 GMT

Erika -
Are you talking about Microsoft Object Linking and Embedding (OLE) ?
Since I don't use that MS Windows, I have not messed with OLE, but I seem to recall rumors of its availability in ArchiCAD for Windows. I have no idea how well it works (or worked), or if it ever really worked at all.
Achille -
The best approach we have found is to diddle the formatting in the Word or Excel source file prior to cutting a pdf for insertion in AC.
As you say, sometimes it takes a few tries until you get the feel, or set up a template (or ten) in Excel for different kinds of tables - kinda like we had to do with AC views and .pmk files in the bad old days when the Layout Book was a separate file from the model. A little frustrating, but not so bad if you can have both files open at the same time (edit, save as, update, edit, ....).

Re: Import excel file into archicad file

Erika Epstein — Fri, 28 May 2010 14:57:51 GMT

It was something about OLE and when we lost that capability I missed it. The extra step of creating a pdf is annoying, but doable. Links are updatable.

Re: Import excel file into archicad file

Anonymous — Fri, 18 Jun 2010 16:27:11 GMT

Here's the Revit point of view that might help this discussion:
Revit doesn't import excel files, but a user (nicholas iyadurai) found a way to do it. He used a scripting tool - Autohotkey - to automate a copy-paste routine. You can check this at http://forums.augi.com/showthread.php?t=97224 and maybe do the same for archicad.
Before the RDBLink (a database bi-directional data tool), I used to use that script all the time.