QST: read_excel - "odf engine" remove "\n" when reading multi-line cell from “ods” file
- [x] I have searched the [[pandas] tag](https://stackoverflow.com/questions/tagged/pandas) on StackOverflow for similar questions.

- [x] I have asked my usage related question on [StackOverflow](https://stackoverflow.com).

---

I've a simple "ods" file (Test01.ods) with the below data in "sheet1" :-

[![enter image description here][2]][2]

also I saved it as "xlsx" (Test01.xlsx) so I've two files contains exactly the same data.

Now when I try to read them using Pandas "read_excel" with the below code

[![enter image description here][3]][3]

the "xslx" file is showing the line break char "\n" while the "ods" file does not.

[![enter image description here][4]][4]

Any idea why? and how to force "odf engine" to output the "\n" to the dataframe?

Thanks in advance


  [1]: https://i.stack.imgur.com/K2PYO.png
  [2]: https://i.stack.imgur.com/1lLUk.png
  [3]: https://i.stack.imgur.com/QCRT5.png
  [4]: https://i.stack.imgur.com/NUV5x.png
