Edit AutoCAD table from Excel or Text file

[Amriya_Exe]

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. 

[cadffm]

Field

Diesel

Getvar ctab substr getvar - strlen 

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

[Amriya_Exe]

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

I have to paste this command in my table CELL?

[cadffm]

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)

Read more about DIESEL, it's useful: [F1]

[Amriya_Exe]

Any update for first query