0

I have an Excel spreadsheet with a column called Map that has the link to the locations on Google Maps. I'm trying to get this link, but in the column on Pandas the text "Link" appears. Is it possible to get the spreadsheet URL using Pandas? Could someone help me, please!

enter image description here

Oberdan O. Fonseca
  • 25
  • 3
  • AFAIK not possible with pandas. Hence the posted answer and linked thread both propose using openpyxl. – BigBen Apr 26 '21 at 23:51

1 Answers1

0

This should work with openpyxl

import openpyxl

wb = openpyxl.load_workbook('filename.xlsm')
ws = wb['Sheet1']
hl = ws.cell(row=3, column=13).hyperlink
Dycann
  • 23
  • 1
  • 3