search

kz26 / PyExcelerate

Accelerated Excel XLSX Writing Library for Python 2/3
https://pypi.org/project/PyExcelerate/
BSD 2-Clause "Simplified" License
530 stars 60 forks source link

Hyper Link is not working #64

Closed sanjusci closed 6 years ago

sanjusci commented 6 years ago

When I am Using hyperlink formula as below:

sheet.set_cell_value(3, 3, '=HYPERLINK("https://abc.com/download", "Download File")')

In the excel file showing formula is invalid because It's adding 1 more (=) equal, Formula in excel sheet as below:

==HYPERLINK("https://abc.com/download", "Download File") means It's adding additional (=) equals. When I am using formula without (=) equal

sheet.set_cell_value(3, 3, 'HYPERLINK("https://abc.com/download", "Download File")')

In the excel file showing formula is invalid.

HYPERLINK("https://abc.com/download", "Download File")

The valid link should be as below: =HYPERLINK("https://abc.com/download", "Download File")

Please check and fix it.

kevmo314 commented 6 years ago

This is fixed in the latest dev version, see #61