When opening a workbook using openpyxl, I typically use the following code:
wb = load_workbook(r'seven.xlsx', data_only=True)
However, there are times when the name of the spreadsheet is not known in advance, requiring me to modify the hardcoding to accommodate a variable while still preserving the r prefix.
If I decide to use a variable named "sheet," the code will look like this:
wb = load_workbook(sheet, data_only=True)
This method, unfortunately, does not retain the r.
Attempting to include r within single quotes around the variable by writing:
wb = load_workbook(r'sheet', data_only=True)
is invalid. How can we effectively add the r prefix to a variable or enclose a variable within r''?