Something wrong when reading from excel

[bing458]

I try to read data from excel,and the contents should be in every line.But when I add the contents, it looks like this(the image below),please help me to solve the problem.thanks

And when I try to read data from txt file like this

then the contents are normal like this

Updated: Text size and images. Please use normal text size next time. Thanks

 

[Nick]

I guess the excel component of ZP is just not designed to work with multiline cell values... After reading a cell value into a variable, do you see line breaks in the "Value" column of the "Variables" panel?

 

[bing458]

I guess the excel component of ZP is just not designed to work with multiline cell values... After reading a cell value into a variable, do you see line breaks in the "Value" column of the "Variables" panel?

line doesen't break in the value column of the variable panel

 

[rostonix]

Plaese PM me your excel file. I will check

 

[bing458]

Have sent you the excel file, please check

 

[rostonix]

Example

 

[bing458]

Thanks very much, it works