Excel 2007 & R16
Excel 2007 & R16
(OP)
I am running R16 and recently upgraded to excel 2007.
Is it possible to export a Catia R16 bill of material to excel 2007? I keep getting an error.
Secondly, I would like to create a document that list part weights of an assembly. I would like to link that document to the part models...is this possible?
Thanks,
Is it possible to export a Catia R16 bill of material to excel 2007? I keep getting an error.
Secondly, I would like to create a document that list part weights of an assembly. I would like to link that document to the part models...is this possible?
Thanks,





RE: Excel 2007 & R16
2)I create a parameter (Type=mass) in the property page of the part. I create a formula like this smartVolume(PartBody )*Density
Density I pull from a design table common to all flexible parts. Now the weights are available to the BOM.
Regards,
Derek
RE: Excel 2007 & R16
"The file you are trying to open, spreadsheet.xls, is a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
It saves a file to the desinated folder, but the file is empty and I get the same message as shown above when I try to open the file.
Could you give me a little more detail on the linked weight application. The document that is created, is it linked and does it update when a part weight has changed?
Thanks Derek for the reply.
RE: Excel 2007 & R16
You generate the BOM in ASD and a weight column appears. There is no links between weight and final output .xls file. If you modify the Partbody the weight will update in Catia at the part properties page.
This process works for my application, what do you need to do with it?
Regards,
Derek
RE: Excel 2007 & R16
http
I have tried the various solutions in the link - with no success.
htt
Regards,
Derek
RE: Excel 2007 & R16
The best work-around I have found is to save the BOM as an HTML file, then open the HTML file in Excel. Take all the data and Copy > Paste Special > Values into a new file or worksheet > Save as xls. It's an extra step, but everything shows up in the right format and arrangement.
Cheers,
Mark