topic Re: Archicad and Excel in Collaboration with other software

Archicad and Excel

Anonymous — Sun, 11 Jan 2015 10:13:07 GMT

Hello.
I have the following issue: I did a table in Excel and I would like to transpose it to Archicad, so that the construction of the table becomes simple lines and the text can be modified.
I tried to import the table as both Rich text and Jpeg, but none of these meet what I want, as written before.
Is there a solution to this?
Thank you.

Re: Archicad and Excel

Dontknow — Sun, 11 Jan 2015 12:05:00 GMT

Maybe you'll find the following topic usefull:

http://archicad-talk.graphisoft.com/viewtopic.php?t=32377&sid=85034c3343bbae80a45f70b498a61d69

Re: Archicad and Excel

Eduardo Rolon — Sun, 11 Jan 2015 14:43:27 GMT

If you are using AC18:

• Export Table from Excel as PDF
• Place PDF in AC
• Right Click on PDF and select "Explode". Check that Text is converted to text and not lines.
---
and now I see that you are not using it.

If you have Adobe Illustrator then you can open the PDF and export to DWG and then import it to AC.

Re: Archicad and Excel

Anonymous — Sun, 11 Jan 2015 15:27:23 GMT

Thank you both for the answers.
No, I do not have Archicad 18, nor do I have Adobe Illustrator.
But I am going to try and install the trial versions of them and try both methods.
Thank you.

Re: Archicad and Excel

Anonymous — Sun, 11 Jan 2015 15:55:31 GMT

P.S. I have Autocad 2010. Does it help in any way? Is there a way through Autocad as well?

Re: Archicad and Excel

Eduardo Rolon — Sun, 11 Jan 2015 16:38:48 GMT

igreere wrote:
P.S. I have Autocad 2010. Does it help in any way? Is there a way through Autocad as well?

Not that I know of.

Re: Archicad and Excel

Anonymous — Sun, 11 Jan 2015 17:46:58 GMT

OK. I made the table in Excel a pdf. Then I imported it into Illustrator, where everything was fine. I exported from Illustrator to .dwg and placed the .dwg as an external drawing into Archicad and then exploded it.
The file is quite a mess, as it is shown in the picture. The construction lines of the table are orange and black, while they should be plain black lines. The numbers are split into individual digits. And sometimes one row is one big text box, with a mess of numbers and text inside.
What is wrong of what I do?
Thank you.

Re: Archicad and Excel

Eduardo Rolon — Sun, 11 Jan 2015 18:09:34 GMT

Now you need to clean it up by editing the line and text settings. The problem might be on how excel exported the PDF or how Illustrator converted it into DWG.
----
Main question here is why do you need to convert the excel file to lines and letters since the normal workflow is to just export to PDF from Excel and Place the PDF in AC and if you need to edit the file you just make the changes in Excel and re-save the PDF overwriting the original one.

Re: Archicad and Excel

Anonymous — Mon, 12 Jan 2015 13:34:39 GMT

I could explode the pdf from Excel in Archicad 18, with the help of a friend that has this AC version. It worked. So thank you very much.
As far as why I am doing this, I can only say that my boss asked me to do it.
Thank you again.