You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
import pylightxl
path = 'test_sheet.xlsx'
db = pylightxl.readxl(fn=path)
print(db.ws_names)
The output is:
["'#3969'", '#3969']
However the file contains only 1 sheet named #3969.
The weird thing is that if I rename the sheet to sheet for example, save it in LibreOffice (see the attached test_sheet_rename.xlsx), then I get from the above code what is expected: ws_names return only 1 sheet named sheet.
@flc and @alexlawriewood Thank you for bringing this to our attention! Sorry about the delay, but i just had a chance to look into this and i am rolling out 1.61 that will fix this issue!
Hi @PydPiper, thanks very much for the fix!
However, I briefly checked the fixed code and I wonder what happens if a sheet name actually contains a single quote. I think that would lead to an incorrect behavior again.
Pylightxl Version: 1.60
Python Version: 3.9.14
Code to reproduce the problem:
The output is:
However the file contains only 1 sheet named
#3969
.The weird thing is that if I rename the sheet to
sheet
for example, save it in LibreOffice (see the attachedtest_sheet_rename.xlsx
), then I get from the above code what is expected:ws_names
return only 1 sheet namedsheet
.test_sheet.xlsx
test_sheet_rename.xlsx
The text was updated successfully, but these errors were encountered: