Need excel data in string variable

Help Studio
, ,
1

Hi Team,

Need excel data in string variable

Input:

image
image239×112 1.86 KB

Output:
variable —> shaik : 1
mukthar : 2
valli : 3

(note : whole table consider as a string varibale)

please help

thanks
shaik

2

Use read range activity to get details in datatable

then output data table to string activity to convert it into string

3

Hi @Mukthar_Valli

Use For Each Row in Data Table activity

Regards,

4

hi @lrtetala

I have edited the post please check

thanks
shaik

5

@Mukthar_Valli

Use Output Data Table as Text activity

A workflow sequence showing data reading from a workbook followed by outputting it as a text data table, both marked with error icons. (Captioned by AI)
A workflow sequence showing data reading from a workbook followed by outputting it as a text data table, both marked with error icons. (Captioned by AI)598×340 12.1 KB

Regards,

6

hey @Mukthar_Valli you can use output data table so it will convert your datatable into string variable

A workflow sequence that builds a data table, converts it to text, and logs a message with the output in a software automation environment. (Captioned by AI)
A workflow sequence that builds a data table, converts it to text, and logs a message with the output in a software automation environment. (Captioned by AI)448×414 9.95 KB

cheers

7

@Mukthar_Valli

If you want to separate the data with ":" then try below

str_Output = String.Join(Environment.NewLine, dt.AsEnumerable().Select(Function(row) String.Join(" : ", row.ItemArray)))

A process workflow that reads data from an Excel file and displays the output in a message box. (Captioned by AI)
A process workflow that reads data from an Excel file and displays the output in a message box. (Captioned by AI)805×529 16.5 KB

Regards,

8

Hi @Mukthar_Valli

Please follow below steps:

An automation workflow reads data from an Excel file and prints each row to the output panel. (Captioned by AI)
An automation workflow reads data from an Excel file and prints each row to the output panel. (Captioned by AI)960×517 28 KB

If you found helpful, feel free to tick as a solution.
Happy Automation

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.