Pivot Tables - Range selection

[Neal369]

Hi Guys,

I am having data in excel range and not in excel table, i want to automate movement of cursor in any cell in a excel data, so that further we can automate converting excel range into excel table and then automate applying Pivots.

This is because to convert excel range into excel table, we have to keep cursor into any cell in excel data range.

Thank you,
@Neal369

[Anil_G (Anil Gorthi)]

@Neal369

If you want to select a particular cell or range you can use select range activity which will automatically move the active cell to the given cell or range

Select Range

Apart from that you can you can actually create a table using create table activity…in which if you pass the sheetname and range then a table is created in that range

Create Table

You have option to create pivots as well

Tutorial: Creating a Pivot Table

Hope this helps

Cheers

[Neal369]

Thank you for the reply,

Is there any way to have dynamic range in Create Table/Create Pivot Table activity so that even if number of columns changes, flow should work and pivot table should be created.

Thank you,
Happy Automation Learning.

[Anil_G (Anil Gorthi)]

@Neal369

Inside use excel file activity…you can try using Excel.Sheet("Sheetname").RowCount which would give you the row count in excel which can be used in create table/create pivot

Something liek this "A1:G" + Excel.Sheet("Sheetname").RowCount.ToString

If by any chance this is not giving you the correct range …then first use a read range activity and read the data into datatable then dt.Rowcount can be used to instead of the previous

Hope this helps

Cheers