Excel table selection

[pari_patel]

@balupad14 Can you help me with some excel activities ? I am using your pacakge of excel with version 2021.0.0.

I want to delete fata from column C to U for sheet 1 .

Then need to select data from sheet2 and paste on sheet1.

After that need to select table as shown below. How should I do?

I have more sheets in one excel so confused how to select specific sheet.

[Ryba (Tomasz)]

To select certain table you have to at first use ‘Get Table range’ activity and use its output as an input to Read Range activity. In each activity you have to specify sheet name.

[balupad14 (Balamurugan)]

HI @pari_patel ,

Yes. It is possible.

To delete the column (It has a video explanation also)

Delete last two columns data and write rest of it in excel

Hi @som17, To delete the column you can use the below activity . Video explanation . [Uipath | excel delete rows | excel delete columns | excel copy as picture (BalaReva)] To save as CSV. Use saveas activity . [image] Regards Balamurugan.S

Copy Paste (It has a video explanation also)

Excel Copy & Paste

Hi @amrit.karwal, Check this Video : [Uipath excel copy paste data | Uipath clipboard to datatable] Regards Balamurugan.S

• I didn’t understand this.

@pari_patel

After that need to select table as shown below

Thank you
Balamurugan.S

[pari_patel]

Thank you @balupad14 for help but I am using balareva.excel.Activities = 2020.3.2 version .

Within that I am using delete data activity which ia givimg me erroe shown below.

Would you be able to help me to reslve this error?

Thanks in advance

[jeevith (Jeevith Hegde, Ph.D.)]

Hi @pari_patel,

I think you have a duplicate post on the same topic (Excel tables)
It is not a good practice to duplicate posts in any forum.

Nonetheless, you can achieve this within an Excel Application Scope without any libraries. (Annotations in the workflow):

Before edits to Column 3 in Table 1:

After edits to Column 3 in Table 1:

Here is the sample workflow and excel file I used: ExcelTablesManipulation.xaml (18.4 KB)
ExcelTable.xlsx (10.4 KB)

---

You can offcourse build on it to make it quite generic so that you can specify a sheet and a table. A pseudo code would be:

Sheets = Workbook.GetSheets  --> Generates a worksheet type output then

For each Sheet in Sheets
      Sheet.ListObjects  --> Gets Tables objects in a given sheet
      For each Table in Sheet.ListObjects
              Table.Name / Table.Item.Name (little unsure) ---> Get the name of the table
              Use Get Table Range Activity with the sheet name and table name --> gets the range of the table
              Read Range for the Table range
              Modify it as required as UiPath Datatable
              Write range back to the table

[pari_patel]

Thanks @jeevith I will try the workflow you sent. Thank you for explaining very nicely.