diff options
| author | Youngwan Kim <y103.kim@gmail.com> | 2017-07-30 14:52:37 +0900 |
|---|---|---|
| committer | Youngwan Kim <y103.kim@gmail.com> | 2017-07-30 15:46:58 +0900 |
| commit | 5a4870d1cf50efe99c6ba8b62a4f0071819ce13f (patch) | |
| tree | c89f9c4add1a4756fef9fa338d569138abe3204a /excelize_test.go | |
| parent | bbed2f6dc9d73bb6ab6e0c7923c18acdafa13cd5 (diff) | |
Add extra argument "Linktype" to SetCellHyperLink
it support "External" and "Location"
Signed-off-by: Youngwan Kim <y103.kim@gmail.com>
Diffstat (limited to 'excelize_test.go')
| -rw-r--r-- | excelize_test.go | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/excelize_test.go b/excelize_test.go index 613da1b..970973a 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -210,9 +210,9 @@ func TestSetCellHyperLink(t *testing.T) { t.Log(err) } // Test set cell hyperlink in a work sheet already have hyperlinks. - xlsx.SetCellHyperLink("sheet1", "B19", "https://github.com/xuri/excelize") + xlsx.SetCellHyperLink("sheet1", "B19", "https://github.com/xuri/excelize", "External") // Test add first hyperlink in a work sheet. - xlsx.SetCellHyperLink("sheet2", "C1", "https://github.com/xuri/excelize") + xlsx.SetCellHyperLink("sheet2", "C1", "https://github.com/xuri/excelize", "External") err = xlsx.Save() if err != nil { t.Log(err) @@ -275,7 +275,7 @@ func TestMergeCell(t *testing.T) { xlsx.SetCellValue("Sheet1", "G11", "set value in merged cell") xlsx.SetCellInt("Sheet1", "H11", 100) xlsx.SetCellValue("Sheet1", "I11", float64(0.5)) - xlsx.SetCellHyperLink("Sheet1", "J11", "https://github.com/xuri/excelize") + xlsx.SetCellHyperLink("Sheet1", "J11", "https://github.com/xuri/excelize", "External") xlsx.SetCellFormula("Sheet1", "G12", "SUM(Sheet1!B19,Sheet1!C19)") xlsx.GetCellValue("Sheet1", "H11") xlsx.GetCellFormula("Sheet1", "G12") @@ -786,7 +786,7 @@ func TestInsertCol(t *testing.T) { xlsx.SetCellStr("Sheet1", axis, axis) } } - xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/xuri/excelize") + xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/xuri/excelize", "External") xlsx.MergeCell("sheet1", "A1", "C3") err := xlsx.AutoFilter("Sheet1", "A2", "B2", `{"column":"B","expression":"x != blanks"}`) t.Log(err) @@ -805,8 +805,8 @@ func TestRemoveCol(t *testing.T) { xlsx.SetCellStr("Sheet1", axis, axis) } } - xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/xuri/excelize") - xlsx.SetCellHyperLink("Sheet1", "C5", "https://github.com") + xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/xuri/excelize", "External") + xlsx.SetCellHyperLink("Sheet1", "C5", "https://github.com", "External") xlsx.MergeCell("sheet1", "A1", "B1") xlsx.MergeCell("sheet1", "A2", "B2") xlsx.RemoveCol("Sheet1", "A") @@ -825,7 +825,7 @@ func TestInsertRow(t *testing.T) { xlsx.SetCellStr("Sheet1", axis, axis) } } - xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/xuri/excelize") + xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/xuri/excelize", "External") xlsx.InsertRow("Sheet1", -1) xlsx.InsertRow("Sheet1", 4) err := xlsx.SaveAs("./test/Workbook_insertrow.xlsx") @@ -857,7 +857,7 @@ func TestRemoveRow(t *testing.T) { xlsx.SetCellStr("Sheet1", axis, axis) } } - xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/xuri/excelize") + xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/xuri/excelize", "External") xlsx.RemoveRow("Sheet1", -1) xlsx.RemoveRow("Sheet1", 4) xlsx.MergeCell("sheet1", "B3", "B5") |