topic Re: Cool Excel in Modeling

Cool Excel

Anonymous — Thu, 16 Feb 2006 04:05:23 GMT

now this would be neat if we could get this to work in AC...

http://www.cadig.com/

Re: Cool Excel

__archiben — Thu, 16 Feb 2006 05:20:36 GMT

it's not live, but you can use the excel camera tool to do much the same thing . . .

paste in as 'drawing elements' and all is good . . .

~/archiben

Re: Cool Excel

Anonymous — Thu, 16 Feb 2006 13:38:11 GMT

problem we have ran into with pasting and live linking is that only allows 45 rows...it's very limited...where is the excel camera tool.....

Re: Cool Excel

__archiben — Thu, 16 Feb 2006 20:48:18 GMT

i've no idea where it's originally found, but i've put it out in my toolbar for easy access . . .

just select the cells you want to 'copy' and then click the camera tool. in archiCAD (or more typically a layout) 'paste' and choose 'as drawing elements'. the text comes in as text and any cell borders are retained as lines.

as i said - it's not live, but it's a pretty quick and easy way of grabbing a chunk of excel data and placing - wysiwyg - in a layout book. especially for non-OLE mac users!

~/archiben

Re: Cool Excel

Anonymous — Thu, 16 Feb 2006 23:29:32 GMT

For Windows users just Highlight area Ctrl-C (Copy) in Excel. Go to PlotMaker, Ctrl-V (Paste). Paste as OLE. This will be live, and Excel sheet can be opened in PM by double clicking the embedded OLE object.

Re: Cool Excel

Chazz — Fri, 17 Feb 2006 13:12:29 GMT

~/archiben wrote:
just select the cells you want to 'copy' and then click the camera tool. in archiCAD (or more typically a layout) 'paste' and choose 'as drawing elements'. the text comes in as text and any cell borders are retained as lines.

archiben, this is the identical behavior I see with a simple copy paste between AC/PM. Any advantage that I'm missing?

Re: Cool Excel

Anonymous — Fri, 17 Feb 2006 21:34:37 GMT

Yes I have been using CTRL C (copy) and I have tried OLE.....but for what ever reasons I get cut off at the 45-50 rows....any clues....

Re: Cool Excel

Anonymous — Fri, 17 Feb 2006 21:49:27 GMT

Just did a quick test and I was able to OLE a Sheet with 83 Rows (row Height set to 15).

I am back on MS Excel 97 SR-2.

Re: Cool Excel

Haneef Tayob — Mon, 20 Feb 2006 08:21:52 GMT

r wrote:
now this would be neat if we could get this to work in AC...

Posted something in Jan 13 2005 where I mentioned how I was pasting 'live' drawing lists from Excel into Plotmaker. There are some issues around it but when it works, it works like a dream.

under construction documentation:
archicad-talk.graphisoft.com/viewtopic.php?p=29170&highlight=excel&sid=a95788d9f1678972b544e5ab83917063#29170

another recent tread also under Construction Documentation you can follow is:
archicad-talk.graphisoft.com/viewtopic.php?p=53770&highlight=excel#53770
it covers size of objects one can paste, etc.

I've even pasted successfully from OpenOffice.

regards
Haneef

Re: Cool Excel

Anonymous — Wed, 22 Feb 2006 14:46:29 GMT

I gave it a run in Plotmaker to Excel...and only get 45 rows....just to let you know...I am using 2003....anyone using 03 give it a try for me and see if you get the same results

Re: Cool Excel

Anonymous — Wed, 22 Feb 2006 18:37:38 GMT

r wrote:
I gave it a run in Plotmaker to Excel.....I am using 2003...

I know there used to be some issues with differing Excel versions. See my comments in this post that was referenced before.