How to read the value in the excel cell with new lines

Help
1

I am trying to read a cell in excel using Read cell activity.
which hold value =

“Maria josephina
AddressLine1
AddressLine2
Country
PinCode”

But when using read cell, the value is read as : “Maria josephinaAddressLine1 AddressLine2 CountryPinCode” without newline characer in between,

Tried the same with Read Range. This is also not working
Please help me with this issue.

Thanks in advance.

2

Could you share your excel file? My Read Cell is reading the new lines.
image image

1 Like
3

@MariaJosephina

Yea Daniel is right. I have tried too, data is extracted in same format with new line characters.

1 Like
4

Could you please try with this @ranjith and @DanielMitchell

Test.XLSX (11.2 KB)

5

@MariaJosephina

Gone through test.xlsx , the value in cell A1 is word wrapped. This is the reason you’re seeing the content with newline character in XL Sheet but not in uipath code. When you copy that value into notepad manually by yourself, you can see the entire text in a single line.

I have included the newline characters manually in the content and stored back to test.xlsx. Check the code with this fileTest.XLSX (11.6 KB)

1 Like
6

@DanielMitchell and @ranjith
One more query.

I am trying to write a value ‘“jhshdhfs” + vbNewLine + “sdfsdf” + vbNewLine + “dfdfd”’ to a cell.
The value contains newLine character as I am appending it.

But when Iam executing read cell of the same written value, it is not containing the new line character.

Please find attached the workflow.
Thanks in advance.

Test.xaml (7.4 KB)

7

@ranjith The file is still opening with A1 word wrapped.