+ Reply to Thread
Results 1 to 4 of 4

Select polyline and bring area back to excel

  1. #1
    Registered User
    Join Date
    11-26-2019
    Location
    Thane
    MS-Off Ver
    2021
    Posts
    42

    Select polyline and bring area back to excel

    Hi friends,
    Please help me for autocad polyline Select and bring area back to excel with inner text (text co-ordinate if possible)

    Please check attach sample drawing and excel
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Select polyline and bring area back to excel

    I'm not sure I understand what your question is. You appear to have an Autocad file that has generated a comma delimited text file, and your question seems to be how to get that text file into Excel. Your .csv file seems to fit my regional settings for list separator and decimal separator, so I can simply open the .csv file using the File-Open command in Excel. In some situations (where your Windows regional settings are different), you may need to use the Import Data->from Text command instead to invoke the text import wizard where you can tell Excel how to import the text file.

    If there is more to your question than that, we will probably need a more detailed description of what you want to do with this text file and what you are stuck on.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    11-26-2019
    Location
    Thane
    MS-Off Ver
    2021
    Posts
    42

    Re: Select polyline and bring area back to excel

    I require area of closed polygon and text written with in it (closed polygon) in excel

    Please check attach sample drawing and excel



    i have area export to excel vba code please see
    Attached Files Attached Files
    Last edited by rajatds31; 12-24-2019 at 02:31 AM. Reason: code paste on massage sorry for that

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Select polyline and bring area back to excel

    This forum can be strict about putting code in code tags. You will want to edit your post to include the code tags (instructions should be in the FAQ/rules links) to avoid having your topic locked.

    I don't know how many of us have access to Autocad. I don't so I can't help with anything on the Autocad side of the question.

    It might be helpful to break this up into parts and focus on the parts that you need help with. How much of this question is Autocad, how much is Excel, and how much is generic geometry (how to find the area of a polygon)?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vlookup - bring back blank cell when it brings back 0 and N/A
    By julee.stein in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2018, 11:12 AM
  2. Excel formula to bring back spelling of a word
    By alexc_2018 in forum Excel General
    Replies: 3
    Last Post: 02-20-2018, 08:05 AM
  3. [SOLVED] Excel formula does not bring back results in all rows
    By jlmaytum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-07-2017, 10:56 AM
  4. Array Formula Lookup - Bring back Lowest Date + Bring Back Cell Location
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2014, 12:08 PM
  5. [SOLVED] Stop Vlookup bringing back 0's or #REF! and bring back blanks instead
    By Carling73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:43 PM
  6. Replies: 2
    Last Post: 12-20-2005, 09:40 AM
  7. [SOLVED] Bring back the FORMULA RESULT BAR in excel
    By Howard in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-19-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1