常量

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

    1. SourceRelationship = "http://schemas.openxmlformats.org/officeDocument/2006/relationships"
    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. SourceRelationshipPivotTable = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotTable"
    11. SourceRelationshipPivotCache = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotCacheDefinition"
    12. SourceRelationshipVBAProject = "http://schemas.microsoft.com/office/2006/relationships/vbaProject"
    13. SourceRelationshipChart201506 = "http://schemas.microsoft.com/office/drawing/2015/06/chart"
    14. SourceRelationshipChart20070802 = "http://schemas.microsoft.com/office/drawing/2007/8/2/chart"
    15. SourceRelationshipChart2014 = "http://schemas.microsoft.com/office/drawing/2014/chart"
    16. SourceRelationshipCompatibility = "http://schemas.openxmlformats.org/markup-compatibility/2006"
    17. NameSpaceDrawingML = "http://schemas.openxmlformats.org/drawingml/2006/main"
    18. NameSpaceDrawingMLChart = "http://schemas.openxmlformats.org/drawingml/2006/chart"
    19. NameSpaceDrawingMLSpreadSheet = "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"
    20. NameSpaceSpreadSheetX15 = "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"
    21. NameSpaceSpreadSheetExcel2006Main = "http://schemas.microsoft.com/office/excel/2006/main"
    22. NameSpaceMacExcel2008Main = "http://schemas.microsoft.com/office/mac/excel/2008/main"
    23. NameSpaceXML = "http://www.w3.org/XML/1998/namespace"
    24. NameSpaceXMLSchemaInstance = "http://www.w3.org/2001/XMLSchema-instance"
    25. StrictSourceRelationship = "http://purl.oclc.org/ooxml/officeDocument/relationships"
    26. StrictSourceRelationshipChart = "http://purl.oclc.org/ooxml/officeDocument/relationships/chart"
    27. StrictSourceRelationshipComments = "http://purl.oclc.org/ooxml/officeDocument/relationships/comments"
    28. StrictSourceRelationshipImage = "http://purl.oclc.org/ooxml/officeDocument/relationships/image"
    29. StrictNameSpaceSpreadSheet = "http://purl.oclc.org/ooxml/spreadsheetml/main"
    30. NameSpaceDublinCore = "http://purl.org/dc/elements/1.1/"
    31. NameSpaceDublinCoreTerms = "http://purl.org/dc/terms/"
    32. NameSpaceDublinCoreMetadataIntiative = "http://purl.org/dc/dcmitype/"
    33. // The extLst child element ([ISO/IEC29500-1:2016] section 18.2.10) of the
    34. // worksheet element ([ISO/IEC29500-1:2016] section 18.3.1.99) is extended by
    35. // the addition of new child ext elements ([ISO/IEC29500-1:2016] section
    36. // 18.2.7)
    37. ExtURIConditionalFormattings = "{78C0D931-6437-407D-A8EE-F0AAD7539E65}"
    38. ExtURIDataValidations = "{CCE6A557-97BC-4B89-ADB6-D9C93CAAB3DF}"
    39. ExtURISlicerCachesListX14 = "{BBE1A952-AA13-448e-AADC-164F8A28A991}"
    40. ExtURISlicerListX15 = "{3A4CF648-6AED-40f4-86FF-DC5316D8AED3}"
    41. ExtURIProtectedRanges = "{FC87AEE6-9EDD-4A0A-B7FB-166176984837}"
    42. ExtURIIgnoredErrors = "{01252117-D84E-4E92-8308-4BE1C098FCBB}"
    43. ExtURIWebExtensions = "{F7C9EE02-42E1-4005-9D12-6889AFFD525C}"
    44. ExtURITimelineRefs = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}"
    45. ExtURIDrawingBlip = "{28A0092B-C50C-407E-A947-70E740481C1C}"
    46. ExtURIMacExcelMX = "{64002731-A6B0-56B0-2670-7721B7C09600}"
    47. )

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

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

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

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