获取工作表视图属性

  1. func (f *File) GetSheetViewOptions(name string, viewIndex int, opts ...SheetViewOptionPtr) error

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

可选视图参数类型
DefaultGridColorbool
RightToLeftbool
ShowFormulasbool
ShowGridLinesbool
ShowRowColHeadersbool
ZoomScalefloat64
TopLeftCellstring
ShowZerosbool
  • 例1，获取名为 Sheet1 的工作表上最后一个视图的网格线属性设置：
  1. var showGridLines excelize.ShowGridLines
  2. err = f.GetSheetViewOptions("Sheet1", -1, &showGridLines)
  • 例2：
  1. f := excelize.NewFile()
  2. const sheet = "Sheet1"
  4. var (
  5.     defaultGridColor  excelize.DefaultGridColor
  6.     rightToLeft       excelize.RightToLeft
  7.     showFormulas      excelize.ShowFormulas
  8.     showGridLines     excelize.ShowGridLines
  9.     showZeros         excelize.ShowZeros
  10.     showRowColHeaders excelize.ShowRowColHeaders
  11.     zoomScale         excelize.ZoomScale
  12.     topLeftCell       excelize.TopLeftCell
  13. )
  15. if err := f.GetSheetViewOptions(sheet, 0,
  16.     &defaultGridColor,
  17.     &rightToLeft,
  18.     &showFormulas,
  19.     &showGridLines,
  20.     &showZeros,
  21.     &showRowColHeaders,
  22.     &zoomScale,
  23.     &topLeftCell,
  24. ); err != nil {
  25.     fmt.Println(err)
  26. }
  28. fmt.Println("Default:")
  29. fmt.Println("- defaultGridColor:", defaultGridColor)
  30. fmt.Println("- rightToLeft:", rightToLeft)
  31. fmt.Println("- showFormulas:", showFormulas)
  32. fmt.Println("- showGridLines:", showGridLines)
  33. fmt.Println("- showZeros:", showZeros)
  34. fmt.Println("- showRowColHeaders:", showRowColHeaders)
  35. fmt.Println("- zoomScale:", zoomScale)
  36. fmt.Println("- topLeftCell:", `"`+topLeftCell+`"`)
  38. if err := f.SetSheetViewOptions(sheet, 0, excelize.TopLeftCell("B2")); err != nil {
  39.     fmt.Println(err)
  40. }
  42. if err := f.GetSheetViewOptions(sheet, 0, &topLeftCell); err != nil {
  43.     fmt.Println(err)
  44. }
  46. if err := f.SetSheetViewOptions(sheet, 0, excelize.ShowGridLines(false)); err != nil {
  47.     fmt.Println(err)
  48. }
  50. if err := f.GetSheetViewOptions(sheet, 0, &showGridLines); err != nil {
  51.     fmt.Println(err)
  52. }
  54. if err := f.SetSheetViewOptions(sheet, 0, excelize.ShowZeros(false)); err != nil {
  55.     fmt.Println(err)
  56. }
  58. if err := f.GetSheetViewOptions(sheet, 0, &showZeros); err != nil {
  59.     fmt.Println(err)
  60. }
  62. fmt.Println("After change:")
  63. fmt.Println("- showGridLines:", showGridLines)
  64. fmt.Println("- showZeros:", showZeros)
  65. fmt.Println("- topLeftCell:", topLeftCell)

得到输出：

  1. Default:
  2. - defaultGridColor: true
  3. - rightToLeft: false
  4. - showFormulas: false
  5. - showGridLines: true
  6. - showZeros: true
  7. - showRowColHeaders: true
  8. - zoomScale: 0
  9. - topLeftCell: ""
  10. After change:
  11. - showGridLines: false
  12. - showZeros: false
  13. - topLeftCell: B2