Troubles with APPs and LISP routine - Need text to excel

[Anonymous]

Hello All,

I have searched everywhere for a solution to my problem. I can't seem to find it anywhere.

Here's my dilemma:

I need a way to extract text from my drawing (Acad 2018) and put it in Excel.

(I would like the text to be in somewhat an order as I pick it or window around it. )

I had IT guys download the APP "TEXTTOEXCEL."

For some strange reason, I could not get this APP to work. I consistently got "Unknown Command".

I contacted the writer of the APP, he sent me a new .vlx to download and re-load into AutoCAD.

I did that, and now I get an error "This routine is only available for ***** Office".

In the meantime, I've downloaded several other text-to-excel LISP routines, thinking that should work.

Each and every one of them, I get an error, unknown command, nil....etc......

I use AutoCAD Electrical 2018, but I only utilize the 2D Drafting & Annotation.

I know and understand LISP routines to get by. I know how to load them, modify on a small level and use them.

But I cannot understand why I cannot get ANY of these things to work on my AutoCAD.

The IT department here doesn't know AutoCAD at all. All they understand to do is to install it, but customization is not on their list of thing to know.

I really need something to work, due to my bosses are counting on me to find something.

Any suggestions????

[rkmcswain]

Do you have to have the routine open the data in Excel?

There are many existing routines that could dump the data to a .CSV file, which the user can then open in Excel.

Here is a very basic one, with no sorting of the selection: http://www.turvill.com/t2/free_stuff/tx2asc.lsp

If you need a professional tool to dump it straight into Excel, then what is your budget?

[Anonymous]

I tried the routine you linked and it did nothing. I appload the LISP routine, did command prompt "TX2ASCM" and it does nothing. It doesn't ask me to select text, or window, nothing. What could be going wrong??

It doesn't HAVE to be a routine, but I figured they are (were) so easy for me to work with, that I thought I would find one that worked, or at least find out why I cant get these APP's and LISP routines to work on my machine.

I don't have the authority to purchase anything, so I can't say what my budget would be.

It would be nice to find something free, since there are so many things available out there.

[3wood]

For simple task, you can try DATAEXTRACTION.

[Anonymous]

Thank you for replying. I have tried Data Extraction, but I didn't work good for the way I wanted the text sorted.

In the meantime, I got the lisp routine and APP working on my computer.

[DannyNL · Accepted solution]

In case the the suggested standard Extract Data tool is not sufficient for your needs.

Direct Excel output is more effort to program and is dependent on if and what version of Office is installed on the current system.

CSV output that can be read by Excel is easy and basic output is not very difficult to program. Basic sorting is possible, but sorting afterwards in Excel is much easier to accomplish.

As with all request; please post an example drawing and also what the output needs to be. That way it will be easier to tell what is possible and if it's easy to build.

[Anonymous · Accepted solution]

Thanks for your reply, but I got things working with the lisp and app I had troubles with earlier.