I have one excel file in which there are multiple duns number.I want to filter the duns =688955830
and remove the remaining duns number in the same excel sheet.how to do it?
Output should be like this-
data is like this-
TIA
I have one excel file in which there are multiple duns number.I want to filter the duns =688955830
and remove the remaining duns number in the same excel sheet.how to do it?
Output should be like this-
I donot know about the range and in Remove duplicate row activity-it will remove duplicate rows or different rows?
remove duplicate rows Activity will remove the duplicate rows
So what should I do to remove all the rows after 10 row?
If you know the index then use delete range activity and mention the starting range
or you want to remove duplicates only?
I want to delete the all data after A10.After this activity which activity should I used?
TIA
no need to use any other activity it will remove all the rows after A10
It shows error range doesnot exist
but i don’t know the ending range.So how to do it?
if you are not using read range for reading the excel then use read range activity and use below expression in assign
outputdt=datatable.Asenumerable.take(9).copytodatatable then no need to delete in excel
it is not deleting the data
Use write range activity to write the data to excel
After assign use write range activity and pass the outputdt in the datatable
Hi @Cuberoot ,
Could you try the below approach :
Use Read Range
Activity and keep the Range property as “A9” and Uncheck Add Headers
Option. Get the datatable value in variable, lets say DT
.
Next, You can use Filter Datatable
activity to Filter values to have only rows containing the DUNS number
value, For that follow the below Configuration in Filter Datatable
activity.
Next, there are multiple ways to proceed from here :
a. As you would require to have it in the same Excel sheet, you could create a Template of it already kept ready, Copy the Template Excel sheet and Write the Filter Datatable Output to it using Write Range
activity starting from Range A9
.
b. You could use Write Cell
activity to clear the Existing data present in the Excel sheet Starting from Range “A9” and after clearing use Write Range
activity to Write the Filtered Datatable output. A more detailed on clearing the data range is provided in the below Post :
Here, Also assuming that the Filtered Rows is needed to be Preserved and not the way of Removing the rows after a certain row number.
it works but it didnot delete the data from rows how to create template.output is like this-
Could you provide us with the Details of the Implementation done so far ? We could maybe try analyse and tweak the necessary parts to get the required output.
I did check with Workbook Write Cell
activity, when writing the cell with empty value, it did not remove the Borders.
As mentioned previously, we would require to understand your implementation done so far, to provide further corrections/suggestions.