+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Junior Member
    Using
    AutoCAD 2018
    Join Date
    Aug 2012
    Posts
    15

    Default PDF import made from Excel File into AutoCAD 2018

    Registered forum members do not see this ad.

    I've imported a PDF file that was is, in essence, an illustration originally built in Excel (yes, Excel).

    The cells are all turned off for the original lines not to show, but somehow AutoCAD is still recognizing and "re-inserting" them from the PDF import and they show horizontally in both model and paper space.

    Anyone have any idea on how (other than tracing manually) I can get rid of those scan lines? through some other file format or formats maybe?

    Thanks,

    K

  2. #2
    Super Moderator Cad64's Avatar
    Computer Details
    Cad64's Computer Details
    Operating System:
    Windows 7 Profesional x64
    Computer:
    XI Computers
    Motherboard:
    Asus P8Z77-V Pro
    CPU:
    Intel Core I7 3770K 4.1 Ghz Quad Core 3rd Gen
    RAM:
    24GB DDR3 @ 1333MHz
    Graphics:
    Nvidia GeForce GTX 570 1280MB GDDR5
    Primary Storage:
    SATAII 500GB 7200 RPM
    Secondary Storage:
    Western Digital My Book Studio Edition II - 2TB capacity
    Monitor:
    HPf2105 21" LCD Widescreen & Cintiq 21ux
    Discipline
    Multi-disciplinary
    Cad64's Discipline Details
    Occupation
    Freelance Digital Artist
    Discipline
    Multi-disciplinary
    Details
    3D model building, texturing and rendering. Photoshop Color Graphics.
    Using
    AutoCAD 2014
    Join Date
    Feb 2006
    Location
    Southern California
    Posts
    10,156

    Default

    What if you open the pdf in Acrobat and then go to the File menu and do a Save As and save to .tif or .jpg format? Will that solve the problem?
    CGSociety Portfolio: http://rdeweese.cgsociety.org/
    Facebook:
    https://www.facebook.com/rdeweese67/


    "Work Smart, Not Hard"

  3. #3
    Junior Member
    Using
    AutoCAD 2018
    Join Date
    Aug 2012
    Posts
    15

    Default

    Quote Originally Posted by Cad64 View Post
    What if you open the pdf in Acrobat and then go to the File menu and do a Save As and save to .tif or .jpg format? Will that solve the problem?
    Can a .tif or .jpg be recognized as having line and color fill individual components like a .pdf in AutoCAD? I wasn't seeing that they could be, so I've stuck with the .pdf import.

    It's a shame because AutoCAD does an amazing job importing the .pdf and separates all items as lines and hatches, but it's just too good - it detects extra horizontal (but not vertical for some reason) lines in the file that didn't show up in a .pdf viewer. Somehow they remained "embedded" from when it was originally constructed in Excel. Strange stuff, very frustrating because I can taste victory of having the workable components in AutoCAD, but the lines are outrageous/unacceptable. I went through last night deleting the extra lines manually and only got half way through to find 3 hours had gone by.

  4. #4
    Senior Member welldriller's Avatar
    Computer Details
    welldriller's Computer Details
    Operating System:
    Windows 10 Home
    Computer:
    Dell inspiration 3650
    CPU:
    x64 processor
    RAM:
    8 GB
    Monitor:
    Dell P190SB#4
    Using
    Solidworks 2017
    Join Date
    Jan 2013
    Location
    Prince George, Va.
    Posts
    299

    Default

    I may be reading your problem all wrong but could it that print grid lines is turned on in Excel?
    Attached Images

  5. #5
    Junior Member
    Using
    AutoCAD 2018
    Join Date
    Aug 2012
    Posts
    15

    Default

    Registered forum members do not see this ad.

    That's ok, thanks for the reply. Yes, I made sure that the print grid lines were all turned off in Excel prior to exporting/generating the pdf. The pdf is fine, wherever it is opened up, i.e Photoshop, Illustrator, Acrobat, etc., but when the pdf import is used in AutoCAD, no matter how I change the import settings, the extra horizontal lines are there.

Similar Threads

  1. Sheet Setup Made Easy with AutoCAD 2018.1 Views and Viewports
    By The CAD Geek Blog in forum AutoCAD RSS Feeds
    Replies: 0
    Last Post: 2nd Aug 2017, 05:50 pm
  2. Replies: 2
    Last Post: 8th Apr 2015, 12:54 pm
  3. import excel file
    By silviu30 in forum AutoCAD General
    Replies: 12
    Last Post: 8th Aug 2010, 12:35 pm
  4. Best Way To Import An Excel File To AutoCAD?
    By AQucsaiJr in forum AutoCAD General
    Replies: 10
    Last Post: 8th Dec 2008, 10:08 pm
  5. Import Txt From External File (excel)
    By MARK in forum AutoCAD Drawing Management & Output
    Replies: 5
    Last Post: 27th Jun 2007, 10:27 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