Sunday, 19 August 2012

L19 - XML Output Value


Step 1 Make a sample xml file as below

<note>
<to>To</to>
<from>Manu</from>
<heading>Learn</heading>
<body>today</body>
</note>

Step 2

To set XML Output Valuet (From resource) Go to Menu Insert -> Output Value -> XML Output Value  (From resource)

Step 3 

Option to choose XML file from source will come, choose any xml file saved to the system.

Step 4

Now a new window will open with name "XML Output properties", check the check boxes on left side whatever needs to be as Output during runtime and press Ok.

A line of code will generate for xml check point as below:

XMLFile("text.xml").Output CheckPoint("text.xml")
We can read the value using below code.
x=datatable.Value("value_from_out", dtgglobalsheet)
msgbox x