- New feature: border setting support (Related issue #21);

- Function parameter code is simplified;
- Fix element `Tint` value parsing error in worksheet;
- Update go test

1 files changed, 35 insertions, 0 deletions

diff --git a/excelize_test.go b/excelize_test.go
index 563f0b6..494156b 100644
--- a/excelize_test.go
+++ b/excelize_test.go
@@ -271,3 +271,38 @@ func TestSetRowHeight(t *testing.T) {
 		t.Log(err)
 	}
 }
+
+func TestSetBorder(t *testing.T) {
+	xlsx, err := OpenFile("./test/Workbook_2.xlsx")
+	if err != nil {
+		t.Log(err)
+	}
+	// Test set border with invalid style parameter.
+	err = xlsx.SetBorder("Sheet1", "J21", "L25", "")
+	if err != nil {
+		t.Log(err)
+	}
+	// Test set border with invalid style index number.
+	err = xlsx.SetBorder("Sheet1", "J21", "L25", "")
+	if err != nil {
+		t.Log(err)
+	}
+	// Test set border on overlapping area.
+	err = xlsx.SetBorder("Sheet1", "J21", "L25", `{"border":[{"type":"left","color":"0000FF","style":-1},{"type":"top","color":"00FF00","style":14},{"type":"bottom","color":"FFFF00","style":5},{"type":"right","color":"FF0000","style":6},{"type":"diagonalDown","color":"A020F0","style":9},{"type":"diagonalUp","color":"A020F0","style":8}]}`)
+	if err != nil {
+		t.Log(err)
+	}
+	err = xlsx.SetBorder("Sheet1", "M28", "K24", `{"border":[{"type":"left","color":"0000FF","style":2},{"type":"top","color":"00FF00","style":3},{"type":"bottom","color":"FFFF00","style":4},{"type":"right","color":"FF0000","style":5},{"type":"diagonalDown","color":"A020F0","style":6},{"type":"diagonalUp","color":"A020F0","style":7}]}`)
+	if err != nil {
+		t.Log(err)
+	}
+	// Test set border for a single cell.
+	err = xlsx.SetBorder("Sheet1", "O22", "O22", `{"border":[{"type":"left","color":"0000FF","style":8},{"type":"top","color":"00FF00","style":9},{"type":"bottom","color":"FFFF00","style":10},{"type":"right","color":"FF0000","style":11},{"type":"diagonalDown","color":"A020F0","style":12},{"type":"diagonalUp","color":"A020F0","style":13}]}`)
+	if err != nil {
+		t.Log(err)
+	}
+	err = xlsx.Save()
+	if err != nil {
+		t.Log(err)
+	}
+}