LT Unlimited

Export AutoCAD LT Table to CSV

Did you know you can turn an AutoCAD LT table into a CSV file with just a few clicks? This is another one of those “when in doubt, right-click” commands, since the shortcut menu is the only place you’ll find it.

(Okay, so you can type TABLEEXPORT too.)

In the dialog that comes up, choose a name and location, and that’s it! You have a brand new CSV (comma-separated values) file that you can edit in Excel, Notepad, or your editor of choice.

Detach Data Link from Table

It’s been a crazy busy couple of weeks for announcements, and they’re not quite over yet, but I thought I’d take a quick break from news and post an actual tip.

I was working with some tables recently, and had a couple that were data linked to Excel spreadsheets, but I didn’t need to keep the link any more. I just wanted the table data in AutoCAD LT. I ended up having to do a little research before I could do this, so now you get the benefit of my findings.

The obvious place to start was in the Data Link Manager (on the Insert tab of the ribbon). Right-clicking on the data link shows a “delete” option. (Remember? When in doubt…right-click.)

But when I tried that, I got a message that said, “The data link is being used and cannot be deleted.” Okay then. Apparently you need to get rid of the link before you get rid of the link…sort of like removing objects from layers before you can purge them.

So I go back to my table. The tricky bit here is that in order to find the “Detach Data Link” option, you need to have a table cell selected. Not the entire table, just one or more cells.

Once you’ve detached the data link, then you can go back to the Data Link Manager and remove the data link itself.

After saying “okay” to a couple of dialogs making sure you know you’re about to remove the link and create a static table instead, you’re all set.

Hopefully this will save you some time if you ever have to detach your own data links.

Tables -- when in doubt, right-click!

The new Table Cell contextual tab has made editing table cells easier by putting all the relevant commands right in front of you. But, as neat as it is, it can't do everything.

(click image for larger version)

