[issue37735] Current Region as a Method either in openpyxl.worksheet.cell.Cell or .cell_range.CellRange
anand Mohan
report at bugs.python.org
Wed Jul 31 12:49:40 EDT 2019
New submission from anand Mohan <anandupad at gmail.com>:
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 sides ( except the case of 1 column and 1 row ) that separate
I have Python code that I written to accomplish this Method. I have extended the CellRange class and added the methodand it is working as expected.
Please let me know if this will be a useful feature and I will submit code. 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 fro Current Region is expected to work (for reference from the 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.currentregion
----------
components: Demos and Tools
files: CurrentRegion.Example.png
messages: 348815
nosy: anand Mohan
priority: normal
severity: normal
status: open
title: Current Region as a Method either in openpyxl.worksheet.cell.Cell or .cell_range.CellRange
type: enhancement
versions: Python 3.7
Added file: https://bugs.python.org/file48524/CurrentRegion.Example.png
_______________________________________
Python tracker <report at bugs.python.org>
<https://bugs.python.org/issue37735>
_______________________________________
More information about the Python-bugs-list
mailing list