Exporting dimensions and block info to excel

[MichaelAllfire]

Hi all!

 

I am trying to accomplish a specific task, one that requires exporting information from CAD to excel. Fixo's DX (dimension export) LISP is a pretty good start, but I am trying to add some features to the command.

 

Currently, the command writes the exported information vertically in columns. I am hoping to have the information run across the page in a long row. I also would like to be able to select a dimension, then select a block and have the information written to the sheet. If I don't select a dimension immediately after a dimension, I want to skip a cell in excel. See attached diagrams for the result I am after.

 

Basically I want to select the dims and blocks down the line ...

 

And have the output to show something like this (not requiring the headings, just the data in row 2 is enough)

 

I would also like the command to write the information to a particular excel file, one named "Dimensions and blocks.xlsx" that sits in the folder above the current dwg file if possible. Fixo's currently writes to a new blank workbook each time the command is run.

 

Thanks all for the help!