OuluChris Posted October 7, 2015 Share Posted October 7, 2015 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 Quote Link to comment Share on other sites More sharing options...
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.