New Feature Request: Hyperlink support

[dollardhingra]

Is there hyperlink support present in PyExcelerate ? like in openpyxl : [https://openpyxl.readthedocs.io/en/latest/_modules/openpyxl/worksheet/hyperlink.html#Hyperlink] ?

[kevmo314]

There's not currently, however we can probably add this. I can take a look.

[kevmo314]

Looking into this more, what's the difference between a hyperlink and the HYPERLINK() function found here? PyExcelerate should have support for formulas if you just set the value to =HYPERLINK(...), does this accomplish your goal?

I ask this because it seems that the ECMA Office Open Standards specification does not explicitly disambiguate for hyperlinks, instead seems to delegate to the hyperlink function. If this is true, I'm not sure if adding a separate param is appropriate here.

[suyash248]

@kevmo314 I've tried to use =HYPERLINK(...) function to add a hyperlink in a particular cell in my excel sheet. But I'm getting this issue. Could you please help me out.

Thanks

[kevmo314]

Since #63 is fixed, you should be able to create a hyperlink via =HYPERLINK(...) correctly in the latest dev version.

[suyash248]

Thanks, @kevmo314. How do I use latest dev using pip?

[suyash248]

I ended up using latest dev as follows -

pip install -e git://github.com/kz26/PyExcelerate.git@be38e3cfcea5aad9ddc83b8f456adea0f8507841#egg=PyExcelerate
Now formulas are working as expected. Thank a lot @kevmo314 👍

[kevmo314]

Great to hear! We'll push an update to master soon so it'll be reflected on the pip version as well.