probably VB would be better/easier (unless you an old-time GRIP hacker)
If a journal, you may have to export data as CSV then open Excel. (I am not sure what export options are available for BOMs)
If a compiled program, you *may* be able to hook directly into the spreadsheet (may depend if Office & Excel use the same version of .NET or whatever)
Production: NX10.0.3.5 MP5 + patch/TC11.2
I'd rather be e-steemed than e-diseaseled
The namespace UF_XS has functions to export and import spreadsheets.
Would be good to always specify the NX release you are working with.
What application are you trying to export the parts list, modeling, drafting, manufacturing, etc.?
Production: NX10.0.3, VERICUT 8.0, FBM, MRL 3.1.4 | TcUA 10.1 MP7 Patch 0 (10.1.7.0) | TcVis 10.1
Development: VB.NET, Tcl/Tk Testing: NX11.0 EAP, NX12.0 EAP
How to Get the Most from Your Signature in the Community
See UF_PLIST_list_to_file(). It is documented as follows:
"Lists the parts list to the specified output file. This takes into
consideration any additions or removals from the parts list, any
changes to: the member attributes, the parts list format, or the output
modes like sorting and callouts."
It is also wrapped for use in .Net. There is no choice of file format, so you'll have to come up with some clever way to get it into the spreadsheet in the format you want.