element14 Community
element14 Community
    Register Log In
  • Site
  • Search
  • Log In Register
  • Community Hub
    Community Hub
    • What's New on element14
    • Feedback and Support
    • Benefits of Membership
    • Personal Blogs
    • Members Area
    • Achievement Levels
  • Learn
    Learn
    • Ask an Expert
    • eBooks
    • element14 presents
    • Learning Center
    • Tech Spotlight
    • STEM Academy
    • Webinars, Training and Events
    • Learning Groups
  • Technologies
    Technologies
    • 3D Printing
    • FPGA
    • Industrial Automation
    • Internet of Things
    • Power & Energy
    • Sensors
    • Technology Groups
  • Challenges & Projects
    Challenges & Projects
    • Design Challenges
    • element14 presents Projects
    • Project14
    • Arduino Projects
    • Raspberry Pi Projects
    • Project Groups
  • Products
    Products
    • Arduino
    • Avnet Boards Community
    • Dev Tools
    • Manufacturers
    • Multicomp Pro
    • Product Groups
    • Raspberry Pi
    • RoadTests & Reviews
  • Store
    Store
    • Visit Your Store
    • Choose another store...
      • Europe
      •  Austria (German)
      •  Belgium (Dutch, French)
      •  Bulgaria (Bulgarian)
      •  Czech Republic (Czech)
      •  Denmark (Danish)
      •  Estonia (Estonian)
      •  Finland (Finnish)
      •  France (French)
      •  Germany (German)
      •  Hungary (Hungarian)
      •  Ireland
      •  Israel
      •  Italy (Italian)
      •  Latvia (Latvian)
      •  
      •  Lithuania (Lithuanian)
      •  Netherlands (Dutch)
      •  Norway (Norwegian)
      •  Poland (Polish)
      •  Portugal (Portuguese)
      •  Romania (Romanian)
      •  Russia (Russian)
      •  Slovakia (Slovak)
      •  Slovenia (Slovenian)
      •  Spain (Spanish)
      •  Sweden (Swedish)
      •  Switzerland(German, French)
      •  Turkey (Turkish)
      •  United Kingdom
      • Asia Pacific
      •  Australia
      •  China
      •  Hong Kong
      •  India
      •  Korea (Korean)
      •  Malaysia
      •  New Zealand
      •  Philippines
      •  Singapore
      •  Taiwan
      •  Thailand (Thai)
      • Americas
      •  Brazil (Portuguese)
      •  Canada
      •  Mexico (Spanish)
      •  United States
      Can't find the country/region you're looking for? Visit our export site or find a local distributor.
  • Translate
  • Profile
  • Settings
Autodesk EAGLE
  • Products
  • More
Autodesk EAGLE
EAGLE User Chat (English) How to place parts using spread sheet
  • Blog
  • Forum
  • Documents
  • Events
  • Polls
  • Files
  • Members
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
Join Autodesk EAGLE to participate - click to join for free!
Actions
  • Share
  • More
  • Cancel
Forum Thread Details
  • Replies 7 replies
  • Subscribers 170 subscribers
  • Views 644 views
  • Users 0 members are here
Related

How to place parts using spread sheet

Former Member
Former Member over 15 years ago

I want to import a spread sheet with the location of where I want the parts

