8000 ENH: Allow safe access to `.book` in ExcelWriter by rhshadrach · Pull Request #45687 · pandas-dev/pandas · GitHub
[go: up one dir, main page]
Skip to content

ENH: Allow safe access to .book in ExcelWriter #45687

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 8 commits into from
Feb 1, 2022
Merged

ENH: Allow safe access to .book in ExcelWriter #45687

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
8 commits
Select commit Hold shift + click to select a range
a641cce
ENH: Allow safe access to `.book` in ExcelWriter
rhshadrach Jan 15, 2022
ba7ff35
Add GH # in tests
rhshadrach Jan 28, 2022
8f433f0
Use context manager in tests
rhshadrach Jan 29, 2022
fdef619
Merge branch 'main' of https://github.com/pandas-dev/pandas into shee…
rhshadrach Jan 30, 2022
7ede1a8
Add back xlsxwriter sheets, add tests
rhshadrach Jan 30, 2022
61c92c2
Add sheets as an abstract property
rhshadrach Jan 30, 2022
bda2efc
Merge branch 'main' of https://github.com/pandas-dev/pandas into shee…
rhshadrach Jan 31, 2022
d8415bf
docstrings
rhshadrach Jan 31, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Use context manager in tests
  • Loading branch information
@rhshadrach
rhshadrach committed Jan 29, 2022
commit 8f433f02eb1f05294d89459e6cf91144bca70d16
10 changes: 5 additions & 5 deletions pandas/tests/io/excel/test_odswriter.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -61,8 +61,8 @@ def test_engine_kwargs(ext, engine_kwargs):
def test_book_and_sheets_consistent(ext):
# GH#45687 - Ensure sheets is updated if user modifies book
with tm.ensure_clean(ext) as f:
writer = ExcelWriter(f)
assert writer.sheets == {}
table = odf.table.Table(name="test_name")
writer.book.spreadsheet.addElement(table)
assert writer.sheets == {"test_name": table}
with ExcelWriter(f) as writer:
assert writer.sheets == {}
table = odf.table.Table(name="test_name")
writer.book.spreadsheet.addElement(table)
assert writer.sheets == {"test_name": table}
8 changes: 4 additions & 4 deletions pandas/tests/io/excel/test_openpyxl.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -384,7 +384,7 @@ def test_read_empty_with_blank_row(datapath, ext, read_only):
def test_book_and_sheets_consistent(ext):
# GH#45687 - Ensure sheets is updated if user modifies book
with tm.ensure_clean(ext) as f:
writer = ExcelWriter(f, engine="openpyxl")
assert writer.sheets == {}
sheet = writer.book.create_sheet("test_name", 0)
assert writer.sheets == {"test_name": sheet}
with ExcelWriter(f, engine="openpyxl") as writer:
assert writer.sheets == {}
sheet = writer.book.create_sheet("test_name", 0)
assert writer.sheets == {"test_name": sheet}
8 changes: 4 additions & 4 deletions pandas/tests/io/excel/test_xlwt.py
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -130,7 +130,7 @@ def test_engine_kwargs(ext, style_compression):
def test_book_and_sheets_consistent(ext):
# GH#45687 - Ensure sheets is updated if user modifies book
with tm.ensure_clean(ext) as f:
writer = ExcelWriter(f)
assert writer.sheets == {}
sheet = writer.book.add_sheet("test_name")
assert writer.sheets == {"test_name": sheet}
with ExcelWriter(f) as writer:
assert writer.sheets == {}
sheet = writer.book.add_sheet("test_name")
assert writer.sheets == {"test_name": sheet}
0