Export Table

Export Table

Anonymous
Not applicable
6,661 Views
23 Replies
Message 1 of 24

Export Table

Anonymous
Not applicable

My original goal was to export a table with the push of a button. I've looked at vba and lisp methods. However, I'm struggling with identifying the table with any method. This is as close as I've made it. I want to name the exported file ( .csv ) as the current layout tab name. I don't want to see the dialog box. When using the lisp below, I have to select the table first which I can live with.

 

The table I export is a material list and I sometimes have as many as five tabs in one file I have to export. I would be fine with switching to each tab in order to run this procedure.  

 

I have limited experience with lisp and no experience with AutoCAD vba but, have used it with excel. Would someone help point me in a better direction. 

 

(defun c:tabx()
	(command "tableexport" "" "test.csv")
	(princ "\nTable Export Complete:")
	(princ)
) ;_end of defun

 

Steve.

Accepted solutions (2)
6,662 Views
23 Replies
Replies (23)
Message 21 of 24

aridzv
Enthusiast
Enthusiast

Not only extensive but also clean,run fast,give very good results and it put me in another programming language.

and I used it a lot all ready...

 

But I started this question from lisp and I wondered if it is possible to do it with lisp?

 

aridzv.

 

0 Likes
Message 22 of 24

Sea-Haven
Mentor
Mentor

I posted an answer that is lisp.

Message 23 of 24

aridzv
Enthusiast
Enthusiast

@Sea-Haven 

Hi.

do you mean using your "insimage" function from "Alan Excel.lsp" inside "tab2excel.lsp" after exporting the table images?

 

0 Likes
Message 24 of 24

Sea-Haven
Mentor
Mentor

Yes the lisp code is for insert an image in Excel.in Alan Excel.lsp is lots of functions you need to copy them out and use in your code.

0 Likes