×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Getting a spreadsheet out of a non-excel BOM (SWX06)

Getting a spreadsheet out of a non-excel BOM (SWX06)

Getting a spreadsheet out of a non-excel BOM (SWX06)

(OP)
I have been very frustrated about copying data from the non-Excel bill of materials out of SWX into a spreadsheet (for costing analysis etc). I like the new BOM as Excel seems to be clunky, but you can't copy and paste the data easily. I have been reduced to creating two drawings with the different BOM types so I can extract the data. However after a bit of fiddling around I have found a way.

If you click anywhere on the BOM, it's property manager appears on the left of the screen. One of the buttons available at the bottom of the box, called 'BOM Contents' allows you to arrange order and hide columns. If you highlight all of the rows, by clicking the empty grey box on the top left of the table (the pointer changes to an arrow) and drag down to the bottom of the row, all the rows turn black. Now press CTRL and C together (standard copy to clipboard) and voila the data is now on the clipboard. (NB: You can't right click and copy)
Paste it into the spreadsheet and you're good to go.

Plusfours
Good taste never goes out of fashion

RE: Getting a spreadsheet out of a non-excel BOM (SWX06)

Yeah, that looks good, but you need to be careful - for example, if you have a part number starting with a zero (0), when you paste it into Excel it sees it as a number and deletes the zero. Still deserves a star.

Regards,

bandh

RE: Getting a spreadsheet out of a non-excel BOM (SWX06)

One ca easily write a macro to read the data in the BOM and write it in an Excel spreadsheet. I've done it and it works. It is so fast I had to insert a timer to slow it down.

RE: Getting a spreadsheet out of a non-excel BOM (SWX06)

Or you could just click on the BOM, then do a File > Save As and select Text or CSV as the "Save as type".

cheers
Helpful SW websites FAQ559-520
How to find answers ... FAQ559-1091

RE: Getting a spreadsheet out of a non-excel BOM (SWX06)

FYI ... SW2007 also has Excel(.xls) as a "Save as type", and the "Save as" is in the RMB click menu.

cheers
Helpful SW websites FAQ559-520
How to find answers ... FAQ559-1091

RE: Getting a spreadsheet out of a non-excel BOM (SWX06)

I have also written a macro.  Works much better than saving the BOM out and then opening it up in Excel.  Saves time and some steps.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources