LISP Modification to add to existing Excel File

[JoeMama22]

I have found this dimension exporter on this very forum. I need to modify it so that I can add other drawings to the same excel file. Currently I have to delete the dim exp file to redo the command onf another drawing. 

Is there any way I can modify this so that the data goes to the same excel file but in a separate row?

 

I am new to AutoCAD lisp and am willing to learn from anybody offering tips!

Thank you.

dimexp.lsp

[pkenewell]

This works for me if the drawings are in the same folder, since the path uses (getvar "dwgprefix"). If you want multiple files in different locations to go to the same csv file, Change:

 

fn (strcat (getvar "dwgprefix") "DimExp.csv")

TO

fn (strcat "C:\\MyPath\\" "DimExp.csv");; Where "C:\\MyPath\\" is the path you want the file to be writtien regardless of the drawing.
			;; It must be an existing path, use '\\' between folders and also end with the same '\\' double-backslash

 

Edited May 7, 2021 by pkenewell

[BIGAL]

You can get Autocad to talk to excel so you can get the last row column value, then would write to the next line, you can also add worksheets if required.

 

The Autocad => Excel is difficult but achievable. You may need a custom solution ie may have to pay, or else will need to paste together snippets of code to do your task.

 

I would start with Getexcel.lsp by Terrycad. The maxrow maxcolumn is in Getexcel, so is putcell for a value