Copy an excel table in autocad and transform it into a drawing

[itacad]

Hi, I'm trying to copy excel tables into autocad.
I've seen several discussions on the subject but I haven't found any easy solutions to what I would like to do.

The starting excel tables are already very clearly formatted (columns width, rows high, merged columns, texts, colors, justifications, etc.).

The best graphic result is to copy and paste them as an image, but obviously this does not allow subsequent modifications.

I tried to follow the insertion methods from Draw --> Table and selection of the table to connect, but I don't get the desired graphic result and I'm not interested in having a connection with the source table.

I tried to insert it as an OLE object, but it still seems to be an image, maybe I'm doing something wrong...

I would like to insert it in order to obtain the graphics most similar to the starting excel table and if possible, explode it to work directly on lines, polylines, texts and colors by drawing normally, I do not need it to be an "Autocad Table".
Is it possible?

Thanks in advance

[fuccaro]

Did you try copy-paste special?

Select the region you need and copy it to the clipboard. In AutoCAD: right-click, clipboard, paste-special. Choose "AutoCAD object" and insert the table in the drawing. You can explode it if that's what you wish...

[itacad]

oh thanks! I didn't know that!
the formatting is not pasted optimally but it is the most convenient solution and similar to what I need!
Thanks!

[BIGAL]

getting cell information from Excel is not a problem via Acad or Brics cad also Libre Calc. You can get columnwidth's using cad.  Alan Excel library.lsp

 

(vlax-get (vlax-get-property  (vlax-get-property myxl "ActiveSheet") "Range" "A1") 'columnwidth)

 In this attached is lots of functions you can use not actual code. One function is just get the actual used range in a spreadsheet. So that makes the double loop required for rows & columns.

 

So can make a table then read all the cells.

 

What other properties of a cell are you after ? Mybe post a excel.