Skip to content

pylightxl.Database.ws_names returns incorrect sheet names in some cases #75

@flc

Description

@flc

Pylightxl Version: 1.60
Python Version: 3.9.14

Code to reproduce the problem:

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.

test_sheet.xlsx
test_sheet_rename.xlsx

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions