Export text to Excel

Does anyone know of a lisp routine that would allow me to extract all Mtext annotations from a drawing and export them to Excel.

Thanks

 

If you can work with a .csv (comma seperated value) file, I can whip up a Lisp to extract and output to that format.

Bob

 

Search for "Visual Lisp & Excel" by ChrisW 4/8/2004 at 2:20pm and then look
at my response "Re: Visual Lisp & Excel by Alan Henderson 4/9/4 at 8:57am".
I posted a program that you will have to modify to work for you.

 

Why don't you just scan the drawing for all mtext entities using ssget and
then use the write-line function to output it to a csv file?

 

Thanks Bob. If all the text from the drawing was able to import into the Excel file and all I had to do was go into Excel and format it, that would work great.

Respond with the details here and maybe leave me a number where I can call you at.

Thanks

Chris

 

Chris,
Give me an E-Mail at
remove the nospam.

Bob

 

Thats a start Alan, but I wouldn't know the first thing about modifying it.

Would love to Devin, but I am not a programmer and that is a bit over my head. Just looking for the easiest way to do this.

You guys have to remember that sometimes the basic CAD guys post to this board for help and that is what I am.