From b8464af0869af6fe84aca2a5f35b08f0efdfa0b4 Mon Sep 17 00:00:00 2001 From: OloloevReal Date: Sun, 15 Apr 2018 22:56:47 +0300 Subject: Added ZoomScale SheetViewOption Accessible value between 10 - 400 Used as: xlsx.SetSheetViewOptions(sheet, 0, excelize.ZoomScale(75)) --- sheetview.go | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'sheetview.go') diff --git a/sheetview.go b/sheetview.go index f05e751..679e915 100644 --- a/sheetview.go +++ b/sheetview.go @@ -24,6 +24,8 @@ type ( ShowGridLines bool // ShowRowColHeaders is a SheetViewOption. ShowRowColHeaders bool + // ZoomScale is a SheetViewOption. + ZoomScale float64 /* TODO // ShowWhiteSpace is a SheetViewOption. ShowWhiteSpace bool @@ -76,6 +78,17 @@ func (o *ShowRowColHeaders) getSheetViewOption(view *xlsxSheetView) { *o = ShowRowColHeaders(defaultTrue(view.ShowRowColHeaders)) // Excel default: true } +func (o ZoomScale) setSheetViewOption(view *xlsxSheetView) { + //This attribute is restricted to values ranging from 10 to 400. + if float64(o) >= 10 && float64(o) <= 400 { + view.ZoomScale = float64(o) + } +} + +func (o *ZoomScale) getSheetViewOption(view *xlsxSheetView) { + *o = ZoomScale(view.ZoomScale) +} + // getSheetView returns the SheetView object func (f *File) getSheetView(sheetName string, viewIndex int) (*xlsxSheetView, error) { xlsx := f.workSheetReader(sheetName) -- cgit v1.2.1