topic Re: need help with lisp to export autocad table to csv and controlling row hight and column width in Visual LISP, AutoLISP and General Customization Forum

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

aridzv — Wed, 16 Apr 2025 12:01:25 GMT

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.

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

Moshe-A — Wed, 16 Apr 2025 13:26:56 GMT

@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

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

Sea-Haven — Thu, 17 Apr 2025 01:35:41 GMT

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.