diff options
author | Ri Xu <xuri.me@gmail.com> | 2018-03-06 10:36:12 +0800 |
---|---|---|
committer | Ri Xu <xuri.me@gmail.com> | 2018-03-06 10:36:12 +0800 |
commit | 06e54bf1c6658f7c78b43c5d1d37b0cc8e2d9e64 (patch) | |
tree | 165924c095144aac1de1ab5688d34c3a7a82f632 /README.md | |
parent | 45c31c4764a78b8b0e04293ae82c097627ed7e73 (diff) |
Readme and godoc has been updated.
Diffstat (limited to 'README.md')
-rw-r--r-- | README.md | 42 |
1 files changed, 21 insertions, 21 deletions
@@ -44,7 +44,7 @@ func main() { // Set active sheet of the workbook. xlsx.SetActiveSheet(index) // Save xlsx file by the given path. - err := xlsx.SaveAs("./Workbook.xlsx") + err := xlsx.SaveAs("./Book1.xlsx") if err != nil { fmt.Println(err) } @@ -65,7 +65,7 @@ import ( ) func main() { - xlsx, err := excelize.OpenFile("./Workbook.xlsx") + xlsx, err := excelize.OpenFile("./Book1.xlsx") if err != nil { fmt.Println(err) return @@ -82,7 +82,6 @@ func main() { fmt.Println() } } - ``` ### Add chart to XLSX file @@ -95,28 +94,29 @@ With Excelize chart generation and management is as easy as a few lines of code. package main import ( - "fmt" + "fmt" - "github.com/360EntSecGroup-Skylar/excelize" + "github.com/360EntSecGroup-Skylar/excelize" ) func main() { - categories := map[string]string{"A2": "Small", "A3": "Normal", "A4": "Large", "B1": "Apple", "C1": "Orange", "D1": "Pear"} - values := map[string]int{"B2": 2, "C2": 3, "D2": 3, "B3": 5, "C3": 2, "D3": 4, "B4": 6, "C4": 7, "D4": 8} - xlsx := excelize.NewFile() - for k, v := range categories { - xlsx.SetCellValue("Sheet1", k, v) - } - for k, v := range values { - xlsx.SetCellValue("Sheet1", k, v) - } - xlsx.AddChart("Sheet1", "E1", `{"type":"bar3D","series":[{"name":"Sheet1!$A$2","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$2:$D$2"},{"name":"Sheet1!$A$3","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$3:$D$3"},{"name":"Sheet1!$A$4","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$4:$D$4"}],"title":{"name":"Fruit 3D Line Chart"}}`) - // Save xlsx file by the given path. - err := xlsx.SaveAs("./Workbook.xlsx") - if err != nil { - fmt.Println(err) - } + categories := map[string]string{"A2": "Small", "A3": "Normal", "A4": "Large", "B1": "Apple", "C1": "Orange", "D1": "Pear"} + values := map[string]int{"B2": 2, "C2": 3, "D2": 3, "B3": 5, "C3": 2, "D3": 4, "B4": 6, "C4": 7, "D4": 8} + xlsx := excelize.NewFile() + for k, v := range categories { + xlsx.SetCellValue("Sheet1", k, v) + } + for k, v := range values { + xlsx.SetCellValue("Sheet1", k, v) + } + xlsx.AddChart("Sheet1", "E1", `{"type":"col3DClustered","series":[{"name":"Sheet1!$A$2","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$2:$D$2"},{"name":"Sheet1!$A$3","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$3:$D$3"},{"name":"Sheet1!$A$4","categories":"Sheet1!$B$1:$D$1","values":"Sheet1!$B$4:$D$4"}],"title":{"name":"Fruit 3D Clustered Column Chart"}}`) + // Save xlsx file by the given path. + err := xlsx.SaveAs("./Book1.xlsx") + if err != nil { + fmt.Println(err) + } } + ``` ### Add picture to XLSX file @@ -134,7 +134,7 @@ import ( ) func main() { - xlsx, err := excelize.OpenFile("./Workbook.xlsx") + xlsx, err := excelize.OpenFile("./Book1.xlsx") if err != nil { fmt.Println(err) return |