Search the Community

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

Hi, I am simply trying to insert an excel datalink into my drawing. However once i complete the process using the datalink manager and click 'OK' nothing happens, i return to my model space window with nothing appearing. I have checked my layers are on and check the extents..... Any help is greatly appreciated

Hello everyone, this is my first post here so hopefully it makes sense. I am trying to find a way to create an index drawing without having to input much information in. I would like to export the attributes from each drawing file in my (project folder) from the title-blocks (drawing numbers and descriptions) into excel and then be able to just datalink that into my Index table in AutoCAD. I know i could put the info in excel and import it into my table in CAD but i am looking for something more Automatic, so that everytime i need to create an index it will automatically extract the info from the drawing files title-blocks. Thanks