i have a excel(.csv) file which contain z-coordinate value in A1 to A50 cell, how can i calculate Zmin and Zmax value using visual lisp.
|
i have a excel(.csv) file which contain z-coordinate value in A1 to A50 cell, how can i calculate Zmin and Zmax value using visual lisp.
Give more details about the goal you are after .
As a primary draft of the steps that you may need to make.
* Use getfiled function to select the excel file.
* Open the file with open function.
* Use while function to iterate through the strings in every row then append the strings to a list.
* Then close the file with close function.
* Now use apply function with either of the two functions min / max on the fore-said list of strings.
Good luck.