How to convert table to range in excel via uipath

Help Studio
, ,
1

We created a table via UiPath but team want to keep the data in range but for running the pivot we created table

How to convert the table into range via UiPath

2

Hello @Abhinavpandey, try this:

Clear Range:

  • Range: Specify the range of the table you want to convert (e.g., “A1:C10”)
  • Clear Formats: Checked
  • Clear Content: Checked

Cheers! :slight_smile:

3

This is clear data from there i feel
I want to just convert table to range and save the data the wY ut way like it had 40 line in table and after convertung 40 line are still there

4

Do any one has resolution for this question ?facing the same issue… Like how to use “Convert to Range”.

5

You could use following VBA code to convert table “TableName” to range:

ActiveSheet.ListObjects("TableName").Unlist

Cheers