for better understanding...please see below:
I need a strategy or technology to use to achieve the following:
1) Create an XML file with the values taken from Excel file.
2) Substitute the values as shown below in the XML template file:
<node type="physicalitem" action="create">
<location>Enterprise:Box: + EXCEL_CELLVALUE[A,i]</location> // WHERE [A,i] IS A COLUMN AND i row (i=1,2,3...)
<title> EXCEL_CELLVALUE[B,i]</title>
<mediatype>87244</mediatype> // remains as a constant
<physicallocation>TIC</physicallocation> // remains as constant
<physicalproperty name="SpecNoTransNo" value=EXCEL_CELLVALUE[C,i]></physicalproperty>
<physicalproperty name="ManufacturerName" value=EXCEL_CELLVALUE[D,i]></physicalproperty>
<physicalproperty name="BoxBarcodeNumber" value=EXCEL_CELLVALUE[E,i]></physicalproperty>
<category name="Livelink Categories:Test Category">
<attribute name="Name">EXCEL_CELLVALUE[F,i]</attribute>
<attribute name="Email">EXCEL_CELLVALUE[G,i]</attribute>
</category>
</node>
Here EXCEL_CELLVALUE[B,i] is the variable or some kind that i need to replace with Excel cell values.
Any idea how can I acheieve this?
Thanks,
Mahesh