Extract URL targets from Excel hyperlink cells

[daviewales]

For some reason I don't understand, the read_only=True argument to openpyxl.load_workbook() strips hyperlink information:

visidata/visidata/loaders/xlsx.py

Line 39 in 9eae2ef

self.workbook = openpyxl.load_workbook(str(self.source), data_only=True, read_only=True)

If I patch the above line to remove read_only=True, then I can open an Excel file with the --xlsx-meta-columns flag, and extract the URL targets with the following Visidata command (where the original column name is Link:

=Link_cellPyObj.hyperlink.display

Would it make sense to remove the read_only=True flag from the Visidata loader by default to enable this use case?
Or at least to remove the read_only=True flag when --xlsx-meta-columns is specified?
Would it make sense to make the URL accessible as a column attribute by default, even without --xlsx-meta-columns?

Compare the properties for a regular cell, vs a read-only cell in OpenPyXL:

• https://openpyxl.readthedocs.io/en/stable/api/openpyxl.cell.cell.html
• https://openpyxl.readthedocs.io/en/stable/api/openpyxl.cell.read_only.html#openpyxl.cell.read_only.ReadOnlyCell