diff options
-rw-r--r-- | README.md | 22 | ||||
-rw-r--r-- | excelize_test.go | 19 | ||||
-rw-r--r-- | file.go | 3 | ||||
-rw-r--r-- | test/Workbook1.xlsx | bin | 19085 -> 18199 bytes |
4 files changed, 37 insertions, 7 deletions
@@ -69,10 +69,30 @@ func main() { xlsx = excelize.SetCellInt(xlsx, "Sheet3", "A23", 10) xlsx = excelize.SetCellStr(xlsx, "Sheet3", "b230", "World") xlsx = excelize.SetActiveSheet(xlsx, 2) + err = excelize.Save(xlsx, "~/Workbook.xlsx") + if err != nil { + fmt.Println(err) + } +} +``` + +### Reading XLSX files + +``` +package main + +import ( + "fmt" + "github.com/Luxurioust/excelize" +) + +func main() { + xlsx, err := excelize.OpenFile("~/Workbook.xlsx") if err != nil { fmt.Println(err) } - err = excelize.Save(xlsx, "~/Workbook.xlsx") + cell := excelize.GetCellValue(file, "Sheet2", "D11") + fmt.Println(cell) } ``` diff --git a/excelize_test.go b/excelize_test.go index 69f7964..456455e 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -9,7 +9,7 @@ func TestExcelize(t *testing.T) { // Test update a XLSX file file, err := OpenFile("./test/Workbook1.xlsx") if err != nil { - t.Error(err) + t.Log(err) } file = SetCellInt(file, "SHEET2", "B2", 100) file = SetCellStr(file, "SHEET2", "C11", "Knowns") @@ -18,12 +18,21 @@ func TestExcelize(t *testing.T) { file = SetCellStr(file, "SHEET3", "b230", "10") file = SetActiveSheet(file, 2) if err != nil { - t.Error(err) + t.Log(err) } for i := 1; i <= 300; i++ { file = SetCellStr(file, "SHEET3", "c"+strconv.Itoa(i), strconv.Itoa(i)) } err = Save(file, "./test/Workbook_2.xlsx") + if err != nil { + t.Log(err) + } + + // Test save to not exist directory + err = Save(file, "") + if err != nil { + t.Log(err) + } // Test create a XLSX file file2 := CreateFile() @@ -31,18 +40,20 @@ func TestExcelize(t *testing.T) { file2 = NewSheet(file2, 3, "TestSheet3") file2 = SetCellInt(file2, "Sheet2", "A23", 10) file2 = SetCellStr(file2, "SHEET1", "B20", "10") + file2 = SetActiveSheet(file2, 0) err = Save(file2, "./test/Workbook_3.xlsx") if err != nil { - t.Error(err) + t.Log(err) } // Test read cell value file, err = OpenFile("./test/Workbook1.xlsx") if err != nil { - t.Error(err) + t.Log(err) } GetCellValue(file, "Sheet2", "a-1") GetCellValue(file, "Sheet2", "a5") + GetCellValue(file, "Sheet2", "C11") GetCellValue(file, "Sheet2", "D11") GetCellValue(file, "Sheet2", "D12") GetCellValue(file, "Sheet2", "E12") @@ -3,7 +3,6 @@ package excelize import ( "archive/zip" "bytes" - "fmt" "os" ) @@ -34,7 +33,7 @@ func Save(files []FileList, name string) error { for _, file := range files { f, err := w.Create(file.Key) if err != nil { - fmt.Println(err) + return err } _, err = f.Write([]byte(file.Value)) if err != nil { diff --git a/test/Workbook1.xlsx b/test/Workbook1.xlsx Binary files differindex cbdeda9..54810bc 100644 --- a/test/Workbook1.xlsx +++ b/test/Workbook1.xlsx |