diff options
| author | Ri Xu <xuri.me@gmail.com> | 2017-01-25 18:13:11 +0800 |
|---|---|---|
| committer | Ri Xu <xuri.me@gmail.com> | 2017-01-25 18:13:11 +0800 |
| commit | a1060e779ee295e9871e2fbe9148d8d9dc72a379 (patch) | |
| tree | 2203416f0de8cf2dd3c5f0c7e09b52fdc8f593ea /excelize_test.go | |
| parent | c0a3020886df623e76baedec04b97903573b6c0d (diff) | |
Make functions: `SetCellValue`, `SetCellInt`, `SetCellHyperLink`, `SetCellFormula`, `GetCellValue` and `GetCellFormula` to support the merged cells.
Diffstat (limited to 'excelize_test.go')
| -rw-r--r-- | excelize_test.go | 23 |
1 files changed, 15 insertions, 8 deletions
diff --git a/excelize_test.go b/excelize_test.go index 4a1c3fb..dc7d510 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -241,14 +241,21 @@ func TestSMergeCell(t *testing.T) { if err != nil { t.Log(err) } - xlsx.MergeCell("sheet1", "D9", "D9") - xlsx.MergeCell("sheet1", "D9", "E9") - xlsx.MergeCell("sheet1", "H14", "G13") - xlsx.MergeCell("sheet1", "C9", "D8") - xlsx.MergeCell("sheet1", "F11", "G13") - xlsx.MergeCell("sheet1", "H7", "B15") - xlsx.MergeCell("sheet1", "D11", "F13") - xlsx.MergeCell("sheet1", "G10", "I11") + xlsx.MergeCell("Sheet1", "D9", "D9") + xlsx.MergeCell("Sheet1", "D9", "E9") + xlsx.MergeCell("Sheet1", "H14", "G13") + xlsx.MergeCell("Sheet1", "C9", "D8") + xlsx.MergeCell("Sheet1", "F11", "G13") + xlsx.MergeCell("Sheet1", "H7", "B15") + xlsx.MergeCell("Sheet1", "D11", "F13") + xlsx.MergeCell("Sheet1", "G10", "K12") + 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/Luxurioust/excelize") + xlsx.SetCellFormula("Sheet1", "G12", "SUM(Sheet1!B19,Sheet1!C19)") + xlsx.GetCellValue("Sheet1", "H11") + xlsx.GetCellFormula("Sheet1", "G12") err = xlsx.Save() if err != nil { t.Log(err) |