summaryrefslogtreecommitdiff
path: root/excelize_test.go
diff options
context:
space:
mode:
Diffstat (limited to 'excelize_test.go')
-rw-r--r--excelize_test.go424
1 files changed, 0 insertions, 424 deletions
diff --git a/excelize_test.go b/excelize_test.go
index ed6f073..abee199 100644
--- a/excelize_test.go
+++ b/excelize_test.go
@@ -287,19 +287,6 @@ func TestColWidth(t *testing.T) {
convertRowHeightToPixels(0)
}
-func TestRowHeight(t *testing.T) {
- xlsx := NewFile()
- xlsx.SetRowHeight("Sheet1", 1, 50)
- xlsx.SetRowHeight("Sheet1", 4, 90)
- t.Log(xlsx.GetRowHeight("Sheet1", 1))
- t.Log(xlsx.GetRowHeight("Sheet1", 0))
- err := xlsx.SaveAs(filepath.Join("test", "TestRowHeight.xlsx"))
- if !assert.NoError(t, err) {
- t.FailNow()
- }
- convertColWidthToPixels(0)
-}
-
func TestSetCellHyperLink(t *testing.T) {
xlsx, err := OpenFile(filepath.Join("test", "Book1.xlsx"))
if err != nil {
@@ -1112,335 +1099,6 @@ func TestRemoveCol(t *testing.T) {
assert.NoError(t, xlsx.SaveAs(filepath.Join("test", "TestRemoveCol.xlsx")))
}
-func TestInsertRow(t *testing.T) {
- xlsx := NewFile()
- for j := 1; j <= 10; j++ {
- for i := 0; i <= 10; i++ {
- axis := ToAlphaString(i) + strconv.Itoa(j)
- xlsx.SetCellStr("Sheet1", axis, axis)
- }
- }
- xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/360EntSecGroup-Skylar/excelize", "External")
- xlsx.InsertRow("Sheet1", -1)
- xlsx.InsertRow("Sheet1", 4)
-
- assert.NoError(t, xlsx.SaveAs(filepath.Join("test", "TestInsertRow.xlsx")))
-}
-
-// Testing internal sructure state after insert operations.
-// It is important for insert workflow to be constant to avoid side effect with functions related to internal structure.
-func TestInsertRowInEmptyFile(t *testing.T) {
- xlsx := NewFile()
- sheet1 := xlsx.GetSheetName(1)
- r := xlsx.workSheetReader(sheet1)
- xlsx.InsertRow(sheet1, 0)
- assert.Len(t, r.SheetData.Row, 0)
- xlsx.InsertRow(sheet1, 1)
- assert.Len(t, r.SheetData.Row, 0)
- xlsx.InsertRow(sheet1, 99)
- assert.Len(t, r.SheetData.Row, 0)
- assert.NoError(t, xlsx.SaveAs(filepath.Join("test", "TestInsertRowInEmptyFile.xlsx")))
-}
-
-func TestDuplicateRow(t *testing.T) {
- const sheet = "Sheet1"
- outFile := filepath.Join("test", "TestDuplicateRow.%s.xlsx")
-
- cells := map[string]string{
- "A1": "A1 Value",
- "A2": "A2 Value",
- "A3": "A3 Value",
- "B1": "B1 Value",
- "B2": "B2 Value",
- "B3": "B3 Value",
- }
-
- newFileWithDefaults := func() *File {
- f := NewFile()
- for cell, val := range cells {
- f.SetCellStr(sheet, cell, val)
-
- }
- return f
- }
-
- t.Run("FromSingleRow", func(t *testing.T) {
- xlsx := NewFile()
- xlsx.SetCellStr(sheet, "A1", cells["A1"])
- xlsx.SetCellStr(sheet, "B1", cells["B1"])
-
- xlsx.DuplicateRow(sheet, 1)
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.FromSingleRow_1"))) {
- t.FailNow()
- }
- expect := map[string]string{
- "A1": cells["A1"], "B1": cells["B1"],
- "A2": cells["A1"], "B2": cells["B1"],
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell), cell) {
- t.FailNow()
- }
- }
-
- xlsx.DuplicateRow(sheet, 2)
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.FromSingleRow_2"))) {
- t.FailNow()
- }
- expect = map[string]string{
- "A1": cells["A1"], "B1": cells["B1"],
- "A2": cells["A1"], "B2": cells["B1"],
- "A3": cells["A1"], "B3": cells["B1"],
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell), cell) {
- t.FailNow()
- }
- }
- })
-
- t.Run("UpdateDuplicatedRows", func(t *testing.T) {
- xlsx := NewFile()
- xlsx.SetCellStr(sheet, "A1", cells["A1"])
- xlsx.SetCellStr(sheet, "B1", cells["B1"])
-
- xlsx.DuplicateRow(sheet, 1)
-
- xlsx.SetCellStr(sheet, "A2", cells["A2"])
- xlsx.SetCellStr(sheet, "B2", cells["B2"])
-
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.UpdateDuplicatedRows"))) {
- t.FailNow()
- }
- expect := map[string]string{
- "A1": cells["A1"], "B1": cells["B1"],
- "A2": cells["A2"], "B2": cells["B2"],
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell), cell) {
- t.FailNow()
- }
- }
- })
-
- t.Run("FirstOfMultipleRows", func(t *testing.T) {
- xlsx := newFileWithDefaults()
-
- xlsx.DuplicateRow(sheet, 1)
-
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.FirstOfMultipleRows"))) {
- t.FailNow()
- }
- expect := map[string]string{
- "A1": cells["A1"], "B1": cells["B1"],
- "A2": cells["A1"], "B2": cells["B1"],
- "A3": cells["A2"], "B3": cells["B2"],
- "A4": cells["A3"], "B4": cells["B3"],
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell), cell) {
- t.FailNow()
- }
- }
- })
-
- t.Run("ZeroWithNoRows", func(t *testing.T) {
- xlsx := NewFile()
-
- xlsx.DuplicateRow(sheet, 0)
-
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.ZeroWithNoRows"))) {
- t.FailNow()
- }
- assert.Equal(t, "", xlsx.GetCellValue(sheet, "A1"))
- assert.Equal(t, "", xlsx.GetCellValue(sheet, "B1"))
- assert.Equal(t, "", xlsx.GetCellValue(sheet, "A2"))
- assert.Equal(t, "", xlsx.GetCellValue(sheet, "B2"))
- expect := map[string]string{
- "A1": "", "B1": "",
- "A2": "", "B2": "",
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell), cell) {
- t.FailNow()
- }
- }
- })
-
- t.Run("MiddleRowOfEmptyFile", func(t *testing.T) {
- xlsx := NewFile()
-
- xlsx.DuplicateRow(sheet, 99)
-
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.MiddleRowOfEmptyFile"))) {
- t.FailNow()
- }
- expect := map[string]string{
- "A98": "",
- "A99": "",
- "A100": "",
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell), cell) {
- t.FailNow()
- }
- }
- })
-
- t.Run("WithLargeOffsetToMiddleOfData", func(t *testing.T) {
- xlsx := newFileWithDefaults()
-
- xlsx.DuplicateRowTo(sheet, 1, 3)
-
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.WithLargeOffsetToMiddleOfData"))) {
- t.FailNow()
- }
- expect := map[string]string{
- "A1": cells["A1"], "B1": cells["B1"],
- "A2": cells["A2"], "B2": cells["B2"],
- "A3": cells["A1"], "B3": cells["B1"],
- "A4": cells["A3"], "B4": cells["B3"],
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell), cell) {
- t.FailNow()
- }
- }
- })
-
- t.Run("WithLargeOffsetToEmptyRows", func(t *testing.T) {
- xlsx := newFileWithDefaults()
-
- xlsx.DuplicateRowTo(sheet, 1, 7)
-
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.WithLargeOffsetToEmptyRows"))) {
- t.FailNow()
- }
- expect := map[string]string{
- "A1": cells["A1"], "B1": cells["B1"],
- "A2": cells["A2"], "B2": cells["B2"],
- "A3": cells["A3"], "B3": cells["B3"],
- "A7": cells["A1"], "B7": cells["B1"],
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell), cell) {
- t.FailNow()
- }
- }
- })
-
- t.Run("InsertBefore", func(t *testing.T) {
- xlsx := newFileWithDefaults()
-
- xlsx.DuplicateRowTo(sheet, 2, 1)
-
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.InsertBefore"))) {
- t.FailNow()
- }
-
- expect := map[string]string{
- "A1": cells["A2"], "B1": cells["B2"],
- "A2": cells["A1"], "B2": cells["B1"],
- "A3": cells["A2"], "B3": cells["B2"],
- "A4": cells["A3"], "B4": cells["B3"],
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell), cell) {
- t.FailNow()
- }
- }
- })
-
- t.Run("InsertBeforeWithLargeOffset", func(t *testing.T) {
- xlsx := newFileWithDefaults()
-
- xlsx.DuplicateRowTo(sheet, 3, 1)
-
- if !assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, "TestDuplicateRow.InsertBeforeWithLargeOffset"))) {
- t.FailNow()
- }
-
- expect := map[string]string{
- "A1": cells["A3"], "B1": cells["B3"],
- "A2": cells["A1"], "B2": cells["B1"],
- "A3": cells["A2"], "B3": cells["B2"],
- "A4": cells["A3"], "B4": cells["B3"],
- }
- for cell, val := range expect {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, cell)) {
- t.FailNow()
- }
- }
- })
-}
-
-func TestDuplicateRowInvalidRownum(t *testing.T) {
- const sheet = "Sheet1"
- outFile := filepath.Join("test", "TestDuplicateRowInvalidRownum.%s.xlsx")
-
- cells := map[string]string{
- "A1": "A1 Value",
- "A2": "A2 Value",
- "A3": "A3 Value",
- "B1": "B1 Value",
- "B2": "B2 Value",
- "B3": "B3 Value",
- }
-
- testRows := []int{-2, -1}
-
- testRowPairs := []struct {
- row1 int
- row2 int
- }{
- {-1, -1},
- {-1, 0},
- {-1, 1},
- {0, -1},
- {0, 0},
- {0, 1},
- {1, -1},
- {1, 1},
- {1, 0},
- }
-
- for i, row := range testRows {
- name := fmt.Sprintf("TestRow_%d", i+1)
- t.Run(name, func(t *testing.T) {
- xlsx := NewFile()
- for col, val := range cells {
- xlsx.SetCellStr(sheet, col, val)
- }
- xlsx.DuplicateRow(sheet, row)
-
- for col, val := range cells {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, col)) {
- t.FailNow()
- }
- }
- assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, name)))
- })
- }
-
- for i, pair := range testRowPairs {
- name := fmt.Sprintf("TestRowPair_%d", i+1)
- t.Run(name, func(t *testing.T) {
- xlsx := NewFile()
- for col, val := range cells {
- xlsx.SetCellStr(sheet, col, val)
- }
- xlsx.DuplicateRowTo(sheet, pair.row1, pair.row2)
-
- for col, val := range cells {
- if !assert.Equal(t, val, xlsx.GetCellValue(sheet, col)) {
- t.FailNow()
- }
- }
- assert.NoError(t, xlsx.SaveAs(fmt.Sprintf(outFile, name)))
- })
- }
-}
-
func TestSetPane(t *testing.T) {
xlsx := NewFile()
xlsx.SetPanes("Sheet1", `{"freeze":false,"split":false}`)
@@ -1455,33 +1113,6 @@ func TestSetPane(t *testing.T) {
assert.NoError(t, xlsx.SaveAs(filepath.Join("test", "TestSetPane.xlsx")))
}
-func TestRemoveRow(t *testing.T) {
- xlsx := NewFile()
- for j := 1; j <= 10; j++ {
- for i := 0; i <= 10; i++ {
- axis := ToAlphaString(i) + strconv.Itoa(j)
- xlsx.SetCellStr("Sheet1", axis, axis)
- }
- }
- xlsx.SetCellHyperLink("Sheet1", "A5", "https://github.com/360EntSecGroup-Skylar/excelize", "External")
- xlsx.RemoveRow("Sheet1", -1)
- xlsx.RemoveRow("Sheet1", 4)
- xlsx.MergeCell("Sheet1", "B3", "B5")
- xlsx.RemoveRow("Sheet1", 2)
- xlsx.RemoveRow("Sheet1", 4)
-
- err := xlsx.AutoFilter("Sheet1", "A2", "A2", `{"column":"A","expression":"x != blanks"}`)
- if !assert.NoError(t, err) {
- t.FailNow()
- }
-
- xlsx.RemoveRow("Sheet1", 0)
- xlsx.RemoveRow("Sheet1", 1)
- xlsx.RemoveRow("Sheet1", 0)
-
- assert.NoError(t, xlsx.SaveAs(filepath.Join("test", "TestRemoveRow.xlsx")))
-}
-
func TestConditionalFormat(t *testing.T) {
xlsx := NewFile()
for j := 1; j <= 10; j++ {
@@ -1604,50 +1235,6 @@ func TestSetSheetRow(t *testing.T) {
assert.NoError(t, xlsx.SaveAs(filepath.Join("test", "TestSetSheetRow.xlsx")))
}
-func TestRows(t *testing.T) {
- xlsx, err := OpenFile(filepath.Join("test", "Book1.xlsx"))
- if !assert.NoError(t, err) {
- t.FailNow()
- }
-
- rows, err := xlsx.Rows("Sheet2")
- if !assert.NoError(t, err) {
- t.FailNow()
- }
-
- rowStrs := make([][]string, 0)
- var i = 0
- for rows.Next() {
- i++
- columns := rows.Columns()
- rowStrs = append(rowStrs, columns)
- }
-
- if !assert.NoError(t, rows.Error()) {
- t.FailNow()
- }
-
- dstRows := xlsx.GetRows("Sheet2")
- if !assert.Equal(t, len(rowStrs), len(dstRows)) {
- t.FailNow()
- }
-
- for i := 0; i < len(rowStrs); i++ {
- if !assert.Equal(t, trimSliceSpace(dstRows[i]), trimSliceSpace(rowStrs[i])) {
- t.FailNow()
- }
- }
-}
-
-func TestRowsError(t *testing.T) {
- xlsx, err := OpenFile(filepath.Join("test", "Book1.xlsx"))
- if !assert.NoError(t, err) {
- t.FailNow()
- }
- _, err = xlsx.Rows("SheetN")
- assert.EqualError(t, err, "Sheet SheetN is not exist")
-}
-
func TestOutlineLevel(t *testing.T) {
xlsx := NewFile()
xlsx.NewSheet("Sheet2")
@@ -1733,17 +1320,6 @@ func TestUnprotectSheet(t *testing.T) {
assert.NoError(t, xlsx.SaveAs(filepath.Join("test", "TestUnprotectSheet.xlsx")))
}
-func trimSliceSpace(s []string) []string {
- for {
- if len(s) > 0 && s[len(s)-1] == "" {
- s = s[:len(s)-1]
- } else {
- break
- }
- }
- return s
-}
-
func prepareTestBook1() (*File, error) {
xlsx, err := OpenFile(filepath.Join("test", "Book1.xlsx"))
if err != nil {
generated by cgit v1.2.1 (git 2.18.0) at 2025-04-19 00:51:07 +0000