On 2022-01-11 06:31, NArshad wrote:
-“How are the relevant cells identified in the spreadsheet?”
The column headings are:
BOOK_NAME
BOOK_AUTHOR
BOOK_ISBN
TOTAL_COPIES
COPIES_LEFT
BORROWER’S_NAME
ISSUE_DATE
RETURN_DATE
-“It's often the case that the cells on the first row contain text as column
labels.”
These I have written above.
-“If that's what you have in your spreadsheet, then read the cells on the first
row for the column labels and put them in a dict to map from column label to
column number.”
This written above I do not understand how to code.
Well, you know how to read the contents of a cell, and how to put items
into a dict (the key will be the cell contents and the value will be the
column number).
The column numbers will go from 1 to sheet.last_column, although some of
them might be empty (their value will be None), which you can remove
from the dict afterwards.
--
https://mail.python.org/mailman/listinfo/python-list
