How to print the text as it available in excel

Help Studio
1

Hi Team,

i have one issue, bot actually reads the excel data and populate that text using form, but not in correct format.
excel format - Hi
Hello
How are you.
Bot reading - Hi Hello How are you

i want to poulate same way as there in excel.

How to resolve this?

Thanks in advance
Rakesh

1 Like
2

@Rakesh_Tiwari

In the “Read Range” activity, set the PreserveFormat property to True . This will ensure that line breaks are not removed while reading the data

3

Hi @rlgandu ,

Checked with above solution but not working.

since i am using forms to display the information using content option, so there formatting will not work

4

@Rakesh_Tiwari After reading excel data convert data table to string using output data table refer below screenshot.

image