+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Forum Newbie
    Discipline
    Facilities Mgmt
    Using
    AutoCAD 2011
    Join Date
    Mar 2017
    Posts
    6

    Default Inserting Excel spreadsheet

    Registered forum members do not see this ad.

    Hi All,


    I have inserted an excel spread sheet into CAD but not all the columns are displayed. It is only when I click on it and it opens in excel that I can see all the data. I want to save the maps in PDF format to distribute to my colleagues as they don't have CAD so will not be able to click on the table to see all the data. Any suggestions?.


    Big thanks


    Franny

  2. #2
    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 K4200, 4GB 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 2018
    Join Date
    Nov 2005
    Location
    Norwalk, CT USofA
    Posts
    46,496

    Default

    Did you insert the spreadsheet as an OLE object? If so, did you import it or embed it?

    One option would be to grab a screenshot of the spreadsheet using the Windows Snipping Tool then insert the saved image into your drawing using the IMAGEATTACH command.
    Last edited by ReMark; 23rd May 2017 at 11:13 am.
    "I have only come here seeking knowledge. Things they wouldn't teach me of in college." The Police

    Eat brains...gain more knowledge!

    I'm now a full member of the Society for the Promotion of Mediocrity in CAD. Standards? We don't need no stinkin' standards! Take whatever advice I offer and do the opposite.

  3. #3
    Luminous Being RobDraw's Avatar
    Using
    MEP 2017
    Join Date
    Apr 2007
    Location
    Connecticut, USA
    Posts
    5,169

    Default

    If you want a table that references the excel sheet so that when changes are made they can be updated within AutoCAD with having to reinsert it, look into DATALINK and AutoCAD tables.
    Drafting is a breeze.

  4. #4
    Super Member chulse's Avatar
    Computer Details
    chulse's Computer Details
    Operating System:
    Windows 7
    Monitor:
    17" wide screen laptop w/ 22" acer
    Discipline
    See details...
    chulse's Discipline Details
    Occupation
    Senior Urban Forester
    Discipline
    See details below.
    Details
    Tree Preservation Planning for civil design and developent
    Using
    Civil 3D 2016
    Join Date
    Jul 2007
    Location
    Front Royal, Virginia
    Posts
    1,320

    Default

    Registered forum members do not see this ad.

    Lately I've taken to printing my excel stuff to PDF and referencing the PDFs into cad. Makes formatting and updating large excel files easier than replacing OLEs. Just update the PDF file.
    Cary Hulse
    Senior Urban Forester
    Wetland Studies and Solutions

Similar Threads

  1. Import excel spreadsheet?
    By Evelynn in forum AutoCAD 2D Drafting, Object Properties & Interface
    Replies: 8
    Last Post: 22nd Jan 2014, 03:01 am
  2. CAD blocks to excel spreadsheet
    By sjw in forum AutoCAD Beginners' Area
    Replies: 6
    Last Post: 5th May 2010, 09:19 am
  3. Inserting an Excel Spreadsheet as a block or image
    By islandeast in forum AutoCAD Beginners' Area
    Replies: 1
    Last Post: 3rd Nov 2008, 06:15 am
  4. Autocad and Excel Spreadsheet
    By newbie84 in forum AutoCAD General
    Replies: 9
    Last Post: 13th Jun 2008, 06:54 am
  5. Importing Excel Spreadsheet
    By CADken in forum AutoCAD Drawing Management & Output
    Replies: 4
    Last Post: 7th Jun 2007, 07:52 pm

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