about excel sheet connect to autocad

[ianlcc]

hi, I am using the CAD 2008 and 2004 version.

I often use the Excel sheet for type the info , and drawing with the info, and I must put the Excel sheet into the CAD's file .

so how to type the AUTOLISP VBA to do it?

or any software can do it ?(like the autotable)

do anyone can help me , please.

[abze]

Would be very usefull to me too

[MiGo]

Are you trying to create a table in cad that represents the table from excell?

 

If you do then do you want the table to be linked to excell so when you update excell the drawing gets updated or do you want just a snapshot of the current table?

[ianlcc]

Are you trying to create a table in cad that represents the table from excell?

 

If you do then do you want the table to be linked to excell so when you update excell the drawing gets updated or do you want just a snapshot of the current table?

 

Hi, first , I wish when I update the excel then the drawing gets updated , just like 「AutoTable」 , this software's function.

I had saw somebady use the VBA, let the drawing and excel sheet can update at same time, but I hadn't found the VBA.

so can someone can share or teach how to do it , or the software can do it.

[MiGo]

I'm not sure on VBA coding, but what people do here are one of three different methods.

 

When I had to bring in an excell spreadsheet we set up the spreadsheet print area and then in autocad go to insert and select OLE Object and you get the Insert Object dialog box. Next you select the bubble Create from File select the Link checkbox, then select on browse. Pick your file you want to link and place it into the drawing.

 

This method seemed to be a pain tho. I am unsure as to if it was poor managment of the links, but they seem to stop updating later on and some links had sizing issues.

 

The other method is while in Excell you highlight the table area and copy. Then go into the autocad drawing, select on Edit meu, then select on paste special. The Paste Specual dialog box will appear. Select the Paste Link bubble and the program should already list the Microsoft Office Excell. Press OK and place the table in the drawing.

 

I have not worked with this method much, but it seems to work great.

 

The third method is creating a data link then inserting a table from the data link. First select on Tools menu, then select on Data Links section and select the Data Link Manager... button. The Data Link Manager will come up. Select Creat a new Excel Data Link and place a name in the dialog box that pops up. The New Excel Data Link: (name) dialog box will appear. Browse for your excell spreadsheet my system has the link entire sheet, but you can select how far you want to link and how far you want to leave select ok after it loads in the dialog box and then select ok in the Data Link Manager.... Go to Insert menu and select table. The Insert Table dialog box should appear. Under insert options select From a data link and then select your data link you named. Press OK and place into drawing.

 

This one is really nifty, because you can lock or unlock cells and update them in cad if unlocked, and it will update if the spreadsheet is updated. Plus there is a grip so if your table is too long for the viewport you just grab that grip to change the length of the table and it just creates multiple sections (columns) of the entire table to that length.

 

Let me know how it turns out for you

[ianlcc]

HI, first I want to say thank you to you , MiGo.

the first method I have not try it, but the second and third method I have try it , and the show sheet not good for do it.

because when I set the link and copy or set it , the sheet form showed at the drawing not the same with the whick in the excel.

My need is when I type or fix in the excel sheet , the drawing will chang at the same time .

[MiGo]

The second method should upate automatically (it does for me). The third method can update by typing in the DATALINKUPDATE command or by selecting a cell and right clicking then going to data link and update data link. I don't know how to make it automatic for the third one.

 

A great note about the third one is that you can change the table in autocad and use the DATALINKUPDATE command and it will update the excell spreadsheet, so you never actually have to have excell open unless you can't do what you need to do through cad.

[ianlcc]

The second method's problem is .....

when I set up the link , the excel sheet in the drawing whick background's color is white , and my autocad's background's color is black.

it's different show.

And i wish my sheet's text and column's color which i set up in the excel , at the same time , it's can link into the drawing.

that's important.

[MiGo]

It will automatically update, but not without a save. When you save the spreadsheet the cad link will update.

[MiGo]

Shading will work when I shaded I highlited the cell right clicked and then went to fill color and when I copied the cells they came over just fine. How are you doing yours?

[Attila The Gel]

I have another problem with the 2nd method?

 

I 'Special paste Linked' a few selections from one .xls file to one .dwg drawing in different layouts. all goes well untill I save and reopen the drawing. The .xls file tries to open in excel for each link in my drawing.

is this normal?