Comments (3)
I find it's a duplicate issue. I close it.
issue page
from pylightxl.
from pylightxl.
hi there, can you try to upgrade to v1.52 and see if that fixes your issue?
On Wed, Jan 27, 2021 at 7:53 AM Darcy @.***> wrote: Pylightxl Version:1.51 Python Version:3.8.3 Office Version: LibreOffice 7.0.4.2 Summary of Bug/Feature: KeyError Bug Traceback: File "......\pylightxl\pylightxl.py", line 135, in readxl worksheet = ordered_ws[order] KeyError: 1 Suggestion for fix: def readxl(fn, ws=None): ... ... # get all worksheets for order in range(1, len(ordered_ws) + 1): ----> for order in ordered_ws.keys(): worksheet = ordered_ws[order] ... ... I found ordered_ws is {2: 'sheet1', 3: 'sheet2', 4: 'sheet3'} It seems like the start number is 2 instead of 1. so I do that change, that worked for me. I am using LibreOffice to edit this xlsx file. So maybe there is some bug in LibreOffice. Thanks :) — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#31>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIOU6F2YE3PHEAU47KW2UTDS4AZGDANCNFSM4WVPXKPA .
-- Best, Viktor Kis
Thank you. v1.52 fixes my issue :>
from pylightxl.
Related Issues (20)
- Cannot Write to newly created blank excel file
- "Worksheet.ssd()" doesn't read all columns
- My xlxs output is converting & to &
- Corrupted excel file when overwritten HOT 3
- Read Failure When Worksheet Missing HOT 1
- Feature request: Read files from urls HOT 1
- Not reading some cell formulas HOT 1
- & replaced by & when writing a URL with parameters in it HOT 1
- Error during date parsing HOT 2
- Formulas in a csv file are parsed incorrectly
- Temporary file creation in current directory can fail. Use standard Python tempfile mechanism.
- OverflowError when parsing date HOT 1
- upload wheel to pypi
- Pylightxl In the help document, missing:
- Handle filenames in the same way for csv and excel
- Handle the encoding in the csv file
- Missing py.typed marker for mypy support
- better add `encoding='utf-8'` in every `with open(some_path, 'w') as f` statements
- Problem with saving bool data.
- Inconsistent handling of non-ASCII chars HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pylightxl.