常量

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

  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. NameSpaceDublinCoreMetadataIntiative="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. )

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

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

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

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

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

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

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

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