If you know the cell name and if its static then try βwrite cellβ activity.
It writes a value into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the SheetName value. If a value exists, it is overwritten. Changes are immediately saved.
The Logic that I would use in this case is - Store the original excel is a datatable say, Originaldatatable, the new excel that i receive everyday in a new datatable say, datatablenew. Both the datatables should have the same columnnames.
Then use the datatable.Merge function. In UiPath, you can use the Invoke Method functionality, with the targetObject as Originaldatatable, Methodname as Merge, parameters collections having one In argument of type Datatable, and value datatablenew(As shown below)
Hi i am reading my mail box and updating L in excel sheet dynamically which date employee apply for leave . if the employee apply for Cancel leave i just want to remove the L from the date dynamically
Ok, in that case, you can do it using the following steps
Read range on the excel β save it to datatable_EmployeeLeave
Read email and extract the Employee ID from the email and save in variable lets assume β EmpID.
Filter the datatable, datatable_EmployeeLeave using the datatable.Select(β[Emp_id] = 'β+EmpId.tostring+β'β) using an Assign activity and assign the resulting Datarow array to a variable, say datarows_filter_byEmpID
Depending on the date of leave applied by the employee, Eg, 6th, you can update your datatable using an assign activity, like datarows_filter_byEmpID(0)(β6β) = βLβ or if you want to cancel it, datarows_filter_byEmpID(0)(β6β) = ββ
I hope this answers your question. Let me know in case of any questions