Lookup Table .csv file/ import excel data

Lookup Table .csv file/ import excel data

Anonymous
Not applicable
1,568 Views
5 Replies
Message 1 of 6

Lookup Table .csv file/ import excel data

Anonymous
Not applicable

Is there a way to access the data stored in and AutoCAD lookup table as a .csv file? I'd like to input large amounts of data in a lookup table, and avoiding individual inputs would be nice. I'm gonna go ahead and start doing individual input, but I would love some insight.

 

Preferably, I'd like a few steps involving some kind of import command, however, I'd be okay with an AutoLISP script to comb through... 

 

Thanks for any input.

 

TM

0 Likes
1,569 Views
5 Replies
Replies (5)
Message 2 of 6

fkp7057
Advocate
Advocate

Hi,

 

you can use normal copy/paste command 

1. Open lookup table not use select all or  ctl+a shortcut for selecting all data , 1st select 1st cell and after that go to the last cell of table select while holding shift (in short jsut select cell where data available dont select last raw of table"

2. right click on it, click on copy .

3..open excel file and paste it on it.

That s it.

 

Thanks,

FKP

Message 3 of 6

MMcCall402
Mentor
Mentor

This works in the other direction as well.  Copy from excel and paste into a lookup or block properties table.

Mark Mccall 
CAD Mangler


EESignature


VHB - Vanasse Hangen Brustlin, Inc.


Linkedin

0 Likes
Message 4 of 6

Kyle_Anthony
Contributor
Contributor

Is there something I am missing? I am trying to use this method in a lookup table and I have no paste option. See the attached. 

0 Likes
Message 5 of 6

MMcCall402
Mentor
Mentor

Try CTRL-V.  Keyboard command for paste

Mark Mccall 
CAD Mangler


EESignature


VHB - Vanasse Hangen Brustlin, Inc.


Linkedin

0 Likes
Message 6 of 6

Kyle_Anthony
Contributor
Contributor

Sadly that did not work. This may be one of those things I just have to accept is not possible at the moment. 

0 Likes