BOM export Excel template

Integrated solution for design, manufacturing and management that provides all standard parts and procedures for wood processing.

Moderators: remi77, Daniel, jacs

User avatar
OMG
Sergeant
Sergeant
Posts: 51
Joined: Sun Nov 11, 2018 7:26 pm
TopSolid Module: TopSolid'Wood
TopSolid Version: 6.20

BOM export Excel template

Unread post by OMG »

Hello

Can you tell me, please, how an Excel file should be defined to work as a template for "use an excel template" option of BOM export to file?
When I try to use this option, TSW overwrites the Excel template file (header and everything).

Thank you
by Woody31 » Thu Jun 17, 2021 1:37 pm
Hello

One of the easier way

1) create a BOM export to an excel file
2) check the names for each cell ( TOP_col0 / TOP_col1...) it's following the BOM columns sequence

3) do such naming in a new xls file ( you can also in tool option delare and use other than the main folio)

4) When exporting a BOM select the final xls file, it will write under the named cell
Go to full post
Woody31
Corporal
Corporal
Posts: 24
Joined: Thu Mar 25, 2021 4:39 pm
Answers: 2
TopSolid Module: TopSolid'Wood
TopSolid Version: 6.22

Re: BOM export Excel template

Unread post by Woody31 »

Hello

One of the easier way

1) create a BOM export to an excel file
2) check the names for each cell ( TOP_col0 / TOP_col1...) it's following the BOM columns sequence

3) do such naming in a new xls file ( you can also in tool option delare and use other than the main folio)

4) When exporting a BOM select the final xls file, it will write under the named cell
Attachments
BOM.jpg
RaudMees
Volunteer Cadet
Volunteer Cadet
Posts: 171
Joined: Wed Dec 30, 2015 11:25 am
TopSolid Module: TopSolid'Wood
TopSolid Version: 6.20
Contact:

Re: BOM export Excel template

Unread post by RaudMees »

You can put those cell names everywhere in Excel. They don't need to be side-by-side. You can skip some columns for math things etc. I have temaplate where named cells starts from row 10. Upper area is for project data and company logo.
It's very nice tool.

RM
User avatar
OMG
Sergeant
Sergeant
Posts: 51
Joined: Sun Nov 11, 2018 7:26 pm
TopSolid Module: TopSolid'Wood
TopSolid Version: 6.20

Re: BOM export Excel template

Unread post by OMG »

Hello

I've tried the Woody's solution and it works just fine, even with some calculation cells on the right side, outside of TSW exported columns.

I will try Raud's idea too because it seems to be very interesting, although I don't know how to protect anything else except the top row not to be overwritten by TSW.

Thank you all for your valuable support!
RaudMees
Volunteer Cadet
Volunteer Cadet
Posts: 171
Joined: Wed Dec 30, 2015 11:25 am
TopSolid Module: TopSolid'Wood
TopSolid Version: 6.20
Contact:

Re: BOM export Excel template

Unread post by RaudMees »

Put Your TOP_col1 to A10 for example. Then rows 1-9 will be empty.
User avatar
OMG
Sergeant
Sergeant
Posts: 51
Joined: Sun Nov 11, 2018 7:26 pm
TopSolid Module: TopSolid'Wood
TopSolid Version: 6.20

Re: BOM export Excel template

Unread post by OMG »

Thank you RaudMees

Your advice was very useful. I already share it with my colleagues.

PS:
I wonder if this kind of trick can be found anywhere in TSW documentation.
Post Reply