Excel Table to CAD dwg

[Mystogan]

Hi to all,

 

I Hope someone can help me on how to solve this excel files.

I try to look all over the internet and none of them fit the way that I need it.

I had 20 workbook in 1 excel files. In every workbook has a Table in it. 

It is possible that the table format in excel where it is as it is will be place in auto cad smoothly? Meaning all the 20 workbook will be place in autocad,

The text style, spacing, size of table etc.,

 

Will be written as normally as it was done in autocad not in excel.

The table that I'm referring to, see Image attach. I also attach the excel file,which it has only 1 workbook.

 

Thank you in advance.

 

 

 

See Image 

Load sched 1.xlsx

Edited September 20, 2020 by Mystogan

[BIGAL]

Duplicating the table is feasible the only thing is getting the properties of the cells rows etc I have seen a post about getting row heights text style etc will try to find again. Need the get property property variable name. 

 

In Autocad would use vlax dump to look at table cell properties. need the .property name in particular the merge cell method. 

 

Some one may have a ".properties" list.  eg  .RowHeight .Value

 

Did some digging .ismerged, 

If .Range("B6").MergeCells Then
            Debug.Print .Range("B6").MergeArea.Address
        End If

This is not a quick task . A small fee for code may be appropriate.

Edited September 21, 2020 by BIGAL