Author Topic: (AutoCAD LT) AutoCad Tables to Excell & back?  (Read 5144 times)

0 Members and 1 Guest are viewing this topic.

craigr

  • Guest
(AutoCAD LT) AutoCad Tables to Excell & back?
« on: March 10, 2008, 04:19:18 PM »
With LT - Is there a way to copy tables to & from Excell & AutoCad?

This way someone can fill out a table in Excell and I could copy those cells to AutoCads Cells.

I don't want to do the OLE thing.

craigr

Greg B

  • Seagull
  • Posts: 12417
  • Tell me a Joke!
Re: AutoCad Tables to Excell & back?
« Reply #1 on: March 10, 2008, 04:31:10 PM »
Can you xref it or doesn't LT do xrefs??

craigr

  • Guest
Re: AutoCad Tables to Excell & back?
« Reply #2 on: March 10, 2008, 04:33:12 PM »
Yes LT does XRefs, but that won't save the table to Excell & Back. If I understand it correctly, that would just save it to another CAD file, right?

I found how to export the table to a .csv file, but how do I take it back to an AutoCad table?

craigr

Kate M

  • Guest
Re: AutoCad Tables to Excell & back?
« Reply #3 on: March 11, 2008, 03:58:47 PM »
Copy cells from Excel. Go to LT, Edit-->Paste Special-->AutoCAD entities. Ta da -- table!

Unless LT has the data extraction tools (which I doubt, but I don't remember), this is about it.

P.S. Somebody wanna move this to the LT forum? :-)

craigr

  • Guest
Re: AutoCad Tables to Excell & back?
« Reply #4 on: March 11, 2008, 04:03:59 PM »
Under 'Paste Special', 'AutoCAD Entities' is not an option.

All that is there is 'UniCode Text' and 'Text'.

Must be a Full CAD option only.

Thanks anyway,

craigr

MP

  • Seagull
  • Posts: 17750
  • Have thousands of dwgs to process? Contact me.
Re: AutoCad Tables to Excell & back?
« Reply #5 on: March 11, 2008, 04:05:30 PM »
Somebody wanna move this to the LT forum? :-)

Done :)
Engineering Technologist CAD Automation Practitioner
Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
cadanalyst@gmail.com http://cadanalyst.slack.com http://linkedin.com/in/cadanalyst

Kate M

  • Guest
Re: AutoCad Tables to Excell & back?
« Reply #6 on: March 11, 2008, 04:08:36 PM »
Under 'Paste Special', 'AutoCAD Entities' is not an option.

All that is there is 'UniCode Text' and 'Text'.

Must be a Full CAD option only.

Thanks anyway,

craigr

I just tested it on AutoCAD LT 2007 and it works. Are you directly copying cells?

craigr

  • Guest
Re: AutoCad Tables to Excell & back?
« Reply #7 on: March 11, 2008, 04:12:40 PM »
Oops...

I just found it.

Apparently, you have to open the Excel file and copy it to the Clipboard, THEN do the 'paste special'.

It worked for me.

Thanks,
craigr

Kate M

  • Guest
Re: AutoCad Tables to Excell & back?
« Reply #8 on: March 11, 2008, 04:17:29 PM »
Cool. 8-)