pandas-dev/pandas issues and pull requests

#62670 - ENH: to_excel engine_kwargs for Excel header Autofilter and optional bold (xlsxwriter/openpyxl)

Pull Request - State: open - Opened by antznette1 about 1 month ago - 1 comment
Labels: Enhancement, IO Excel

#62576 - BUG : Fix Excel header NaN duplication with merged MultiIndex columns in to_excel

Pull Request - State: open - Opened by justine202429 about 2 months ago
Labels: IO Excel

#62391 - Backport PR #62348 on branch 2.3.x (TYP: Ignore xlsxwriter _book typing)

Pull Request - State: closed - Opened by meeseeksmachine about 2 months ago
Labels: IO Excel, Typing

#62340 - BUG: NaN categorical in multi-level column gets replaced in to_excel output

Issue - State: open - Opened by niclas-muller 2 months ago - 4 comments
Labels: Bug, IO Excel, MultiIndex

#61788 - BUG: read_excel() converts the string "None" in an Excel file to "NaN"

Issue - State: closed - Opened by jmcnamara 5 months ago - 6 comments
Labels: Bug, IO Excel, Closing Candidate

#61741 - TST: Test coverage for Excel Formatter.py

Pull Request - State: closed - Opened by lsgordon 5 months ago
Labels: Testing, IO Excel

#61741 - TST: Test coverage for Excel Formatter.py

Pull Request - State: closed - Opened by lsgordon 5 months ago
Labels: Testing, IO Excel

#61697 - TST: Increase test coverage for pandas.io.formats.excel.py

Pull Request - State: closed - Opened by lsgordon 5 months ago - 1 comment
Labels: Testing, IO Excel

#61697 - TST: Increase test coverage for pandas.io.formats.excel.py

Pull Request - State: closed - Opened by lsgordon 5 months ago
Labels: Testing, IO Excel

#61539 - ENH: Columns formatted as "Text" in Excel are read as numbers

Issue - State: open - Opened by pranay-sa 6 months ago
Labels: Enhancement, IO Excel, Needs Triage

#61123 - DOC: `read_excel` `nrows` parameter reads extra rows when tables are adjacent (no blank row)

Issue - State: closed - Opened by robertutterback 8 months ago - 1 comment
Labels: Docs, IO Excel, good first issue

#60909 - BUG: pandas.read_excel returns dict type if sheet_name=None

Issue - State: closed - Opened by Filip-Regenczuk 9 months ago - 3 comments
Labels: Docs, IO Excel

#60578 - BUG: Reading Excel File - unsupported operand type(s) for +: 'NoneType' and 'int'

Issue - State: closed - Opened by Pandas-Unimpressed 11 months ago - 6 comments
Labels: Bug, IO Excel, Needs Info, Needs Triage

#60293 - BUG: Don't merge Excel cells to a single row with merge_cells=False

Pull Request - State: closed - Opened by rhshadrach about 1 year ago - 1 comment
Labels: Bug, IO Excel, MultiIndex

#60293 - BUG: Don't merge Excel cells to a single row with merge_cells=False

Pull Request - State: closed - Opened by rhshadrach about 1 year ago
Labels: Bug, IO Excel, MultiIndex

#60277 - DOC: Make document merge_cells=columns in to_excel

Pull Request - State: closed - Opened by ZKaoChi about 1 year ago - 1 comment
Labels: Docs, IO Excel

#60277 - DOC: Make document merge_cells=columns in to_excel

Pull Request - State: closed - Opened by ZKaoChi about 1 year ago
Labels: Docs, IO Excel

#60275 - DOC: Document merge_cells="columns" in to_excel

Issue - State: closed - Opened by rhshadrach about 1 year ago - 2 comments
Labels: Docs, IO Excel, good first issue

#60274 - API: to_excel with merge_cells=False treats index and columns differently

Issue - State: closed - Opened by rhshadrach about 1 year ago - 3 comments
Labels: Bug, IO Excel, MultiIndex

#60182 - BUG: Convert output type in Excel for MultiIndex with period levels

