summaryrefslogtreecommitdiff
path: root/cellmerged_test.go
diff options
context:
space:
mode:
Diffstat (limited to 'cellmerged_test.go')
-rw-r--r--cellmerged_test.go54
1 files changed, 54 insertions, 0 deletions
diff --git a/cellmerged_test.go b/cellmerged_test.go
new file mode 100644
index 0000000..d53acc2
--- /dev/null
+++ b/cellmerged_test.go
@@ -0,0 +1,54 @@
+package excelize
+
+import (
+ "path/filepath"
+ "testing"
+
+ "github.com/stretchr/testify/assert"
+)
+
+func TestGetMergeCells(t *testing.T) {
+ wants := []struct {
+ value string
+ start string
+ end string
+ }{{
+ value: "A1",
+ start: "A1",
+ end: "B1",
+ }, {
+ value: "A2",
+ start: "A2",
+ end: "A3",
+ }, {
+ value: "A4",
+ start: "A4",
+ end: "B5",
+ }, {
+ value: "A7",
+ start: "A7",
+ end: "C10",
+ }}
+
+ f, err := OpenFile(filepath.Join("test", "MergeCell.xlsx"))
+ if !assert.NoError(t, err) {
+ t.FailNow()
+ }
+ sheet1 := f.GetSheetName(1)
+
+ mergeCells, err := f.GetMergeCells(sheet1)
+ if !assert.Len(t, mergeCells, len(wants)) {
+ t.FailNow()
+ }
+ assert.NoError(t, err)
+
+ for i, m := range mergeCells {
+ assert.Equal(t, wants[i].value, m.GetCellValue())
+ assert.Equal(t, wants[i].start, m.GetStartAxis())
+ assert.Equal(t, wants[i].end, m.GetEndAxis())
+ }
+
+ // Test get merged cells on not exists worksheet.
+ _, err = f.GetMergeCells("SheetN")
+ assert.EqualError(t, err, "sheet SheetN is not exist")
+}