Everyday one of report need to be amended in a excel sheet as master data. after amendment, few more columns need to populated manually, which i am trying to automate through Ui Path.
I used Find Fast/Last Row activity to find the populated data in a excel sheet. now I want to use Fill range activity to populate the specific values. I need to update at least 9 columns with different values but range remain same.
while doing like this (“K”+Firstrow+" : "+“K”+Lastrow) in Fill range, it showing error. please let me know how I can resolve the error by using rowcount or First /last data row.
when using the Fill Range activity, you need to provide a valid range that follows the Excel column and row format.
The “K+FR:K+LR” range you mentioned seems to be a combination of a column letter (“K”) and two numerical values (“FR” and “LR”) that might represent row numbers.
What do you mean by K+FR?
However, UiPath expects the range to be in a specific format, such as “A1:B10”, where “A1” represents the top-left cell and “B10” represents the bottom-right cell of the range you want to fill.
FR and LR both variables, Which hold numbers. Like K1 (1=FR) and same for LR.
but i like to know how to place code under range with variables. tried the below but still shows error.
parvathi_ayanala
jamiejam
Anirudh_Tugawe