Pull Request - State: closed - Opened by ZKaoChi about 1 year ago - 7 comments
Labels: Bug, IO Excel, Period, MultiIndex

#60182 - BUG: Convert output type in Excel for MultiIndex with period levels

Pull Request - State: closed - Opened by ZKaoChi about 1 year ago - 5 comments
Labels: Bug, IO Excel, Period, MultiIndex

#60099 - BUG: Inconsistent output type in Excel for PeriodIndex in Index or MultiIndex

Issue - State: closed - Opened by pforero about 1 year ago - 2 comments
Labels: Bug, IO Excel, Period, MultiIndex

#60088 - BUG: Datatypes not preserved on pd.read_excel

Issue - State: closed - Opened by vignesh14052002 about 1 year ago - 5 comments
Labels: Bug, IO Excel, Needs Triage

#60062 - BUG: pyxlsb fails to parse datetime-like data

Issue - State: closed - Opened by MCRE-BE about 1 year ago - 3 comments
Labels: Bug, IO Excel, Needs Triage

#59777 - ENH: Add a clear option to interpret strings as Pandas dtypes specifically.

Issue - State: open - Opened by vitkosbence about 1 year ago - 1 comment
Labels: Enhancement, IO Excel, Strings, Needs Info

#59704 - BUG: Excel corruption when reading twice the same file

Issue - State: closed - Opened by GuidoManfredi about 1 year ago - 4 comments
Labels: Bug, IO Excel

#59508 - fix: type error when exporting file as bytes

Pull Request - State: closed - Opened by zhaxnb over 1 year ago - 4 comments
Labels: IO Excel, Typing

#59348 - TST: Remove unnecessary test_boolean_types.xlsx

Pull Request - State: closed - Opened by mroeschke over 1 year ago - 1 comment
Labels: Testing, IO Excel

#59188 - Difference between calamine and openpyxl readers fixed

Pull Request - State: closed - Opened by Riyazul555 over 1 year ago - 2 comments
Labels: IO Excel, Stale

#59185 - DOC: Fix for excelwriter engine for ods files

Pull Request - State: closed - Opened by asishm over 1 year ago
Labels: Docs, IO Excel

#59185 - DOC: Fix for excelwriter engine for ods files

Pull Request - State: closed - Opened by asishm over 1 year ago - 1 comment
Labels: Docs, IO Excel

#59180 - PERF: to_excel slowing runtime

Issue - State: closed - Opened by OnindoK over 1 year ago - 2 comments
Labels: Performance, IO Excel, Needs Info

#59081 - ENH: Add option to only merge column header cells in `ExcelFormatter`.

Pull Request - State: closed - Opened by ulido over 1 year ago - 3 comments
Labels: IO Excel

#59081 - ENH: Add option to only merge column header cells in `ExcelFormatter`.

Pull Request - State: closed - Opened by ulido over 1 year ago - 2 comments
Labels: IO Excel

#59042 - BUG: `pd.read_excel` gives uninformative error for protected files

Issue - State: closed - Opened by fzhem over 1 year ago - 2 comments
Labels: Bug, IO Excel, Closing Candidate

#58994 - BUG: True cannot be cast to bool in read_excel

Pull Request - State: closed - Opened by rmhowe425 over 1 year ago - 4 comments
Labels: IO Excel

#58994 - BUG: True cannot be cast to bool in read_excel

Pull Request - State: closed - Opened by rmhowe425 over 1 year ago - 5 comments
Labels: IO Excel

#58899 - [BUG] read_excel: fixes handling of multi index header and other corner cases

Pull Request - State: closed - Opened by PL-SalvadorFandino over 1 year ago - 13 comments
Labels: Bug, IO Excel

#58899 - [BUG] read_excel: fixes handling of multi index header and other corner cases

Pull Request - State: closed - Opened by PL-SalvadorFandino over 1 year ago - 13 comments
Labels: Bug, IO Excel

#58849 - BUG: to_excel() cuts off list of values when creating Excel file

Issue - State: closed - Opened by josemariagarcia95 over 1 year ago - 4 comments
Labels: Bug, IO Excel, Needs Info

#58497 - REF: Read excel parse refactor

