pyexcel
pyexcel copied to clipboard
Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files
During keyword ingestion in: https://github.com/pyexcel/pyexcel/blob/d8b965060889708ed7f718139076a71fe8c25490/pyexcel/core.py#L86 pyexcel assumes dest_file_name is a str, does not tolerate pathlib.Path Here's an example: ```python >>> pyexcel.save_as(array=data, dest_file_name=path) Traceback (most recent call last): File "", line...
The supported formats for import are documented, but the supported formats for output are not. 
Would it be possible to add a progress bar ([tqdm](https://github.com/tqdm/tqdm) preferred) to load & save sheet/book? I often see 400-500Mb xlsx books and it does take a little while to...
There are small typos in: - docs/source/renderers.rst - pyexcel/core.py - pyexcel/internal/meta.py - pyexcel/internal/sheets/matrix.py - pyexcel/plugins/parsers/sqlalchemy.py - pyexcel/plugins/sources/db_sources.py - pyexcel/plugins/sources/output_to_memory.py - pyexcel/sheet.py - pyexcel/source.py Fixes: - Should read `similar` rather than...
## Description I prefer `Path` rather than the path string. `Path` operates path string more friendly (such as connecting paths via `/`). And `Path` get more and more popular. Whether...
With your PR, here is a check list: - [ ] Has test cases written? - not needed - [x] Has all code lines tested? - no new features introduced...
Hi. I love to use pyexcel. Thanks. I have a question. Just now I realized column headers are gone after some processes with a single sheet, which has column headers...
When supplying (incorrectly) `file_name` to `pyexcel.save_as`, the error message mentions a different argument: Minimal example: ``` import pyexcel data = pyexcel.get_array(file_name=r"some_file.csv") pyexcel.save_as(array=data, file_name="some_other_file.csv") ``` ``` Python 3.9.7 | packaged by...
Hi, I wrote a script to do some elaboration of a ods file and i noticed it looses the cells formatting. So i tried with xlsx and xls and it...
The title is a little _accusatory_ but this is currently the most likely cause to an issue I'm having 🙏 😄 I have a client who is uploading an `.xlsx`...