pyexcel icon indicating copy to clipboard operation
pyexcel copied to clipboard

Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files

Results 32 pyexcel issues
Sort by recently updated
recently updated
newest added

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. ![image](https://user-images.githubusercontent.com/4048422/183254704-228a8ca3-7cbe-4eae-a885-2d79b64afff1.png)

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`...