Olá,
Estou usando o seguinte código ilogic para exportar a quantidade de itens da BOM para o excel:
.ActiveCell.Value = ThisBOM.CalculateQuantity("Parts Only", ShortName)
porem esse código recalcula a BOM e somente exporta a quantidade real de componentes que estão inseridas no desenho...
minha necessidade é que exporte o valor editado ou seja Static Quantity se alguém souber fico grato.
Solved! Go to Solution.
Solved by xiaodong_liang. Go to Solution.
Hi,
Could you write the question in English? I am afriad not many peers are familar in the language you wrote in. Thank you!
or you may search with the keywords "Export BOM Excel" if there is any existing posts.
Below is english version of query
Hello,
I am using the following code to export the iLogic amount of BOM items to excel:
. ThisBOM.CalculateQuantity ActiveCell.Value = ("Parts Only", ShortName)
put this code recalculates the BOM and only exports the actual quantity of components that are embedded in the design ...
My need is to export the edited value or Static Quantity if anyone knows I am grateful.
Hi,
I did not find a direct way of iLogic. But the Inventor API can access it. the code below can run in iLogic. It dumps the edited quantity of the first row of the first bomview.
Dim oBom quantity = ThisApplication.ActiveDocument.ComponentDefinition.BOM.BomViews(1).BomRows(1).TotalQuantity MsgBox(quantity )
thanks Adam's translation.
Our engineer team confirmed that you would have to use the Inventor API BOMRow.TotalQuantity property to read back the overridden quantity. The CalculateQuantity function is specifically intended to recalculate the quantity without any override.