常量

以下这些常量定义了当前支持的图表类型：

  1. const (
  2.     Area                        = "area"
  3.     AreaStacked                 = "areaStacked"
  4.     AreaPercentStacked          = "areaPercentStacked"
  5.     Area3D                      = "area3D"
  6.     Area3DStacked               = "area3DStacked"
  7.     Area3DPercentStacked        = "area3DPercentStacked"
  8.     Bar                         = "bar"
  9.     BarStacked                  = "barStacked"
  10.     BarPercentStacked           = "barPercentStacked"
  11.     Bar3DClustered              = "bar3DClustered"
  12.     Bar3DStacked                = "bar3DStacked"
  13.     Bar3DPercentStacked         = "bar3DPercentStacked"
  14.     Bar3DConeClustered          = "bar3DConeClustered"
  15.     Bar3DConeStacked            = "bar3DConeStacked"
  16.     Bar3DConePercentStacked     = "bar3DConePercentStacked"
  17.     Bar3DPyramidClustered       = "bar3DPyramidClustered"
  18.     Bar3DPyramidStacked         = "bar3DPyramidStacked"
  19.     Bar3DPyramidPercentStacked  = "bar3DPyramidPercentStacked"
  20.     Bar3DCylinderClustered      = "bar3DCylinderClustered"
  21.     Bar3DCylinderStacked        = "bar3DCylinderStacked"
  22.     Bar3DCylinderPercentStacked = "bar3DCylinderPercentStacked"
  23.     Col                         = "col"
  24.     ColStacked                  = "colStacked"
  25.     ColPercentStacked           = "colPercentStacked"
  26.     Col3D                       = "col3D"
  27.     Col3DClustered              = "col3DClustered"
  28.     Col3DStacked                = "col3DStacked"
  29.     Col3DPercentStacked         = "col3DPercentStacked"
  30.     Col3DCone                   = "col3DCone"
  31.     Col3DConeClustered          = "col3DConeClustered"
  32.     Col3DConeStacked            = "col3DConeStacked"
  33.     Col3DConePercentStacked     = "col3DConePercentStacked"
  34.     Col3DPyramid                = "col3DPyramid"
  35.     Col3DPyramidClustered       = "col3DPyramidClustered"
  36.     Col3DPyramidStacked         = "col3DPyramidStacked"
  37.     Col3DPyramidPercentStacked  = "col3DPyramidPercentStacked"
  38.     Col3DCylinder               = "col3DCylinder"
  39.     Col3DCylinderClustered      = "col3DCylinderClustered"
  40.     Col3DCylinderStacked        = "col3DCylinderStacked"
  41.     Col3DCylinderPercentStacked = "col3DCylinderPercentStacked"
  42.     Doughnut                    = "doughnut"
  43.     Line                        = "line"
  44.     Pie                         = "pie"
  45.     Pie3D                       = "pie3D"
  46.     PieOfPieChart               = "pieOfPie"
  47.     BarOfPieChart               = "barOfPie"
  48.     Radar                       = "radar"
  49.     Scatter                     = "scatter"
  50.     Surface3D                   = "surface3D"
  51.     WireframeSurface3D          = "wireframeSurface3D"
  52.     Contour                     = "contour"
  53.     WireframeContour            = "wireframeContour"
  54.     Bubble                      = "bubble"
  55.     Bubble3D                    = "bubble3D"
  56. )

