Line breaks not consistent

[subsurfaceiodev]

Hi! We've noticed that calamine handles line breaks different than all other engines when reading excel files via pandas, running the following code:

data.xlsx

import pandas as pd

df = pd.read_excel('data.xlsx')
print(df)

df_calamine = pd.read_excel('data.xlsx', engine='calamine')
print(df_calamine)

we get:

print(df):
header1 header2 header\nwith break
0 1 4 7
1 2 5 8
2 3 6 9

print(df_calamine):
header1 header2 header\r\nwith break
0 1 4 7
1 2 5 8
2 3 6 9

As you can see, calamine is representing line breaks as r\n\ while other engines consider usual \n break.

[dimastbk]

It's bug (?) in upstream.

[NathanDWalsh]

Hi, I have observed this issue in an inconsistent way. In my case the line breaks are not in the headers but in the table cells.

When I run tests directly with pytest, line breaks are imported as the expected \n. However when I run tests with tox on the same Windows machine (validating the requirements/dependencies are consistent), I get line breaks coming in as \r\n.