Hi I am trying to extract the local link from cell using Python. It shows 1 instead of showing the location link.
Please look at the image here!!
Can anyone help me out?
Thank you.
Asked
Active
Viewed 158 times
0
-
What python package are you using to read the excel sheet? You should post the code you are using so we can help you better. – LeopoldVonBuschLight Aug 14 '17 at 18:58
-
I am using openpyxl – Phemia Aug 14 '17 at 19:00
-
You might need to try to extract the formula and then parse out the link from the formula. Have a look [here](https://stackoverflow.com/a/23362361/2280345) – LeopoldVonBuschLight Aug 14 '17 at 19:05
-
I looked at it.. I still don't get how to do it? Please help! – Phemia Aug 14 '17 at 19:30
-
How can I parse out the link from the formula? The link you posted was not about it.. – Phemia Aug 14 '17 at 19:31
-
Have you tried using the data_only=False flag in load_workbook? – LeopoldVonBuschLight Aug 14 '17 at 19:35
-
I did. It doesn't work. Still the same.. – Phemia Aug 14 '17 at 19:48