I’m working on an automation project in which I need to feed data from an excel into an application on Citrix, need to process only those rows where value in “Status” column is NULL, also need to update the “Status” column as Pass or Fail after the data for the specific row is uploaded into the application.
Thanks for the help, it did helped but partially. The BOT is now picking the right rows (i.e. the rows having status as ‘NULL’) to insert into the application. However, the status column is not being correctly updated with a ‘Pass’ or ‘Fail’. I’m using the below syntax to get the status updated for the rows which have been picked up for processing having status as ‘NULL’ but it is updating from row 2 and not just the one which has been processed.
This is giving me “End of expression expected” error.
Below is a sample of what is required:
BOT should pick up row 3 and 5 for processing as ‘Status’ value is ‘NULL’ for them and after processing it should update ‘C3’ and ‘C5’ as ‘Pass’ or ‘Fail’. This is placed inside a Try Catch.
You should be modifying the contents of the DataTable (dtCitrix) and then using Write Range to export the whole table back to Excel. This saves you the hassle of converting a row position to Excel coordinates manually.
Just to update this is working fine. However, I have another issue at hand. The data is to be feeded to 2 applications, The “Successful” entries of the first application are the only ones to be feeded into 2nd. We were able to pick up Status as “Null” for 1st application now need to pick entries marked as “Success” under Status1 and also update Staus2 with Pass or Fail. Attached is a sample sheet wherein row 3 & 5 are required to be processed in 2nd application as Status1 is Success and cell D3 & D5 to be updated as Pass or Fail.