获取工作表属性

  1. func (f *File) GetSheetPrOptions(sheet string, opts ...SheetPrOptionPtr) error

根据给定的工作表名称和筛选项获取工作表属性。

可选属性类型
CodeNamestring
EnableFormatConditionsCalculationbool
Publishedbool
FitToPagebool
TabColorIndexedint
TabColorRGBstring
TabColorThemeint
TabColorTintfloat64
AutoPageBreaksbool
OutlineSummaryBelowbool

例如：

  1. f := excelize.NewFile()
  2. const sheet = "Sheet1"
  4. var (
  5.     codeName                          excelize.CodeName
  6.     enableFormatConditionsCalculation excelize.EnableFormatConditionsCalculation
  7.     published                         excelize.Published
  8.     fitToPage                         excelize.FitToPage
  9.     tabColorIndexed                   excelize.TabColorIndexed
  10.     tabColorRGB                       excelize.TabColorRGB
  11.     tabColorTheme                     excelize.TabColorTheme
  12.     tabColorTint                      excelize.TabColorTint
  13.     autoPageBreaks                    excelize.AutoPageBreaks
  14.     outlineSummaryBelow               excelize.OutlineSummaryBelow
  15. )
  17. if err := f.GetSheetPrOptions(sheet,
  18.     &codeName,
  19.     &enableFormatConditionsCalculation,
  20.     &published,
  21.     &fitToPage,
  22.     &tabColorIndexed,
  23.     &tabColorRGB,
  24.     &tabColorTheme,
  25.     &tabColorTint,
  26.     &autoPageBreaks,
  27.     &outlineSummaryBelow,
  28. ); err != nil {
  29.     fmt.Println(err)
  30. }
  31. fmt.Println("Defaults:")
  32. fmt.Printf("- codeName: %q\n", codeName)
  33. fmt.Println("- enableFormatConditionsCalculation:", enableFormatConditionsCalculation)
  34. fmt.Println("- published:", published)
  35. fmt.Println("- fitToPage:", fitToPage)
  36. fmt.Printf("- tabColorIndexed: %d\n", tabColorIndexed)
  37. fmt.Printf("- tabColorRGB: %q\n", tabColorRGB)
  38. fmt.Printf("- tabColorTheme: %d\n", tabColorTheme)
  39. fmt.Printf("- tabColorTint: %f\n", tabColorTint)
  40. fmt.Println("- autoPageBreaks:", autoPageBreaks)
  41. fmt.Println("- outlineSummaryBelow:", outlineSummaryBelow)

输出：

  1. Defaults:
  2. - codeName: ""
  3. - enableFormatConditionsCalculation: true
  4. - published: true
  5. - fitToPage: false
  6. - tabColorIndexed: -1
  7. - tabColorRGB: ""
  8. - tabColorTheme: -1
  9. - tabColorTint: 0.000000
  10. - autoPageBreaks: false
  11. - outlineSummaryBelow: true