Reading from excel

bot1robot

Member
Agree with @Janya . Utilit-xml VBO contains actions named "Get Elements","Get Element","Read File" etc.
These actions includes parsing and processing of xml data which may lead to more processing time.
If in case you need to convert xml data to datatable bellow code would be helpful .

DataSet ds = new DataSet();
ds.ReadXml("D:\testFile.xml");
DataTable dt = ds.Tables[0];
This code can be stuffed inside code stage with xmlFilePath as input and collection as output.

Hope this helps.
 
Top