Results 1 to 2 of 2

Thread: extract data from excel file.

  1. #1
    Member
    Join Date
    2015-09
    Posts
    11
    Login to Give a bone
    0

    Default extract data from excel file.

    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.

  2. #2
    All AUGI, all the time
    Join Date
    2010-06
    Posts
    962
    Login to Give a bone
    0

    Default Re: extract data from excel file.

    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.

Similar Threads

  1. Extract Title Block Attribute Data to Excel
    By bzrqmy in forum AutoCAD Customization
    Replies: 7
    Last Post: 2017-04-26, 06:26 AM
  2. Please, help me extract data Dynamic Blocks and Attribute blocks to Excel
    By minhphuong.humg453254 in forum Dynamic Blocks - Technical
    Replies: 1
    Last Post: 2014-04-17, 08:12 PM
  3. Excel file data onto Civil 3D map
    By hankl32211636161 in forum AutoCAD Civil 3D - General
    Replies: 5
    Last Post: 2013-01-16, 07:21 PM
  4. Create lisp to extract data from excel file
    By Lions60 in forum AutoLISP
    Replies: 7
    Last Post: 2008-01-30, 04:32 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •