diff options
Diffstat (limited to 'excelize_test.go')
| -rw-r--r-- | excelize_test.go | 71 |
1 files changed, 66 insertions, 5 deletions
diff --git a/excelize_test.go b/excelize_test.go index f55ac01..6eb3692 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -21,9 +21,9 @@ func TestOpenFile(t *testing.T) { t.Error(err) } // Test get all the rows in a not exists worksheet. - rows := xlsx.GetRows("Sheet4") + xlsx.GetRows("Sheet4") // Test get all the rows in a worksheet. - rows = xlsx.GetRows("Sheet2") + rows := xlsx.GetRows("Sheet2") for _, row := range rows { for _, cell := range row { t.Log(cell, "\t") @@ -128,7 +128,7 @@ func TestOpenFile(t *testing.T) { } err = xlsx.Save() if err != nil { - t.Log(err) + t.Error(err) } // Test write file to not exist directory. err = xlsx.SaveAs("") @@ -162,6 +162,24 @@ func TestAddPicture(t *testing.T) { if err != nil { t.Log(err) } + err = xlsx.AddPictureFromBytes("Sheet1", "G21", "", "Excel Logo", "jpg", make([]byte, 1)) + if err != nil { + t.Log(err) + } + // Test add picture to worksheet with invalid file data. + err = xlsx.AddPictureFromBytes("Sheet1", "G21", "", "Excel Logo", ".jpg", make([]byte, 1)) + if err != nil { + t.Log(err) + } + file, err := ioutil.ReadFile("./test/images/excel.jpg") + if err != nil { + t.Error(err) + } + // Test add picture to worksheet from bytes. + err = xlsx.AddPictureFromBytes("Sheet1", "Q1", "", "Excel Logo", ".jpg", file) + if err != nil { + t.Log(err) + } // Test write file to given path. err = xlsx.SaveAs("./test/Book2.xlsx") if err != nil { @@ -211,9 +229,14 @@ func TestNewFile(t *testing.T) { if err != nil { t.Error(err) } - // Test add picture to worksheet with invalid formatset + // Test add picture to worksheet without formatset. err = xlsx.AddPicture("Sheet1", "C2", "./test/images/excel.png", "") if err != nil { + t.Error(err) + } + // Test add picture to worksheet with invalid formatset. + err = xlsx.AddPicture("Sheet1", "C2", "./test/images/excel.png", `{`) + if err != nil { t.Log(err) } err = xlsx.SaveAs("./test/Book3.xlsx") @@ -548,7 +571,7 @@ func TestSetCellStyleCurrencyNumberFormat(t *testing.T) { xlsx.SetCellValue("Sheet1", "A1", 42920.5) xlsx.SetCellValue("Sheet1", "A2", 42920.5) - style, err = xlsx.NewStyle(`{"number_format": 26, "lang": "zh-tw"}`) + _, err = xlsx.NewStyle(`{"number_format": 26, "lang": "zh-tw"}`) if err != nil { t.Log(err) } @@ -1225,6 +1248,44 @@ func TestHSL(t *testing.T) { t.Log(RGBToHSL(250, 50, 100)) } +func TestSearchSheet(t *testing.T) { + xlsx, err := OpenFile("./test/SharedStrings.xlsx") + if err != nil { + t.Error(err) + return + } + // Test search in a not exists worksheet. + t.Log(xlsx.SearchSheet("Sheet4", "")) + // Test search a not exists value. + t.Log(xlsx.SearchSheet("Sheet1", "X")) + t.Log(xlsx.SearchSheet("Sheet1", "A")) +} + +func TestProtectSheet(t *testing.T) { + xlsx := NewFile() + xlsx.ProtectSheet("Sheet1", nil) + xlsx.ProtectSheet("Sheet1", &FormatSheetProtection{ + Password: "password", + EditScenarios: false, + }) + err := xlsx.SaveAs("./test/Book_protect_sheet.xlsx") + if err != nil { + t.Error(err) + } +} + +func TestUnprotectSheet(t *testing.T) { + xlsx, err := OpenFile("./test/Book1.xlsx") + if err != nil { + t.Error(err) + } + xlsx.UnprotectSheet("Sheet1") + err = xlsx.Save() + if err != nil { + t.Error(err) + } +} + func trimSliceSpace(s []string) []string { for { if len(s) > 0 && s[len(s)-1] == "" { |