export Coordinates from CAD to Excel

export Coordinates from CAD to Excel

iftikharahmed_arain
Participant Participant
966 Views
0 Replies
Message 1 of 1

export Coordinates from CAD to Excel

iftikharahmed_arain
Participant
Participant

Excellent solution was provided by Ranjit Singh to one of my request for help. The Lisp code was to the point and so simple to understand for the person like me who never used Lisp before. it was so easy that I managed to edit this code to create a new code for a different type of coordinates (requiring no angle). It was explained well step by step how to run the Lisp code. 

When I put my first post on forum ,I just asked for simply exporting data from CAD to Excel and attached a simple CAD drawing and Excel data file to avoid make it complicated so that you guys on forum easily understand what I need because I was not sure in getting any solution but thanks to Ranjit he done it.  The code provided by Ranjit Singh helpful for me to export 90% of data from CAD to Excel, I need some amendment in the code and also there are some other additional detail that also required to export to excel file explained as under; I have attached CAD and excel files. I have deleted 90% detail in these files for clarity. 

1. 90% of Rail seats require 2 sets of rail clips but at some position require only 1 rail clip as shown in drawing for sleeper no's 109 to 112.

    a. Refer excel file- sleeper no. 109, Rail seat B with 1 Clip, how I can skip Column L & M after capturing angle & coordinates of clip no. 3

        Rail seat C with 1 clip, how I can skip columns N & O then to capture angle & coordinates of clip no. 6.

2. Sometime I need to export some other additional details as shown in tabs on excel file

     a. Insulator Clips.  Only one position of Clip with  XY Coordinates & angle.

     b. Vossloh Inserts. Only XY Coordinates, no angle required.

     Is it possible to export data in other  tab on excel file? 

If solution not possible for above both items 1 & 2, Is it possible to pause using Code provided by Ranjit Singh and to put detail manually by keyboard then again resume to export detail by code.

     

0 Likes
967 Views
0 Replies
Replies (0)