I have a simple data in my excel file like this [read_only_one_row.xls - Compatibility Mode - Excel] then in UiPath i set something like this. [image] and then i RUN test the result show like this [image] How can i print it out in NICE FORMAT something like this? [image] Thanks

Hi, You can convert the data table to Jarray and pass the same Jarray to Message Box. Converting to Jarray JArrayVariable = Newtonsoft.Json.JsonConvert.DeserializeObject(Of Newtonsoft.Json.Linq.Jarray)(Newtonsoft.Json.JsonConvert.SerializeObject(DT)) Pass the JArrayVariable to Message box. JArr…

How to print out nice JSON format in 'Message Box' in Activities

Help Studio

lovepong66 (Rugpong Sirimart (Luck)) October 10, 2022, 9:15am 5

Nothing come out
JArrayVariable.Select(Function(s) s(“Name”).ToString)

Please show me an example of code.

Topic		Replies	Views
Data Table to JSON (Array) Activities excel , activities	6	3136	October 25, 2020
Json to data-table Activities datatable , excel , activities , studio , question	47	4356	September 22, 2022
JsonArray to String /Data table Help	9	4320	March 26, 2019
Convert response body into excel Studio excel , uiautomation , api , rest-api , web-api	7	997	February 25, 2023
Read the data from Jsonarry to convert into datatable Studio studio , question , activities_panel	3	29	May 9, 2025

How to print out nice JSON format in 'Message Box' in Activities

Related topics