Documentation ¶
Index ¶
- Constants
- type Book
- type CTypes
- type Cell
- type Col
- type Cols
- type Dimension
- type Element
- type MergeCell
- type MergeCells
- type Override
- type Rel
- type Rels
- type Row
- type SSI
- type SSR
- type SST
- type Sheet
- func (a *Sheet) DeleteCols(j int, n int)
- func (a *Sheet) DeleteRows(i int, m int)
- func (a *Sheet) ExtendCols(j int, n int, count int)
- func (a *Sheet) ExtendRows(i int, m int, count int)
- func (a *Sheet) Get(i, j int) *Cell
- func (a *Sheet) ICell(i, j int) *Cell
- func (a *Sheet) IMerge(i, j int, m, n int)
- func (a *Sheet) MarshalXML(e *xml.Encoder, start xml.StartElement) error
- func (a *Sheet) Set(i, j int, cell *Cell) *Sheet
- func (a *Sheet) UnmarshalXML(d *xml.Decoder, start xml.StartElement) error
- type SheetFormatPr
- type SheetInfo
- type Text
Constants ¶
const ( TypeError = "e" TypeString = "s" TypeBool = "b" TypeNumber = "n" )
Cell type.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type Book ¶
type Book struct { XMLName xml.Name Attrs []xml.Attr `xml:",any,attr,omitempty"` FileVersion *Element `xml:"fileVersion,omitempty"` WorkbookPr *Element `xml:"workbookPr,omitempty"` WorkbookProtection *Element `xml:"workbookProtection,omitempty"` BookViews *Element `xml:"bookViews,omitempty"` Sheets []*SheetInfo `xml:"sheets>sheet"` DefinedNames *Element `xml:"definedNames,omitempty"` CalcPr string `xml:"calcPr"` PivotCaches *Element `xml:"pivotCaches,omitempty"` }
Book represents a workbook.
func (*Book) UnmarshalXML ¶
UnmarshalXML decodes a single XML element beginning with the given start element.
type CTypes ¶
type CTypes struct { XMLName xml.Name Defaults []*Element `xml:"Default,omitempty"` Overrides []Override `xml:"Override,omitempty"` }
CTypes represents the content types.
type Cell ¶
type Cell struct { Attrs []xml.Attr `xml:",any,attr,omitempty"` Ref string `xml:"r,attr,omitempty"` Style string `xml:"s,attr,omitempty"` Type string `xml:"t,attr,omitempty"` Formula *Element `xml:"f,omitempty"` Value string `xml:"v,omitempty"` Is *SSI `xml:"is,omitempty"` // contains filtered or unexported fields }
Cell represents a cell.
type Col ¶
type Col struct { Attrs []xml.Attr `xml:",any,attr,omitempty"` Min int `xml:"min,attr,omitempty"` Max int `xml:"max,attr,omitempty"` }
Col represents a col.
type Cols ¶
type Cols []*Col
Cols represents the cols.
func (Cols) MarshalXML ¶
MarshalXML encodes the receiver as zero or more XML elements.
func (*Cols) UnmarshalXML ¶
UnmarshalXML decodes a single XML element beginning with the given start element.
type Dimension ¶
type Dimension struct {
Ref string `xml:"ref,attr"`
}
Dimension represents a dimension element.
type Element ¶
type Element struct { Attrs []xml.Attr `xml:",any,attr,omitempty"` InnerXML []byte `xml:",innerxml"` }
Element represents a xml element.
type MergeCell ¶
type MergeCell struct {
Ref string `xml:"ref,attr"`
}
MergeCell represents a mergeCell element.
type MergeCells ¶
type MergeCells struct { Count int `xml:"count,attr"` Entries []*MergeCell `xml:"mergeCell,omitempty"` }
MergeCells represents the mergeCell elements.
type Override ¶
type Override struct { PartName string `xml:"PartName,attr"` ContentType string `xml:"ContentType,attr"` }
Override represents the content override.
type Rel ¶
type Rel struct { ID string `xml:"Id,attr"` Type string `xml:"Type,attr"` Target string `xml:"Target,attr"` }
Rel represents represents rel.
type Row ¶
type Row struct { Attrs []xml.Attr `xml:",any,attr,omitempty"` Ref string `xml:"r,attr,omitempty"` CustomHeight string `xml:"customHeight,attr,omitempty"` Spans string `xml:"spans,attr,omitempty"` Cells []*Cell `xml:"c,omitempty"` }
Row represents a row.
type SST ¶
type SST struct { XMLName xml.Name Count int `xml:"count,attr"` UniqueCount int `xml:"uniqueCount,attr"` SSIs []SSI `xml:"si"` // contains filtered or unexported fields }
SST represents the shared strings.
func (*SST) MarshalXML ¶
MarshalXML encodes the receiver as zero or more XML elements.
func (*SST) UnmarshalXML ¶
UnmarshalXML decodes a single XML element beginning with the given start element.
type Sheet ¶
type Sheet struct { XMLName xml.Name Attrs []xml.Attr `xml:",any,attr,omitempty"` SheetPr *Element `xml:"sheetPr,omitempty"` Dimension Dimension `xml:"dimension"` SheetViews *Element `xml:"sheetViews,omitempty"` SheetFormatPr SheetFormatPr `xml:"sheetFormatPr"` Cols Cols `xml:"cols,omitempty"` Rows []*Row `xml:"sheetData>row"` SheetProtection *Element `xml:"sheetProtection,omitempty"` AutoFilter *Element `xml:"autoFilter,omitempty"` MergeCells *MergeCells `xml:"mergeCells,omitempty"` DataValidations *Element `xml:"dataValidations,omitempty"` Hyperlinks *Element `xml:"hyperlinks,omitempty"` PrintOptions *Element `xml:"printOptions,omitempty"` PageMargins *Element `xml:"pageMargins,omitempty"` PageSetup *Element `xml:"pageSetup,omitempty"` Drawing *Element `xml:"drawing,omitempty"` LegacyDrawing *Element `xml:"legacyDrawing,omitempty"` TableParts *Element `xml:"tableParts,omitempty"` // contains filtered or unexported fields }
Sheet represents the worksheet.
func (*Sheet) DeleteCols ¶
DeleteCols deletes n cols from index j.
func (*Sheet) DeleteRows ¶
DeleteRows deletes m rows from index i.
func (*Sheet) ExtendCols ¶
ExtendCols extends n cols at index j.
func (*Sheet) ExtendRows ¶
ExtendRows extends m rows at index i.
func (*Sheet) MarshalXML ¶
MarshalXML encodes the receiver as zero or more XML elements.
func (*Sheet) UnmarshalXML ¶
UnmarshalXML decodes a single XML element beginning with the given start element.
type SheetFormatPr ¶
type SheetFormatPr struct { Attrs []xml.Attr `xml:",any,attr,omitempty"` CustomHeight string `xml:"customHeight,attr,omitempty"` }
SheetFormatPr represents a sheetFormatPr element.