check https://openpyxl.readthedocs.io/en/stabl...many-cells and next section - https://openpyxl.readthedocs.io/en/stabl...alues-only
using
By the way, you may want to upload a workbook with dummy data as it will help - everyone who wants to help will work with same test data.
Here is the full API
https://openpyxl.readthedocs.io/en/stabl...npyxl.html
for example here are all properties and methods for worksheet https://openpyxl.readthedocs.io/en/stabl...sheet.html
by the way, according to docs, max_col and max_row will return:
max_column
The maximum column index containing data (1-based)
Type: int
max_row
The maximum row index containing data (1-based)
Type: int
using
tuple(ws.rows)
or tuple(ws.values)
you will get tuple of tuples and then you can sort/process, etc.By the way, you may want to upload a workbook with dummy data as it will help - everyone who wants to help will work with same test data.
(Jan-09-2019, 08:06 PM)Netopia Wrote: Does anyone know of a comprehensive listing of all of the functions/commands and their current names and usages within openpyxl? I have found precious little thus far.
Here is the full API
https://openpyxl.readthedocs.io/en/stabl...npyxl.html
for example here are all properties and methods for worksheet https://openpyxl.readthedocs.io/en/stabl...sheet.html
by the way, according to docs, max_col and max_row will return:
max_column
The maximum column index containing data (1-based)
Type: int
max_row
The maximum row index containing data (1-based)
Type: int
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs