I guess you were saying about the Select Range property in Read Range Activity. If you need to grab the entire sheets data into datatable variable then leave select range property as blank. And also check the Add Header property if your sheet has headers.
I think maybe you could read the file as a datatable and then use a for each activity to loop through each column (item) and assign the values to another variable as say, an array of int, which you can then use for pasting elsewhere?
This is a simple way of reading the data form a single column int he attached excel file, you will see at the end it is just added to a string and then logged. I have repeated for column 2 but you can repeat for all columns.
I have gone through your sample workflow but I am not getting correct solution to my problem. can you please look into it.
I am new to UiPath and I am trying to test facebook using excel sheet. I am able to loop the workflow using for each row activity successfully. For the first time the application is taking input value correctly. But, second time the application is taking empty spaces and unable to login facebook. Please find attached excel sheet and workflow.
You could just create a string variable with the column name which you require (strColumnName), then use a for each row to iterate through your datatable, and put a log in the body of the for each, with ‘row(strColumnName).tostring’. This will will iterate through and log the data from that column. Obviously instead of a log you could be extracting that data, or putting it into a system etc.
Is this what you need? it reads an excel with columns ‘Date’ and ‘Last’, and iterates through, where the ‘Date’ column matches today’s date, it calculates the range in days between ‘Date’ and ‘Last’, logging the result. If there is no match for today’s date then it logs ‘No Match’ with the date from the ‘Date’ column
Hi I have doubt in one scenario: If Day is there instead of date in date column, for that I need to match the day with current day. If it matched get the current date. then find the difference of Last Date with current date