of code reads an Excel file. This excel file holds information such as customer job numbers,
customer names, sites, works description ect..
What this code will do when completed (I hope) is read the last line of the worksheet (this is taken
from a counter on the worksheet at cell 'P1'), create folders based on cell content, and create a
hyperlink on the worksheet to open the lowest local folder that was created.
I have extracted the info I need from the worksheet to understand what folders need to be created,
but I am not able to write a hyperlink to the cell on the row in column B.
#Insert Hyperlink to folder
def folder_hyperlink(last_row_position, destination):
cols = 'B'
rows = str(last_row_position)
position = cols + rows
final_position = "".join(position)
print final_position # This is just to check the value
# The statement below should insert hyperlink in eps.xlsm > worksheet jobnoeps at column B and
last completed row.
ws.cell(final_position).hyperlink = destination
The complete code is below but h