Problem with Read Range workbook activity

Help Studio
, ,
1

Hi,

Pls help me.. Whenever i try to read a .xlsx excel file. My read range workbook acitivty reads it as JSON Format.

I need to know 2 things,

  1. Mine’s was latest UiPath edition. Maybe it was causing the issue?If it was which version i need to use?
  2. However it reads that excel file as JSON. How can i convert that into datable. Since it was already in datatable format?

image
image1913×1101 196 KB

2

Hi @Salman_Faries

Use the output data table activity and covert into string then use that variable to message box and test.

If you found helpful, mark as a solution

3

No brother. I need to know actually why my read ranges taking it as JSON instead of datatable?

4

@Salman_Faries See if you can check in message box, it’ll always visible like yours o/p.
Try to write whole datatable to excel sheet and check.

OR

Use the Excel Application Scope for reading .xlsx files. Excel Application Scope properly handles Excel-specific features, whereas workbook activities can sometimes misinterpret file formats.

5

@Salman_Faries,

It’s not JSON it’s Datatable. If you see the datatype from the Locals panel, it’s available there.

If you log dt_TransactionData.RowCount it will give you how many rows are there is the datatable.

6

Post a screenshot of the data in the Excel file please.

7

Hi @Salman_Faries

Have you tried accessing the data from your datatable and faced any issue?

I don’t see any issue right now. If you try to use for each row in datatable after your log message activity and try to print/access your datatable, it should work.

8

@Salman_Faries

  1. Is it happening for all excel files? can you create a file and check please
  2. Looks like its a dowloaded excel from internet whcih is formatted as JSON. That can be the reason of this issue
  3. Just to confirm as we are not seeing such change in latest version can you do a dt.rowscount. if the count says 1 then whole data is read into row 1 and column1 as a json because of the way the data is represented

cheers

9

A screenshot of the excel would help to find the solution. I believe the output is coming as data table only but the column content is in Json format

To view the table in a proper manner - Follow the below steps

From Manage packages - download Balareva.EasyDatatable.Activities

The image shows the "Manage Packages" window in UiPath, highlighting the installation details for the BalaReva.EasyDataTable.Activities package version 5.0.0. (Captioned by AI)
The image shows the "Manage Packages" window in UiPath, highlighting the installation details for the BalaReva.EasyDataTable.Activities package version 5.0.0. (Captioned by AI)1336×790 78.6 KB

Then use the activity “show data table”

The image shows a workflow sequence in a software interface, featuring a "Build Data Table" step followed by a "Show DataTable" step, with an arrow pointing towards the latter. (Captioned by AI)
The image shows a workflow sequence in a software interface, featuring a "Build Data Table" step followed by a "Show DataTable" step, with an arrow pointing towards the latter. (Captioned by AI)1546×384 14.2 KB

This will help us to segregate the issue better

The image shows a datatable view with two columns labeled "Column1" and "Column2," containing the values "text" and "1" respectively, and a header note advising to double-click into the cell for column information. (Captioned by AI)
The image shows a datatable view with two columns labeled "Column1" and "Column2," containing the values "text" and "1" respectively, and a header note advising to double-click into the cell for column information. (Captioned by AI)1195×250 4.51 KB