Hello Latha,

To delete a particular range in the excel you can use the delete range command under excel commands. You can use any delimiter to excel column and use that column in the different excel or data table commands. For example use read range under excel commands and store the data in a datatable variable , then you can use filter data table command and use the delimited column to filter the rows in that particular data table. For removing the duplicate from a column you can use Send Advanced Keystrokes under Input commands to send hot keys on the excel for deletions of duplicate data.

Hi , I have used available excel commands to filter using Filter-Excel command. I want to do delete the filtered rows, how to apply delimiter to column, removing duplicates of column.. Please help in doing this .

Hello Latha,

when working with Excel spreadsheets, there are two options you can follow. First, you can use the existing commands under the Excel group to perform modifications to your Excel document. Each command has a specific functionality, make sure to read the commands descriptions and decide whether there is a command that you can use to build your automation. The other option is to get the Excel information as a datatable variable and perform the wanted modification to this variable instead. This will allow you to use the datatable commands in combination with any method available for datatable variables on C#. For example, under the DataTable Commands group you'll find the Filter DataTable command, which allows you to filter specific rows from a DataTable into a new DataTable.

Hope this helps!