diff options
author | Eugene Dzhurinsky <jdevelop@gmail.com> | 2018-05-09 07:44:04 -0400 |
---|---|---|
committer | Eugene Dzhurinsky <jdevelop@gmail.com> | 2018-05-09 08:13:20 -0400 |
commit | 1787c3533b7ae5070001982b282cdeeab1b42e12 (patch) | |
tree | 6f4410ac3e3e700a3a431695d1be01906a1e9b71 | |
parent | e09e47d9883c6d5928e59b8de1a49499d51cb4c8 (diff) |
Use format string for chart dimension.
Signed-off-by: Eugene Dzhurinsky <jdevelop@gmail.com>
-rw-r--r-- | README.md | 2 | ||||
-rw-r--r-- | chart.go | 42 | ||||
-rw-r--r-- | chart_test.go | 2 | ||||
-rw-r--r-- | xmlChart.go | 20 |
4 files changed, 21 insertions, 45 deletions
@@ -109,7 +109,7 @@ func main() { 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"}}`,excelize.ChartWidth(800), excelize.ChartHeight(600)) + xlsx.AddChart("Sheet1", "E1", `{"type":"col3DClustered","dimension":{"width":640, "height":480},"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 { @@ -194,6 +194,10 @@ var ( // chart with default value. func parseFormatChartSet(formatSet string) *formatChart { format := formatChart{ + Dimension: formatChartDimension{ + Width: 480, + Height: 290, + }, Format: formatPicture{ FPrintsWithSheet: true, FLocksWithSheet: false, @@ -351,13 +355,7 @@ func parseFormatChartSet(formatSet string) *formatChart { // maximum: Specifies that the fixed maximum, 0 is auto. The maximum property is optional. The default value is auto. // minimum: Specifies that the fixed minimum, 0 is auto. The minimum property is optional. The default value is auto. // -func (f *File) AddChart(sheet, cell, format string, opts ...chartOpts) { - - var defOpts = defaultChartOptions - for _, optF := range opts { - optF(&defOpts) - } - +func (f *File) AddChart(sheet, cell, format string) { formatSet := parseFormatChartSet(format) // Read sheet data. xlsx := f.workSheetReader(sheet) @@ -367,40 +365,12 @@ func (f *File) AddChart(sheet, cell, format string, opts ...chartOpts) { drawingXML := "xl/drawings/drawing" + strconv.Itoa(drawingID) + ".xml" drawingID, drawingXML = f.prepareDrawing(xlsx, drawingID, sheet, drawingXML) drawingRID := f.addDrawingRelationships(drawingID, SourceRelationshipChart, "../charts/chart"+strconv.Itoa(chartID)+".xml", "") - f.addDrawingChart(sheet, drawingXML, cell, defOpts.width, defOpts.height, drawingRID, &formatSet.Format) + f.addDrawingChart(sheet, drawingXML, cell, formatSet.Dimension.Width, formatSet.Dimension.Height, drawingRID, &formatSet.Format) f.addChart(formatSet) f.addContentTypePart(chartID, "chart") f.addContentTypePart(drawingID, "drawings") } -type chartOptions struct { - width int - height int -} - -var defaultChartOptions = chartOptions{ - width: 480, - height: 290, -} - -type chartOpts func(opts *chartOptions) - -// ChartWidth sets the chart width. -func ChartWidth(width int) chartOpts { - return func(opts *chartOptions) { - opts.width = width - return - } -} - -// ChartHeight sets the chart height. -func ChartHeight(height int) chartOpts { - return func(opts *chartOptions) { - opts.height = height - return - } -} - // countCharts provides function to get chart files count storage in the // folder xl/charts. func (f *File) countCharts() int { diff --git a/chart_test.go b/chart_test.go index f360f77..d35c272 100644 --- a/chart_test.go +++ b/chart_test.go @@ -19,7 +19,7 @@ func TestChartSize(t *testing.T) { for k, v := range values { xlsx.SetCellValue("Sheet1", k, v) } - xlsx.AddChart("Sheet1", "E4", `{"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"}}`, ChartWidth(640), ChartHeight(480)) + xlsx.AddChart("Sheet1", "E4", `{"type":"col3DClustered","dimension":{"width":640, "height":480},"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.Write(&buffer) if err != nil { diff --git a/xmlChart.go b/xmlChart.go index 252a896..a263334 100644 --- a/xmlChart.go +++ b/xmlChart.go @@ -506,15 +506,21 @@ type formatChartAxis struct { NameLayout formatLayout `json:"name_layout"` } +type formatChartDimension struct { + Width int `json:"width"` + Height int `json:"height"` +} + // formatChart directly maps the format settings of the chart. type formatChart struct { - Type string `json:"type"` - Series []formatChartSeries `json:"series"` - Format formatPicture `json:"format"` - Legend formatChartLegend `json:"legend"` - Title formatChartTitle `json:"title"` - XAxis formatChartAxis `json:"x_axis"` - YAxis formatChartAxis `json:"y_axis"` + Type string `json:"type"` + Series []formatChartSeries `json:"series"` + Format formatPicture `json:"format"` + Dimension formatChartDimension `json:"dimension"` + Legend formatChartLegend `json:"legend"` + Title formatChartTitle `json:"title"` + XAxis formatChartAxis `json:"x_axis"` + YAxis formatChartAxis `json:"y_axis"` Chartarea struct { Border struct { None bool `json:"none"` |