Unbale to see the excel data in a table format using read range workbook activity

Help Studio
1

Hi,

I am using Read Range Workbook activity and storing the data in datatable, while debugging it is showing me the data in jason format and in string format not in a table format.

image
image756×678 51.1 KB

kindly suggest

2

Hi @balkishan ,

I think output is storing in the vDataTable Variable which is datatype of datatable.

Could you please check by printing log message ->vDataTable.rows.count..

or
use for each row in vdatatable
Log message->Currentrow(“Columnname”).tostring

It will show in the lacals panel like that..

Hope it helps!!

3

Hi,

can you see, it is strange why it is showing like this,

image
image909×600 49.1 KB

normally it should show in a tabular format

image
image858×747 36.5 KB

4

@balkishan

It is showing OutArgument<DataTable> because the DataTable property in the Read Range Workbook activity is an output argument that stores the extracted Excel data into your variable.

This is expected behavior in UiPath debugger and does not mean the variable type is incorrect.

Hope you got it!!

5

i did not select outargumanet, but how can i see in a tabular view, how we can see in Automation Anywhere , power automate..hope you got

by default it is out argu

image
image1213×405 55.2 KB

but why, can not we change, i don’t need out argument type.

i want to use locally in the seq

6

@balkishan

This is expected behavior in the latest UiPath Studio version I think from 2025+, where DataTables are represented as JSON strings in the Locals Panel during debugging for improved readability of the data structure, rather than showing technical memory references.

This is a visual display change, not a functional one, and your DataTable still contains the correct tabular data.

If you want to see any specific data use Watch Panel and add the expression you want like first row data - dtOutput.Rows(0)

7

@balkishan ,

Yes, got it
Unlike Automation Anywhere or Power Automate, UiPath debugger does not always show DataTable data directly in a tabular/grid view in the Locals panel.

if you want to see

simply use:

  • Write Range to a temporary Excel
  • vDataTable