ml

package
v1.0.4 Latest Latest
Warning

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

 Go to latest Published: Nov 2, 2019 License: MIT Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AutoFilter 

type AutoFilter struct {
	FilterColumn *[]*FilterColumn  `xml:"filterColumn,omitempty"`
	SortState    *ml.Reserved      `xml:"sortState,omitempty"`
	ExtLst       *ml.Reserved      `xml:"extLst,omitempty"`
	Bounds       primitives.Bounds `xml:"ref,attr"`
}

AutoFilter is direct mapping of XSD CT_AutoFilter

func (*AutoFilter) MarshalXML 

func (r *AutoFilter) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal AutoFilter

type BookView 

type BookView struct {
	ExtLst                 *ml.Reserved              `xml:"extLst,omitempty"`
	Visibility             primitives.VisibilityType `xml:"visibility,attr,omitempty"`
	Minimized              bool                      `xml:"minimized,attr,omitempty"`
	ShowHorizontalScroll   bool                      `xml:"showHorizontalScroll,attr,omitempty"`
	ShowVerticalScroll     bool                      `xml:"showVerticalScroll,attr,omitempty"`
	ShowSheetTabs          bool                      `xml:"showSheetTabs,attr,omitempty"`
	AutoFilterDateGrouping bool                      `xml:"autoFilterDateGrouping,attr,omitempty"`
	XWindow                int                       `xml:"xWindow,attr,omitempty"`
	YWindow                int                       `xml:"yWindow,attr,omitempty"`
	WindowHeight           uint                      `xml:"windowHeight,attr,omitempty"`
	WindowWidth            uint                      `xml:"windowWidth,attr,omitempty"`
	TabRatio               uint                      `xml:"tabRatio,attr,omitempty"`
	FirstSheet             uint                      `xml:"firstSheet,attr,omitempty"`
	ActiveTab              int                       `xml:"activeTab,attr,omitempty"`
}

BookView is a direct mapping of XSD CT_BookView

type BookViewList 

type BookViewList struct {
	Items []*BookView `xml:"workbookView,omitempty"`
}

BookViewList is a direct mapping of XSD CT_BookViews

func (*BookViewList) MarshalXML 

