summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEugene Dzhurinsky <jdevelop@gmail.com>2018-05-09 07:44:04 -0400
committerEugene Dzhurinsky <jdevelop@gmail.com>2018-05-09 08:13:20 -0400
commit1787c3533b7ae5070001982b282cdeeab1b42e12 (patch)
tree6f4410ac3e3e700a3a431695d1be01906a1e9b71
parente09e47d9883c6d5928e59b8de1a49499d51cb4c8 (diff)
Use format string for chart dimension.
Signed-off-by: Eugene Dzhurinsky <jdevelop@gmail.com>
-rw-r--r--README.md2
-rw-r--r--chart.go42
-rw-r--r--chart_test.go2
-rw-r--r--xmlChart.go20
4 files changed, 21 insertions, 45 deletions
diff --git a/README.md b/README.md
index d49b2ba..ecba08b 100644
--- a/README.md
+++ b/README.md
@@ -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 {
diff --git a/chart.go b/chart.go
index b589726..78bbe6e 100644
--- a/chart.go
+++ b/chart.go
@@ -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"`