Excelize

Fork

Add stacked bar chart

Merge pull request #156 from dolmen-go/fix/SheetViewOptPtr-is-a-SheetViewOpt

SheetViewOptionPtr: document that it is a superset of SheetViewOption

Merge pull request #154 from dolmen-go/feature/SheetPr-options

Add {G,S}etSheetPrOptions() to allow to set FitToPage for printing

SheetViewOptionPtr: document that it is a superset of SheetViewOption

Document in type system (not just in text for humans) that
all SheetViewOptionPtr are also SheetViewOption (well, if not nil).
This improves documentation visible with godoc but this simple change
also allows more flexibility to manipulate SheetViewOption programatically
such as saving and restoring values:

var opt excelize.ShowFormulas
opt = new(excelize.ShowFormulas)
_ = xl.GetSheetViewOptions(sheet, -1, opt)
_ = xl.SetSheetViewOptions(sheet, -1, opt)

Add {G,S}etSheetPrOptions()

Add SetSheetPrOptions and GetSheetPrOptions to allow to set options on
<sheetPr> and <pageSetUpPr>.

The following options are implemented:
- CodeName (string)
- EnableFormatConditionsCalculation (bool)
- Published (bool)
- FitToPage (bool)
- AutoPageBreaks (bool)

Merge pull request #149 from dolmen-go/feature/SheetView-options

Add SetSheetViewOptions()

Add SetSheetViewOptions and GetSheetViewOptions (#145)

Two new methods:
- SetSheetViewOptions(sheetName string, viewIndex int, opts ...SheetViewOption) error
- GetSheetViewOptions(sheetName string, viewIndex int, opts ...SheetViewOptionPtr) error

The option values are given by the user through types that have privates methods
that implement the private SheetViewOption and SheetViewOptionPtr interfaces:
- DefaultGridColor(bool)
- RightToLeft(bool)
- ShowFormulas(bool)
- ShowGridLines(bool)
- ShowRowColHeaders(bool)

Examples:
err := xl.SetSheetViewOptions("Sheet1", -1, excelize.ShowGridLines(true))

var showGridLines excelize.ShowGridLines
err := xl.GetSheetViewOptions("Sheet1", -1, &showGridLines)

Fixes #145.

Add missing XML attributes `customWorkbookViews` and `customWorkbookView` in the workbook, relate issue #152.

Signed-off-by: Ri Xu <xuri.me@gmail.com>

Rename import path to github.com/360EntSecGroup-Skylar/excelize

Bugfix: corrupted xlsx after write operation, relate issue #152.

Signed-off-by: Ri Xu <xuri.me@gmail.com>

Merge pull request #141 from WingGao/wing

fix OpenReader no sheet error

- Bugfix: use sheet name in func `AddPicture`, relate issue #142;
- godoc updated

fix OpenReader no sheet error

Bugfix: use sheet name in func `AddChat`, relate issue #138

Signed-off-by: Ri Xu <xuri.me@gmail.com>

Bugfix: read sheet name error, relate issue #137

Signed-off-by: Ri Xu <xuri.me@gmail.com>

- Add unsigned integer data type support, related issue #136;
- go test and godoc updated

Signed-off-by: Ri Xu <xuri.me@gmail.com>

Performance optimization, use the array index instead of the value in range.

Improve code readability.

Merge pull request #126 from dvrkps/patch-1

travis: update go versions

travis: update go versions

Handle coordinate parse exception, relate issue #122.

godoc updated.

- API changed, use worksheet name instead of "sheet" + index, related issue #25, #43, #47, #51, #89, #101, #116 and #120.
- go test updated

Simple go test.

go test added for pull request #114

Merge pull request #114 from lichaofei/master

change the TitleToNumber function

Optimize code.

Merge pull request #1 from lichaofei/test

Test

Update lib.go

Update lib.go