Topic: Table from a Data link

[Fabricio28]

Hi guys,

 I'm having trouble to format the table from a data link. The table is larger and I can't delete column or rows of the table.

Anybody can help me please?

Thank in advance


Take a look in the files attached, please...
.

[Drafter X]

When you create your data link, specify the rows and columns you want to show. Once its a linked table in autocad, autocad wont let you delete, it wouldn't be a data link then as it would not match the linked source

[Fabricio28]

Thanks for the quick replay Drafter X,
 But When I insert a Table from a data link, you can't specify the rows and columns.

When you create your data link, specify the rows and columns you want to show.

When you create, yes. Right?


Regards

[Drafter X]

yes.

[Fabricio28]

So, Im not trying to create a table.
 
I've inserted from a data link. But the table is too large and I'd like to remove columns and rows.

Anybody can help me??

[Drafter X]

create a new data link from the same table with the rows/columns you want. Or edit the data link itself

[Fabricio28]

Thanks Drafter X,
 
I created other file and it works.

Best Regards

[Jeff H]

 :-[
You gotta unlock the cells

[Drafter X]

I always had bad luck doing that, dunno if 2013 plays better. That and saving data back to source I always had issues with.

[Jeff H]

Sorry for anyone who has dial-up and this was always easiest for me to do formating and add extra colums
 
Attached at bottom are updated files and should work if saved in same folder
 
 

• Open Excel SpreadSheet Select the cells you want and click in Name Box and enter name the press enter to create a named range.

 
 

• I named it Linky

 
 

• The use DATALINK command and select the NamedRange

 
 

• Then in TABLE command select the named range

 

 

• Select the entire table by clicking top left corner and unlock the cells

 
 

• Now the Linked cells will be available

 

• Click the the little arrow at bottom

 

• Then Check allow writing to source files

 

[Drafter X]

I know how, but have had cases where data did NOT write back to the source and it threw no sign of an error. My last company experimented with that a lot and had consistantly inconsistant results with it.  As I said, I have not messed with it in 2013 though.

[Fabricio28]

Hi Jeff H

Great tutorial!

Thanks for the excellent explanation. You helped me a lot.

Many Thanks
Greetings

[Jeff H]

I know how, but have had cases where data did NOT write back to the source and it threw no sign of an error. My last company experimented with that a lot and had consistantly inconsistant results with it.  As I said, I have not messed with it in 2013 though.

The linking back to source file was thrown in for whoever but was pointing out that I have had better formatting luck creating a named range in excel file and using that as the source.

[Drafter X]

Good point, and I am glad you did, made me realize something with automation in that regards thats going to make some stuff a heck of a lot easier.

[Jeff H]

Hi Jeff H

Great tutorial!

Thanks for the excellent explanation. You helped me a lot.

Many Thanks
Greetings

Not the quickest way but thought would be easiest to show how.
 
Depending on setting for cells in excel file and in autocad if a cell contents is very close to filling a cell it might cause it in autocad to make the row turn into two, until you get the settings right the quickest way was to click table and select open source and make column slighty bigger close and save
 

[Fabricio28]

Not the quickest way but thought would be easiest to show how.

It's impossible more clear than that, Jeff H.

I'm really appreciate your help.
Thank you!

[Jeff H]

Once recent thing that it came it handy was for a huge project that sites in every single state and the clients had all these spreadsheets that needed to somehow refer to the sheets for each row, and on top that there were all these TDP-I, TDP-II, etc... packages that had to be created so one little change and the documentation had to be updated and the drawings, etc.....
 
So it helped out greatly linking the spreadsheet that documents were printed from then ability to add columns and insert fields from the spreadsheet.
So did not have worry if sheetnumber changed or this changed just re-published it and was done.
 

[Drafter X]

Very nice, if I ever get time (yeah, that happens) I intend to get deeper into using fields and the ssm. The work I do generally requires the same information types repeated with only the values changing and I would love to take that to the next level. I already automate a lot of it and standard jobs are cake right now. Taking it to the next level will make it even more profitable for me.

[Jeff H]

Very nice, if I ever get time (yeah, that happens) I intend to get deeper into using fields and the ssm. The work I do generally requires the same information types repeated with only the values changing and I would love to take that to the next level. I already automate a lot of it and standard jobs are cake right now. Taking it to the next level will make it even more profitable for me.

Let me know when your ready and will show what things i picked up from using it, and the examples i have seen from AU and other sources gave some bad tips in my opinion.

[Drafter X]

will do. might take me a while to get to it though. Might finally sit down with that over the christmas break