topic Re: Edit AutoCAD table from Excel or Text file in AutoCAD Forum

Edit AutoCAD table from Excel or Text file

Amriya_Exe — Thu, 22 Feb 2024 17:33:30 GMT

I created Table in AutoCAD layout as shown below I have to edit cell values which highlighted in red for all layouts.

Any way to do automatic from excel/text file?

Second request is

For all layout in reference details I am writing this location span number manual.
I know the Field command CTAB but I need only last 6 digits from Layout name.

Betreff: Edit AutoCAD table from Excel or Text file

cadffm — Thu, 22 Feb 2024 17:44:55 GMT

Field

Diesel

Getvar ctab substr getvar - strlen

https://www.theswamp.org/index.php?topic=48156.0

Betreff: Edit AutoCAD table from Excel or Text file

Amriya_Exe — Thu, 22 Feb 2024 18:04:05 GMT

$(substr,$(getvar,DWGNAME),1,14)

I have to paste this command in my table CELL?

Betreff: Edit AutoCAD table from Excel or Text file

cadffm — Thu, 22 Feb 2024 18:33:32 GMT

Hi,

No, you have to activate your cell, rightmouseclick -> Insert Field

https://help.autodesk.com/view/ACD/2024/ENU/?guid=GUID-1B6DD22B-10D1-44ED-BAA2-E6D79FE52327

In Field dialog, choose category DIESEL (or Diesel Expression?) and there is a place to paste this code.

>>"$(substr,$(getvar,DWGNAME),1,14)"

1. This code reads your DWGNAME variable, you talked about the CTAB variable.

2. This will read the first, not the last characters

3. 14 characters instead 6

for you:

$(substr,$(getvar,CTAB),$(-,$(strlen,$(getvar,CTAB)),5),99)

Re: Edit AutoCAD table from Excel or Text file

Amriya_Exe — Sat, 24 Feb 2024 05:21:28 GMT

Any update for first query