Using excel Developer I can convert a data table into XML file using a template.
It is possible to load this XML file content as String to a cell in another sheet?
e.g.,
Sheet 1
col1 col2 col3
a 1 z
b 2 x
c 3 w
This table can be exported using a template as
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<conf xmlns:xsi="http://ift.tt/ra1lAU">
<data>
<col1>a</col1>
<col2>1</col2>
<col3>z</col3>
</data>
<data>
<col1>b</col1>
<col2>2</col2>
<col3>x</col3>
</data>
<data>
<col1>c</col1>
<col2>3</col2>
<col3>w</col3>
</data>
</conf>
How can I put this XML as String into Sheet2 in A1 cell?
No comments:
Post a Comment