Unable to change data type from data table to list while reading from Excel
- 515 Views
- Last Post 18 May 2018
Apologies for delayed respons also thanks for your interest in INTELLIBOT!
With respect to your query,
seems like you want to execute commands on command prompt,where all the commands are stored in Excel file.
Here are the simple steps :
1.First read data from excel file using ReadFromExcel component which is under Utilities-DataReader.
2.Start cmd prompt using StartApp by providing a path of command prompt ex: C:\Windows\system32\cmd.exe.
3.Whatever the data we are reading from excel file pass it to for-each loop,which will return a single row data on each loop.
4.Connect for-each component output to GetListitem to get the column value based on its index.
5.Using Format-text component,concat a [Enter] key.
6.Drag and drop a Sendkeys component on to the designer surface and click on camera icon to capture the command prompt image, provide a Anchor ,so that component can do its action on specified anchor.
7.Output of format-text can be given as input to Sendkeys component.
For furthur details refer the given workflow image :