Line breaks not consistent #57
Description
Hi! We've noticed that calamine handles line breaks different than all other engines when reading excel files via pandas, running the following code:
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.