to be layout on my PCB. Is that possible? How would one do that?

 

 

 

  • Sign in to reply
  • Cancel
  • autodeskguest
    autodeskguest over 15 years ago

    Dang Tran wrote:

    I want to import a spread sheet with the location of where I want the parts

    to be layout on my PCB. Is that possible? How would one do that?

     

    in the end you need to issue 'move partname (x y)' commands in the

    board context for each part you want to place.

     

    How you get that commands generated from your speadsheet is up to you

    8-)

     

     

    either let the speadsheet application generate it,

     

    or export the the data to a text file, then write an ULP that parses

    the text file and generates the commands.

    --

     

    Lorenz

     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • autodeskguest
    autodeskguest over 15 years ago

    On 5/26/2010 11:01 AM, Dang Tran wrote:

    I want to import a spread sheet with the location of where I want the parts

    to be layout on my PCB. Is that possible? How would one do that?

     

     

     

    Hi Dang,

     

    The example illustrates how you can use a spreadsheet to move the

    components on a board. This was sent to a support customer and I thought

    it would be good to post.

     

    The first thing to do was to obtain the part numbers and values from the

    board. For this I used the bom.ulp and exported from it a text file.

    This file is originally tab delimited, however it's not organized well

    enough so I had to go in and add one more delimiter in order for the

    data to import correctly into OpenOffice. I included both files so you

    could see what I did.

     

    I then imported the data into OpenOffice, using the open command. Now

    things get interesting if you look on sheet 2, I created two columns

    with the x, y locations for the components and I transferred the part

    name to sheet 2 below it I setup the syntax for a script file and then

    had OpenOffice reference the values I inputed for x and y ( As shown it

    places all of the components in a diagonal line, if you have the free or

    standard version you might not be able to execute all of the moves since

    the last part would be placed at 6,6 (I set my grid to inches).

     

    With the syntax up, I open Notepad(Or equivalent text editor) and simply

    copy paste the syntax from the spreadsheet into the Notepad. Save the

    text file with the extension .scr(Script file).

     

    If you run the script in EAGLE you'll get the results shown in the

    included board file.

     

    Hope this gives you some cool ideas.

     

    Regards,

    Jorge Garcia

     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • autodeskguest
    autodeskguest over 15 years ago

    "Jorge Garcia" <jorge@cadsoftusa.com> wrote in message

    news:htmju0$tga$2@cheetah.cadsoft.de...

    On 5/26/2010 11:01 AM, Dang Tran wrote:

    I want to import a spread sheet with the location of where I want the

    parts

    to be layout on my PCB. Is that possible? How would one do that?

     

    Hi Dang,

     

    The example illustrates how you can use a spreadsheet to move the

    components on a board. This was sent to a support customer and I thought

    it would be good to post.

     

    The first thing to do was to obtain the part numbers and values from the

    board. For this I used the bom.ulp and exported from it a text file.

    This file is originally tab delimited, however it's not organized well

    enough so I had to go in and add one more delimiter in order for the

    data to import correctly into OpenOffice. I included both files so you

    could see what I did.

     

    I then imported the data into OpenOffice, using the open command. Now

    things get interesting if you look on sheet 2, I created two columns

    with the x, y locations for the components and I transferred the part

    name to sheet 2 below it I setup the syntax for a script file and then

    had OpenOffice reference the values I inputed for x and y ( As shown it

    places all of the components in a diagonal line, if you have the free or

    standard version you might not be able to execute all of the moves since

    the last part would be placed at 6,6 (I set my grid to inches).

     

    With the syntax up, I open Notepad(Or equivalent text editor) and simply

    copy paste the syntax from the spreadsheet into the Notepad. Save the

    text file with the extension .scr(Script file).

     

    If you run the script in EAGLE you'll get the results shown in the

    included board file.

     

    Hope this gives you some cool ideas.

     

    Regards,

    Jorge Garcia

     

    Please post your examples. I am interested in a similar process. I would

    like to see a ulp/scr that places the components within the PCB with

    positioning relative to positions in the schematic. I think this would be a

    nice starting point for the PCB.

     

    BTW: By coincident I modified bom_w_attr_v1.03.ulp last night to have

    selectable delimiters for CSV output because it wouldn't open cleanly in

    excel.

     

    regards

    Greg

     

     

     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • autodeskguest
    autodeskguest over 15 years ago

    On 5/27/2010 6:18 PM, Greg Erskine wrote:

    "Jorge Garcia"<jorge@cadsoftusa.com>  wrote in message

    news:htmju0$tga$2@cheetah.cadsoft.de...

    On 5/26/2010 11:01 AM, Dang Tran wrote:

    I want to import a spread sheet with the location of where I want the

    parts

    to be layout on my PCB. Is that possible? How would one do that?

     

    Hi Dang,

     

    The example illustrates how you can use a spreadsheet to move the

    components on a board. This was sent to a support customer and I thought

    it would be good to post.

     

    The first thing to do was to obtain the part numbers and values from the

    board. For this I used the bom.ulp and exported from it a text file.

    This file is originally tab delimited, however it's not organized well

    enough so I had to go in and add one more delimiter in order for the

    data to import correctly into OpenOffice. I included both files so you

    could see what I did.

     

    I then imported the data into OpenOffice, using the open command. Now

    things get interesting if you look on sheet 2, I created two columns

    with the x, y locations for the components and I transferred the part

    name to sheet 2 below it I setup the syntax for a script file and then

    had OpenOffice reference the values I inputed for x and y ( As shown it

    places all of the components in a diagonal line, if you have the free or

    standard version you might not be able to execute all of the moves since

    the last part would be placed at 6,6 (I set my grid to inches).

     

    With the syntax up, I open Notepad(Or equivalent text editor) and simply

    copy paste the syntax from the spreadsheet into the Notepad. Save the

    text file with the extension .scr(Script file).

     

    If you run the script in EAGLE you'll get the results shown in the

    included board file.

     

    Hope this gives you some cool ideas.

     

    Regards,

    Jorge Garcia

     

    Please post your examples. I am interested in a similar process. I would

    like to see a ulp/scr that places the components within the PCB with

    positioning relative to positions in the schematic. I think this would be a

    nice starting point for the PCB.

     

    BTW: By coincident I modified bom_w_attr_v1.03.ulp last night to have

    selectable delimiters for CSV output because it wouldn't open cleanly in

    excel.

     

    regards

    Greg

     

     

    Hi Greg,

     

    Let me try to post the example again. I don't know how I would post the

    results, the server tells me the files are too big.

     

    Any suggestions?

     

    Regards,

    Jorge Garcia

     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • autodeskguest
    autodeskguest over 15 years ago

    Hi Greg

     

    I would like to see a ulp/scr that places the components within the

    PCB with positioning relative to positions in the schematic. I think

    this would be a nice starting point for the PCB.

     

    Have you tried the place50.ulp that is available in the ULP downloads

    area of the Cadsoft website?  My recollection is that it does this type

    of initial placement.

     

    Regards,

    Neil

     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • autodeskguest
    autodeskguest over 15 years ago

    "Neil Allison" <neil@avon-tech-solutions.co.nz> wrote in message

    news:htq9ts$c9v$1@cheetah.cadsoft.de...

    Hi Greg

     

    I would like to see a ulp/scr that places the components within the

    PCB with positioning relative to positions in the schematic. I think

    this would be a nice starting point for the PCB.

     

    Have you tried the place50.ulp that is available in the ULP downloads area

    of the Cadsoft website?  My recollection is that it does this type of

    initial placement.

     

    Regards,

    Neil

     

    Hi Neil,

     

    That does exactly what I want. Thanks. I spent a couple of hours half doing

    it last night. I even downloaded all the ULPs from CADsoft this mornong.

    Thanks for the heads up, this one works well.

     

    regards

    Greg

     

     

     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • autodeskguest
    autodeskguest over 15 years ago

    Lorenz wrote on Thu, 27 May 2010 01:37

    in the end you need to issue 'move partname (x y)' commands in the

    board context for each part you want to place.

     

    That gets the location correct, but will use the default orientation.

     

    --

    Web access to CadSoft support forums at www.eaglecentral.ca.  Where the CadSoft EAGLE community meets.

     

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
element14 Community

element14 is the first online community specifically for engineers. Connect with your peers and get expert answers to your questions.

  • Members
  • Learn
  • Technologies
  • Challenges & Projects
  • Products
  • Store
  • About Us
  • Feedback & Support
  • FAQs
  • Terms of Use
  • Privacy Policy
  • Legal and Copyright Notices
  • Sitemap
  • Cookies

An Avnet Company © 2025 Premier Farnell Limited. All Rights Reserved.

Premier Farnell Ltd, registered in England and Wales (no 00876412), registered office: Farnell House, Forge Lane, Leeds LS12 2NE.

ICP 备案号 10220084.

Follow element14

  • X
  • Facebook
  • linkedin
  • YouTube