Merge branch 'master' into fix/cell_lock

1 files changed, 542 insertions, 0 deletions

diff --git a/sparkline.go b/sparkline.go
new file mode 100644
index 0000000..ce5be4c
--- /dev/null
+++ b/sparkline.go
@@ -0,0 +1,542 @@
+// Copyright 2016 - 2020 The excelize Authors. All rights reserved. Use of
+// this source code is governed by a BSD-style license that can be found in
+// the LICENSE file.
+//
+// Package excelize providing a set of functions that allow you to write to
+// and read from XLSX files. Support reads and writes XLSX file generated by
+// Microsoft Excel™ 2007 and later. Support save file without losing original
+// charts of XLSX. This library needs Go version 1.10 or later.
+
+package excelize
+
+import (
+	"encoding/xml"
+	"errors"
+	"io"
+	"strings"
+)
+
+// addSparklineGroupByStyle provides a function to create x14:sparklineGroups
+// element by given sparkline style ID.
+func (f *File) addSparklineGroupByStyle(ID int) *xlsxX14SparklineGroup {
+	groups := []*xlsxX14SparklineGroup{
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 4, Tint: -0.499984740745262},
+			ColorNegative: &xlsxTabColor{Theme: 5},
+			ColorMarkers:  &xlsxTabColor{Theme: 4, Tint: -0.499984740745262},
+			ColorFirst:    &xlsxTabColor{Theme: 4, Tint: 0.39997558519241921},
+			ColorLast:     &xlsxTabColor{Theme: 4, Tint: 0.39997558519241921},
+			ColorHigh:     &xlsxTabColor{Theme: 4},
+			ColorLow:      &xlsxTabColor{Theme: 4},
+		}, // 0
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 4, Tint: -0.499984740745262},
+			ColorNegative: &xlsxTabColor{Theme: 5},
+			ColorMarkers:  &xlsxTabColor{Theme: 4, Tint: -0.499984740745262},
+			ColorFirst:    &xlsxTabColor{Theme: 4, Tint: 0.39997558519241921},
+			ColorLast:     &xlsxTabColor{Theme: 4, Tint: 0.39997558519241921},
+			ColorHigh:     &xlsxTabColor{Theme: 4},
+			ColorLow:      &xlsxTabColor{Theme: 4},
+		}, // 1
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 5, Tint: -0.499984740745262},
+			ColorNegative: &xlsxTabColor{Theme: 6},
+			ColorMarkers:  &xlsxTabColor{Theme: 5, Tint: -0.499984740745262},
+			ColorFirst:    &xlsxTabColor{Theme: 5, Tint: 0.39997558519241921},
+			ColorLast:     &xlsxTabColor{Theme: 5, Tint: 0.39997558519241921},
+			ColorHigh:     &xlsxTabColor{Theme: 5},
+			ColorLow:      &xlsxTabColor{Theme: 5},
+		}, // 2
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 6, Tint: -0.499984740745262},
+			ColorNegative: &xlsxTabColor{Theme: 7},
+			ColorMarkers:  &xlsxTabColor{Theme: 6, Tint: -0.499984740745262},
+			ColorFirst:    &xlsxTabColor{Theme: 6, Tint: 0.39997558519241921},
+			ColorLast:     &xlsxTabColor{Theme: 6, Tint: 0.39997558519241921},
+			ColorHigh:     &xlsxTabColor{Theme: 6},
+			ColorLow:      &xlsxTabColor{Theme: 6},
+		}, // 3
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 7, Tint: -0.499984740745262},
+			ColorNegative: &xlsxTabColor{Theme: 8},
+			ColorMarkers:  &xlsxTabColor{Theme: 7, Tint: -0.499984740745262},
+			ColorFirst:    &xlsxTabColor{Theme: 7, Tint: 0.39997558519241921},
+			ColorLast:     &xlsxTabColor{Theme: 7, Tint: 0.39997558519241921},
+			ColorHigh:     &xlsxTabColor{Theme: 7},
+			ColorLow:      &xlsxTabColor{Theme: 7},
+		}, // 4
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 8, Tint: -0.499984740745262},
+			ColorNegative: &xlsxTabColor{Theme: 9},
+			ColorMarkers:  &xlsxTabColor{Theme: 8, Tint: -0.499984740745262},
+			ColorFirst:    &xlsxTabColor{Theme: 8, Tint: 0.39997558519241921},
+			ColorLast:     &xlsxTabColor{Theme: 8, Tint: 0.39997558519241921},
+			ColorHigh:     &xlsxTabColor{Theme: 8},
+			ColorLow:      &xlsxTabColor{Theme: 8},
+		}, // 5
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 9, Tint: -0.499984740745262},
+			ColorNegative: &xlsxTabColor{Theme: 4},
+			ColorMarkers:  &xlsxTabColor{Theme: 9, Tint: -0.499984740745262},
+			ColorFirst:    &xlsxTabColor{Theme: 9, Tint: 0.39997558519241921},
+			ColorLast:     &xlsxTabColor{Theme: 9, Tint: 0.39997558519241921},
+			ColorHigh:     &xlsxTabColor{Theme: 9},
+			ColorLow:      &xlsxTabColor{Theme: 9},
+		}, // 6
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorNegative: &xlsxTabColor{Theme: 5},
+			ColorMarkers:  &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 5},
+			ColorLow:      &xlsxTabColor{Theme: 5},
+		}, // 7
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorNegative: &xlsxTabColor{Theme: 6},
+			ColorMarkers:  &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+		}, // 8
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorNegative: &xlsxTabColor{Theme: 7},
+			ColorMarkers:  &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+		}, // 9
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorNegative: &xlsxTabColor{Theme: 8},
+			ColorMarkers:  &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+		}, // 10
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorNegative: &xlsxTabColor{Theme: 9},
+			ColorMarkers:  &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+		}, // 11
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorNegative: &xlsxTabColor{Theme: 4},
+			ColorMarkers:  &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+		}, // 12
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 4},
+			ColorNegative: &xlsxTabColor{Theme: 5},
+			ColorMarkers:  &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+		}, // 13
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 5},
+			ColorNegative: &xlsxTabColor{Theme: 6},
+			ColorMarkers:  &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+		}, // 14
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 6},
+			ColorNegative: &xlsxTabColor{Theme: 7},
+			ColorMarkers:  &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+		}, // 15
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 7},
+			ColorNegative: &xlsxTabColor{Theme: 8},
+			ColorMarkers:  &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+		}, // 16
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 8},
+			ColorNegative: &xlsxTabColor{Theme: 9},
+			ColorMarkers:  &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+		}, // 17
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 9},
+			ColorNegative: &xlsxTabColor{Theme: 4},
+			ColorMarkers:  &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+		}, // 18
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 4, Tint: 0.39997558519241921},
+			ColorNegative: &xlsxTabColor{Theme: 0, Tint: -0.499984740745262},
+			ColorMarkers:  &xlsxTabColor{Theme: 4, Tint: 0.79998168889431442},
+			ColorFirst:    &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 4, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 4, Tint: -0.499984740745262},
+			ColorLow:      &xlsxTabColor{Theme: 4, Tint: -0.499984740745262},
+		}, // 19
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 5, Tint: 0.39997558519241921},
+			ColorNegative: &xlsxTabColor{Theme: 0, Tint: -0.499984740745262},
+			ColorMarkers:  &xlsxTabColor{Theme: 5, Tint: 0.79998168889431442},
+			ColorFirst:    &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 5, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 5, Tint: -0.499984740745262},
+			ColorLow:      &xlsxTabColor{Theme: 5, Tint: -0.499984740745262},
+		}, // 20
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 6, Tint: 0.39997558519241921},
+			ColorNegative: &xlsxTabColor{Theme: 0, Tint: -0.499984740745262},
+			ColorMarkers:  &xlsxTabColor{Theme: 6, Tint: 0.79998168889431442},
+			ColorFirst:    &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 6, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 6, Tint: -0.499984740745262},
+			ColorLow:      &xlsxTabColor{Theme: 6, Tint: -0.499984740745262},
+		}, // 21
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 7, Tint: 0.39997558519241921},
+			ColorNegative: &xlsxTabColor{Theme: 0, Tint: -0.499984740745262},
+			ColorMarkers:  &xlsxTabColor{Theme: 7, Tint: 0.79998168889431442},
+			ColorFirst:    &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 7, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 7, Tint: -0.499984740745262},
+			ColorLow:      &xlsxTabColor{Theme: 7, Tint: -0.499984740745262},
+		}, // 22
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 8, Tint: 0.39997558519241921},
+			ColorNegative: &xlsxTabColor{Theme: 0, Tint: -0.499984740745262},
+			ColorMarkers:  &xlsxTabColor{Theme: 8, Tint: 0.79998168889431442},
+			ColorFirst:    &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 8, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 8, Tint: -0.499984740745262},
+			ColorLow:      &xlsxTabColor{Theme: 8, Tint: -0.499984740745262},
+		}, // 23
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 9, Tint: 0.39997558519241921},
+			ColorNegative: &xlsxTabColor{Theme: 0, Tint: -0.499984740745262},
+			ColorMarkers:  &xlsxTabColor{Theme: 9, Tint: 0.79998168889431442},
+			ColorFirst:    &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 9, Tint: -0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 9, Tint: -0.499984740745262},
+			ColorLow:      &xlsxTabColor{Theme: 9, Tint: -0.499984740745262},
+		}, // 24
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 1, Tint: 0.499984740745262},
+			ColorNegative: &xlsxTabColor{Theme: 1, Tint: 0.249977111117893},
+			ColorMarkers:  &xlsxTabColor{Theme: 1, Tint: 0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 1, Tint: 0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 1, Tint: 0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 1, Tint: 0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 1, Tint: 0.249977111117893},
+		}, // 25
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 1, Tint: 0.34998626667073579},
+			ColorNegative: &xlsxTabColor{Theme: 0, Tint: 0.249977111117893},
+			ColorMarkers:  &xlsxTabColor{Theme: 0, Tint: 0.249977111117893},
+			ColorFirst:    &xlsxTabColor{Theme: 0, Tint: 0.249977111117893},
+			ColorLast:     &xlsxTabColor{Theme: 0, Tint: 0.249977111117893},
+			ColorHigh:     &xlsxTabColor{Theme: 0, Tint: 0.249977111117893},
+			ColorLow:      &xlsxTabColor{Theme: 0, Tint: 0.249977111117893},
+		}, // 26
+		{
+			ColorSeries:   &xlsxTabColor{RGB: "FF323232"},
+			ColorNegative: &xlsxTabColor{RGB: "FFD00000"},
+			ColorMarkers:  &xlsxTabColor{RGB: "FFD00000"},
+			ColorFirst:    &xlsxTabColor{RGB: "FFD00000"},
+			ColorLast:     &xlsxTabColor{RGB: "FFD00000"},
+			ColorHigh:     &xlsxTabColor{RGB: "FFD00000"},
+			ColorLow:      &xlsxTabColor{RGB: "FFD00000"},
+		}, // 27
+		{
+			ColorSeries:   &xlsxTabColor{RGB: "FF000000"},
+			ColorNegative: &xlsxTabColor{RGB: "FF0070C0"},
+			ColorMarkers:  &xlsxTabColor{RGB: "FF0070C0"},
+			ColorFirst:    &xlsxTabColor{RGB: "FF0070C0"},
+			ColorLast:     &xlsxTabColor{RGB: "FF0070C0"},
+			ColorHigh:     &xlsxTabColor{RGB: "FF0070C0"},
+			ColorLow:      &xlsxTabColor{RGB: "FF0070C0"},
+		}, // 28
+		{
+			ColorSeries:   &xlsxTabColor{RGB: "FF376092"},
+			ColorNegative: &xlsxTabColor{RGB: "FFD00000"},
+			ColorMarkers:  &xlsxTabColor{RGB: "FFD00000"},
+			ColorFirst:    &xlsxTabColor{RGB: "FFD00000"},
+			ColorLast:     &xlsxTabColor{RGB: "FFD00000"},
+			ColorHigh:     &xlsxTabColor{RGB: "FFD00000"},
+			ColorLow:      &xlsxTabColor{RGB: "FFD00000"},
+		}, // 29
+		{
+			ColorSeries:   &xlsxTabColor{RGB: "FF0070C0"},
+			ColorNegative: &xlsxTabColor{RGB: "FF000000"},
+			ColorMarkers:  &xlsxTabColor{RGB: "FF000000"},
+			ColorFirst:    &xlsxTabColor{RGB: "FF000000"},
+			ColorLast:     &xlsxTabColor{RGB: "FF000000"},
+			ColorHigh:     &xlsxTabColor{RGB: "FF000000"},
+			ColorLow:      &xlsxTabColor{RGB: "FF000000"},
+		}, // 30
+		{
+			ColorSeries:   &xlsxTabColor{RGB: "FF5F5F5F"},
+			ColorNegative: &xlsxTabColor{RGB: "FFFFB620"},
+			ColorMarkers:  &xlsxTabColor{RGB: "FFD70077"},
+			ColorFirst:    &xlsxTabColor{RGB: "FF5687C2"},
+			ColorLast:     &xlsxTabColor{RGB: "FF359CEB"},
+			ColorHigh:     &xlsxTabColor{RGB: "FF56BE79"},
+			ColorLow:      &xlsxTabColor{RGB: "FFFF5055"},
+		}, // 31
+		{
+			ColorSeries:   &xlsxTabColor{RGB: "FF5687C2"},
+			ColorNegative: &xlsxTabColor{RGB: "FFFFB620"},
+			ColorMarkers:  &xlsxTabColor{RGB: "FFD70077"},
+			ColorFirst:    &xlsxTabColor{RGB: "FF777777"},
+			ColorLast:     &xlsxTabColor{RGB: "FF359CEB"},
+			ColorHigh:     &xlsxTabColor{RGB: "FF56BE79"},
+			ColorLow:      &xlsxTabColor{RGB: "FFFF5055"},
+		}, // 32
+		{
+			ColorSeries:   &xlsxTabColor{RGB: "FFC6EFCE"},
+			ColorNegative: &xlsxTabColor{RGB: "FFFFC7CE"},
+			ColorMarkers:  &xlsxTabColor{RGB: "FF8CADD6"},
+			ColorFirst:    &xlsxTabColor{RGB: "FFFFDC47"},
+			ColorLast:     &xlsxTabColor{RGB: "FFFFEB9C"},
+			ColorHigh:     &xlsxTabColor{RGB: "FF60D276"},
+			ColorLow:      &xlsxTabColor{RGB: "FFFF5367"},
+		}, // 33
+		{
+			ColorSeries:   &xlsxTabColor{RGB: "FF00B050"},
+			ColorNegative: &xlsxTabColor{RGB: "FFFF0000"},
+			ColorMarkers:  &xlsxTabColor{RGB: "FF0070C0"},
+			ColorFirst:    &xlsxTabColor{RGB: "FFFFC000"},
+			ColorLast:     &xlsxTabColor{RGB: "FFFFC000"},
+			ColorHigh:     &xlsxTabColor{RGB: "FF00B050"},
+			ColorLow:      &xlsxTabColor{RGB: "FFFF0000"},
+		}, // 34
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 3},
+			ColorNegative: &xlsxTabColor{Theme: 9},
+			ColorMarkers:  &xlsxTabColor{Theme: 8},
+			ColorFirst:    &xlsxTabColor{Theme: 4},
+			ColorLast:     &xlsxTabColor{Theme: 5},
+			ColorHigh:     &xlsxTabColor{Theme: 6},
+			ColorLow:      &xlsxTabColor{Theme: 7},
+		}, // 35
+		{
+			ColorSeries:   &xlsxTabColor{Theme: 1},
+			ColorNegative: &xlsxTabColor{Theme: 9},
+			ColorMarkers:  &xlsxTabColor{Theme: 8},
+			ColorFirst:    &xlsxTabColor{Theme: 4},
+			ColorLast:     &xlsxTabColor{Theme: 5},
+			ColorHigh:     &xlsxTabColor{Theme: 6},
+			ColorLow:      &xlsxTabColor{Theme: 7},
+		}, // 36
+	}
+	return groups[ID]
+}
+
+// AddSparkline provides a function to add sparklines to the worksheet by
+// given formatting options. Sparklines are small charts that fit in a single
+// cell and are used to show trends in data. Sparklines are a feature of Excel
+// 2010 and later only. You can write them to an XLSX file that can be read by
+// Excel 2007 but they won't be displayed. For example, add a grouped
+// sparkline. Changes are applied to all three:
+//
+//    err := f.AddSparkline("Sheet1", &excelize.SparklineOption{
+//        Location: []string{"A1", "A2", "A3"},
+//        Range:    []string{"Sheet2!A1:J1", "Sheet2!A2:J2", "Sheet2!A3:J3"},
+//        Markers:  true,
+//    })
+//
+// The following shows the formatting options of sparkline supported by excelize:
+//
+//     Parameter | Description
+//    -----------+--------------------------------------------
+//     Location  | Required, must have the same number with 'Range' parameter
+//     Range     | Required, must have the same number with 'Location' parameter
+//     Type      | Enumeration value: line, column, win_loss
+//     Style     | Value range: 0 - 35
+//     Hight     | Toggle sparkline high points
+//     Low       | Toggle sparkline low points
+//     First     | Toggle sparkline first points
+//     Last      | Toggle sparkline last points
+//     Negative  | Toggle sparkline negative points
+//     Markers   | Toggle sparkline markers
+//     ColorAxis | An RGB Color is specified as RRGGBB
+//     Axis      | Show sparkline axis
+//
+func (f *File) AddSparkline(sheet string, opt *SparklineOption) (err error) {
+	var (
+		ws                             *xlsxWorksheet
+		sparkType                      string
+		sparkTypes                     map[string]string
+		specifiedSparkTypes            string
+		ok                             bool
+		group                          *xlsxX14SparklineGroup
+		groups                         *xlsxX14SparklineGroups
+		sparklineGroupsBytes, extBytes []byte
+	)
+
+	// parameter validation
+	if ws, err = f.parseFormatAddSparklineSet(sheet, opt); err != nil {
+		return
+	}
+	// Handle the sparkline type
+	sparkType = "line"
+	sparkTypes = map[string]string{"line": "line", "column": "column", "win_loss": "stacked"}
+	if opt.Type != "" {
+		if specifiedSparkTypes, ok = sparkTypes[opt.Type]; !ok {
+			err = errors.New("parameter 'Type' must be 'line', 'column' or 'win_loss'")
+			return
+		}
+		sparkType = specifiedSparkTypes
+	}
+	group = f.addSparklineGroupByStyle(opt.Style)
+	group.Type = sparkType
+	group.ColorAxis = &xlsxColor{RGB: "FF000000"}
+	group.DisplayEmptyCellsAs = "gap"
+	group.High = opt.High
+	group.Low = opt.Low
+	group.First = opt.First
+	group.Last = opt.Last
+	group.Negative = opt.Negative
+	group.DisplayXAxis = opt.Axis
+	group.Markers = opt.Markers
+	if opt.SeriesColor != "" {
+		group.ColorSeries = &xlsxTabColor{
+			RGB: getPaletteColor(opt.SeriesColor),
+		}
+	}
+	if opt.Reverse {
+		group.RightToLeft = opt.Reverse
+	}
+	f.addSparkline(opt, group)
+	if ws.ExtLst.Ext != "" { // append mode ext
+		if err = f.appendSparkline(ws, group, groups); err != nil {
+			return
+		}
+	} else {
+		groups = &xlsxX14SparklineGroups{
+			XMLNSXM:         NameSpaceSpreadSheetExcel2006Main,
+			SparklineGroups: []*xlsxX14SparklineGroup{group},
+		}
+		if sparklineGroupsBytes, err = xml.Marshal(groups); err != nil {
+			return
+		}
+		if extBytes, err = xml.Marshal(&xlsxWorksheetExt{
+			URI:     ExtURISparklineGroups,
+			Content: string(sparklineGroupsBytes),
+		}); err != nil {
+			return
+		}
+		ws.ExtLst.Ext = string(extBytes)
+	}
+
+	return
+}
+
+// parseFormatAddSparklineSet provides a function to validate sparkline
+// properties.
+func (f *File) parseFormatAddSparklineSet(sheet string, opt *SparklineOption) (*xlsxWorksheet, error) {
+	ws, err := f.workSheetReader(sheet)
+	if err != nil {
+		return ws, err
+	}
+	if opt == nil {
+		return ws, errors.New("parameter is required")
+	}
+	if len(opt.Location) < 1 {
+		return ws, errors.New("parameter 'Location' is required")
+	}
+	if len(opt.Range) < 1 {
+		return ws, errors.New("parameter 'Range' is required")
+	}
+	// The ranges and locations must match.\
+	if len(opt.Location) != len(opt.Range) {
+		return ws, errors.New(`must have the same number of 'Location' and 'Range' parameters`)
+	}
+	if opt.Style < 0 || opt.Style > 35 {
+		return ws, errors.New("parameter 'Style' must betweent 0-35")
+	}
+	if ws.ExtLst == nil {
+		ws.ExtLst = &xlsxExtLst{}
+	}
+	return ws, err
+}
+
+// addSparkline provides a function to create a sparkline in a sparkline group
+// by given properties.
+func (f *File) addSparkline(opt *SparklineOption, group *xlsxX14SparklineGroup) {
+	for idx, location := range opt.Location {
+		group.Sparklines.Sparkline = append(group.Sparklines.Sparkline, &xlsxX14Sparkline{
+			F:     opt.Range[idx],
+			Sqref: location,
+		})
+	}
+}
+
+// appendSparkline provides a function to append sparkline to sparkline
+// groups.
+func (f *File) appendSparkline(ws *xlsxWorksheet, group *xlsxX14SparklineGroup, groups *xlsxX14SparklineGroups) (err error) {
+	var (
+		idx                                                    int
+		decodeExtLst                                           *decodeWorksheetExt
+		decodeSparklineGroups                                  *decodeX14SparklineGroups
+		ext                                                    *xlsxWorksheetExt
+		sparklineGroupsBytes, sparklineGroupBytes, extLstBytes []byte
+	)
+	decodeExtLst = new(decodeWorksheetExt)
+	if err = f.xmlNewDecoder(strings.NewReader("<extLst>" + ws.ExtLst.Ext + "</extLst>")).
+		Decode(decodeExtLst); err != nil && err != io.EOF {
+		return
+	}
+	for idx, ext = range decodeExtLst.Ext {
+		if ext.URI == ExtURISparklineGroups {
+			decodeSparklineGroups = new(decodeX14SparklineGroups)
+			if err = f.xmlNewDecoder(strings.NewReader(ext.Content)).
+				Decode(decodeSparklineGroups); err != nil && err != io.EOF {
+				return
+			}
+			if sparklineGroupBytes, err = xml.Marshal(group); err != nil {
+				return
+			}
+			groups = &xlsxX14SparklineGroups{
+				XMLNSXM: NameSpaceSpreadSheetExcel2006Main,
+				Content: decodeSparklineGroups.Content + string(sparklineGroupBytes),
+			}
+			if sparklineGroupsBytes, err = xml.Marshal(groups); err != nil {
+				return
+			}
+			decodeExtLst.Ext[idx].Content = string(sparklineGroupsBytes)
+		}
+	}
+	if extLstBytes, err = xml.Marshal(decodeExtLst); err != nil {
+		return
+	}
+	ws.ExtLst = &xlsxExtLst{
+		Ext: strings.TrimSuffix(strings.TrimPrefix(string(extLstBytes), "<extLst>"), "</extLst>"),
+	}
+	return
+}