func (r *BookViewList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal BookViewList

type Border 

type Border struct {
	Left         *BorderSegment `xml:"left,omitempty"`  //WTF at ECMA-376 Edition 2/3/4/5, there is 'start', but no 'left'?!?!
	Right        *BorderSegment `xml:"right,omitempty"` //WTF at ECMA-376 Edition 2/3/4/5, there is 'end', but no 'right'?!?!
	Top          *BorderSegment `xml:"top,omitempty"`
	Bottom       *BorderSegment `xml:"bottom,omitempty"`
	Diagonal     *BorderSegment `xml:"diagonal,omitempty"`
	Vertical     *BorderSegment `xml:"vertical,omitempty"`
	Horizontal   *BorderSegment `xml:"horizontal,omitempty"`
	DiagonalUp   bool           `xml:"diagonalUp,attr,omitempty"`
	DiagonalDown bool           `xml:"diagonalDown,attr,omitempty"`
	Outline      bool           `xml:"outline,attr,omitempty"`
}

Border is a direct mapping of XSD CT_Border

func (*Border) Hash 

func (border *Border) Hash() index.Code

Hash builds hash code for all required values of Border to use as unique index

type BorderList 

type BorderList struct {
	Count int       `xml:"count,attr"`
	Items []*Border `xml:"border,omitempty"`
}

BorderList is a direct mapping of XSD CT_Borders

func (*BorderList) MarshalXML 

func (r *BorderList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal BorderList

type BorderSegment 

type BorderSegment struct {
	Color *Color                     `xml:"color,omitempty"`
	Type  primitives.BorderStyleType `xml:"style,attr,omitempty"`
}

BorderSegment is a direct mapping of XSD CT_BorderPr

type Cell 

type Cell struct {
	Formula   *CellFormula        `xml:"f,omitempty"`
	Value     string              `xml:"v,omitempty"`
	InlineStr *StringItem         `xml:"is,omitempty"`
	ExtLst    *ml.Reserved        `xml:"extLst,omitempty"`
	Ref       primitives.CellRef  `xml:"r,attr"`
	Style     DirectStyleID       `xml:"s,attr,omitempty"`
	Ph        bool                `xml:"ph,attr,omitempty"`
	Type      primitives.CellType `xml:"t,attr,omitempty"`
	Cm        ml.OptionalIndex    `xml:"cm,attr,omitempty"`
	Vm        ml.OptionalIndex    `xml:"vm,attr,omitempty"`
}

Cell is a direct mapping of XSD CT_Cell

type CellAlignment 

type CellAlignment struct {
	Horizontal      primitives.HAlignType `xml:"horizontal,attr,omitempty"`
	Vertical        primitives.VAlignType `xml:"vertical,attr,omitempty"`
	WrapText        bool                  `xml:"wrapText,attr,omitempty"`
	JustifyLastLine bool                  `xml:"justifyLastLine,attr,omitempty"`
	ShrinkToFit     bool                  `xml:"shrinkToFit,attr,omitempty"`
	TextRotation    int                   `xml:"textRotation,attr,omitempty"`
	Indent          int                   `xml:"indent,attr,omitempty"`
	RelativeIndent  int                   `xml:"relativeIndent,attr,omitempty"`
	ReadingOrder    int                   `xml:"readingOrder,attr,omitempty"`
}

CellAlignment is a direct mapping of XSD CT_CellAlignment

func (*CellAlignment) Hash 

func (a *CellAlignment) Hash() index.Code

Hash builds hash code for all required values of CellAlignment to use as unique index

type CellFormula 

type CellFormula struct {
	Aca     bool                       `xml:"aca,attr,omitempty"`
	Dt2D    bool                       `xml:"dt2D,attr,omitempty"`
	Dtr     bool                       `xml:"dtr,attr,omitempty"`
	Del1    bool                       `xml:"del1,attr,omitempty"`
	Del2    bool                       `xml:"del2,attr,omitempty"`
	Ca      bool                       `xml:"ca,attr,omitempty"`
	Bx      bool                       `xml:"bx,attr,omitempty"`
	T       primitives.CellFormulaType `xml:"t,attr,omitempty"` //default 'normal'
	Bounds  primitives.Bounds          `xml:"ref,attr,omitempty"`
	Content string                     `xml:",chardata"`
	R1      primitives.CellRef         `xml:"r1,attr,omitempty"`
	R2      primitives.CellRef         `xml:"r2,attr,omitempty"`
	Si      ml.OptionalIndex           `xml:"si,attr,omitempty"`
}

CellFormula is a direct mapping of XSD CT_CellFormula

type CellProtection 

type CellProtection struct {
	Locked bool `xml:"locked,attr,omitempty"`
	Hidden bool `xml:"hidden,attr,omitempty"`
}

CellProtection is a direct mapping of XSD CT_CellProtection

func (*CellProtection) Hash 

func (p *CellProtection) Hash() index.Code

Hash builds hash code for all required values of CellProtection to use as unique index

type ClientData 

type ClientData struct {
	XMLName       xml.Name `xml:"x:ClientData"`
	MoveWithCells bool     `xml:"x:MoveWithCells,omitempty"`
	SizeWithCells bool     `xml:"x:SizeWithCells,omitempty"`
	AutoFill      bool     `xml:"x:AutoFill,omitempty"`
	Type          string   `xml:"ObjectType,attr"`
	Anchor        string   `xml:"x:Anchor,omitempty"`
	Row           int      `xml:"x:Row"`
	Column        int      `xml:"x:Column"`
}

ClientData is direct mapping for CT_ClientData, that used for Excel specific settings of Shape

type Col 

type Col struct {
	Min          int           `xml:"min,attr"`
	Max          int           `xml:"max,attr"`
	Width        float32       `xml:"width,attr,omitempty"`
	Style        DirectStyleID `xml:"style,attr,omitempty"`
	Hidden       bool          `xml:"hidden,attr,omitempty"`
	BestFit      bool          `xml:"bestFit,attr,omitempty"`
	CustomWidth  bool          `xml:"customWidth,attr,omitempty"`
	Phonetic     bool          `xml:"phonetic,attr,omitempty"`
	OutlineLevel uint8         `xml:"outlineLevel,attr,omitempty"`
	Collapsed    bool          `xml:"collapsed,attr,omitempty"`
}

Col is a direct mapping of XSD CT_Col

type ColList 

type ColList struct {
	Items []*Col `xml:"col,omitempty"`
}

ColList is a direct mapping of XSD CT_Cols

func (*ColList) MarshalXML 

func (cols *ColList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal ColList

type Color 

type Color struct {
	Auto    bool    `xml:"auto,attr,omitempty"`
	RGB     string  `xml:"rgb,attr,omitempty"`
	Tint    float64 `xml:"tint,attr,omitempty"` //default 0.0
	Indexed *int    `xml:"indexed,attr,omitempty"`
	Theme   *int    `xml:"theme,attr,omitempty"`
}

Color is a direct mapping of XSD CT_Color

func (*Color) Hash 

func (c *Color) Hash() index.Code

Hash builds hash code for all required values of Color to use as unique index

type ColorScale 

type ColorScale struct {
	Values []*ConditionValue `xml:"cfvo"`  //minimum 2 values
	Colors []*Color          `xml:"color"` //minimum 2 values
}

ColorScale is a direct mapping of XSD CT_ColorScale

type Comment 

type Comment struct {
	Text     *StringItem       `xml:"text"`
	Options  *CommentOptions   `xml:"commentPr,omitempty"`
	Ref      primitives.Bounds `xml:"ref,attr"`
	AuthorID int               `xml:"authorId,attr"`
	Guid     GUID              `xml:"guid,attr,omitempty"`
	ShapeID  ml.OptionalIndex  `xml:"shapeId,attr,omitempty"`
}

Comment is a direct mapping of XSD CT_Comment

type CommentOptions 

type CommentOptions struct {
	Anchor      *ml.Reserved `xml:"anchor"`
	Locked      *bool        `xml:"locked,attr,omitempty"`
	DefaultSize *bool        `xml:"defaultSize,attr,omitempty"`
	Print       *bool        `xml:"print,attr,omitempty"`
	Disabled    bool         `xml:"disabled,attr,omitempty"`
	JustLastX   bool         `xml:"justLastX,attr,omitempty"`
	AutoScale   bool         `xml:"autoScale,attr,omitempty"`
	AutoFill    *bool        `xml:"autoFill,attr,omitempty"`
	AutoLine    *bool        `xml:"autoLine,attr,omitempty"`
	AltText     string       `xml:"altText,attr,omitempty"`
	TextHAlign  *ml.Reserved `xml:"textHAlign,attr,omitempty"`
	TextVAlign  *ml.Reserved `xml:"textVAlign,attr,omitempty"`
	LockText    *bool        `xml:"lockText,attr,omitempty"`
}

CommentOptions is a direct mapping of CT_CommentPr

type Comments 

type Comments struct {
	XMLName     xml.Name          `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main comments"`
	Authors     []primitives.Text `xml:"authors>author"`
	CommentList []*Comment        `xml:"commentList>comment"`
	ExtLst      *ml.Reserved      `xml:"extLst,omitempty"`
}

Comments is a direct mapping of XSD CT_Comments

type ConditionValue 

type ConditionValue struct {
	ExtLst           *ml.Reserved                  `xml:"extLst,omitempty"`
	Type             primitives.ConditionValueType `xml:"type,attr"`
	Value            string                        `xml:"val,attr,omitempty"`
	GreaterThanEqual *bool                         `xml:"gte,attr,omitempty"`
}

ConditionValue is a direct mapping of XSD CT_Cfvo

type ConditionalFormatting 

type ConditionalFormatting struct {
	Pivot  bool                  `xml:"pivot,attr,omitempty"`
	Bounds primitives.BoundsList `xml:"sqref,attr"`
	Rules  []*ConditionalRule    `xml:"cfRule"`
	ExtLst *ml.Reserved          `xml:"extLst,omitempty"`
}

ConditionalFormatting is a direct mapping of XSD CT_ConditionalFormatting

type ConditionalRule 

type ConditionalRule struct {
	Formula      []Formula                        `xml:"formula,omitempty"`
	ColorScale   *ColorScale                      `xml:"colorScale,omitempty"`
	DataBar      *DataBar                         `xml:"dataBar,omitempty"`
	IconSet      *IconSet                         `xml:"iconSet,omitempty"`
	ExtLst       *ml.Reserved                     `xml:"extLst,omitempty"`
	Type         primitives.ConditionType         `xml:"type,attr"`
	Operator     primitives.ConditionOperatorType `xml:"operator,attr,omitempty"`
	TimePeriod   primitives.TimePeriodType        `xml:"timePeriod,attr,omitempty"`
	StopIfTrue   bool                             `xml:"stopIfTrue,attr,omitempty"`
	Percent      bool                             `xml:"percent,attr,omitempty"`
	Bottom       bool                             `xml:"bottom,attr,omitempty"`
	EqualAverage bool                             `xml:"equalAverage,attr,omitempty"`
	Priority     int                              `xml:"priority,attr"`
	Style        *DiffStyleID                     `xml:"dxfId,attr,omitempty"`
	AboveAverage *bool                            `xml:"aboveAverage,attr,omitempty"`
	Text         string                           `xml:"text,attr,omitempty"`
	Rank         uint                             `xml:"rank,attr,omitempty"`
	StdDev       int                              `xml:"stdDev,attr,omitempty"`
}

ConditionalRule is a direct mapping of XSD CT_CfRule

type DataBar 

type DataBar struct {
	Values    []*ConditionValue `xml:"cfvo"` //2 values only
	Color     *Color            `xml:"color"`
	MinLength uint              `xml:"minLength,attr,omitempty"`
	MaxLength uint              `xml:"maxLength,attr,omitempty"`
	ShowValue *bool             `xml:"showValue,attr,omitempty"`
}

DataBar is a direct mapping of XSD CT_DataBar

type DiffStyle 

type DiffStyle struct {
	NumberFormat *NumberFormat   `xml:"numFmt,omitempty"`
	Font         *Font           `xml:"font,omitempty"`
	Fill         *Fill           `xml:"fill,omitempty"`
	Border       *Border         `xml:"border,omitempty"`
	Alignment    *CellAlignment  `xml:"alignment,omitempty"`
	Protection   *CellProtection `xml:"protection,omitempty"`
	ExtLst       *ml.Reserved    `xml:"extLst,omitempty"`
}

DiffStyle is a direct mapping of XSD CT_Dxf

func (*DiffStyle) Hash 

func (ds *DiffStyle) Hash() index.Code

Hash builds hash code for all required values of DiffStyle to use as unique index

type DiffStyleID 

type DiffStyleID int

DiffStyleID is helper alias type for ID of CT_Dxf to make it easier to read/understand markup files

type DiffStyleList 

type DiffStyleList struct {
	Count int          `xml:"count,attr"`
	Items []*DiffStyle `xml:"dxf,omitempty"`
}

DiffStyleList is a direct mapping of XSD CT_Dxfs

func (*DiffStyleList) MarshalXML 

func (r *DiffStyleList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal DiffStyleList

type DirectStyle 

type DirectStyle struct {
	Style
	XfId NamedStyleID `xml:"xfId,attr"`
}

DirectStyle is helper alias type for cellXfs->xf of XSD CT_Xf to make it easier to read/understand markup files

func (*DirectStyle) Hash 

func (ds *DirectStyle) Hash() index.Code

Hash builds hash code for all required values of DirectStyle to use as unique index

type DirectStyleID 

type DirectStyleID int

DirectStyleID is helper alias type for ID of CT_Xf to make it easier to read/understand markup files

type DirectStyleList 

type DirectStyleList struct {
	Count int            `xml:"count,attr"`
	Items []*DirectStyle `xml:"xf,omitempty"`
}

DirectStyleList is a direct mapping of XSD CT_CellXfs

func (*DirectStyleList) MarshalXML 

func (r *DirectStyleList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal DirectStyleList

type ExternalReference 

type ExternalReference struct {
	RID ml.RID `xml:"id,attr,omitempty"`
}

ExternalReference is a direct mapping of XSD CT_ExternalReference

type ExternalReferenceList 

type ExternalReferenceList struct {
	Items []*ExternalReference `xml:"workbookView,omitempty"`
}

ExternalReferenceList is a direct mapping of XSD CT_ExternalReferences

func (*ExternalReferenceList) MarshalXML 

func (r *ExternalReferenceList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal ExternalReferenceList

type FileVersion 

type FileVersion struct {
	AppName      string `xml:"appName,attr,omitempty"`
	CodeName     string `xml:"codeName,attr,omitempty"`
	LastEdited   string `xml:"lastEdited,attr,omitempty"`
	LowestEdited string `xml:"lowestEdited,attr,omitempty"`
	RupBuild     string `xml:"rupBuild,attr,omitempty"`
}

FileVersion is a direct mapping of XSD CT_FileVersion

type Fill 

type Fill struct {
	Pattern  *PatternFill  `xml:"patternFill,omitempty"`
	Gradient *GradientFill `xml:"gradientFill,omitempty"`
}

Fill is a direct mapping of XSD CT_Fill

func (*Fill) Hash 

func (fill *Fill) Hash() index.Code

Hash builds hash code for all required values of Fill to use as unique index

type FillList 

type FillList struct {
	Count int     `xml:"count,attr"`
	Items []*Fill `xml:"fill,omitempty"`
}

FillList is a direct mapping of XSD CT_Fills

func (*FillList) MarshalXML 

func (r *FillList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal FillList

type FilterColumn 

type FilterColumn struct {
	Filters       *ml.Reserved `xml:"filters,omitempty"`
	Top10         *ml.Reserved `xml:"top10,omitempty"`
	CustomFilters *ml.Reserved `xml:"customFilters,omitempty"`
	DynamicFilter *ml.Reserved `xml:"dynamicFilter,omitempty"`
	ColorFilter   *ml.Reserved `xml:"colorFilter,omitempty"`
	IconFilter    *ml.Reserved `xml:"iconFilter,omitempty"`
	ExtLst        *ml.Reserved `xml:"extLst,omitempty"`
	ColId         int          `xml:"colId,attr"`
	HiddenButton  bool         `xml:"hiddenButton,attr"`
	ShowButton    *bool        `xml:"showButton,attr"`
}

FilterColumn is direct mapping of XSD CT_FilterColumn

type Font 

type Font struct {
	Name      ml.Property                `xml:"name,omitempty"`
	Charset   primitives.FontCharsetType `xml:"charset,omitempty"`
	Family    primitives.FontFamilyType  `xml:"family,omitempty"`
	Bold      ml.PropertyBool            `xml:"b,omitempty"`
	Italic    ml.PropertyBool            `xml:"i,omitempty"`
	Strike    ml.PropertyBool            `xml:"strike,omitempty"`
	Shadow    ml.PropertyBool            `xml:"shadow,omitempty"`
	Condense  ml.PropertyBool            `xml:"condense,omitempty"`
	Extend    ml.PropertyBool            `xml:"extend,omitempty"`
	Color     *Color                     `xml:"color,omitempty"`
	Size      ml.PropertyDouble          `xml:"sz,omitempty"`
	Underline primitives.UnderlineType   `xml:"u,omitempty"`
	Effect    primitives.FontEffectType  `xml:"vertAlign,omitempty"`
	Scheme    primitives.FontSchemeType  `xml:"scheme,omitempty"`
}

Font is a direct mapping of XSD CT_Font

func (*Font) Hash 

func (f *Font) Hash() index.Code

Hash builds hash code for all required values of Font to use as unique index

type FontList 

type FontList struct {
	Count int     `xml:"count,attr"`
	Items []*Font `xml:"font,omitempty"`
}

FontList is a direct mapping of XSD CT_Fonts

func (*FontList) MarshalXML 

func (r *FontList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal FontList

type Formula 

type Formula string

Formula is a direct mapping of XSD ST_Formula

type GUID 

type GUID string

GUID is a direct mapping of XSD ST_Guid

type GradientFill 

type GradientFill struct {
	Stop   []*GradientStop         `xml:"stop,omitempty"`
	Degree float64                 `xml:"degree,attr,omitempty"` //default 0.0
	Left   float64                 `xml:"left,attr,omitempty"`   //default 0.0
	Right  float64                 `xml:"right,attr,omitempty"`  //default 0.0
	Top    float64                 `xml:"top,attr,omitempty"`    //default 0.0
	Bottom float64                 `xml:"bottom,attr,omitempty"` //default 0.0
	Type   primitives.GradientType `xml:"type,attr,omitempty"`   //default linear
}

GradientFill is a direct mapping of XSD CT_GradientFill

type GradientStop 

type GradientStop struct {
	Color    *Color  `xml:"color"`
	Position float64 `xml:"position,attr"`
}

GradientStop is a direct mapping of XSD CT_GradientStop 

type Hyperlink struct {
	Bounds   primitives.Bounds `xml:"ref,attr"`
	Location string            `xml:"location,attr,omitempty"`
	Tooltip  string            `xml:"tooltip,attr,omitempty"`
	Display  string            `xml:"display,attr,omitempty"`
	RID      ml.RID            `xml:"id,attr,omitempty"`
}

Hyperlink is a direct mapping of XSD CT_Hyperlink 

type HyperlinkList struct {
	Items []*Hyperlink `xml:"hyperlink,omitempty"`
}

HyperlinkList is a direct mapping of XSD CT_Hyperlinks

func (*HyperlinkList) MarshalXML 

func (r *HyperlinkList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal HyperlinkList

type IconSet 

type IconSet struct {
	Values    []*ConditionValue      `xml:"cfvo"` //minimum 2 values
	Type      primitives.IconSetType `xml:"iconSet,attr,omitempty"`
	Reverse   bool                   `xml:"reverse,attr,omitempty"`
	ShowValue *bool                  `xml:"showValue,attr,omitempty"`
	Percent   *bool                  `xml:"percent,attr,omitempty"`
}

IconSet is a direct mapping of XSD ST_IconSetType

type LegacyDrawing 

type LegacyDrawing struct {
	RID ml.RID `xml:"id,attr"`
}

LegacyDrawing is a direct mapping of XSD CT_LegacyDrawing

type MergeCell 

type MergeCell struct {
	Bounds primitives.Bounds `xml:"ref,attr"`
}

MergeCell is a direct mapping of XSD CT_MergeCell

type MergedCellList 

type MergedCellList struct {
	Count int          `xml:"count,attr"`
	Items []*MergeCell `xml:"mergeCell,omitempty"`
}

MergedCellList is a direct mapping of XSD CT_MergeCells

func (*MergedCellList) MarshalXML 

func (r *MergedCellList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal MergedCellList

type NamedStyle 

type NamedStyle Style

NamedStyle is helper alias type for cellStyleXfs->xf of XSD CT_Xf to make it easier to read/understand markup files

func (*NamedStyle) Hash 

func (ns *NamedStyle) Hash() index.Code

Hash builds hash code for all required values of NamedStyle to use as unique index

type NamedStyleID 

type NamedStyleID int

NamedStyleID is helper alias type for ID of CT_CellStyle to make it easier to read/understand markup files

type NamedStyleInfo 

type NamedStyleInfo struct {
	Name          string       `xml:"name,attr,omitempty"`
	XfId          NamedStyleID `xml:"xfId,attr"`
	BuiltinId     *int         `xml:"builtinId,attr,omitempty"`
	ILevel        uint         `xml:"iLevel,attr,omitempty"`
	Hidden        bool         `xml:"hidden,attr,omitempty"`
	CustomBuiltin bool         `xml:"customBuiltin,attr,omitempty"`
	ExtLst        *ml.Reserved `xml:"extLst,omitempty"`
}

NamedStyleInfo is a direct mapping of XSD CT_CellStyle

type NamedStyleInfoList 

type NamedStyleInfoList struct {
	Count int               `xml:"count,attr"`
	Items []*NamedStyleInfo `xml:"cellStyle,omitempty"`
}

NamedStyleInfoList is a direct mapping of XSD CT_CellStyles

func (*NamedStyleInfoList) MarshalXML 

func (r *NamedStyleInfoList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal NamedStyleInfoList

type NamedStyleList 

type NamedStyleList struct {
	Count int           `xml:"count,attr"`
	Items []*NamedStyle `xml:"xf,omitempty"`
}

NamedStyleList is a direct mapping of XSD cellStyleXfs

func (*NamedStyleList) MarshalXML 

func (r *NamedStyleList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal NamedStyleList

type NumberFormat 

type NumberFormat struct {
	ID   int    `xml:"numFmtId,attr"`
	Code string `xml:"formatCode,attr"`
}

NumberFormat is a direct mapping of XSD CT_NumFmt

func (*NumberFormat) Hash 

func (f *NumberFormat) Hash() index.Code

Hash builds hash code for all required values of NumberFormat to use as unique index

type NumberFormatList 

type NumberFormatList struct {
	Count int             `xml:"count,attr"`
	Items []*NumberFormat `xml:"numFmt,omitempty"`
}

NumberFormatList is a direct mapping of XSD CT_NumFmts

func (*NumberFormatList) MarshalXML 

func (r *NumberFormatList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal NumberFormatList

type PatternFill 

type PatternFill struct {
	Color      *Color                 `xml:"fgColor,omitempty"`
	Background *Color                 `xml:"bgColor,omitempty"`
	Type       primitives.PatternType `xml:"patternType,attr,omitempty"`
}

PatternFill is a direct mapping of XSD CT_PatternFill

type RichFont 

type RichFont struct {
	Name      ml.Property                `xml:"rFont,omitempty"`
	Charset   primitives.FontCharsetType `xml:"charset,omitempty"`
	Family    primitives.FontFamilyType  `xml:"family,omitempty"`
	Bold      ml.PropertyBool            `xml:"b,omitempty"`
	Italic    ml.PropertyBool            `xml:"i,omitempty"`
	Strike    ml.PropertyBool            `xml:"strike,omitempty"`
	Shadow    ml.PropertyBool            `xml:"shadow,omitempty"`
	Condense  ml.PropertyBool            `xml:"condense,omitempty"`
	Extend    ml.PropertyBool            `xml:"extend,omitempty"`
	Color     *Color                     `xml:"color,omitempty"`
	Size      ml.PropertyDouble          `xml:"sz,omitempty"`
	Underline primitives.UnderlineType   `xml:"u,omitempty"`
	Effect    primitives.FontEffectType  `xml:"vertAlign,omitempty"`
	Scheme    primitives.FontSchemeType  `xml:"scheme,omitempty"`
}

RichFont is a direct mapping of XSD CT_RPrElt N.B.: it's weird, but CT_RPrElt is clone CT_Font, except different tag for 'Name' field

type RichText 

type RichText struct {
	Font *RichFont       `xml:"rPr,omitempty"`
	Text primitives.Text `xml:"t"` //required
}

RichText is a direct mapping of XSD CT_RElt

type Row 

type Row struct {
	Cells        []*Cell       `xml:"c"`
	ExtLst       *ml.Reserved  `xml:"extLst,omitempty"`
	Ref          int           `xml:"r,attr,omitempty"` //1-based index
	Spans        string        `xml:"spans,attr,omitempty"`
	Style        DirectStyleID `xml:"s,attr,omitempty"`
	CustomFormat bool          `xml:"customFormat,attr,omitempty"`
	Height       float32       `xml:"ht,attr,omitempty"`
	Hidden       bool          `xml:"hidden,attr,omitempty"`
	CustomHeight bool          `xml:"customHeight,attr,omitempty"`
	OutlineLevel uint8         `xml:"outlineLevel,attr,omitempty"`
	Collapsed    bool          `xml:"collapsed,attr,omitempty"`
	ThickTop     bool          `xml:"thickTop,attr,omitempty"`
	ThickBot     bool          `xml:"thickBot,attr,omitempty"`
	Phonetic     bool          `xml:"ph,attr,omitempty"`
}

Row is a direct mapping of XSD CT_Row

type SharedStrings 

type SharedStrings struct {
	XMLName     xml.Name      `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main sst"`
	Count       uint          `xml:"count,attr,omitempty"`
	UniqueCount uint          `xml:"uniqueCount,attr,omitempty"`
	StringItem  []*StringItem `xml:"si"`
	ExtLst      *ml.Reserved  `xml:"extLst,omitempty"`
}

SharedStrings is a direct mapping of XSD CT_Sst

type Sheet 

type Sheet struct {
	Name    string                    `xml:"name,attr"`
	SheetID uint                      `xml:"sheetId,attr"`
	State   primitives.VisibilityType `xml:"state,attr,omitempty"`
	RID     ml.RID                    `xml:"id,attr"`
}

Sheet is a direct mapping of XSD CT_Sheet

type SheetDimension 

type SheetDimension struct {
	Bounds primitives.Bounds `xml:"ref,attr"`
}

SheetDimension is a direct mapping of XSD CT_SheetDimension

type SheetView 

type SheetView struct {
	Pane                     *ml.Reserved       `xml:"pane,omitempty"`
	Selection                []*ml.Reserved     `xml:"selection,omitempty"`
	PivotSelection           []*ml.Reserved     `xml:"pivotSelection,omitempty"`
	ExtLst                   *ml.Reserved       `xml:"extLst,omitempty"`
	WindowProtection         bool               `xml:"windowProtection,attr,omitempty"`
	ShowFormulas             bool               `xml:"showFormulas,attr,omitempty"`
	ShowGridLines            bool               `xml:"showGridLines,attr,omitempty"`
	ShowRowColHeaders        bool               `xml:"showRowColHeaders,attr,omitempty"`
	ShowZeros                bool               `xml:"showZeros,attr,omitempty"`
	RightToLeft              bool               `xml:"rightToLeft,attr,omitempty"`
	TabSelected              bool               `xml:"tabSelected,attr,omitempty"`
	ShowRuler                bool               `xml:"showRuler,attr,omitempty"`
	ShowOutlineSymbols       bool               `xml:"showOutlineSymbols,attr,omitempty"`
	DefaultGridColor         bool               `xml:"defaultGridColor,attr,omitempty"`
	ShowWhiteSpace           bool               `xml:"showWhiteSpace,attr,omitempty"`
	View                     string             `xml:"view,attr,omitempty"` //ST_SheetViewType
	TopLeftCell              primitives.CellRef `xml:"topLeftCell,attr,omitempty"`
	ColorId                  uint               `xml:"colorId,attr,omitempty"`
	ZoomScale                uint               `xml:"zoomScale,attr,omitempty"`
	ZoomScaleNormal          uint               `xml:"zoomScaleNormal,attr,omitempty"`
	ZoomScaleSheetLayoutView uint               `xml:"zoomScaleSheetLayoutView,attr,omitempty"`
	ZoomScalePageLayoutView  uint               `xml:"zoomScalePageLayoutView,attr,omitempty"`
	WorkbookViewId           uint               `xml:"workbookViewId,attr"`
}

SheetView is a direct mapping of XSD CT_SheetView

type SheetViewList 

type SheetViewList struct {
	Items  []*SheetView `xml:"sheetView,omitempty"`
	ExtLst *ml.Reserved `xml:"extLst,omitempty"`
}

SheetViewList is a direct mapping of XSD CT_SheetViews

func (*SheetViewList) MarshalXML 

func (r *SheetViewList) MarshalXML(e *xml.Encoder, start xml.StartElement) error

MarshalXML marshal SheetViewList

type StringItem 

type StringItem struct {
	Text       primitives.Text `xml:"t,omitempty"`   //optional
	RichText   []*RichText     `xml:"r,omitempty"`   //optional
	RPh        []*ml.Reserved  `xml:"rPh,omitempty"` //optional
	PhoneticPr *ml.Reserved    `xml:"phoneticPr,omitempty"`
}

StringItem is a direct mapping of XSD CT_Rst

func (*StringItem) Hash 

func (s *StringItem) Hash() index.Code

Hash builds hash code for all required values of StringItem to use as unique index

type Style 

type Style struct {
	NumFmtId          int             `xml:"numFmtId,attr"`
	FontId            int             `xml:"fontId,attr"`
	FillId            int             `xml:"fillId,attr"`
	BorderId          int             `xml:"borderId,attr"`
	QuotePrefix       bool            `xml:"quotePrefix,attr,omitempty"`
	PivotButton       bool            `xml:"pivotButton,attr,omitempty"`
	ApplyNumberFormat bool            `xml:"applyNumberFormat,attr,omitempty"`
	ApplyFont         bool            `xml:"applyFont,attr,omitempty"`
	ApplyFill         bool            `xml:"applyFill,attr,omitempty"`
	ApplyBorder       bool            `xml:"applyBorder,attr,omitempty"`
	ApplyAlignment    bool            `xml:"applyAlignment,attr,omitempty"`
	ApplyProtection   bool            `xml:"applyProtection,attr,omitempty"`
	Alignment         *CellAlignment  `xml:"alignment,omitempty"`
	Protection        *CellProtection `xml:"protection,omitempty"`
	ExtLst            *ml.Reserved    `xml:"extLst,omitempty"`
}

Style is just underlayed struct to hold Xf master records and is a direct mapping of XSD CT_Xf

type StyleSheet 

type StyleSheet struct {
	XMLName       xml.Name           `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main styleSheet"`
	NumberFormats NumberFormatList   `xml:"numFmts"`
	Fonts         FontList           `xml:"fonts"`
	Fills         FillList           `xml:"fills"`
	Borders       BorderList         `xml:"borders"`
	CellStyleXfs  NamedStyleList     `xml:"cellStyleXfs"`
	CellXfs       DirectStyleList    `xml:"cellXfs"`
	CellStyles    NamedStyleInfoList `xml:"cellStyles"`
	Dxfs          DiffStyleList      `xml:"dxfs"`
	TableStyles   *ml.Reserved       `xml:"tableStyles,omitempty"`
	Colors        *ml.Reserved       `xml:"colors,omitempty"`
	ExtLst        *ml.Reserved       `xml:"extLst,omitempty"`
}

StyleSheet is a direct mapping of XSD CT_Stylesheet

type Workbook 

type Workbook struct {
	XMLName             xml.Name              `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main workbook"`
	RIDName             ml.RIDName            `xml:",attr"`
	FileVersion         *FileVersion          `xml:"fileVersion,omitempty"`
	FileSharing         *ml.Reserved          `xml:"fileSharing,omitempty"`
	WorkbookPr          *WorkbookPr           `xml:"workbookPr,omitempty"`
	WorkbookProtection  *ml.Reserved          `xml:"workbookProtection,omitempty"`
	BookViews           BookViewList          `xml:"bookViews"`
	Sheets              []*Sheet              `xml:"sheets>sheet"`
	FunctionGroups      *ml.Reserved          `xml:"functionGroups,omitempty"`
	ExternalReferences  ExternalReferenceList `xml:"externalReferences"`
	DefinedNames        *ml.Reserved          `xml:"definedNames,omitempty"`
	CalcPr              *ml.Reserved          `xml:"calcPr,omitempty"`
	OleSize             *ml.Reserved          `xml:"oleSize,omitempty"`
	CustomWorkbookViews *ml.Reserved          `xml:"customWorkbookViews,omitempty"`
	PivotCaches         *ml.Reserved          `xml:"pivotCaches,omitempty"`
	SmartTagPr          *ml.Reserved          `xml:"smartTagPr,omitempty"`
	SmartTagTypes       *ml.Reserved          `xml:"smartTagTypes,omitempty"`
	WebPublishing       *ml.Reserved          `xml:"webPublishing,omitempty"`
	FileRecoveryPr      *ml.Reserved          `xml:"fileRecoveryPr,omitempty"`
	WebPublishObjects   *ml.Reserved          `xml:"webPublishObjects,omitempty"`
	ExtLst              *ml.Reserved          `xml:"extLst,omitempty"`
	Conformance         string                `xml:"conformance,attr,omitempty"`
}

Workbook is a direct mapping of XSD CT_Workbook

type WorkbookPr 

type WorkbookPr struct {
	Date1904                   bool                       `xml:"date1904,attr,omitempty"`
	ShowBorderUnselectedTables bool                       `xml:"showBorderUnselectedTables,attr,omitempty"`
	FilterPrivacy              bool                       `xml:"filterPrivacy,attr,omitempty"`
	PromptedSolutions          bool                       `xml:"promptedSolutions,attr,omitempty"`
	ShowInkAnnotation          bool                       `xml:"showInkAnnotation,attr,omitempty"`
	BackupFile                 bool                       `xml:"backupFile,attr,omitempty"`
	SaveExternalLinkValues     bool                       `xml:"saveExternalLinkValues,attr,omitempty"`
	HidePivotFieldList         bool                       `xml:"hidePivotFieldList,attr,omitempty"`
	ShowPivotChartFilter       bool                       `xml:"showPivotChartFilter,attr,omitempty"`
	AllowRefreshQuery          bool                       `xml:"allowRefreshQuery,attr,omitempty"`
	PublishItems               bool                       `xml:"publishItems,attr,omitempty"`
	CheckCompatibility         bool                       `xml:"checkCompatibility,attr,omitempty"`
	AutoCompressPictures       bool                       `xml:"autoCompressPictures,attr,omitempty"`
	RefreshAllConnections      bool                       `xml:"refreshAllConnections,attr,omitempty"`
	ShowObjects                primitives.ObjectsType     `xml:"showObjects,attr,omitempty"`
	UpdateLinks                primitives.UpdateLinksType `xml:"updateLinks,attr,omitempty"`
	DefaultThemeVersion        uint                       `xml:"defaultThemeVersion,attr,omitempty"`
	CodeName                   string                     `xml:"codeName,attr,omitempty"`
}

WorkbookPr is a direct mapping of XSD CT_WorkbookPr

type Worksheet 

type Worksheet struct {
	XMLName               xml.Name                  `xml:"http://schemas.openxmlformats.org/spreadsheetml/2006/main worksheet"`
	RIDName               ml.RIDName                `xml:",attr"`
	SheetPr               *ml.Reserved              `xml:"sheetPr,omitempty"`
	Dimension             *SheetDimension           `xml:"dimension,omitempty"`
	SheetViews            SheetViewList             `xml:"sheetViews"`
	SheetFormatPr         *ml.Reserved              `xml:"sheetFormatPr,omitempty"`
	Cols                  ColList                   `xml:"cols"`
	SheetData             []*Row                    `xml:"sheetData>row"`
	SheetCalcPr           *ml.Reserved              `xml:"sheetCalcPr,omitempty"`
	SheetProtection       *ml.Reserved              `xml:"sheetProtection,omitempty"`
	ProtectedRanges       *ml.Reserved              `xml:"protectedRanges,omitempty"`
	Scenarios             *ml.Reserved              `xml:"scenarios,omitempty"`
	AutoFilter            AutoFilter                `xml:"autoFilter"`
	SortState             *ml.Reserved              `xml:"sortState,omitempty"`
	DataConsolidate       *ml.Reserved              `xml:"dataConsolidate,omitempty"`
	CustomSheetViews      *ml.Reserved              `xml:"customSheetViews,omitempty"`
	MergeCells            MergedCellList            `xml:"mergeCells"`
	PhoneticPr            *ml.Reserved              `xml:"phoneticPr,omitempty"`
	ConditionalFormatting *[]*ConditionalFormatting `xml:"conditionalFormatting,omitempty"`
	DataValidations       *ml.Reserved              `xml:"dataValidations,omitempty"`
	Hyperlinks            HyperlinkList             `xml:"hyperlinks"`
	PrintOptions          *ml.Reserved              `xml:"printOptions,omitempty"`
	PageMargins           *ml.Reserved              `xml:"pageMargins,omitempty"`
	PageSetup             *ml.Reserved              `xml:"pageSetup,omitempty"`
	HeaderFooter          *ml.Reserved              `xml:"headerFooter,omitempty"`
	RowBreaks             *ml.Reserved              `xml:"rowBreaks,omitempty"`
	ColBreaks             *ml.Reserved              `xml:"colBreaks,omitempty"`
	CustomProperties      *ml.Reserved              `xml:"customProperties,omitempty"`
	CellWatches           *ml.Reserved              `xml:"cellWatches,omitempty"`
	IgnoredErrors         *ml.Reserved              `xml:"ignoredErrors,omitempty"`
	SmartTags             *ml.Reserved              `xml:"smartTags,omitempty"`
	Drawing               *ml.Reserved              `xml:"drawing,omitempty"`
	LegacyDrawing         *LegacyDrawing            `xml:"legacyDrawing,omitempty"`
	LegacyDrawingHF       *ml.Reserved              `xml:"legacyDrawingHF,omitempty"`
	DrawingHF             *ml.Reserved              `xml:"drawingHF,omitempty"`
	Picture               *ml.Reserved              `xml:"picture,omitempty"`
	OleObjects            *ml.Reserved              `xml:"oleObjects,omitempty"`
	Controls              *ml.Reserved              `xml:"controls,omitempty"`
	WebPublishItems       *ml.Reserved              `xml:"webPublishItems,omitempty"`
	TableParts            *ml.Reserved              `xml:"tableParts,omitempty"`
	ExtLst                *ml.Reserved              `xml:"extLst,omitempty"`
}

Worksheet is a direct mapping of XSD CT_Worksheet

Source Files

View all Source files

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.