以下这些常量定义了 XML 标签的命名空间：

  1. const (
  2.     SourceRelationshipChart                      = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart"
  3.     SourceRelationshipComments                   = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments"
  4.     SourceRelationshipImage                      = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/image"
  5.     SourceRelationshipTable                      = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/table"
  6.     SourceRelationshipDrawingML                  = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing"
  7.     SourceRelationshipDrawingVML                 = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing"
  8.     SourceRelationshipHyperLink                  = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink"
  9.     SourceRelationshipWorkSheet                  = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet"
  10.     SourceRelationshipChartsheet                 = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/chartsheet"
  11.     SourceRelationshipDialogsheet                = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/dialogsheet"
  12.     SourceRelationshipPivotTable                 = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotTable"
  13.     SourceRelationshipPivotCache                 = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotCacheDefinition"
  14.     SourceRelationshipSharedStrings              = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings"
  15.     SourceRelationshipVBAProject                 = "http://schemas.microsoft.com/office/2006/relationships/vbaProject"
  16.     NameSpaceXML                                 = "http://www.w3.org/XML/1998/namespace"
  17.     NameSpaceXMLSchemaInstance                   = "http://www.w3.org/2001/XMLSchema-instance"
  18.     StrictSourceRelationship                     = "http://purl.oclc.org/ooxml/officeDocument/relationships"
  19.     StrictSourceRelationshipChart                = "http://purl.oclc.org/ooxml/officeDocument/relationships/chart"
  20.     StrictSourceRelationshipComments             = "http://purl.oclc.org/ooxml/officeDocument/relationships/comments"
  21.     StrictSourceRelationshipImage                = "http://purl.oclc.org/ooxml/officeDocument/relationships/image"
  22.     StrictNameSpaceSpreadSheet                   = "http://purl.oclc.org/ooxml/spreadsheetml/main"
  23.     NameSpaceDublinCore                          = "http://purl.org/dc/elements/1.1/"
  24.     NameSpaceDublinCoreTerms                     = "http://purl.org/dc/terms/"
  25.     NameSpaceDublinCoreMetadataInitiative        = "http://purl.org/dc/dcmitype/"
  26.     ContentTypeDrawing                           = "application/vnd.openxmlformats-officedocument.drawing+xml"
  27.     ContentTypeDrawingML                         = "application/vnd.openxmlformats-officedocument.drawingml.chart+xml"
  28.     ContentTypeMacro                             = "application/vnd.ms-excel.sheet.macroEnabled.main+xml"
  29.     ContentTypeSpreadSheetMLChartsheet           = "application/vnd.openxmlformats-officedocument.spreadsheetml.chartsheet+xml"
  30.     ContentTypeSpreadSheetMLComments             = "application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml"
  31.     ContentTypeSpreadSheetMLPivotCacheDefinition = "application/vnd.openxmlformats-officedocument.spreadsheetml.pivotCacheDefinition+xml"
  32.     ContentTypeSpreadSheetMLPivotTable           = "application/vnd.openxmlformats-officedocument.spreadsheetml.pivotTable+xml"
  33.     ContentTypeSpreadSheetMLSharedStrings        = "application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"
  34.     ContentTypeSpreadSheetMLTable                = "application/vnd.openxmlformats-officedocument.spreadsheetml.table+xml"
  35.     ContentTypeSpreadSheetMLWorksheet            = "application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"
  36.     ContentTypeVBA                               = "application/vnd.ms-office.vbaProject"
  37.     ContentTypeVML                               = "application/vnd.openxmlformats-officedocument.vmlDrawing"
  38.     // ExtURIConditionalFormattings is the extLst child element
  39.     // ([ISO/IEC29500-1:2016] section 18.2.10) of the worksheet element
  40.     // ([ISO/IEC29500-1:2016] section 18.3.1.99) is extended by the addition of
  41.     // new child ext elements ([ISO/IEC29500-1:2016] section 18.2.7)
  42.     ExtURIConditionalFormattings = "{78C0D931-6437-407D-A8EE-F0AAD7539E65}"
  43.     ExtURIDataValidations        = "{CCE6A557-97BC-4B89-ADB6-D9C93CAAB3DF}"
  44.     ExtURISparklineGroups        = "{05C60535-1F16-4fd2-B633-F4F36F0B64E0}"
  45.     ExtURISlicerListX14          = "{A8765BA9-456A-4DAB-B4F3-ACF838C121DE}"
  46.     ExtURISlicerCachesListX14    = "{BBE1A952-AA13-448e-AADC-164F8A28A991}"
  47.     ExtURISlicerListX15          = "{3A4CF648-6AED-40f4-86FF-DC5316D8AED3}"
  48.     ExtURIProtectedRanges        = "{FC87AEE6-9EDD-4A0A-B7FB-166176984837}"
  49.     ExtURIIgnoredErrors          = "{01252117-D84E-4E92-8308-4BE1C098FCBB}"
  50.     ExtURIWebExtensions          = "{F7C9EE02-42E1-4005-9D12-6889AFFD525C}"
  51.     ExtURITimelineRefs           = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}"
  52.     ExtURIDrawingBlip            = "{28A0092B-C50C-407E-A947-70E740481C1C}"
  53.     ExtURIMacExcelMX             = "{64002731-A6B0-56B0-2670-7721B7C09600}"
  54. )

下面的常量定义了 Excel 工作表和工作簿规范与限制：

  1. const (
  2.     UnzipSizeLimit       = 1000 << 24
  3.     StreamChunkSize      = 1 << 24
  4.     MaxFontFamilyLength  = 31
  5.     MaxFontSize          = 409
  6.     MaxFileNameLength    = 207
  7.     MaxFieldLength       = 255
  8.     MaxColumnWidth       = 255
  9.     MaxRowHeight         = 409
  10.     TotalRows            = 1048576
  11.     TotalColumns         = 16384
  12.     TotalSheetHyperlinks = 65529
  13.     TotalCellChars       = 32767
  14. )

下面的常量定义了 EMU (English Metric Units) 单位：

  1. const (
  2.     EMU int = 9525
  3. )

下面的常量定义了 XML 文档中的独立声明：

  1. const XMLHeader = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n"

以下这些常量定义了当前支持的数据验证类型：

  1. const (
  2.     DataValidationTypeCustom
  3.     DataValidationTypeDate
  4.     DataValidationTypeDecimal
  5.     DataValidationTypeTextLength
  6.     DataValidationTypeTime
  7.     DataValidationTypeWhole
  8. )

以下这些常量定义了当前支持的数据验证条件：

  1. const (
  2.     DataValidationOperatorBetween
  3.     DataValidationOperatorEqual
  4.     DataValidationOperatorGreaterThan
  5.     DataValidationOperatorGreaterThanOrEqual
  6.     DataValidationOperatorLessThan
  7.     DataValidationOperatorLessThanOrEqual
  8.     DataValidationOperatorNotBetween
  9.     DataValidationOperatorNotEqual
  10. )

CellType 定义了单元格的数据类型：

  1. const (
  2.     CellTypeUnset CellType = iota
  3.     CellTypeBool
  4.     CellTypeDate
  5.     CellTypeError
  6.     CellTypeNumber
  7.     CellTypeString
  8. )