packaging

package
v1.0.0 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Mar 12, 2021 License: BSD-2-Clause Imports: 3 Imported by: 0

Documentation

Index

Constants

View Source
const (
	ContentTypesPath     = ""
	ContentTypesFileName = "[Content_Types].xml"
)

ContentTypes Defines

View Source
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

View Source
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

View Source
const (
	WorkbookRelationshipsPath     = "xl/_rels"
	WorkbookRelationshipsFileName = "workbook.xml.rels"

	RootRelationshipsPath     = "_rels"
	RootRelationshipsFileName = ".rels"
)

Relationships Defines

View Source
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

View Source
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

View Source
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

View Source
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

View Source
const (
	// RelationshipContentType rels ContentType
	RelationshipContentType = "application/vnd.openxmlformats-package.relationships+xml"
)
View Source
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 XBorders

type XBorders struct {
	Count int `xml:"count,attr"`

	Border []*XBorder `xml:"border"`
}

XBorders Borders type

type XBordersU

type XBordersU struct {
	Count int `xml:"count,attr"`

	Border []*XBorderU `xml:"border"`
}

XBordersU fix XML ns for XBorders

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

type XCellStyleXfs struct {
	Count int `xml:"count,attr"`

	Xf []*XXf `xml:"xf"`
}

XCellStyleXfs CellStyleXfs type

type XCellStyleXfsU

type XCellStyleXfsU struct {
	Count int `xml:"count,attr"`

	Xf []*XXfU `xml:"xf"`
}

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 XCellXfs

type XCellXfs struct {
	Count int `xml:"count,attr"`

	Xf []*XXf `xml:"xf"`
}

XCellXfs CellXfs type

type XCellXfsU

type XCellXfsU struct {
	Count int `xml:"count,attr"`

	Xf []*XXfU `xml:"xf"`
}

XCellXfsU fix XML ns for XCellXfs

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 XColor

type XColor struct {
	Theme string `xml:"theme,attr"`
}

XColor Color type

type XColorU

type XColorU struct {
	Theme string `xml:"theme,attr"`
}

XColorU fix XML ns for XColor

type XCols

type XCols struct {
	Col []*XCol `xml:"col"`
}

XCols Cols node

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

type XDctermsElement struct {
	Text string `xml:",chardata"`
	Type string `xml:"xsi:type,attr"`
}

XDctermsElement document time element

type XDctermsElementU

type XDctermsElementU struct {
	Text string `xml:",chardata"`
	Type string `xml:"type,attr"`
}

XDctermsElementU fix XML ns for XDctermsElement

type XDefault

type XDefault struct {
	Extension   string `xml:",attr"`
	ContentType string `xml:",attr"`
}

XDefault directly maps the override element in the namespace

type XDimension

type XDimension struct {
	Ref string `xml:"ref,attr"`
}

XDimension Dimension node

type XDxfs

type XDxfs struct {
	Count int `xml:"count,attr"`
}

XDxfs Dxfs type

type XDxfsU

type XDxfsU struct {
	Count int `xml:"count,attr"`
}

XDxfsU fix XML ns for XDxfs

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 XExtLst

type XExtLst struct {
	Ext *XExt `xml:"a:ext"`
}

XExtLst ExtLst type

type XExtLstU

type XExtLstU struct {
	Ext *XExtU `xml:"ext"`
}

XExtLstU fix XML ns

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"`
	SharedDoc         string  `xml:"SharedDoc"`
	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"`
	SharedDoc         string   `xml:"SharedDoc"`
	HyperlinksChanged string   `xml:"HyperlinksChanged"`
	AppVersion        string   `xml:"AppVersion"`
}

XExtendedPropertiesU fix XML ns for XExtendedProperties

type XExtraClrSchemeLst

type XExtraClrSchemeLst struct {
}

XExtraClrSchemeLst ExtraClrSchemeLst type

type XExtraClrSchemeLstU

type XExtraClrSchemeLstU struct {
}

XExtraClrSchemeLstU fix XML ns

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 XFill

type XFill struct {
	PatternFill *XPatternFill `xml:"patternFill"`
}

XFill Fill type

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 XFills

type XFills struct {
	Count int `xml:"count,attr"`

	Fill []*XFill `xml:"fill"`
}

XFills Fills type

type XFillsU

type XFillsU struct {
	Count int `xml:"count,attr"`

	Fill []*XFillU `xml:"fill"`
}

XFillsU fix XML ns for XFills

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 XGsLst

