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
rlgandu
(Rajyalakshmi Gandu)
August 9, 2023, 10:30am
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
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
indra
(Indra)
August 9, 2023, 1:50pm
4
@Rakesh_Tiwari After reading excel data convert data table to string using output data table refer below screenshot.