How to create a temporary BOM excel file

[gustavo.cassel]

Hello

Im searching for a way to export the BOM structured view as a excel file, but i dont want to every time delete this file when im done.

Is there a way to export the bom structured view as a excel temporary file? Then I do my things with the information that was in it and just set the excel object to nothing.

Thanks

[basautomationservices · Accepted solution]

You can create a temporary file, just delete it after you're done.

You could also store the bom information in a list and do with it what you want, then you do not need to use excel at all.

[gustavo.cassel]

I can't store the information in a list because i need more than 1 information of the same .ipt or .iam, it like 5 informations of each.

Using a excel file it was easy to get the right info of a determined part or assembly. But i cant keep creating excel's files in my hard drive. I just want a way to create a "only virtual" excel file and work with the info.

If you know the answer for this i'll be gratefull.

[A.Acheson · Accepted solution]

Export BOM via code to a set path and filename say "TempBOMExport" in the temp folder or wherever and use System.IO to check the path exists and if it does delete the path before you export. You end up with only one file on your drive and no manual user deletion simply save and close and it will remain there untill you export a new BOM. Does that fit the workflow you want? 

This post here post 1 uses that approach, change the path as you need.