BOM export Excel template

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

Moderators: remi77, jacs, Daniel

User avatar
OMG
Master Chief
Master Chief
Posts: 112
Joined: Sun Nov 11, 2018 7:26 pm
Answers: 3
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
Sergeant
Sergeant
Posts: 68
Joined: Thu Mar 25, 2021 4:39 pm
Answers: 8
TopSolid Module: TopSolid'Wood
TopSolid Version: 6.23
Location: Toulouse
Contact:

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
Second Officer Cadet
Second Officer Cadet
Posts: 209
Joined: Wed Dec 30, 2015 11:25 am
Answers: 3
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
Master Chief
Master Chief
Posts: 112
Joined: Sun Nov 11, 2018 7:26 pm
Answers: 3
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
Second Officer Cadet
Second Officer Cadet
Posts: 209
Joined: Wed Dec 30, 2015 11:25 am
Answers: 3
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
Master Chief
Master Chief
Posts: 112
Joined: Sun Nov 11, 2018 7:26 pm
Answers: 3
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