{"action":"created","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/13439","repository_url":"https://api.github.com/repos/pydata/pandas","labels_url":"https://api.github.com/repos/pydata/pandas/issues/13439/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/13439/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/13439/events","html_url":"https://github.com/pydata/pandas/issues/13439","id":160180982,"number":13439,"title":"Feature request: read_excel to support hyperlinks split into label and hyperlink","user":{"login":"DocViper666","id":19929980,"avatar_url":"https://avatars.githubusercontent.com/u/19929980?v=3","gravatar_id":"","url":"https://api.github.com/users/DocViper666","html_url":"https://github.com/DocViper666","followers_url":"https://api.github.com/users/DocViper666/followers","following_url":"https://api.github.com/users/DocViper666/following{/other_user}","gists_url":"https://api.github.com/users/DocViper666/gists{/gist_id}","starred_url":"https://api.github.com/users/DocViper666/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DocViper666/subscriptions","organizations_url":"https://api.github.com/users/DocViper666/orgs","repos_url":"https://api.github.com/users/DocViper666/repos","events_url":"https://api.github.com/users/DocViper666/events{/privacy}","received_events_url":"https://api.github.com/users/DocViper666/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pydata/pandas/labels/API%20Design","name":"API Design","color":"AD7FA8"},{"url":"https://api.github.com/repos/pydata/pandas/labels/IO%20Excel","name":"IO Excel","color":"bfe5bf"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-06-14T13:27:25Z","updated_at":"2016-06-15T12:23:01Z","closed_at":null,"body":"Situation:\r\n.xlsx file having a column with label and hyperlinks (see screenshot collage)\r\nIn Excel, label: Python (that has a hyperlink to i.e.: www.python.org)\r\n\r\n#### Code Sample, a copy-pastable example if possible\r\ndata = pd.read_excel('Book1.xlsx')\r\ncolumn has just \"Python\" as content. Hyperlink information is lost.\r\n(see screenshot)\r\n\r\n![excel-hyperlink](https://cloud.githubusercontent.com/assets/19929980/16044286/25e27eca-3244-11e6-8ce4-2ae0ec34ba77.png)\r\n\r\n#### Expected Output, Proposal:\r\nAdd an argument  for example named hyperlinkparser to read_excel()\r\nthat offers options: \"label\", \"hyperlink\", \"both\"\r\nlabel ... just the label (this is how it is handled now)\r\nhyperlink ... just the hyperlink, drop the label\r\nsplit ... created two separate columns for label and hyperlink each\r\n\r\nwith example it could look like:\r\n         | MyLinks | MyLinks_hyperlink\r\n0       | Python   | www.python.org\r\n\r\nbtw. openpyxl 2.4.+ has this feature now included (was broken in previous versions). Maybe this helps for implementation.\r\n\r\nThank you!\r\n"},"comment":{"url":"https://api.github.com/repos/pydata/pandas/issues/comments/226171206","html_url":"https://github.com/pydata/pandas/issues/13439#issuecomment-226171206","issue_url":"https://api.github.com/repos/pydata/pandas/issues/13439","id":226171206,"user":{"login":"sinhrks","id":1696302,"avatar_url":"https://avatars.githubusercontent.com/u/1696302?v=3","gravatar_id":"","url":"https://api.github.com/users/sinhrks","html_url":"https://github.com/sinhrks","followers_url":"https://api.github.com/users/sinhrks/followers","following_url":"https://api.github.com/users/sinhrks/following{/other_user}","gists_url":"https://api.github.com/users/sinhrks/gists{/gist_id}","starred_url":"https://api.github.com/users/sinhrks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sinhrks/subscriptions","organizations_url":"https://api.github.com/users/sinhrks/orgs","repos_url":"https://api.github.com/users/sinhrks/repos","events_url":"https://api.github.com/users/sinhrks/events{/privacy}","received_events_url":"https://api.github.com/users/sinhrks/received_events","type":"User","site_admin":false},"created_at":"2016-06-15T12:23:01Z","updated_at":"2016-06-15T12:23:01Z","body":"@DocViper666 The enhancement should allow something like:\r\n\r\n```\r\npd.read_excel(\"xxx.xlsx\", converters={\"target_col_name\": lambda x: str(x.value) + \"|\"+ str(x.hyperlink.target), raw=True)\r\n``` \r\n\r\nAs long as I know, xlrd also has a class corresponding to cell.\r\n\r\n- http://www.lexicon.net/sjmachin/xlrd.html#xlrd.Cell-class"}}
{"actor":{"display_login":"sinhrks"}}