type XGsLst struct {
	Gs []*XGs `xml:"a:gs"`
}

XGsLst GsLst type

type XGsLstU

type XGsLstU struct {
	Gs []*XGsU `xml:"gs"`
}

XGsLstU fix XML ns

type XGsU

type XGsU struct {
	Pos       string       `xml:"pos,attr"`
	SchemeClr *XSchemeClrU `xml:"schemeClr"`
}

XGsU fix XML ns

type XLatin

type XLatin struct {
	Typeface string `xml:"typeface,attr"`
	Panose   string `xml:"panose,attr"`
}

XLatin Latin type

type XLatinU

type XLatinU struct {
	Typeface string `xml:"typeface,attr"`
	Panose   string `xml:"panose,attr"`
}

XLatinU fix XML ns

type XLin

type XLin struct {
	Ang    string `xml:"ang,attr"`
	Scaled string `xml:"scaled,attr"`
}

XLin Lin type

type XLinU

type XLinU struct {
	Ang    string `xml:"ang,attr"`
	Scaled string `xml:"scaled,attr"`
}

XLinU 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 XLnStyleLst

type XLnStyleLst struct {
	Ln []*XLn `xml:"a:ln"`
}

XLnStyleLst LnStyleLst type

type XLnStyleLstU

type XLnStyleLstU struct {
	Ln []*XLnU `xml:"ln"`
}

XLnStyleLstU fix XML ns

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 XMiter

type XMiter struct {
	Lim string `xml:"lim,attr"`
}

XMiter Miter type

type XMiterU

type XMiterU struct {
	Lim string `xml:"lim,attr"`
}

XMiterU fix XML ns

type XObjectDefaults

type XObjectDefaults struct {
}

XObjectDefaults ObjectDefaults type

type XObjectDefaultsU

type XObjectDefaultsU struct {
}

XObjectDefaultsU 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 XOverride

type XOverride struct {
	PartName    string `xml:",attr"`
	ContentType string `xml:",attr"`
}

XOverride directly maps the default element in the namespace

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"`
	Footer float64 `xml:"footer,attr"`
}

XPageMargins PageMargins node

type XPairs

type XPairs struct {
	Vector *XVector `xml:"vt:vector"`
}

XPairs Pairs Type

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

type XSheetData struct {
	XMLName xml.Name `xml:"sheetData"`
	Row     []*XRow  `xml:"row"`
}

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 XSheets

type XSheets struct {
	Sheet []*XSheet `xml:"sheet"`
}

XSheets Sheets type

type XSheetsU

type XSheetsU struct {
	Sheet []*XSheetU `xml:"sheet"`
}

XSheetsU fix XML ns

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 XSysClr

type XSysClr struct {
	Val     string `xml:"val,attr"`
	LastClr string `xml:"lastClr,attr"`
}

XSysClr SysClr type

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 XSysClrU

type XSysClrU struct {
	Val     string `xml:"val,attr"`
	LastClr string `xml:"lastClr,attr"`
}

XSysClrU 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

type XThemeFont struct {
	Script   string `xml:"script,attr"`
	Typeface string `xml:"typeface,attr"`
}

XThemeFont ThemeFont type

type XThemeFontU

type XThemeFontU struct {
	Script   string `xml:"script,attr"`
	Typeface string `xml:"typeface,attr"`
}

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 XVariant

type XVariant struct {
	Lpstr string `xml:"vt:lpstr,omitempty"`
	I4    int32  `xml:"vt:i4,omitempty"`
}

XVariant Variant Type

type XVariantU

type XVariantU struct {
	Lpstr string `xml:"lpstr,omitempty"`
	I4    int32  `xml:"i4,omitempty"`
}

XVariantU fix XML ns for XVariant

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

type XXf

type XXf struct {
	NumFmtID string `xml:"numFmtId,attr"`
	FontID   string `xml:"fontId,attr"`
	FillID   string `xml:"fillId,attr"`
	BorderID string `xml:"borderId,attr"`
	XfID     string `xml:"xfId,attr,omitempty"`
}

XXf Xf type

type XXfU

type XXfU struct {
	NumFmtID string `xml:"numFmtId,attr"`
	FontID   string `xml:"fontId,attr"`
	FillID   string `xml:"fillId,attr"`
	BorderID string `xml:"borderId,attr"`
	XfID     string `xml:"xfId,attr,omitempty"`
}

XXfU fix XML ns for XXf

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
JackTT - Gopher 🇻🇳