Jump to content
OuluChris

Format small table (imported from Excel)

Recommended Posts

OuluChris

Hi,

 

I'm trying to import four cells from Excel that will be a small table. The four cells each contain a numerical value.

 

I've read a bit about this and decided that the PASTESPEC command was most appropriate. I then select "paste link" and "AutoCAD entities".

 

This works fine. The cells are imported and the values automatically update whenever the Excel file is changed.

 

However, because of the formatting style of the Excel sheet, the four cells are not always the same size, have different borders, etc.

 

With my first test import I modified each cell in AutoCAD (cell width, cell height, alignment, borders, margins, etc) so that it looked good.

 

So far so good.

 

When I import a second value once again the various cell properties are wrong. I want it to be formatted like my first test import but no amount of reading about this has yet revealed a way to do this. MATCHPROP doesn't seem to do anything!

 

There are potentially a hundred or so of these four cell groups to import so modifying every cell, as I did with the first one, is definitely not on the cards.

 

My question is in two parts:

 

(1) Is there a way to quickly format new imports so that it looks exactly like my first test?

 

(2) Is it possible to create a 2-row 2-column table in AutoCAD, define all the parameters that I want and lock them, and then copy and paste (or another method if necessary) my information from Excel?

 

Many thanks,

 

 

Chris

Share this post


Link to post
Share on other sites
RobDraw

This is possible using tables/data link in AutoCAD to import the data from Excel. A table style can be used for consistent formatting.

Edited by RobDraw

Share this post


Link to post
Share on other sites
OuluChris
This is possible using tables/data link in AutoCAD to import the data from Excel.

 

As far as I can tell the data link is created automatically when using the PASTESPEC command.

 

A template can be used for consistent formatting.

 

Would you have any idea, and if so would you be willing to share, how to create such a template?

 

Thanks,

 

 

Chris

Share this post


Link to post
Share on other sites
RobDraw

The style is created and used with the table command. Check it out and come back with any questions.

Edited by RobDraw

Share this post


Link to post
Share on other sites
ReMark

Oulu: A table created via a DATALINK is not the same as using the PASTESPEC command.

Share this post


Link to post
Share on other sites
Ski_Me

I think what the OP is saying is that the formatting of the table is different than what it is in excel. The data is fine but the format is not what he wants. Oulu look at creating a table style in autocad that suits your needs and use that every time. If you create a template, meaning that every time you start a new drawing you start with a drawing template, save that table style in the template you make. It takes some work but in the end you will save yourself a lot of time. There are tutorials here about creating templates and people here that will help get you started.

Share this post


Link to post
Share on other sites
RobDraw

I've had to edit my posts to say (table) style instead of template. Sorry for the misuse of terminology and any confusion it may have caused.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...