Support > Forums > OpenBots Studio > Excel-operations

Excel-operations

latha lenkalapelli

  • Reporter
  • Calender Icon June 21,2021 at 9:43 AM

Hi Team, I am trying to do delete filtered rows, clear filter, How to apply delimiter on a column , and removing duplicates in specific column of Excel. But I was unable to find, Correct me if any Wrong .Please help me in doing these different types Excel-Operations.

Thanks Latha

This forum has 172 topics, 459 replies, and was last updated 1 hours ago by Poornima Malv

Sahil Wadhwa

  • Participant
  • Calender Icon June 29,2021 at 2:56 PM

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.

latha lenkalapelli

  • Participant
  • Calender Icon June 25,2021 at 1:22 PM

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 .

Nataly Alvarado

  • Participant
  • Calender Icon June 24,2021 at 2:43 PM

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!

You are not authorized to reply, please click here to login and add your reply to this topic.