python-calamine icon indicating copy to clipboard operation
python-calamine copied to clipboard

Line breaks not consistent

Open subsurfaceiodev opened this issue 1 year ago • 2 comments

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.

subsurfaceiodev avatar Mar 15 '24 04:03 subsurfaceiodev

It's bug (?) in upstream.

dimastbk avatar Jul 15 '24 10:07 dimastbk