设置工作表视图属性

  1. func (f *File) SetSheetViewOptions(sheet string, viewIndex int, opts ...SheetViewOption) error

根据给定的工作表名称、视图索引和视图参数设置工作表视图属性，viewIndex 可以是负数，如果是这样，则向后计数（-1 代表最后一个视图）。

可选视图参数类型
DefaultGridColorbool
ShowFormulasbool
ShowGridLinesbool
ShowRowColHeadersbool
ShowZerosbool
RightToLeftbool
ShowRulerbool
Viewstring
TopLeftCellstring
ZoomScalefloat64
  • 例1:
  1. err = f.SetSheetViewOptions("Sheet1", -1, ShowGridLines(false))
  • 例2:
  1. f := excelize.NewFile()
  2. const sheet = "Sheet1"
  4. if err := f.SetSheetViewOptions(sheet, 0,
  5.     excelize.DefaultGridColor(false),
  6.     excelize.ShowFormulas(true),
  7.     excelize.ShowGridLines(true),
  8.     excelize.ShowRowColHeaders(true),
  9.     excelize.RightToLeft(false),
  10.     excelize.ShowRuler(false),
  11.     excelize.View("pageLayout"),
  12.     excelize.TopLeftCell("C3"),
  13.     excelize.ZoomScale(80),
  14. ); err != nil {
  15.     fmt.Println(err)
  16. }
  18. var zoomScale ZoomScale
  19. fmt.Println("Default:")
  20. fmt.Println("- zoomScale: 80")
  22. if err := f.SetSheetViewOptions(sheet, 0, excelize.ZoomScale(500)); err != nil {
  23.     fmt.Println(err)
  24. }
  26. if err := f.GetSheetViewOptions(sheet, 0, &zoomScale); err != nil {
  27.     fmt.Println(err)
  28. }
  30. fmt.Println("Used out of range value:")
  31. fmt.Println("- zoomScale:", zoomScale)
  33. if err := f.SetSheetViewOptions(sheet, 0, excelize.ZoomScale(123)); err != nil {
  34.     fmt.Println(err)
  35. }
  37. if err := f.GetSheetViewOptions(sheet, 0, &zoomScale); err != nil {
  38.     fmt.Println(err)
  39. }
  41. fmt.Println("Used correct value:")
  42. fmt.Println("- zoomScale:", zoomScale)

得到输出：

  1. Default:
  2. - zoomScale: 80
  3. Used out of range value:
  4. - zoomScale: 80
  5. Used correct value:
  6. - zoomScale: 123