Pandas read_excel with Hyperlink

by

This can be done with openpyxl, I’m not sure its possible with Pandas at all. Here’s how I’ve done it:

import openpyxl

wb = openpyxl.load_workbook('yourfile.xlsm')
ws = wb.get_sheet_by_name('Sheet1')
print(ws.cell(row=2, column=1).hyperlink.target)

You can also use iPython, and set a variable equal to the hyperlink object:

t = ws.cell(row=2, column=1).hyperlink

then do t. and press tab to see all the options for what you can do with or access from the object.

More Related Contents:

  1. Excel Number Separation [closed]
  2. excel vba compare & copy worksheets from 2 excel files
  3. VBA Stuck after certain loop
  4. How to return a result from a VBA function
  5. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  6. Convert Text to Date?
  7. Loop through each cell in a range of cells when given a Range object
  8. How to create a string or formula containing double quotes in Excel?
  9. Properly Handling Errors in VBA (Excel)
  10. Is there a way to slow down a Web Scraper so it will pick up the code?
  11. Create a folder and sub folder in Excel VBA
  12. How to suppress the file corrupt warning at Excel download?
  13. Excel: Formulas for converting data among column / row / matrix
  14. Renaming Files with Excel VBA
  15. Is there a way to import data from .csv to active excel sheet?
  16. Comparison of Dictionary, Collections and Arrays
  17. Break out of a While…Wend loop
  18. the file you are trying to open is in a different format than specified by the file extension in Asp.Net
  19. From password-protected Excel file to pandas DataFrame
  20. Leave dates as strings using read_excel function from pandas in python
  21. How to make safe API Timers in VBA?
  22. How to split texts from dynamic range?
  23. Excel: the Incredible Shrinking and Expanding Controls [closed]
  24. Excel: Search for a list of strings within a particular string using array formulas?
  25. Generate Word Documents (in Excel VBA) from a series of Document Templates
  26. Pandas: parse merged header columns from Excel
  27. Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
  28. How to implement custom iterable class in VBA
  29. move files from one folder to another
  30. Programmatically Export SSRS report from sharepoint using ReportService2010.asmx

Leave a Comment