openpyxl issueshttps://foss.heptapod.net/openpyxl/openpyxl/-/issues2021-04-07T22:45:06Zhttps://foss.heptapod.net/openpyxl/openpyxl/-/issues/1313Current Region as a Method either in openpyxl.worksheet.cell.Cell or .cell_ra...2021-04-07T22:45:06ZBitbucket ImporterCurrent Region as a Method either in openpyxl.worksheet.cell.Cell or .cell_range.CellRange*Created originally on Bitbucket by [anand Mohan](https://bitbucket.org/%7Be31aed4f-32f8-4499-9cb6-f44cbb34ff64%7D/)*
Excel has a CurrentRegion Method that is invoked as
Range\(range\_string\).CurrentRegion
The idea behind this i...*Created originally on Bitbucket by [anand Mohan](https://bitbucket.org/%7Be31aed4f-32f8-4499-9cb6-f44cbb34ff64%7D/)*
Excel has a CurrentRegion Method that is invoked as
Range\(range\_string\).CurrentRegion
The idea behind this is to choose a region that have contiguous blank cells on all 4 sides \( except the case of cells in 1st column and cells in 1st row, in which case it will be 3 sides \) that separates from other regions
I have written a Python code that accomplishes this task. I have extended the CellRange class and added the method and it is working as expected.
Please let me know if this will be a useful feature and I will the submit code for review and standardization.
It may not be the best code, but has performed well and correctly in all my testing so far
Please see example snap shots attached for how CurrentRegion is expected to work
\(reference link https://www.excel-easy.com/vba/examples/currentregion.html
Here is additional reference to the Method as implemented in Excel VBA
https://docs.microsoft.com/en-us/office/vba/api/excel.range.currentregio
*Attachments:* [CurrentRegion.Example](/uploads/9e2bd1388bb678be22c76e2bbfac059a/CurrentRegion.Example.png)https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1283Where can I help with translation for doc?2020-06-26T11:50:51ZBitbucket ImporterWhere can I help with translation for doc?*Created originally on Bitbucket by [24hRun](https://bitbucket.org/%7B4ccc7cdd-09a1-4e8c-b902-bc5506fe86a7%7D/)*
Is there an official translation platform?*Created originally on Bitbucket by [24hRun](https://bitbucket.org/%7B4ccc7cdd-09a1-4e8c-b902-bc5506fe86a7%7D/)*
Is there an official translation platform?https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1234Use @deprecated library2020-06-26T11:49:09ZBitbucket ImporterUse @deprecated library*Created originally on Bitbucket by [Tantale (Laurent LAPORTE)](https://bitbucket.org/%7B20c7f458-24b6-44c0-ab05-60c98cc8e883%7D/)*
Hi Charlie & Co.
I have just seen that you use an "enhanced" copy of the [Deprecated](https://pypi.or...*Created originally on Bitbucket by [Tantale (Laurent LAPORTE)](https://bitbucket.org/%7B20c7f458-24b6-44c0-ab05-60c98cc8e883%7D/)*
Hi Charlie & Co.
I have just seen that you use an "enhanced" copy of the [Deprecated](https://pypi.org/project/Deprecated/) library. But this version is old now and have limitations (i.e.: you can't decorate classes).
The new version (1.2.x branch) has support for Sphinx directives. So you can decorate a deprecated function/method/class and update its docstring.
For instance:
```python
from deprecated.sphinx import deprecated
@deprecated(version='1.0', reason="This function will be removed soon")
def function_three():
'''This is the function three'''
```
It will add the ``.. deprecated::`` directive automatically.
Also take into consideration that this new implementation uses [Wrapt](https://pypi.org/project/wrapt/), which allows an efficient implementation of decorators.
As you know, I am the author of this library, I think it would be great to use it in OpenPyXl.
Regards,
– Laurent.https://foss.heptapod.net/openpyxl/openpyxl/-/issues/1056Guideline/ example for using pivot package2020-06-26T11:43:04ZBitbucket ImporterGuideline/ example for using pivot package*Created originally on Bitbucket by [Nhan Tran Hoang Vo (hoangnhan votran)](https://bitbucket.org/%7Bb119dc38-330b-4964-b72f-f4e6f90f0f9e%7D/)*
I need to create some pivot table from a data sheet in excel file. I found that openpyxl hav...*Created originally on Bitbucket by [Nhan Tran Hoang Vo (hoangnhan votran)](https://bitbucket.org/%7Bb119dc38-330b-4964-b72f-f4e6f90f0f9e%7D/)*
I need to create some pivot table from a data sheet in excel file. I found that openpyxl have add pivot package from ver. 2.5:
[https://openpyxl.readthedocs.io/en/2.5/api/openpyxl.pivot.html](https://openpyxl.readthedocs.io/en/2.5/api/openpyxl.pivot.html)
But it's hard to understand how to use this package. May you add some more example source code of using pivot package to add pivot to excel file.https://foss.heptapod.net/openpyxl/openpyxl/-/issues/745Save of huge workbook/worksheet yields MemoryError2020-06-26T11:31:53ZBitbucket ImporterSave of huge workbook/worksheet yields MemoryError*Created originally on Bitbucket by [walkerjim](https://bitbucket.org/%7Bfa3164d4-d93e-41d5-815a-c23abfda4d9b%7D/)*
I have a write-only workbook with two sheets. The first one is huge, with 2201 columns and 6630 rows. The second sheet i...*Created originally on Bitbucket by [walkerjim](https://bitbucket.org/%7Bfa3164d4-d93e-41d5-815a-c23abfda4d9b%7D/)*
I have a write-only workbook with two sheets. The first one is huge, with 2201 columns and 6630 rows. The second sheet is small enough not to be an issue.
Filling the workbook works fine; it all fits. Then I want to save it. I traced it down to the statement "out = src.read()" in method _write() on line 254 in write_only.py. Apparently it wants to slurp each worksheet's whole xml file in one go -- over 400Mb in my case -- and it crashes out with a BEX in the vc++ DLL. My suggestion would be for _write to deliver the file handle instead of the entire, read-out string to the caller. I know that at some point the ZipFile is going to make the xml data a _LOT_ smaller, so that so much memory will not be needed at once. However, I don't know enough about the library to recognize all the implications of just passing the file handle back up the call stack.https://foss.heptapod.net/openpyxl/openpyxl/-/issues/531TextBox support?2021-07-26T16:46:56ZBitbucket ImporterTextBox support?*Created originally on Bitbucket by [Ryan](https://bitbucket.org/%7B32fbb482-717f-4c87-8303-bb91d99a90ca%7D/)*
From what I've been able to find it looks like openpyxl supports TextBoxes in Charts and Comments, but not standalone TextBox...*Created originally on Bitbucket by [Ryan](https://bitbucket.org/%7B32fbb482-717f-4c87-8303-bb91d99a90ca%7D/)*
From what I've been able to find it looks like openpyxl supports TextBoxes in Charts and Comments, but not standalone TextBoxes. Is there any plan to add support for TextBoxes in the future, and/or am I missing something? Here's an example of what I mean in another library (I need to be able to read and write spreadsheets so unfortunately using that library isn't an option for me) http://xlsxwriter.readthedocs.org/en/latest/working_with_textboxes.html#working-with-textboxes https://foss.heptapod.net/openpyxl/openpyxl/-/issues/303It seems that MS Excel 2010 ignores "applyFill"2020-06-26T11:16:34ZBitbucket ImporterIt seems that MS Excel 2010 ignores "applyFill"*Created originally on Bitbucket by [certatorc](https://bitbucket.org/%7B1707ed97-6b5e-44e1-9841-04ba8018bdc6%7D/)*
I don't know why that happens - bug, or it is "by design". But, I see, that MS Excel ignores "applyFill" attribute of <x...*Created originally on Bitbucket by [certatorc](https://bitbucket.org/%7B1707ed97-6b5e-44e1-9841-04ba8018bdc6%7D/)*
I don't know why that happens - bug, or it is "by design". But, I see, that MS Excel ignores "applyFill" attribute of <xf> style tag. I attached 2 files - with applyFill and without.
I have changed styles.xml for test.
Original file (applyFillText.xslx):
```
#!xml
<xf numFmtId="0" fontId="0" fillId="2" borderId="0" xfId="0" applyFill="1"/>
<xf numFmtId="0" fontId="0" fillId="3" borderId="0" xfId="0" applyFill="1"/>
```
Patched file (wo_fills.xlsx)
```
#!xml
<xf numFmtId="0" fontId="0" fillId="2" borderId="0" xfId="0"/>
<xf numFmtId="0" fontId="0" fillId="3" borderId="0" xfId="0" applyFill="0"/>
```
As I see - nothing changed.
*Attachments:* [wo_fills.xlsx](/uploads/4198236839dc2175e2ba23f8db9abfe1/wo_fills.xlsx)[applyFillTest.xlsx](/uploads/5170fc347b410ed477246a3e32dfea81/applyFillTest.xlsx)https://foss.heptapod.net/openpyxl/openpyxl/-/issues/135Make worksheet numpy-style subscriptable2020-06-26T11:11:18ZBitbucket ImporterMake worksheet numpy-style subscriptable*Created originally on Bitbucket by [jtratner (Jeffrey Tratner)](https://bitbucket.org/%7Bb168e977-3337-4444-acdc-ac8ea2ab1a0a%7D/)*
I'm interested in extending the Worksheet class to be subscriptable in a similar manner to numpy arrays...*Created originally on Bitbucket by [jtratner (Jeffrey Tratner)](https://bitbucket.org/%7Bb168e977-3337-4444-acdc-ac8ea2ab1a0a%7D/)*
I'm interested in extending the Worksheet class to be subscriptable in a similar manner to numpy arrays. (using tuple syntax)
Examples:
* sheet1[10,15] --> returns (the value or cell object) for cell(col=10, row=15)
* sheet1[:,15] --> generator/iterator for row 15 (or possibly a slice)
* sheet1[10,:] --> generator/iterator for col 10 (or possibly a slice)
* sheet1[-1,:] --> generator/iterator for last column
* sheet1[:,-1] --> generator/iterator for last row
* sheet1[5:10, 15] --> returns generator/iterator for cells (5,15),(6,15),(7,15),(8,15),(9,15) [if 5:10 exists] -- same as slice notation
I don't think this would be that difficult to implement, just using the same hooks, exceptions, etc as the cell(col=, row=) function and a generator function for the iterators.
I'm volunteering to do it and debug it. Just would like to know in advance that the main devs would be interested in such an addition (and that this hasn't come up and been rejected previously)