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.