Oct-13-2018, 08:09 AM
Hi,
Thanks for the code line.
Regarding that f-String:
phil
Thanks for the code line.
Regarding that f-String:
wb.active.cell(row, col).value = f'row:{row}, column:{col}'can we break this down a bit?
wb.active # openpyxl method to assign an active worksheet .cell # openpyxl method to activate a spreadsheet cell (row, col) # where are you pulling this from? The only usable code from above is 'rows' & 'columns' (the variable names) .value # openpyxl method to assign a value within a cell = # assignment operator f' # python declaration for the start of a f-String row: # where is this from? {row}, # what is this pointing to? column: # where is this from? {col} # what is this pointing to? ' # end of python f-stringthanks,
phil