Documentation ¶
Index ¶
- type AutoFilter
- type BookView
- type BookViewList
- type Border
- type BorderList
- type BorderSegment
- type Cell
- type CellAlignment
- type CellFormula
- type CellProtection
- type ClientData
- type Col
- type ColList
- type Color
- type ColorScale
- type Comment
- type CommentOptions
- type Comments
- type ConditionValue
- type ConditionalFormatting
- type ConditionalRule
- type DataBar
- type DiffStyle
- type DiffStyleID
- type DiffStyleList
- type DirectStyle
- type DirectStyleID
- type DirectStyleList
- type ExternalReference
- type ExternalReferenceList
- type FileVersion
- type Fill
- type FillList
- type FilterColumn
- type Font
- type FontList
- type Formula
- type GUID
- type GradientFill
- type GradientStop
- type Hyperlink
- type HyperlinkList
- type IconSet
- type LegacyDrawing
- type MergeCell
- type MergedCellList
- type NamedStyle
- type NamedStyleID
- type NamedStyleInfo
- type NamedStyleInfoList
- type NamedStyleList
- type NumberFormat
- type NumberFormatList
- type PatternFill
- type RichFont
- type RichText
- type Row
- type SharedStrings
- type Sheet
- type SheetDimension
- type SheetView
- type SheetViewList
- type StringItem
- type Style
- type StyleSheet
- type Workbook
- type WorkbookPr
- type Worksheet
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
type BorderList ¶
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 ¶
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
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
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 ¶
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 ¶
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
type FillList ¶
FillList is a direct mapping of XSD CT_Fills
func (*FillList) MarshalXML ¶
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
type FontList ¶
FontList is a direct mapping of XSD CT_Fonts
func (*FontList) MarshalXML ¶
MarshalXML marshal FontList
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 ¶
GradientStop is a direct mapping of XSD CT_GradientStop
type Hyperlink ¶
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 ¶
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 ¶
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 ¶
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 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"` 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