I’m removing maching value from data table after that i want to rewrite that table to same excel file ,but it was not removing complete row from data table some columns have sum at bottom these corresponding column rows not removing? anuyone know why ?
Anil_G
December 14, 2022, 9:40am
2
@pravin_bindage
Did you try using filter datatable to filter out the non required rows?
cheers
Hi @pravin_bindage ,
When rewriting the data to the same excel sheet, you would need to remove/Delete the rows that is already present and then Insert the new Data.
The removal of existing data can be done by using a Write Cell Activity. Below post describes the steps to perform the operation :
@kasey.betts , Assuming that we have the Data already available in Datatable, which Represents the Data in the Excel, we can use it’s Column Count and Row Count information to Clear the Contents using Write Cell Activity.
For Example :
Let the Datatable be DT
We get the Column Letter of the Excel by using the Column Count information as follows :
columnLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.Count+1)
The above would help us get the Col…
system
December 21, 2022, 10:34am
4
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.