获取工作表格式属性

  1. func (f *File) GetSheetFormatPr(sheet string, opts ...SheetFormatPrOptionsPtr) error

根据给定的工作表名称获取格式属性。

可选格式参数数据类型
BaseColWidthuint8
DefaultColWidthfloat64
DefaultRowHeightfloat64
CustomHeightbool
ZeroHeightbool
ThickTopbool
ThickBottombool

例子:

  1. f := excelize.NewFile()
  2. const sheet = "Sheet1"
  4. var (
  5.     baseColWidth     excelize.BaseColWidth
  6.     defaultColWidth  excelize.DefaultColWidth
  7.     defaultRowHeight excelize.DefaultRowHeight
  8.     customHeight     excelize.CustomHeight
  9.     zeroHeight       excelize.ZeroHeight
  10.     thickTop         excelize.ThickTop
  11.     thickBottom      excelize.ThickBottom
  12. )
  14. if err := f.GetSheetFormatPr(sheet,
  15.     &baseColWidth,
  16.     &defaultColWidth,
  17.     &defaultRowHeight,
  18.     &customHeight,
  19.     &zeroHeight,
  20.     &thickTop,
  21.     &thickBottom,
  22. ); err != nil {
  23.     fmt.Println(err)
  24. }
  25. fmt.Println("Defaults:")
  26. fmt.Println("- baseColWidth:", baseColWidth)
  27. fmt.Println("- defaultColWidth:", defaultColWidth)
  28. fmt.Println("- defaultRowHeight:", defaultRowHeight)
  29. fmt.Println("- customHeight:", customHeight)
  30. fmt.Println("- zeroHeight:", zeroHeight)
  31. fmt.Println("- thickTop:", thickTop)
  32. fmt.Println("- thickBottom:", thickBottom)

得到输出：

  1. Defaults:
  2. - baseColWidth: 0
  3. - defaultColWidth: 0
  4. - defaultRowHeight: 15
  5. - customHeight: false
  6. - zeroHeight: false
  7. - thickTop: false
  8. - thickBottom: false