NX VB Journal to create EXCEL file

[NXJockey]

Hi,

Does anybody have a simple it of example code of how to write to an EXCEL file from a NX visual basic journal please?

Kind regards,

NXj

 

[cowski]

Yamada (he created SNAP and wrote the documentation) wrote a good guide on working with NX and Excel:

Siemens Digital Industries Software Community

The guide above assumes that you have an author license (and a SNAP license, for some of the example code). If you do not have an author license, you cannot add a reference to the Excel library, but you can still effectively work with Excel (it's just more difficult).

Here are a few examples of working with Excel with no license (searching may turn up more):

http://nxjournaling.com/comment/623#comment-623

http://nxjournaling.com/comment/4964#comment-4964

If you use the example code from nxjournaling, I'd suggest adding in the "cleanup" code provided by Yamada; not all of the examples include it. Also, check the NXOpen samples folder that ships with NX; there is at least 1 example that uses Excel.

www.nxjournaling.com

 

[NXJockey]

Thanks,

NXjockey