Node method (.NET): XmlImportXml in Workbook from ExcelApplication

[planiste]

Hello everyone,

I am quite new to labview and I am on a project where I need to import XML data into excel spreadsheet basically.

So I am trying to use the method XmlImportXml with Workbook as reference but I can't find any examples where this method is used and I don't know how to use the entry "Destination" of this method.

Here a visual example of what I am trying to do:

The idea is just to import on every sheet my XML data, so I browse all the sheet and want to import my data with the method XmlImportXml but I can't find a way to give the "Destination" entry a proper format to tell it I want to write at a specific spreadsheet and range.

If someone has an example using this method, I am all for it

Thanks in advance.

Planiste

[planiste · Accepted solution]

After some research, I find out that my labview code was correct. The only problem here was that my excel sheet already had an array from a previous import therefore the map format didn't match. 

Just for information, my value RANGE2 was "A1".