Pull Request - State: closed - Opened by iangainey over 1 year ago - 1 comment
Labels: Refactor, IO Excel

#58497 - REF: Read excel parse refactor

Pull Request - State: closed - Opened by iangainey over 1 year ago
Labels: Refactor, IO Excel

#58470 - BUG: how to convert .xls to .xlsx because Pandas failed to open .xls files

Issue - State: closed - Opened by Chirawat3987 over 1 year ago - 13 comments
Labels: Bug, IO Excel, Closing Candidate

#58261 - DOC: Reference Excel reader installation in the read and write tabular data tutorial

Pull Request - State: closed - Opened by jmbenson over 1 year ago - 1 comment
Labels: Docs, IO Excel

#58261 - DOC: Reference Excel reader installation in the read and write tabular data tutorial

Pull Request - State: closed - Opened by jmbenson over 1 year ago
Labels: Docs, IO Excel

#58247 - DEPR: ExcelFile.parse

Issue - State: open - Opened by rhshadrach over 1 year ago
Labels: IO Excel, Deprecate, Needs Discussion

#58235 - DOC: Enforce Numpy Docstring Validation for pandas.ExcelFile, pandas.ExcelFile.parse and pandas.ExcelWriter

Pull Request - State: closed - Opened by tuhinsharma121 over 1 year ago - 2 comments
Labels: Docs, IO Excel

#58235 - DOC: Enforce Numpy Docstring Validation for pandas.ExcelFile, pandas.ExcelFile.parse and pandas.ExcelWriter

Pull Request - State: closed - Opened by tuhinsharma121 over 1 year ago - 1 comment
Labels: Docs, IO Excel

#58128 - When excel cell with 0x005F_FFFF, pandas read excel with wrong output read value 0FFFF

Issue - State: closed - Opened by Kane-W over 1 year ago - 7 comments
Labels: Bug, IO Excel, Needs Triage

#57771 - DOC: Fix PR01 and SA01 errors in pandas.ExcelFile

Pull Request - State: closed - Opened by iridiium over 1 year ago - 5 comments
Labels: Docs, IO Excel

#57771 - DOC: Fix PR01 and SA01 errors in pandas.ExcelFile

Pull Request - State: closed - Opened by iridiium over 1 year ago - 5 comments
Labels: Docs, IO Excel

#57708 - REF: Avoid importing xlrd

Pull Request - State: closed - Opened by rhshadrach over 1 year ago - 4 comments
Labels: Refactor, IO Excel, Dependencies

#57708 - REF: Avoid importing xlrd

Pull Request - State: closed - Opened by rhshadrach over 1 year ago - 3 comments
Labels: Refactor, IO Excel, Dependencies

#57697 - BUG: Fix empty MultiIndex DataFrame xlsx export

Pull Request - State: closed - Opened by speleo3 over 1 year ago - 3 comments
Labels: Bug, IO Excel, MultiIndex

#57667 - ENH: Report how far off the formatting is

Issue - State: closed - Opened by larsoner over 1 year ago
Labels: Enhancement, IO Excel, Warnings

#57601 - DOC: Fixing GL08 errors for pandas.ExcelFile.sheet_names and pandas.MultiIndex.codes

Pull Request - State: closed - Opened by thomasdamcevski over 1 year ago - 1 comment
Labels: Docs, CI, IO Excel, MultiIndex

#57601 - DOC: Fixing GL08 errors for pandas.ExcelFile.sheet_names and pandas.MultiIndex.codes

Pull Request - State: closed - Opened by thomasdamcevski over 1 year ago
Labels: Docs, CI, IO Excel, MultiIndex

#57516 - CI/TST: Use tmp_path for excel test

Pull Request - State: closed - Opened by mroeschke over 1 year ago
Labels: CI, IO Excel

#57516 - CI/TST: Use tmp_path for excel test

Pull Request - State: closed - Opened by mroeschke over 1 year ago
Labels: CI, IO Excel

#57230 - DOC: fix PR02 errors in docstring for pandas.io.formats.style.Styler.to_excel

Pull Request - State: closed - Opened by jordan-d-murphy almost 2 years ago
Labels: Docs, IO Excel

