You can use Generic data type as an output vairable for “Get Row Item” Activity because when you will use “Ctrl+k” it will create a variable of Generic data type for that activity but still you can use string data type as well depends on input excel data datatype.
thanks for your reply. I can perform “get row item” as well. what I cannot perform is to get multiple row items…may I know if UIPath hv similar function of getting multiple row items and save to different string output? thanks~
Hi @aksh1yadav, it looks great! just a quick question, im pretty new to UiPath, where can I find all the functions like dt1.Columns.Cast(Of DataColumn).Select(function(x) x.ColumnName).ToArray(). Im not sure which are the syntax that are compatible in UiPath
Btw how do I paste them into excel workbook in the same format? I don’t really know how to iterate row by row, so currently if I use add data row, all the information will be in one column instead of row by row
@aksh1yadav basically im trying to select certain entries and write those rows to another excel workbook. The video tutorial from the website shows how to do that if there are a few columns, Excel Automation Tutorial - DataTables Automation | UiPath, for this video, the last example is what I am trying, just that instead of the 3 columns, is there a way to read multiple columns at the same time instead of creating a get row?
Hey hi @aksh1yadav I just need explanation for the code " dt1.Columns.Cast(Of DataColumn).Select(function(x) x.ColumnName).ToArray()." what is that function(x).? what x stands for?? Please reply me as soon as possible. because i need same line of code to extract data…