![]() ![]() I will open up both the trash Excel file and the refined Excel file, then simply use Windows Copy (Ctrl+C) and Windows Paste (Ctrl+V) to move the attribute information from the trash Excel file to the refined Excel file. For me, this exported file is trash, because I have another refined Excel file that I have set up with formulas and appearance. ![]() Again, right-click on the table and choose Export. (Basically, it deletes the table and recreates it from scratch every time you refresh or change the settings.) I think it's best to port out that information to Excel. Any changes will be deleted once you refresh or change settings. "If you modify your table (e.g., add formulas, rows, or columns) in AutoCAD, please be careful. You can also just update the table by right-clicking on the table and choosing Update Table > Refresh Only. Just be careful: if you change anything, the pages after may not fully reflect your original settings. If you forgot a step or you wonder which options you selected, you can easily go back by right-clicking on the table and selecting Update Table > Edit Extraction Settings, and you will go through the setup wizard with all of your settings. I just like to keep an AutoCAD file because it makes it easy to update and it also keeps a record of what you have done, as I will demonstrate. Click Next and then Finish, and place your table into your AutoCAD file. Fill out the overall heading of the table and select any table style that you have previously set up. You can export to an external file that Excel can read now, but for this exercise leave that blank, as we are going to do that later. You can also set up how the table is sorted by double-clicking on a column's heading (an up or down arrow will appear to correspond with ascending and descending). Now just click and drag the column were you want it, and make sure you checked AutoCAD Table. (Hint: click on 'Exclude blocks without attributes' and also 'Exclude general block properties' if that is what suits your needs.) Click on the next page. "Now on to the next page: here you will select the blocks and the respective attributes you want to put in the table. Whatever you pick, don't forget to click on the additional settings and make sure the settings suit your needs. I'm going to let you do your own thing here, but I prefer to choose 'Select drawing / sheet sets,' as I like all my information for a project to be in one spot. This is where your previous 'hardest decision' will come into play. I like to pick 'Create table or external file from scratch' and then click Next. "Open your file and run Eattext (yes, it is the attribute extraction command). Please note that I'm using AutoCAD 2007 the method, means, and results may vary per version of software. Stay with me - this is a bit long - and please follow along in AutoCAD. Once you decide that, just follow these basic steps. I like to have it in one file, but maybe you would like it spread out in multiple files. Wish you could port some information from a block's attributes? It's as easy as eating pancakes! The hardest decision will be to figure out where you want this information to reside. ![]() "Tired of the basic table in AutoCAD? Wish you could use Excel instead? Not a problem. Tipster Jesse Moore thoroughly describes how to get your AutoCAD data into a spreadsheet or table in AutoCAD.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |