Exporting data from CAD to Excel

Exporting data from CAD to Excel

iftikharahmed_arain
Participant Participant
257 Views
1 Reply
Message 1 of 2

Exporting data from CAD to Excel

iftikharahmed_arain
Participant
Participant

Hi, I need some help on programming attached(RBD). In this program, data start exported from CAD drawing in row 13 on spreadsheet. 

I asked AI, how I can select row & column for entering data into spreadsheet and got program attached(RBDAI), but it didn't work as I wanted. I can select row & column but doesn't work when I press enter key to move onto other object on drawing and show an error on CAD drawing. 

Anyone could please help by looking on program file RBD and to make some amendment so I can select row & column on spreadsheet when select "yes" to move onto other object.

0 Likes
258 Views
1 Reply
Reply (1)
Message 2 of 2

Sea-Haven
Mentor
Mentor

If you know your row and column then use this.

 

;;	Thanks to fixo			;;
;;   = Set Excel cell text =    ;;
;;				;;
(defun xlsetcelltext ( row column text)
(setq cells (vlax-get-property  (vlax-get-property xclobj "ActiveSheet") "Cells"))
  (vl-catch-all-apply
    'vlax-put-property
    (list cells 'Item row column
	(vlax-make-variant (vl-princ-to-string text) vlax-vbstring)))
)
0 Likes