Sometimes, the right-click menu is the best place to find the option you're looking for. If you don't have menus turned on, you really should. (There's no reason not to now, not with time-sensitive right-clicks.)

Depending on where you are in the table-editing process, the menu options will change. Here's a quick run-down on what's available where.

Entire Table Selected

Cell(s) Selected

Cell Active

(Look familiar? It's the same as for the Mtext Editor...notice that the contextual tab also shifts to the Text Editor tab when you activate a cell. Sneaky!)

Autofill Grip Active

You see that there's a whole host of tools and functions just waiting to be discovered in the right-click menu...happy exploring!

Table Cell Styles

Just like any other kind of annotation, AutoCAD LT tables have styles. Each style really just has one setting: the table direction (down or up). The real meat of the table style is in the cell styles.

Each table style, by default, comes populated with 3 cell styles: Title, Header, and Data. You can see an example of where each style might be used in the image above.

On the General tab are cell formatting options like Fill Color, Alignment, Format (text, percentage, data, etc.), Type (label or data), and Margins. You can also choose whether to merge new cells into the existing one when you create a new row or column -- this option is useful for Title cell styles.

The Text tab contains standard text options like style, height, color, and angle. If your text style has a defined height, then the height box here will be unavailable.

The last tab enables you to control the borders for each cell of that type -- lineweight, linetype, color, and you can even choose a double-line border. With the buttons at the bottom, you can choose which sides of the cell to apply the formatting to.

For some tables, three styles may be enough. If they're not, though, it's easy enough to create more. The two buttons next to the cell style pull-down enable you to create new styles or modify the existing list. There isn't a separate dialog to manage cell styles -- once you create a new style, you adjust its properties in the Table Style dialog. Cell styles don't translate between Table styles, either. They can only be used in the Table style where they were defined.

Of course, you can always directly modify the properties of existing table cells through the Table Cell contextual tab or the right-click menu. But sometimes it's nice to have styles predefined, to cut down on repetitive work later.

Grips in Tables

It's been a while since I posted about table functions, so I thought I'd dedicate this week to them.

First up are table grips. Just like dynamic blocks, tables have lots of specialized grips to help you edit them, and it's important to know the difference between their functions.

When you left-click once on a table, the entire table is highlighted. The image below shows the grips you'll see and their purpose.

Entire Table Selected

(click on the image for a larger version)

Most of the grips are straightforward, but the one tricky bit is that to resize a SINGLE column (and move the others) you have to left-click once on the grip, then press and hold CTRL before you left-click again to define the new width.

When you click again on the border of a cell, different grips appear with different behaviors.

Single Cell Selected

(click on the image for a larger version)

See this post for more on Autofill.

Finally, it's possible to select a range of cells by clicking-and-dragging to define your selection area. This is probably the ONLY time in AutoCAD LT where you actually need to hold the left button down as you move the mouse. (Okay, so the other exception might be selecting a range of text to edit. But honestly, that's it. The rest of the time, click once and let go, then click again. No need to press down forever.)

Multiple Cells Selected

(click on image for larger version)

Really, the only difference in the grip behavior between having many cells selected and one is that the change in distance is equally applied across all the selected rows or columns instead of just one.

Break Table Into Columns

Tables can be split up into columns while remaining one entity, just like mtext objects. The easiest way to do this is with the light-blue triangular grip at the bottom of the table. (It's the one in the middle of the row pointing upward. The other two re-size the table's rows or columns.)

If you don't like the way the default break looks, the Properties palette is full of options.

• Enabled just means that table breaks are turned on. If you set it to No, the table goes back to one big long column.
• Direction (right, left, or down) controls the placement of the additional columns.
• Repeat top/bottom labels controls the display of header rows (so that the extra columns get headings too). See this post for more on that.
• Manual positions lets you decide whether the columns can be moved independently of one another.
• Manual heights lets you decide whether each column can have its own height or whether they should all be the same (although the last one may be shorter).
• Break height is the height of the column (if Manual heights is set to No).
• Spacing is the distance between columns.

With all these options, you should be able to get your long tables to fit in any space you need them to.

Repeat First Row in Table

Since the ability to break tables into columns was introduced in LT 2008, a lot of people have wondered how to get the first row(s) to repeat across each column, the way you can in Excel when you print a spreadsheet on multiple pages.

The answer is in two pieces -- the cell style and the table properties. If you want a table row to repeat across columns, you have to make sure that in the Cell styles part of the Table Styles Manager, the Type is set to Label.

Also, in the properties of the Table itself, the Repeat Top Labels item must be set to Yes.

Now you should be able to use the triangular grip at the bottom of the table to break the table into columns, and see the title and header rows repeat in each column.

For (many) more tips like this, check out the Annotation webcast tomorrow at 10:00 PDT!

Auto-fill Table Data

Tables in AutoCAD LT have been greatly improved since their introduction in LT 2006, with every version incorporating more and more features.

One helpful feature is the AutoFill grip. The image below shows the four familiar dark blue resizing grips as well as the light blue AutoFill grip.

Once you have cells selected you can left-click on the AutoFill grip to increment or copy the data in the cell to adjacent cells. (You can specify which method to use with options in the right-click menu available inside AutoFill. In other words, left-click to start AutoFill, then right-click to see the options.) The grip tooltip says "click and drag", but remember that those are two separate actions. You don't have to keep holding the mouse button down.

If you only select one cell, as shown above, the increment value is 1.

If you want a different increment value, all you need to do is fill in the second value in your series, select both cells, and LT does the rest.

Bonus Tip: AutoFill works with dates as well as numbers.

Quickly Create AutoCAD Table from Excel Data

If you already have a table or schedule in Excel, you can quickly convert it to an AutoCAD table. Simply open Excel, select the cells you want, and Ctrl+C. Switch to AutoCAD, go to Edit-->Paste Special, and select “AutoCAD Entities”. Voila – there’s your table.

Now, it may not look exactly the way you want it to. Select the table, right-click, and choose “remove property overrides” to get it to match a defined table style. The column and row sizes may still be off, but it’s a lot quicker to grip-edit them to the right size than it would have been to re-create the table!

Shade Table Cells

It’s possible to give individual cells in your AutoCAD tables a shaded background! Simply left-click on the cell to select it, open the Properties window, and look for “Background Fill”. Select the color you want, and you’re done. Keep in mind that any color that prints black will obscure any text in the cell. Most company's pen tables have a "screened" color or two (ours is color 8) that will print lighter, so it can be used for emphasis without hiding the text. If you're printing in color, though, you're only limited by your creativity.