Open a Spreadsheet

Submitted by fmattel on Thu, 05/11/2017 - 03:20
Forums: 
Journaling / NXOpen API

Good Morning

My question is simple.
I have a part with a SpreadSheet in. This SpreadSheet updates the part thanks to the connection between the SpreadSheet and UG Expressions.

I know that is possible to open an external excel file using Open NX but is it possible to open the Part's SpreadSheet with Open NX, execute a macro inside this spreadsheet and close the spreadsheet ?

Thanks in advance

NXJournaling - Thu, 05/11/2017 - 08:00

The .ExtractSpreadsheet and .StoreSpreadsheet methods should do what you want. You can extract the part spreadsheet to Excel, manipulate it, and finally store the results (if desired) back in the part file. The closest example code that is currently on the site can be found here:
http://nxjournaling.com/content/editing-spreadsheet-controlled-tabular-note

The code edits a spreadsheet controlled tabular note. It successfully extracts the spreadsheet, but errors when trying to store the spreadsheet due to a limitation with the method (ER 7540975). It should work with the modeling or gateway sheet, though.

fmattel - Thu, 05/11/2017 - 21:24

Hello

Yes, I think I can do something like. In fact I just need to extract the spreadsheet (or perhaps just a single sheet , not the complete spreadsheet to gain time) and execute the Excel VBA Code from this single sheet.
I don't need to store the result back in the Part's spreadsheet at the end because my VBA Code just send information from the Extracted sheet to an Access DB.

I will try and post my code if it works

Many thanks for your support