Documentation
¶
Index ¶
- Constants
- type XBgFillStyleLst
- type XBgFillStyleLstU
- type XBookViews
- type XBookViewsU
- type XBorder
- type XBorderU
- type XBorders
- type XBordersU
- type XC
- type XCalcPr
- type XCalcPrU
- type XCellStyle
- type XCellStyleU
- type XCellStyleXfs
- type XCellStyleXfsU
- type XCellStyles
- type XCellStylesU
- type XCellXfs
- type XCellXfsU
- type XClrScheme
- type XClrSchemeU
- type XCol
- type XColor
- type XColorU
- type XCols
- type XContentTypes
- type XCoreProperties
- type XCorePropertiesU
- type XDctermsElement
- type XDctermsElementU
- type XDefault
- type XDimension
- type XDxfs
- type XDxfsU
- type XEffectLst
- type XEffectLstU
- type XEffectStyle
- type XEffectStyleLst
- type XEffectStyleLstU
- type XEffectStyleU
- type XExt
- type XExtLst
- type XExtLstU
- type XExtU
- type XExtendedProperties
- type XExtendedPropertiesU
- type XExtraClrSchemeLst
- type XExtraClrSchemeLstU
- type XF
- type XFile
- type XFileVersion
- type XFileVersionU
- type XFill
- type XFillStyleLst
- type XFillStyleLstU
- type XFillU
- type XFills
- type XFillsU
- type XFmtScheme
- type XFmtSchemeU
- type XFontElement
- type XFontElementU
- type XFontScheme
- type XFontSchemeU
- type XFonts
- type XFontsU
- type XGradFill
- type XGradFillU
- type XGs
- type XGsLst
- type XGsLstU
- type XGsU
- type XLatin
- type XLatinU
- type XLin
- type XLinU
- type XLn
- type XLnStyleLst
- type XLnStyleLstU
- type XLnU
- type XMiter
- type XMiterU
- type XObjectDefaults
- type XObjectDefaultsU
- type XOuterShdw
- type XOuterShdwU
- type XOverride
- type XPageMargins
- type XPairs
- type XPairsU
- type XPatternFill
- type XPatternFillU
- type XRelationship
- type XRelationships
- type XRow
- type XSchemeClr
- type XSchemeClrU
- type XSheet
- type XSheetData
- type XSheetFormatPr
- type XSheetU
- type XSheetView
- type XSheetViews
- type XSheets
- type XSheetsU
- type XSlicerStyles
- type XSlicerStylesU
- type XSolidFill
- type XSolidFillU
- type XSrgbClr
- type XSrgbClrElement
- type XSrgbClrElementU
- type XSrgbClrU
- type XStyleSheet
- type XStyleSheetExt
- type XStyleSheetExtLst
- type XStyleSheetExtLstU
- type XStyleSheetExtU
- type XStyleSheetFont
- type XStyleSheetFontU
- type XStyleSheetU
- type XSysClr
- type XSysClrElement
- type XSysClrElementU
- type XSysClrU
- type XTableStyles
- type XTableStylesU
- type XTheme
- type XThemeElements
- type XThemeElementsU
- type XThemeFamily
- type XThemeFamilyU
- type XThemeFont
- type XThemeFontU
- type XThemeU
- type XTimelineStyles
- type XTimelineStylesU
- type XTypeface
- type XTypefaceU
- type XValAttrElement
- type XValAttrElementU
- type XVariant
- type XVariantU
- type XVector
- type XVectorU
- type XWorkBookView
- type XWorkBookViewU
- type XWorkbook
- type XWorkbookPr
- type XWorkbookPrU
- type XWorkbookU
- type XWorksheet
- type XXf
- type XXfU
Constants ¶
const ( ContentTypesPath = "" ContentTypesFileName = "[Content_Types].xml" )
ContentTypes Defines
const ( CorePropertiesContentType = "application/vnd.openxmlformats-package.core-properties+xml" CorePropertiesRelationshipType = "http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties" CorePropertiesPath = "docProps" CorePropertiesFileName = "core.xml" )
CoreProperties Defines
const ( ExtendedPropertiesContentType = "application/vnd.openxmlformats-officedocument.extended-properties+xml" ExtendedPropertiesRelationshipType = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" ExtendedPropertiesPath = "docProps" ExtendedPropertiesFileName = "app.xml" )
ExtendedProperties Defines
const ( WorkbookRelationshipsPath = "xl/_rels" WorkbookRelationshipsFileName = "workbook.xml.rels" RootRelationshipsPath = "_rels" RootRelationshipsFileName = ".rels" )
Relationships Defines
const ( StyleSheetContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml" StyleSheetRelationshipType = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" StyleSheetPath = "xl" StyleSheetFileName = "styles.xml" )
StyleSheet Defines
const ( ThemeContentType = "application/vnd.openxmlformats-officedocument.theme+xml" ThemeRelationshipType = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/theme" ThemePath = "xl" ThemeFileName = "theme/theme%d.xml" )
Theme Defines
const ( WorkbookContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" WorkbookRelationshipType = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" WorkbookPath = "xl" WorkbookFileName = "workbook.xml" )
Workbook Defines
const ( WorksheetContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" WorksheetRelationshipType = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" WorksheetPath = "xl" WorksheetFileName = "worksheets/sheet%d.xml" )
Worksheet Defines
const (
// RelationshipContentType rels ContentType
RelationshipContentType = "application/vnd.openxmlformats-package.relationships+xml"
)
const (
// XMLHeader XML Document Header
XMLHeader = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n"
)
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type XBgFillStyleLst ¶
type XBgFillStyleLst struct { SolidFill []*XSolidFill `xml:"a:solidFill"` GradFill *XGradFill `xml:"a:gradFill"` }
XBgFillStyleLst BgFillStyleLst type
type XBgFillStyleLstU ¶
type XBgFillStyleLstU struct { SolidFill []*XSolidFillU `xml:"solidFill"` GradFill *XGradFillU `xml:"gradFill"` }
XBgFillStyleLstU fix XML ns
type XBookViews ¶
type XBookViews struct {
WorkBookView []*XWorkBookView `xml:"workbookView"`
}
XBookViews BookViews type
type XBookViewsU ¶
type XBookViewsU struct {
WorkBookView []*XWorkBookViewU `xml:"workbookView"`
}
XBookViewsU fix XML ns
type XBorder ¶
type XBorder struct { Left string `xml:"left"` Right string `xml:"right"` Top string `xml:"top"` Bottom string `xml:"bottom"` Diagonal string `xml:"diagonal"` }
XBorder Border type
type XBorderU ¶
type XBorderU struct { Left string `xml:"left"` Right string `xml:"right"` Top string `xml:"top"` Bottom string `xml:"bottom"` Diagonal string `xml:"diagonal"` }
XBorderU fix XML ns for XBorder
type XC ¶
type XC struct { XMLName xml.Name R string `xml:"r,attr"` S int `xml:"s,attr,omitempty"` T string `xml:"t,attr,omitempty"` F *XF `xml:"f,omitempty"` V string `xml:"v,omitempty"` }
XC C node
type XCalcPr ¶
type XCalcPr struct {
CalcID string `xml:"calcId,attr,omitempty"`
}
XCalcPr CalcPr type
type XCalcPrU ¶
type XCalcPrU struct {
CalcID string `xml:"calcId,attr,omitempty"`
}
XCalcPrU fix XML ns
type XCellStyle ¶
type XCellStyle struct { Name string `xml:"name,attr"` XfID string `xml:"xfId,attr"` BuiltinID string `xml:"builtinId,attr"` }
XCellStyle CellStyle type
type XCellStyleU ¶
type XCellStyleU struct { Name string `xml:"name,attr"` XfID string `xml:"xfId,attr"` BuiltinID string `xml:"builtinId,attr"` }
XCellStyleU fix XML ns for XCellStyle
type XCellStyleXfs ¶
XCellStyleXfs CellStyleXfs type
type XCellStyleXfsU ¶
XCellStyleXfsU fix XML ns for XCellStyleXfs
type XCellStyles ¶
type XCellStyles struct { Count int `xml:"count,attr"` CellStyle []*XCellStyle `xml:"cellStyle"` }
XCellStyles CellStyles type
type XCellStylesU ¶
type XCellStylesU struct { Count int `xml:"count,attr"` CellStyle []*XCellStyleU `xml:"cellStyle"` }
XCellStylesU fix XML ns for XCellStyles
type XClrScheme ¶
type XClrScheme struct { Name string `xml:"name,attr"` Dk1 *XSysClrElement `xml:"a:dk1"` Lt1 *XSysClrElement `xml:"a:lt1"` Dk2 *XSrgbClrElement `xml:"a:dk2"` Lt2 *XSrgbClrElement `xml:"a:lt2"` Accent1 *XSrgbClrElement `xml:"a:accent1"` Accent2 *XSrgbClrElement `xml:"a:accent2"` Accent3 *XSrgbClrElement `xml:"a:accent3"` Accent4 *XSrgbClrElement `xml:"a:accent4"` Accent5 *XSrgbClrElement `xml:"a:accent5"` Accent6 *XSrgbClrElement `xml:"a:accent6"` Hlink *XSrgbClrElement `xml:"a:hlink"` FolHlink *XSrgbClrElement `xml:"a:folHlink"` }
XClrScheme ClrScheme type
type XClrSchemeU ¶
type XClrSchemeU struct { Name string `xml:"name,attr"` Dk1 *XSysClrElementU `xml:"dk1"` Lt1 *XSysClrElementU `xml:"lt1"` Dk2 *XSrgbClrElementU `xml:"dk2"` Lt2 *XSrgbClrElementU `xml:"lt2"` Accent1 *XSrgbClrElementU `xml:"accent1"` Accent2 *XSrgbClrElementU `xml:"accent2"` Accent3 *XSrgbClrElementU `xml:"accent3"` Accent4 *XSrgbClrElementU `xml:"accent4"` Accent5 *XSrgbClrElementU `xml:"accent5"` Accent6 *XSrgbClrElementU `xml:"accent6"` Hlink *XSrgbClrElementU `xml:"hlink"` FolHlink *XSrgbClrElementU `xml:"folHlink"` }
XClrSchemeU fix XML ns
type XCol ¶
type XCol struct { Min int `xml:"min,attr"` Max int `xml:"max,attr"` BestFit bool `xml:"bestFit,attr,omitempty"` Collapsed bool `xml:"collapsed,attr,omitempty"` CustomWidth bool `xml:"customWidth,attr,omitempty"` Hidden bool `xml:"hidden,attr,omitempty"` OutlineLevel uint8 `xml:"outlineLevel,attr,omitempty"` Phonetic bool `xml:"phonetic,attr,omitempty"` Style int `xml:"style,attr,omitempty"` Width float64 `xml:"width,attr,omitempty"` }
XCol Col node
type XColorU ¶
type XColorU struct {
Theme string `xml:"theme,attr"`
}
XColorU fix XML ns for XColor
type XContentTypes ¶
type XContentTypes struct { XMLName xml.Name `xml:"http://schemas.openxmlformats.org/package/2006/content-types Types"` Defaults []*XDefault `xml:"Default"` Overrides []*XOverride `xml:"Override"` }
XContentTypes directly maps the types element of content types for relationships
func NewXContentTypes ¶
func NewXContentTypes(worksheetRelations *XRelationships) (contentTypes *XContentTypes)
NewXContentTypes create XContentTypes from WorksheetRelations
type XCoreProperties ¶
type XCoreProperties struct { XMLName xml.Name `xml:"cp:coreProperties"` XmlnsCp string `xml:"xmlns:cp,attr"` XmlnsDc string `xml:"xmlns:dc,attr"` XmlnsDcterms string `xml:"xmlns:dcterms,attr"` XmlnsDcmitype string `xml:"xmlns:dcmitype,attr"` XmlnsXsi string `xml:"xmlns:xsi,attr"` DcCreator string `xml:"dc:creator"` CpLastModifiedBy string `xml:"cp:lastModifiedBy"` Created *XDctermsElement `xml:"dcterms:created"` Modified *XDctermsElement `xml:"dcterms:modified"` }
XCoreProperties directly maps the root element
func NewDefaultXCoreProperties ¶
func NewDefaultXCoreProperties() *XCoreProperties
NewDefaultXCoreProperties create *XCoreProperties with default template
type XCorePropertiesU ¶
type XCorePropertiesU struct { XMLName xml.Name `xml:"coreProperties"` XmlnsCp string `xml:"cp,attr"` XmlnsDc string `xml:"dc,attr"` XmlnsDcterms string `xml:"dcterms,attr"` XmlnsDcmitype string `xml:"dcmitype,attr"` XmlnsXsi string `xml:"xsi,attr"` DcCreator string `xml:"creator"` CpLastModifiedBy string `xml:"lastModifiedBy"` Created *XDctermsElementU `xml:"created"` Modified *XDctermsElementU `xml:"modified"` }
XCorePropertiesU fix XML ns for XCoreProperties
type XDctermsElement ¶
XDctermsElement document time element
type XDctermsElementU ¶
XDctermsElementU fix XML ns for XDctermsElement
type XEffectLst ¶
type XEffectLst struct {
OuterShdw *XOuterShdw `xml:"a:outerShdw"`
}
XEffectLst EffectLst type
type XEffectLstU ¶
type XEffectLstU struct {
OuterShdw *XOuterShdwU `xml:"outerShdw"`
}
XEffectLstU fix XML ns
type XEffectStyle ¶
type XEffectStyle struct {
EffectLst *XEffectLst `xml:"a:effectLst"`
}
XEffectStyle EffectStyle type
type XEffectStyleLst ¶
type XEffectStyleLst struct {
EffectStyle []*XEffectStyle `xml:"a:effectStyle"`
}
XEffectStyleLst EffectStyleLst type
type XEffectStyleLstU ¶
type XEffectStyleLstU struct {
EffectStyle []*XEffectStyleU `xml:"effectStyle"`
}
XEffectStyleLstU fix XML ns
type XEffectStyleU ¶
type XEffectStyleU struct {
EffectLst *XEffectLstU `xml:"effectLst"`
}
XEffectStyleU fix XML ns
type XExt ¶
type XExt struct { URI string `xml:"uri,attr"` ThemeFamily *XThemeFamily `xml:"thm15:themeFamily"` }
XExt Ext type
type XExtU ¶
type XExtU struct { URI string `xml:"uri,attr"` ThemeFamily *XThemeFamilyU `xml:"themeFamily"` }
XExtU fix XML ns
type XExtendedProperties ¶
type XExtendedProperties struct { XMLName xml.Name `xml:"http://schemas.openxmlformats.org/officeDocument/2006/extended-properties Properties"` XmlnsVt string `xml:"xmlns:vt,attr"` Application string `xml:"Application"` DocSecurity string `xml:"DocSecurity"` ScaleCrop string `xml:"ScaleCrop"` HeadingPairs *XPairs `xml:"HeadingPairs"` TitlesOfParts *XPairs `xml:"TitlesOfParts"` Company string `xml:"Company"` LinksUpToDate string `xml:"LinksUpToDate"` HyperlinksChanged string `xml:"HyperlinksChanged"` AppVersion string `xml:"AppVersion"` }
XExtendedProperties Document extended properties
func NewXExtendedProperties ¶
func NewXExtendedProperties(workbook *XWorkbook) (properties *XExtendedProperties)
NewXExtendedProperties create *XExtendedProperties from Workbook
type XExtendedPropertiesU ¶
type XExtendedPropertiesU struct { XMLName xml.Name `xml:"http://schemas.openxmlformats.org/officeDocument/2006/extended-properties Properties"` XmlnsVt string `xml:"vt,attr"` Application string `xml:"Application"` DocSecurity string `xml:"DocSecurity"` ScaleCrop string `xml:"ScaleCrop"` HeadingPairs *XPairsU `xml:"HeadingPairs"` TitlesOfParts *XPairsU `xml:"TitlesOfParts"` Company string `xml:"Company"` LinksUpToDate string `xml:"LinksUpToDate"` HyperlinksChanged string `xml:"HyperlinksChanged"` AppVersion string `xml:"AppVersion"` }
XExtendedPropertiesU fix XML ns for XExtendedProperties
type XExtraClrSchemeLst ¶
type XExtraClrSchemeLst struct { }
XExtraClrSchemeLst ExtraClrSchemeLst type
type XF ¶
type XF struct { Content string `xml:",chardata"` T string `xml:"t,attr,omitempty"` // Formula type Ref string `xml:"ref,attr,omitempty"` // Shared formula ref Si int `xml:"si,attr,omitempty"` // Shared formula index }
XF F node
type XFile ¶
type XFile struct { ContentTypes *XContentTypes // [Content_Types].xml Worksheets []*XWorksheet // xl/worksheets/sheet?.xml Workbook *XWorkbook // xl/workbook.xml WorkbookRelationships *XRelationships // xl/_rels/workbook.xml.rels RootRelationships *XRelationships // _rels/.rels ExtendedProperties *XExtendedProperties // docProps/app.xml CoreProperties *XCoreProperties // docProps/core.xml Themes []*XTheme // xl/theme/theme?.xml StyleSheet *XStyleSheet // xl/styles.xml }
XFile Document all Data
func NewDefaultFile ¶
func NewDefaultFile() (file *XFile)
NewDefaultFile create *XFile with default template
type XFileVersion ¶
type XFileVersion struct { AppName string `xml:"appName,attr,omitempty"` LastEdited string `xml:"lastEdited,attr,omitempty"` LowestEdited string `xml:"lowestEdited,attr,omitempty"` RupBuild string `xml:"rupBuild,attr,omitempty"` }
XFileVersion FileVersion type
type XFileVersionU ¶
type XFileVersionU struct { AppName string `xml:"appName,attr,omitempty"` LastEdited string `xml:"lastEdited,attr,omitempty"` LowestEdited string `xml:"lowestEdited,attr,omitempty"` RupBuild string `xml:"rupBuild,attr,omitempty"` }
XFileVersionU fix XML ns
type XFillStyleLst ¶
type XFillStyleLst struct { SolidFill *XSolidFill `xml:"a:solidFill"` GradFill []*XGradFill `xml:"a:gradFill"` }
XFillStyleLst FillStyleLst type
type XFillStyleLstU ¶
type XFillStyleLstU struct { SolidFill *XSolidFillU `xml:"solidFill"` GradFill []*XGradFillU `xml:"gradFill"` }
XFillStyleLstU fix XML ns
type XFillU ¶
type XFillU struct {
PatternFill *XPatternFillU `xml:"patternFill"`
}
XFillU fix XML ns for XFill
type XFmtScheme ¶
type XFmtScheme struct { Name string `xml:"name,attr"` FillStyleLst *XFillStyleLst `xml:"a:fillStyleLst"` LnStyleLst *XLnStyleLst `xml:"a:lnStyleLst"` EffectStyleLst *XEffectStyleLst `xml:"a:effectStyleLst"` BgFillStyleLst *XBgFillStyleLst `xml:"a:bgFillStyleLst"` }
XFmtScheme FmtScheme type
type XFmtSchemeU ¶
type XFmtSchemeU struct { Name string `xml:"name,attr"` FillStyleLst *XFillStyleLstU `xml:"fillStyleLst"` LnStyleLst *XLnStyleLstU `xml:"lnStyleLst"` EffectStyleLst *XEffectStyleLstU `xml:"effectStyleLst"` BgFillStyleLst *XBgFillStyleLstU `xml:"bgFillStyleLst"` }
XFmtSchemeU fix XML ns
type XFontElement ¶
type XFontElement struct { Latin *XLatin `xml:"a:latin"` Ea *XTypeface `xml:"a:ea"` Cs *XTypeface `xml:"a:cs"` Font []*XThemeFont `xml:"a:font"` }
XFontElement FontElement type
type XFontElementU ¶
type XFontElementU struct { Latin *XLatinU `xml:"latin"` Ea *XTypefaceU `xml:"ea"` Cs *XTypefaceU `xml:"cs"` Font []*XThemeFontU `xml:"font"` }
XFontElementU fix XML ns
type XFontScheme ¶
type XFontScheme struct { Name string `xml:"name,attr"` MajorFont *XFontElement `xml:"a:majorFont"` MinorFont *XFontElement `xml:"a:minorFont"` }
XFontScheme FontScheme type
type XFontSchemeU ¶
type XFontSchemeU struct { Name string `xml:"name,attr"` MajorFont *XFontElementU `xml:"majorFont"` MinorFont *XFontElementU `xml:"minorFont"` }
XFontSchemeU fix XML ns
type XFonts ¶
type XFonts struct { Count int `xml:"count,attr"` KnownFonts string `xml:"x14ac:knownFonts,attr"` Font []*XStyleSheetFont `xml:"font"` }
XFonts Fonts type
type XFontsU ¶
type XFontsU struct { Count int `xml:"count,attr"` KnownFonts string `xml:"knownFonts,attr"` Font []*XStyleSheetFontU `xml:"font"` }
XFontsU fix XML ns for XFonts
type XGradFill ¶
type XGradFill struct { RotWithShape string `xml:"rotWithShape,attr"` GsLst *XGsLst `xml:"a:gsLst"` Lin *XLin `xml:"a:lin"` }
XGradFill GradFill type
type XGradFillU ¶
type XGradFillU struct { RotWithShape string `xml:"rotWithShape,attr"` GsLst *XGsLstU `xml:"gsLst"` Lin *XLinU `xml:"lin"` }
XGradFillU fix XML ns
type XGs ¶
type XGs struct { Pos string `xml:"pos,attr"` SchemeClr *XSchemeClr `xml:"a:schemeClr"` }
XGs Gs type
type XGsU ¶
type XGsU struct { Pos string `xml:"pos,attr"` SchemeClr *XSchemeClrU `xml:"schemeClr"` }
XGsU fix XML ns
type XLn ¶
type XLn struct { W string `xml:"w,attr"` Cap string `xml:"cap,attr"` Cmpd string `xml:"cmpd,attr"` Algn string `xml:"algn,attr"` SolidFill *XSolidFill `xml:"a:solidFill"` PrstDash *XValAttrElement `xml:"a:prstDash"` Miter *XMiter `xml:"a:miter"` }
XLn Ln type
type XLnU ¶
type XLnU struct { W string `xml:"w,attr"` Cap string `xml:"cap,attr"` Cmpd string `xml:"cmpd,attr"` Algn string `xml:"algn,attr"` SolidFill *XSolidFillU `xml:"solidFill"` PrstDash *XValAttrElementU `xml:"prstDash"` Miter *XMiterU `xml:"miter"` }
XLnU fix XML ns
type XOuterShdw ¶
type XOuterShdw struct { BlurRad string `xml:"blurRad,attr"` Dist string `xml:"dist,attr"` Dir string `xml:"dir,attr"` Algn string `xml:"algn,attr"` RotWithShape string `xml:"rotWithShape,attr"` SrgbClr *XSrgbClr `xml:"a:srgbClr"` }
XOuterShdw OuterShdw type
type XOuterShdwU ¶
type XOuterShdwU struct { BlurRad string `xml:"blurRad,attr"` Dist string `xml:"dist,attr"` Dir string `xml:"dir,attr"` Algn string `xml:"algn,attr"` RotWithShape string `xml:"rotWithShape,attr"` SrgbClr *XSrgbClrU `xml:"srgbClr"` }
XOuterShdwU fix XML ns
type XPageMargins ¶
type XPageMargins struct { Left float64 `xml:"left,attr"` Right float64 `xml:"right,attr"` Top float64 `xml:"top,attr"` Bottom float64 `xml:"bottom,attr"` Header float64 `xml:"header,attr"` }
XPageMargins PageMargins node
type XPairsU ¶
type XPairsU struct {
Vector *XVectorU `xml:"vector"`
}
XPairsU fix XML ns for XPairs
type XPatternFill ¶
type XPatternFill struct {
PatternType string `xml:"patternType,attr"`
}
XPatternFill PatternFill type
type XPatternFillU ¶
type XPatternFillU struct {
PatternType string `xml:"patternType,attr"`
}
XPatternFillU fix XML ns for XPatternFill
type XRelationship ¶
type XRelationship struct { ID string `xml:"Id,attr"` Type string `xml:"Type,attr"` Target string `xml:"Target,attr"` Index int `xml:"-"` }
XRelationship Relationship type
type XRelationships ¶
type XRelationships struct { XMLName xml.Name `xml:"http://schemas.openxmlformats.org/package/2006/relationships Relationships"` Relationships []*XRelationship `xml:"Relationship"` }
XRelationships .rels XMLDocument type
func NewDefaultRootXRelationships ¶
func NewDefaultRootXRelationships() *XRelationships
NewDefaultRootXRelationships create *XRelationships with default template
func NewWorkbookXRelationships ¶
func NewWorkbookXRelationships(worksheets []*XWorksheet, themes []*XTheme) (workbookRelations *XRelationships)
NewWorkbookXRelationships create *XRelationships from Worksheets and Themes
type XRow ¶
type XRow struct { R int `xml:"r,attr"` Spans string `xml:"spans,attr,omitempty"` Hidden bool `xml:"hidden,attr,omitempty"` C []*XC `xml:"c"` Ht string `xml:"ht,attr,omitempty"` CustomHeight bool `xml:"customHeight,attr,omitempty"` OutlineLevel uint8 `xml:"outlineLevel,attr,omitempty"` }
XRow Row node
type XSchemeClr ¶
type XSchemeClr struct { Val string `xml:"val,attr"` LumMod *XValAttrElement `xml:"a:lumMod,omitempty"` SatMod *XValAttrElement `xml:"a:satMod,omitempty"` Tint *XValAttrElement `xml:"a:tint,omitempty"` Shade *XValAttrElement `xml:"a:shade,omitempty"` }
XSchemeClr SchemeClr type
type XSchemeClrU ¶
type XSchemeClrU struct { Val string `xml:"val,attr"` LumMod *XValAttrElementU `xml:"lumMod,omitempty"` SatMod *XValAttrElementU `xml:"satMod,omitempty"` Tint *XValAttrElementU `xml:"tint,omitempty"` Shade *XValAttrElementU `xml:"shade,omitempty"` }
XSchemeClrU fix XML ns
type XSheet ¶
type XSheet struct { Name string `xml:"name,attr,omitempty"` SheetID int `xml:"sheetId,attr,omitempty"` Rid string `xml:"r:id,attr,omitempty"` }
XSheet Sheet type
type XSheetData ¶
XSheetData SheetData node
type XSheetFormatPr ¶
type XSheetFormatPr struct { DefaultRowHeight float64 `xml:"defaultRowHeight,attr"` X14acDyDescent float64 `xml:"x14ac:dyDescent,attr"` }
XSheetFormatPr SheetFormatPr node
type XSheetU ¶
type XSheetU struct { Name string `xml:"name,attr,omitempty"` SheetID int `xml:"sheetId,attr,omitempty"` Rid string `xml:"id,attr,omitempty"` }
XSheetU fix XML ns
type XSheetView ¶
type XSheetView struct { TabSelected int `xml:"tabSelected,attr,omitempty"` WorkbookViewID int `xml:"workbookViewId,attr"` }
XSheetView SheetView node
type XSheetViews ¶
type XSheetViews struct {
SheetView *XSheetView `xml:"sheetView"`
}
XSheetViews SheetViews node
type XSlicerStyles ¶
type XSlicerStyles struct {
DefaultSlicerStyle string `xml:"defaultSlicerStyle,attr"`
}
XSlicerStyles SlicerStyles type
type XSlicerStylesU ¶
type XSlicerStylesU struct {
DefaultSlicerStyle string `xml:"defaultSlicerStyle,attr"`
}
XSlicerStylesU fix XML ns for XSlicerStyles
type XSolidFill ¶
type XSolidFill struct { SchemeClr *XSchemeClr `xml:"a:schemeClr"` Tint *XValAttrElement `xml:"a:tint,omitempty"` SatMod *XValAttrElement `xml:"a:satMod,omitempty"` }
XSolidFill SolidFill type
type XSolidFillU ¶
type XSolidFillU struct { SchemeClr *XSchemeClrU `xml:"schemeClr"` Tint *XValAttrElementU `xml:"tint,omitempty"` SatMod *XValAttrElementU `xml:"satMod,omitempty"` }
XSolidFillU fix XML ns
type XSrgbClr ¶
type XSrgbClr struct { Val string `xml:"val,attr"` Alpha *XValAttrElement `xml:"a:alpha,omitempty"` }
XSrgbClr SrgbClr type
type XSrgbClrElement ¶
type XSrgbClrElement struct {
SrgbClr *XSrgbClr `xml:"a:srgbClr"`
}
XSrgbClrElement SrgbClrElement type
type XSrgbClrElementU ¶
type XSrgbClrElementU struct {
SrgbClr *XSrgbClrU `xml:"srgbClr"`
}
XSrgbClrElementU fix XML ns
type XSrgbClrU ¶
type XSrgbClrU struct { Val string `xml:"val,attr"` Alpha *XValAttrElementU `xml:"alpha,omitempty"` }
XSrgbClrU fix XML ns
type XStyleSheet ¶
type XStyleSheet struct { XMLName xml.Name `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main styleSheet"` XmlnsMc string `xml:"xmlns:mc,attr"` McIgnorable string `xml:"mc:Ignorable,attr"` XmlnsX14ac string `xml:"xmlns:x14ac,attr"` XmlnsX16r2 string `xml:"xmlns:x16r2,attr"` Fonts *XFonts `xml:"fonts"` Fills *XFills `xml:"fills"` Borders *XBorders `xml:"borders"` CellStyleXfs *XCellStyleXfs `xml:"cellStyleXfs"` CellXfs *XCellXfs `xml:"cellXfs"` CellStyles *XCellStyles `xml:"cellStyles"` Dxfs *XDxfs `xml:"dxfs"` TableStyles *XTableStyles `xml:"tableStyles"` ExtLst *XStyleSheetExtLst `xml:"extLst"` }
XStyleSheet StyleSheet XML document
func NewDefaultXStyleSheet ¶
func NewDefaultXStyleSheet() *XStyleSheet
NewDefaultXStyleSheet create *XStyleSheet with default template
type XStyleSheetExt ¶
type XStyleSheetExt struct { URI string `xml:"uri,attr"` XmlnsX14 string `xml:"xmlns:x14,attr,omitempty"` XmlnsX15 string `xml:"xmlns:x15,attr,omitempty"` SlicerStyles *XSlicerStyles `xml:"x14:slicerStyles,omitempty"` TimelineStyles *XTimelineStyles `xml:"x15:timelineStyles,omitempty"` }
XStyleSheetExt StyleSheetExt type
type XStyleSheetExtLst ¶
type XStyleSheetExtLst struct {
Ext []*XStyleSheetExt `xml:"ext"`
}
XStyleSheetExtLst StyleSheetExtLst type
type XStyleSheetExtLstU ¶
type XStyleSheetExtLstU struct {
Ext []*XStyleSheetExtU `xml:"ext"`
}
XStyleSheetExtLstU fix XML ns for XStyleSheetExtLst
type XStyleSheetExtU ¶
type XStyleSheetExtU struct { URI string `xml:"uri,attr"` XmlnsX14 string `xml:"x14,attr,omitempty"` XmlnsX15 string `xml:"x15,attr,omitempty"` SlicerStyles *XSlicerStylesU `xml:"slicerStyles,omitempty"` TimelineStyles *XTimelineStylesU `xml:"timelineStyles,omitempty"` }
XStyleSheetExtU fix XML ns for XStyleSheetExt
type XStyleSheetFont ¶
type XStyleSheetFont struct { Sz *XValAttrElement `xml:"sz"` Color *XColor `xml:"color"` Name *XValAttrElement `xml:"name"` Family *XValAttrElement `xml:"family"` Scheme *XValAttrElement `xml:"scheme"` B *XValAttrElement `xml:"b,omitempty"` I *XValAttrElement `xml:"i,omitempty"` U *XValAttrElement `xml:"u,omitempty"` Strike *XValAttrElement `xml:"strike,omitempty"` }
XStyleSheetFont StyleSheetFont type
type XStyleSheetFontU ¶
type XStyleSheetFontU struct { Sz *XValAttrElementU `xml:"sz"` Color *XColorU `xml:"color"` Name *XValAttrElementU `xml:"name"` Family *XValAttrElementU `xml:"family"` Scheme *XValAttrElementU `xml:"scheme"` B *XValAttrElementU `xml:"b,omitempty"` I *XValAttrElementU `xml:"i,omitempty"` U *XValAttrElementU `xml:"u,omitempty"` Strike *XValAttrElementU `xml:"strike,omitempty"` }
XStyleSheetFontU fix XML ns for XStyleSheetFont
type XStyleSheetU ¶
type XStyleSheetU struct { XMLName xml.Name `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main styleSheet"` XmlnsMc string `xml:"mc,attr"` McIgnorable string `xml:"Ignorable,attr"` XmlnsX14ac string `xml:"x14ac,attr"` XmlnsX16r2 string `xml:"x16r2,attr"` Fonts *XFontsU `xml:"fonts"` Fills *XFillsU `xml:"fills"` Borders *XBordersU `xml:"borders"` CellStyleXfs *XCellStyleXfsU `xml:"cellStyleXfs"` CellXfs *XCellXfsU `xml:"cellXfs"` CellStyles *XCellStylesU `xml:"cellStyles"` Dxfs *XDxfsU `xml:"dxfs"` TableStyles *XTableStylesU `xml:"tableStyles"` ExtLst *XStyleSheetExtLstU `xml:"extLst"` }
XStyleSheetU fix XML ns for XStyleSheet
type XSysClrElement ¶
type XSysClrElement struct {
SysClr *XSysClr `xml:"a:sysClr"`
}
XSysClrElement SysClrElement type
type XSysClrElementU ¶
type XSysClrElementU struct {
SysClr *XSysClrU `xml:"sysClr"`
}
XSysClrElementU fix XML ns
type XTableStyles ¶
type XTableStyles struct { Count int `xml:"count,attr"` DefaultTableStyle string `xml:"defaultTableStyle,attr"` DefaultPivotStyle string `xml:"defaultPivotStyle,attr"` }
XTableStyles TableStyles type
type XTableStylesU ¶
type XTableStylesU struct { Count int `xml:"count,attr"` DefaultTableStyle string `xml:"defaultTableStyle,attr"` DefaultPivotStyle string `xml:"defaultPivotStyle,attr"` }
XTableStylesU fix XML ns for XTableStyles
type XTheme ¶
type XTheme struct { XMLName xml.Name `xml:"a:theme"` XmlnsA string `xml:"xmlns:a,attr"` Name string `xml:"name,attr"` ThemeElements *XThemeElements `xml:"a:themeElements"` ObjectDefaults *XObjectDefaults `xml:"a:objectDefaults"` ExtraClrSchemeLst *XExtraClrSchemeLst `xml:"a:extraClrSchemeLst"` ExtLst *XExtLst `xml:"a:extLst"` }
XTheme Theme XML doc
func NewDefaultXTheme ¶
func NewDefaultXTheme() *XTheme
NewDefaultXTheme create *XTheme with default template
type XThemeElements ¶
type XThemeElements struct { ClrScheme *XClrScheme `xml:"a:clrScheme"` FontScheme *XFontScheme `xml:"a:fontScheme"` FmtScheme *XFmtScheme `xml:"a:fmtScheme"` }
XThemeElements ThemeElements type
type XThemeElementsU ¶
type XThemeElementsU struct { ClrScheme *XClrSchemeU `xml:"clrScheme"` FontScheme *XFontSchemeU `xml:"fontScheme"` FmtScheme *XFmtSchemeU `xml:"fmtScheme"` }
XThemeElementsU fix XML ns
type XThemeFamily ¶
type XThemeFamily struct { XmlnsThm15 string `xml:"xmlns:thm15,attr"` Name string `xml:"name,attr"` ID string `xml:"id,attr"` Vid string `xml:"vid,attr"` }
XThemeFamily ThemeFamily type
type XThemeFamilyU ¶
type XThemeFamilyU struct { XmlnsThm15 string `xml:"thm15,attr"` Name string `xml:"name,attr"` ID string `xml:"id,attr"` Vid string `xml:"vid,attr"` }
XThemeFamilyU fix XML ns
type XThemeFont ¶
XThemeFont ThemeFont type
type XThemeFontU ¶
XThemeFontU fix XML ns
type XThemeU ¶
type XThemeU struct { XMLName xml.Name `xml:"theme"` XmlnsA string `xml:"a,attr"` Name string `xml:"name,attr"` ThemeElements *XThemeElementsU `xml:"themeElements"` ObjectDefaults *XObjectDefaultsU `xml:"objectDefaults"` ExtraClrSchemeLst *XExtraClrSchemeLstU `xml:"extraClrSchemeLst"` ExtLst *XExtLstU `xml:"extLst"` }
XThemeU fix XML ns
type XTimelineStyles ¶
type XTimelineStyles struct {
DefaultTimelineStyle string `xml:"defaultTimelineStyle,attr"`
}
XTimelineStyles TimelineStyles type
type XTimelineStylesU ¶
type XTimelineStylesU struct {
DefaultTimelineStyle string `xml:"defaultTimelineStyle,attr"`
}
XTimelineStylesU fix XML ns for XTimelineStyles
type XTypeface ¶
type XTypeface struct {
Typeface string `xml:"typeface,attr"`
}
XTypeface Typeface type
type XTypefaceU ¶
type XTypefaceU struct {
Typeface string `xml:"typeface,attr"`
}
XTypefaceU fix XML ns
type XValAttrElement ¶
type XValAttrElement struct {
Val string `xml:"val,attr"`
}
XValAttrElement Val type
type XValAttrElementU ¶
type XValAttrElementU struct {
Val string `xml:"val,attr"`
}
XValAttrElementU fix XML ns
type XVector ¶
type XVector struct { Size int `xml:"size,attr"` BaseType string `xml:"baseType,attr"` Lpstr []string `xml:"vt:lpstr,omitempty"` Variant []*XVariant `xml:"vt:variant,omitempty"` }
XVector Vector Type
type XVectorU ¶
type XVectorU struct { Size int `xml:"size,attr"` BaseType string `xml:"baseType,attr"` Lpstr []string `xml:"lpstr,omitempty"` Variant []*XVariantU `xml:"variant,omitempty"` }
XVectorU fix XML ns for XVector
type XWorkBookView ¶
type XWorkBookView struct { XWindow string `xml:"xWindow,attr,omitempty"` YWindow string `xml:"yWindow,attr,omitempty"` WindowWidth int `xml:"windowWidth,attr,omitempty"` WindowHeight int `xml:"windowHeight,attr,omitempty"` }
XWorkBookView WorkBookView type
type XWorkBookViewU ¶
type XWorkBookViewU struct { XWindow string `xml:"xWindow,attr,omitempty"` YWindow string `xml:"yWindow,attr,omitempty"` WindowWidth int `xml:"windowWidth,attr,omitempty"` WindowHeight int `xml:"windowHeight,attr,omitempty"` }
XWorkBookViewU fix XML ns
type XWorkbook ¶
type XWorkbook struct { XMLName xml.Name `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main workbook"` XmlnsR string `xml:"xmlns:r,attr"` XmlnsMC string `xml:"xmlns:mc,attr"` McIgnorable string `xml:"mc:Ignorable,attr"` XmlnsX15 string `xml:"xmlns:x15,attr"` FileVersion *XFileVersion `xml:"fileVersion"` WorkbookPr *XWorkbookPr `xml:"workbookPr"` BookViews *XBookViews `xml:"bookViews"` Sheets *XSheets `xml:"sheets"` CalcPr *XCalcPr `xml:"calcPr"` }
XWorkbook Workbook XML struct
func NewXWorkbook ¶
func NewXWorkbook(worksheetRelations *XRelationships) (workbook *XWorkbook)
NewXWorkbook create *XWorkbook from WorksheetRelationships
type XWorkbookPr ¶
type XWorkbookPr struct {
DefaultThemeVersion string `xml:"defaultThemeVersion,attr,omitempty"`
}
XWorkbookPr WorkbookPr type
type XWorkbookPrU ¶
type XWorkbookPrU struct {
DefaultThemeVersion string `xml:"defaultThemeVersion,attr,omitempty"`
}
XWorkbookPrU fix XML ns
type XWorkbookU ¶
type XWorkbookU struct { XMLName xml.Name `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main workbook"` XmlnsR string `xml:"r,attr"` XmlnsMC string `xml:"mc,attr"` McIgnorable string `xml:"Ignorable,attr"` XmlnsX15 string `xml:"x15,attr"` FileVersion *XFileVersionU `xml:"fileVersion"` WorkbookPr *XWorkbookPrU `xml:"workbookPr"` BookViews *XBookViewsU `xml:"bookViews"` Sheets *XSheetsU `xml:"sheets"` CalcPr *XCalcPrU `xml:"calcPr"` }
XWorkbookU fix XML ns
type XWorksheet ¶
type XWorksheet struct { XMLName xml.Name `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main worksheet"` XmlnsR string `xml:"xmlns:r,attr"` XmlnsMc string `xml:"xmlns:mc,attr"` XmlnsX14ac string `xml:"xmlns:x14ac,attr"` McIgnorable string `xml:"mc:Ignorable,attr"` Dimension *XDimension `xml:"dimension"` SheetViews *XSheetViews `xml:"sheetViews"` SheetFormatPr *XSheetFormatPr `xml:"sheetFormatPr"` Cols *XCols `xml:"cols,omitempty"` SheetData *XSheetData `xml:"sheetData"` PageMargins *XPageMargins `xml:"pageMargins"` }
XWorksheet Worksheet XML doc
func NewDefaultXWorksheet ¶
func NewDefaultXWorksheet() *XWorksheet
NewDefaultXWorksheet create *XWorksheet with default template