New submission from anand Mohan <anandu...@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 <rep...@bugs.python.org> <https://bugs.python.org/issue37735> _______________________________________ _______________________________________________ Python-bugs-list mailing list Unsubscribe: https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com