#57230 - DOC: fix PR02 errors in docstring for pandas.io.formats.style.Styler.to_excel

Pull Request - State: closed - Opened by jordan-d-murphy almost 2 years ago - 1 comment
Labels: Docs, IO Excel

#57103 - ENH: Add check for character limmit

Pull Request - State: closed - Opened by luke396 almost 2 years ago - 4 comments
Labels: Enhancement, IO Excel, Warnings

#57103 - ENH: Add check for character limmit

Pull Request - State: closed - Opened by luke396 almost 2 years ago - 3 comments
Labels: Enhancement, IO Excel, Warnings

#57081 - Update install.rst to match the newest code

Pull Request - State: closed - Opened by NewUserHa almost 2 years ago - 7 comments
Labels: IO Excel

#57081 - Update install.rst to match the newest code

Pull Request - State: closed - Opened by NewUserHa almost 2 years ago - 6 comments
Labels: IO Excel

#56954 - ENH: show warning when exporting dataframe and hitting excel truncating limit

Issue - State: closed - Opened by SophieGarden almost 2 years ago - 4 comments
Labels: Enhancement, Docs, IO Excel, Warnings

#56810 - BUG: read_excel fuction return "zipfile.BadZipFile: File is not a zip file"

Issue - State: closed - Opened by dogeCoinMasterCoin almost 2 years ago - 6 comments
Labels: Bug, IO Excel, Needs Info

#56730 - Backport PR #56543 on branch 2.2.x (DOC: Update docstring for read_excel)

Pull Request - State: closed - Opened by meeseeksmachine almost 2 years ago
Labels: Docs, IO Excel

#56730 - Backport PR #56543 on branch 2.2.x (DOC: Update docstring for read_excel)

Pull Request - State: closed - Opened by meeseeksmachine almost 2 years ago
Labels: Docs, IO Excel

#56692 - pandas.read_excel 'Can't determine version for xlrd' - old bug on pandas-2.1

Issue - State: closed - Opened by brobr almost 2 years ago - 6 comments
Labels: Bug, IO Excel, Dependencies

#56543 - DOC: Update docstring for read_excel

Pull Request - State: closed - Opened by phofl almost 2 years ago - 4 comments
Labels: Docs, IO Excel

#56543 - DOC: Update docstring for read_excel

Pull Request - State: closed - Opened by phofl almost 2 years ago - 3 comments
Labels: Docs, IO Excel

#56542 - DEPR: Deprecate xlrd and pyxlsb excel engines

Issue - State: open - Opened by phofl almost 2 years ago - 4 comments
Labels: IO Excel, Deprecate, Needs Discussion

#56534 - TST: Adjust excel tests for new string option

Pull Request - State: closed - Opened by phofl almost 2 years ago - 1 comment
Labels: IO Excel, Strings

#56453 - DOC: Improve ``io/excel/_base.py``

Pull Request - State: closed - Opened by linus-md almost 2 years ago - 1 comment
Labels: Docs, IO Excel

#56280 - DEP: update python-calamine to 0.1.7

Pull Request - State: closed - Opened by dimastbk almost 2 years ago - 1 comment
Labels: IO Excel, Dependencies

#55857 - Added str to index_col attribute in the read_excel function description

Pull Request - State: closed - Opened by shyamala-venkat about 2 years ago - 3 comments
Labels: IO Excel, Typing

#55843 - Internal `read_excel()` typing for `index_col` is incorrect

Issue - State: closed - Opened by Dr-Irv about 2 years ago - 5 comments
Labels: IO Excel, good first issue, Typing

#55807 - ENH: Allow passing `read_only`, `data_only` and `keep_links` arguments to openpyxl using `engine_kwargs`

Pull Request - State: closed - Opened by dweindl about 2 years ago - 2 comments
Labels: IO Excel

#55760 - BUG: Inconsistent Boolean Cell format in Output Spreadsheet

Issue - State: closed - Opened by Kruegerrr about 2 years ago - 3 comments
Labels: Bug, IO Excel, Closing Candidate, Upstream issue

