Hyperlink and StreamWriter

[k1ng440]

Description
Set hyperlink to a cell after flushing StreamWriter does not work

Steps to reproduce the issue:

1. StreamWriter.Flush
2. SetCellHyperLink
3. Save

Describe the results you received:
Hyperlinks are not created

Describe the results you expected:
Hyperlinks should be created

Output of go version:

go version go1.16.5 linux/amd64

Excelize version or commit ID:

	github.com/360EntSecGroup-Skylar/excelize/v2 v2.4.0

Environment details (OS, Microsoft Excel™ version, physical, etc.):
Windows, Office 365

[xuri]

Note that according to the documentation, the normal API and streaming API can't be work mixed to writing data on the worksheets.

[k1ng440]

Note that according to the documentation, the normal API and streaming API can't be work mixed to writing data on the worksheets.

we generate huge documents. links are must to navigate between sheets

is there any possibility to add it, please?

[xuri]

The stream writer doesn't support set hyperlinks currently, I have added this feature request to the Roadmap.

[yinziyang]

you can use HYPERLINK

like this:

link := "https://www.google.com"
streamWriter.SetRow("A1", []interface{}{
    excelize.Cell{Formula: `HYPERLINK("` + link + `","Open")`},
})