+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Forum Newbie
    Using
    AutoCAD 2012
    Join Date
    Aug 2012
    Posts
    2

    Default Exporting text to Excel

    Registered forum members do not see this ad.

    I am trying to export a manually generated material list (not an AutoCAD "table") to an Excel spreadsheet or a .csv file. I've tried selecting the text and right clicking, but there is no export option. I've also tried selecting the text and going directly to Export, but I see no option to save it as a .csv.

  2. #2
    Forum Deity MSasu's Avatar
    Discipline
    Construction
    MSasu's Discipline Details
    Occupation
    engineer
    Discipline
    Construction
    Details
    AutoLISP programmer
    Using
    AutoCAD 2013
    Join Date
    Mar 2009
    Location
    Brasov, Romania
    Posts
    3,041

    Default

    You may try to use the DATAEXTRACTION command - I believe that is better to proceed with one column or row (the ones which are less) at a time to have some level of control over data extracted.
    Regards,
    Mircea

    AutoCAD's happy user equation: FILEDIA + PICKADD² + PICKFIRST = 3

  3. #3
    Forum Newbie
    Using
    AutoCAD 2012
    Join Date
    Aug 2012
    Posts
    2

    Default

    Quote Originally Posted by MSasu View Post
    You may try to use the DATAEXTRACTION command - I believe that is better to proceed with one column or row (the ones which are less) at a time to have some level of control over data extracted.
    That seems like it will work, though it will be a time-consuming process. It seems like I remember doing this when I used AutoCAD regularly in the late 90's and it was much easier. Regardless, thank you for your help.

  4. #4
    Quantum Mechanic ReMark's Avatar
    Computer Details
    ReMark's Computer Details
    Operating System:
    Windows 7 Pro 64-bit
    Computer:
    Thinkmate
    Motherboard:
    Intel DX58SO2 LGA1366 X58
    CPU:
    Intel i7-960 Quad-core 3.20GHz 8MB cache
    RAM:
    12GB (3x4GB) PC3-106000 DDR3
    Graphics:
    nVidia Quadro 4000, 2GB GDDR5
    Primary Storage:
    150GB Velocipraptor 10,000 rpm
    Secondary Storage:
    none
    Monitor:
    Dell P24LLH - 24" wide screen LCD
    Discipline
    See details...
    ReMark's Discipline Details
    Occupation
    CAD Draftsman/Designer...chemical manufacturing.
    Discipline
    See details below.
    Details
    I work for a specialty chemical manufacturer. I do a little bit of everything from P&IDs to civil to architectural and structural.
    Using
    AutoCAD 2013
    Join Date
    Nov 2005
    Location
    Norwalk, CT USofA
    Posts
    33,486

    Default

    Registered forum members do not see this ad.

    You probably used a custom lisp routine. Something like the one in this thread...

    http://forums.augi.com/showthread.ph...o-excel-urgent
    "I have only come here seeking knowledge. Things they wouldn't teach me of in college." The Police

    Eat brains...gain more knowledge!

Similar Threads

  1. Exporting layout to excel
    By Proctor in forum AutoCAD General
    Replies: 5
    Last Post: 27th Jan 2012, 05:04 pm
  2. adding text issue and exporting to excel
    By casualmasters in forum AutoCAD Beginners' Area
    Replies: 3
    Last Post: 15th Mar 2009, 11:57 pm
  3. Exporting to Excel
    By Ndape in forum AutoLISP, Visual LISP & DCL
    Replies: 7
    Last Post: 2nd Jul 2008, 06:49 am
  4. exporting attributes to excel
    By comcu in forum AutoCAD Drawing Management & Output
    Replies: 2
    Last Post: 25th Jun 2007, 08:32 pm
  5. Associating text/location and exporting/importing to excel
    By anonypuff in forum AutoCAD Beginners' Area
    Replies: 0
    Last Post: 8th Sep 2005, 01:23 am

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