#55757 - Clarify dtype parameter in read_excel

Pull Request - State: closed - Opened by gadeatric about 2 years ago - 1 comment
Labels: Docs, IO Excel

#55727 - BUG: Comment in ODS-file gets included in string cells

Pull Request - State: closed - Opened by dimastbk about 2 years ago - 1 comment
Labels: IO Excel

#55669 - TST: de-duplicate, be stricter in excel/test_readers.py

Pull Request - State: closed - Opened by jbrockmendel about 2 years ago - 1 comment
Labels: Testing, IO Excel

#55573 - BUG: ExcelWriter not passing engine_kwargs properly for xlsxwriter

Issue - State: closed - Opened by Zethtren about 2 years ago - 3 comments
Labels: Bug, IO Excel, Closing Candidate

#55489 - BUG: pandas.read_excel() with dtype=object is broken in pandas 2.1.1

Issue - State: closed - Opened by VisualDev-FR about 2 years ago - 8 comments
Labels: Docs, IO Excel, good first issue

#55324 - BUG: fix parsing of ODF time values with comments

Pull Request - State: closed - Opened by mzuzek about 2 years ago - 6 comments
Labels: IO Excel, Stale

#55223 - BUG: `read_excel` with both `usecols` and `dtype` throws error on pandas 2.1.0

Issue - State: closed - Opened by dvd101x about 2 years ago - 4 comments
Labels: Bug, IO Excel, Closing Candidate

#55219 - BUG: manage raw ods file without cell cache

Pull Request - State: closed - Opened by guillett about 2 years ago - 1 comment
Labels: IO Excel

#55200 - BUG: Comment in ODS-file gets included in string cells

Issue - State: closed - Opened by pyZerrenner about 2 years ago - 6 comments
Labels: Bug, IO Excel

#55196 - BUG: ExcelWriter set_column with num_format datetime doesn't work (but it works for xlsxwriter)

Issue - State: open - Opened by lrisch about 2 years ago - 12 comments
Labels: Bug, IO Excel, Needs Discussion, Closing Candidate

#55045 - BUG (test): bad file for testing ODFReader

Issue - State: open - Opened by dimastbk about 2 years ago
Labels: Bug, IO Excel

#55030 - ENH: make read_excel dtype parameter compatible with multiple sheets (e.g sheet_name =[0,"list_of_sheets"])

Issue - State: open - Opened by struck89 about 2 years ago - 3 comments
Labels: Enhancement, IO Excel, Closing Candidate

#54998 - ENH: add calamine excel reader (close #50395)

Pull Request - State: closed - Opened by dimastbk about 2 years ago - 6 comments
Labels: Enhancement, IO Excel

#54996 - BUG: boolean/string value in OdsWriter (#54994)

Pull Request - State: closed - Opened by dimastbk about 2 years ago - 5 comments
Labels: Bug, IO Excel

#54994 - BUG: boolean/string in OdsWriter

Issue - State: closed - Opened by dimastbk about 2 years ago
Labels: Bug, IO Excel

#54703 - DEPR: deprecated nonkeyword arguments in to_excel

Pull Request - State: closed - Opened by rsm-23 about 2 years ago - 3 comments
Labels: IO Excel, Deprecate

#54567 - fix #54564

Pull Request - State: closed - Opened by burnpanck over 2 years ago - 4 comments
Labels: Bug, Missing-data, IO Excel

#54564 - BUG: pd.read_excel with engine "xlrd" fails when a cell contains NaN/inf

Issue - State: closed - Opened by burnpanck over 2 years ago - 4 comments
Labels: Bug, Missing-data, IO SQL, IO Excel

#54552 - ENH: support using letters as column names in read_excel

Issue - State: open - Opened by wangxiya over 2 years ago - 6 comments
Labels: Enhancement, IO Excel, Needs Discussion, Closing Candidate

#54551 - BUG: pandas.read_excel方法，在读取有公式的格子时，读取值为0

Issue - State: open - Opened by wangxiya over 2 years ago - 6 comments
Labels: Bug, IO Excel

GitHub / pandas-dev/pandas issues and pull requests