need help with lisp to export autocad table to csv and controlling row hight and column width

[aridzv]

Hi.

I started my quest here but asked to start a new topic.

the issue is this:

I need to export a cad table to csv and in the output csv set row hight to all the rows to a sertian value (10 for the example) and the second column width to 20 for that example.

how can I do it?

thanks,

aridzv.

[Moshe-A]

@aridzv ,

You want to set the width + height in csv file? (i thought you are talking on AutoCAD table?!)

this only possible with xlsx file, different story 😀

Moshe

[Sea-Haven]

Go back to other post I think I posted something there, yes direct to Excel you can mimic the table setting in Excel like set column width in Excel.

this is get width

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

this is put width
(vlax-put-property (vlax-get-property  (vlax-get-property myxl "ActiveSheet") "Range" "A1") 'columnwidth 28)

I am sure I have posted to you the Alan Excel.lsp so can get MYXL application.