xlsx

Documentation

Index

• type PivotCacheDefinition
• type PivotTableDefinition
• type Sst
• type StyleSheet
• type Workbook
• type Worksheet

Types

type PivotCacheDefinition

type PivotCacheDefinition struct {
	XMLName               xml.Name `xml:"pivotCacheDefinition"`
	Text                  string   `xml:",chardata"`
	Xmlns                 string   `xml:"xmlns,attr"`
	R                     string   `xml:"r,attr"`
	ID                    string   `xml:"id,attr"`
	RefreshedBy           string   `xml:"refreshedBy,attr"`
	RefreshedDate         string   `xml:"refreshedDate,attr"`
	CreatedVersion        string   `xml:"createdVersion,attr"`
	RefreshedVersion      string   `xml:"refreshedVersion,attr"`
	MinRefreshableVersion string   `xml:"minRefreshableVersion,attr"`
	RecordCount           string   `xml:"recordCount,attr"`
	CacheSource           struct {
		Text            string `xml:",chardata"`
		Type            string `xml:"type,attr"`
		WorksheetSource struct {
			Text  string `xml:",chardata"`
			Ref   string `xml:"ref,attr"`
			Sheet string `xml:"sheet,attr"`
		} `xml:"worksheetSource"`
	} `xml:"cacheSource"`
	CacheFields struct {
		Text       string `xml:",chardata"`
		Count      string `xml:"count,attr"`
		CacheField []struct {
			Text        string `xml:",chardata"`
			Name        string `xml:"name,attr"`
			NumFmtId    string `xml:"numFmtId,attr"`
			SharedItems struct {
				Text                   string `xml:",chardata"`
				ContainsSemiMixedTypes string `xml:"containsSemiMixedTypes,attr"`
				ContainsNonDate        string `xml:"containsNonDate,attr"`
				ContainsDate           string `xml:"containsDate,attr"`
				ContainsString         string `xml:"containsString,attr"`
				MinDate                string `xml:"minDate,attr"`
				MaxDate                string `xml:"maxDate,attr"`
				Count                  string `xml:"count,attr"`
				ContainsNumber         string `xml:"containsNumber,attr"`
				ContainsInteger        string `xml:"containsInteger,attr"`
				MinValue               string `xml:"minValue,attr"`
				MaxValue               string `xml:"maxValue,attr"`
				D                      []struct {
					Text string `xml:",chardata"`
					V    string `xml:"v,attr"`
				} `xml:"d"`
				S []struct {
					Text string `xml:",chardata"`
					V    string `xml:"v,attr"`
				} `xml:"s"`
			} `xml:"sharedItems"`
		} `xml:"cacheField"`
	} `xml:"cacheFields"`
	ExtLst struct {
		Text string `xml:",chardata"`
		Ext  struct {
			Text                 string `xml:",chardata"`
			URI                  string `xml:"uri,attr"`
			X14                  string `xml:"x14,attr"`
			PivotCacheDefinition struct {
				Text string `xml:",chardata"`
			} `xml:"pivotCacheDefinition"`
		} `xml:"ext"`
	} `xml:"extLst"`
}

PivotCacheDefinition was generated 2019-04-06 22:26:52 by rcir178 on rcir178-Latitude-E7470.

type PivotTableDefinition

type PivotTableDefinition struct {
	XMLName                 xml.Name `xml:"pivotTableDefinition"`
	Text                    string   `xml:",chardata"`
	Xmlns                   string   `xml:"xmlns,attr"`
	Name                    string   `xml:"name,attr"`
	CacheId                 string   `xml:"cacheId,attr"`
	ApplyNumberFormats      string   `xml:"applyNumberFormats,attr"`
	ApplyBorderFormats      string   `xml:"applyBorderFormats,attr"`
	ApplyFontFormats        string   `xml:"applyFontFormats,attr"`
	ApplyPatternFormats     string   `xml:"applyPatternFormats,attr"`
	ApplyAlignmentFormats   string   `xml:"applyAlignmentFormats,attr"`
	ApplyWidthHeightFormats string   `xml:"applyWidthHeightFormats,attr"`
	DataCaption             string   `xml:"dataCaption,attr"`
	UpdatedVersion          string   `xml:"updatedVersion,attr"`
	MinRefreshableVersion   string   `xml:"minRefreshableVersion,attr"`
	UseAutoFormatting       string   `xml:"useAutoFormatting,attr"`
	ItemPrintTitles         string   `xml:"itemPrintTitles,attr"`
	CreatedVersion          string   `xml:"createdVersion,attr"`
	Indent                  string   `xml:"indent,attr"`
	Outline                 string   `xml:"outline,attr"`
	OutlineData             string   `xml:"outlineData,attr"`
	MultipleFieldFilters    string   `xml:"multipleFieldFilters,attr"`
	Location                struct {
		Text           string `xml:",chardata"`
		Ref            string `xml:"ref,attr"`
		FirstHeaderRow string `xml:"firstHeaderRow,attr"`
		FirstDataRow   string `xml:"firstDataRow,attr"`
		FirstDataCol   string `xml:"firstDataCol,attr"`
		RowPageCount   string `xml:"rowPageCount,attr"`
		ColPageCount   string `xml:"colPageCount,attr"`
	} `xml:"location"`
	PivotFields struct {
		Text       string `xml:",chardata"`
		Count      string `xml:"count,attr"`
		PivotField []struct {
			Text      string `xml:",chardata"`
			Axis      string `xml:"axis,attr"`
			NumFmtId  string `xml:"numFmtId,attr"`
			ShowAll   string `xml:"showAll,attr"`
			DataField string `xml:"dataField,attr"`
			Items     struct {
				Text  string `xml:",chardata"`
				Count string `xml:"count,attr"`
				Item  []struct {
					Text string `xml:",chardata"`
					X    string `xml:"x,attr"`
					T    string `xml:"t,attr"`
				} `xml:"item"`
			} `xml:"items"`
		} `xml:"pivotField"`
	} `xml:"pivotFields"`
	RowFields struct {
		Text  string `xml:",chardata"`
		Count string `xml:"count,attr"`
		Field []struct {
			Text string `xml:",chardata"`
			X    string `xml:"x,attr"`
		} `xml:"field"`
	} `xml:"rowFields"`
	RowItems struct {
		Text  string `xml:",chardata"`
		Count string `xml:"count,attr"`
		I     []struct {
			Text string `xml:",chardata"`
			R    string `xml:"r,attr"`
			T    string `xml:"t,attr"`
			X    struct {
				Text string `xml:",chardata"`
				V    string `xml:"v,attr"`
			} `xml:"x"`
		} `xml:"i"`
	} `xml:"rowItems"`
	ColFields struct {
		Text  string `xml:",chardata"`
		Count string `xml:"count,attr"`
		Field []struct {
			Text string `xml:",chardata"`
			X    string `xml:"x,attr"`
		} `xml:"field"`
	} `xml:"colFields"`
	ColItems struct {
		Text  string `xml:",chardata"`
		Count string `xml:"count,attr"`
		I     []struct {
			Text string `xml:",chardata"`
			R    string `xml:"r,attr"`
			I    string `xml:"i,attr"`
			T    string `xml:"t,attr"`
			X    []struct {
				Text string `xml:",chardata"`
				V    string `xml:"v,attr"`
			} `xml:"x"`
		} `xml:"i"`
	} `xml:"colItems"`
	PageFields struct {
		Text      string `xml:",chardata"`
		Count     string `xml:"count,attr"`
		PageField []struct {
			Text string `xml:",chardata"`
			Fld  string `xml:"fld,attr"`
			Hier string `xml:"hier,attr"`
		} `xml:"pageField"`
	} `xml:"pageFields"`
	DataFields struct {
		Text      string `xml:",chardata"`
		Count     string `xml:"count,attr"`
		DataField []struct {
			Text      string `xml:",chardata"`
			Name      string `xml:"name,attr"`
			Fld       string `xml:"fld,attr"`
			BaseField string `xml:"baseField,attr"`
			BaseItem  string `xml:"baseItem,attr"`
			Subtotal  string `xml:"subtotal,attr"`
		} `xml:"dataField"`
	} `xml:"dataFields"`
	PivotTableStyleInfo struct {
		Text           string `xml:",chardata"`
		Name           string `xml:"name,attr"`
		ShowRowHeaders string `xml:"showRowHeaders,attr"`
		ShowColHeaders string `xml:"showColHeaders,attr"`
		ShowRowStripes string `xml:"showRowStripes,attr"`
		ShowColStripes string `xml:"showColStripes,attr"`
		ShowLastColumn string `xml:"showLastColumn,attr"`
	} `xml:"pivotTableStyleInfo"`
	ExtLst struct {
		Text string `xml:",chardata"`
		Ext  struct {
			Text                 string `xml:",chardata"`
			URI                  string `xml:"uri,attr"`
			X14                  string `xml:"x14,attr"`
			PivotTableDefinition struct {
				Text          string `xml:",chardata"`
				HideValuesRow string `xml:"hideValuesRow,attr"`
				Xm            string `xml:"xm,attr"`
			} `xml:"pivotTableDefinition"`
		} `xml:"ext"`
	} `xml:"extLst"`
}

PivotTableDefinition was generated 2019-04-06 22:26:52 by rcir178 on rcir178-Latitude-E7470.

type Sst

type Sst struct {
	XMLName     xml.Name `xml:"sst"`
	Text        string   `xml:",chardata"`
	Xmlns       string   `xml:"xmlns,attr"`
	Count       string   `xml:"count,attr"`
	UniqueCount string   `xml:"uniqueCount,attr"`
	Si          []struct {
		Text string `xml:",chardata"`
		T    struct {
			Text string `xml:",chardata"` // Month, Salesman, Region, ...
		} `xml:"t"`
	} `xml:"si"`
}

Sst was generated 2019-04-06 22:26:52 by rcir178 on rcir178-Latitude-E7470.

type StyleSheet

type StyleSheet struct {
	XMLName xml.Name `xml:"styleSheet"`
	Text    string   `xml:",chardata"`
	Xmlns   string   `xml:"xmlns,attr"`
	NumFmts struct {
		Text   string `xml:",chardata"`
		Count  string `xml:"count,attr"`
		NumFmt []struct {
			Text       string `xml:",chardata"`
			NumFmtId   string `xml:"numFmtId,attr"`
			FormatCode string `xml:"formatCode,attr"`
		} `xml:"numFmt"`
	} `xml:"numFmts"`
	Fonts struct {
		Text  string `xml:",chardata"`
		Count string `xml:"count,attr"`
		Font  []struct {
			Text string `xml:",chardata"`
			Sz   struct {
				Text string `xml:",chardata"`
				Val  string `xml:"val,attr"`
			} `xml:"sz"`
			Name struct {
				Text string `xml:",chardata"`
				Val  string `xml:"val,attr"`
			} `xml:"name"`
			Family struct {
				Text string `xml:",chardata"`
				Val  string `xml:"val,attr"`
			} `xml:"family"`
			Charset struct {
				Text string `xml:",chardata"`
				Val  string `xml:"val,attr"`
			} `xml:"charset"`
			B struct {
				Text string `xml:",chardata"`
				Val  string `xml:"val,attr"`
			} `xml:"b"`
			Color struct {
				Text string `xml:",chardata"`
				Rgb  string `xml:"rgb,attr"`
			} `xml:"color"`
		} `xml:"font"`
	} `xml:"fonts"`
	Fills struct {
		Text  string `xml:",chardata"`
		Count string `xml:"count,attr"`
		Fill  []struct {
			Text        string `xml:",chardata"`
			PatternFill struct {
				Text        string `xml:",chardata"`
				PatternType string `xml:"patternType,attr"`
			} `xml:"patternFill"`
		} `xml:"fill"`
	} `xml:"fills"`
	Borders struct {
		Text   string `xml:",chardata"`
		Count  string `xml:"count,attr"`
		Border []struct {
			Text         string `xml:",chardata"`
			DiagonalUp   string `xml:"diagonalUp,attr"`
			DiagonalDown string `xml:"diagonalDown,attr"`
			Left         struct {
				Text  string `xml:",chardata"`
				Style string `xml:"style,attr"`
			} `xml:"left"`
			Right struct {
				Text  string `xml:",chardata"`
				Style string `xml:"style,attr"`
			} `xml:"right"`
			Top struct {
				Text  string `xml:",chardata"`
				Style string `xml:"style,attr"`
			} `xml:"top"`
			Bottom struct {
				Text  string `xml:",chardata"`
				Style string `xml:"style,attr"`
			} `xml:"bottom"`
			Diagonal struct {
				Text  string `xml:",chardata"`
				Style string `xml:"style,attr"`
			} `xml:"diagonal"`
		} `xml:"border"`
	} `xml:"borders"`
	CellStyleXfs struct {
		Text  string `xml:",chardata"`
		Count string `xml:"count,attr"`
		Xf    []struct {
			Text              string `xml:",chardata"`
			NumFmtId          string `xml:"numFmtId,attr"`
			FontId            string `xml:"fontId,attr"`
			FillId            string `xml:"fillId,attr"`
			BorderId          string `xml:"borderId,attr"`
			ApplyFont         string `xml:"applyFont,attr"`
			ApplyFill         string `xml:"applyFill,attr"`
			ApplyBorder       string `xml:"applyBorder,attr"`
			ApplyAlignment    string `xml:"applyAlignment,attr"`
			ApplyProtection   string `xml:"applyProtection,attr"`
			ApplyNumberFormat string `xml:"applyNumberFormat,attr"`
			Alignment         struct {
				Text         string `xml:",chardata"`
				Horizontal   string `xml:"horizontal,attr"`
				Vertical     string `xml:"vertical,attr"`
				TextRotation string `xml:"textRotation,attr"`
				WrapText     string `xml:"wrapText,attr"`
				Indent       string `xml:"indent,attr"`
				ShrinkToFit  string `xml:"shrinkToFit,attr"`
			} `xml:"alignment"`
			Protection struct {
				Text   string `xml:",chardata"`
				Locked string `xml:"locked,attr"`
				Hidden string `xml:"hidden,attr"`
			} `xml:"protection"`
		} `xml:"xf"`
	} `xml:"cellStyleXfs"`
	CellXfs struct {
		Text  string `xml:",chardata"`
		Count string `xml:"count,attr"`
		Xf    []struct {
			Text              string `xml:",chardata"`
			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"`
			ApplyBorder       string `xml:"applyBorder,attr"`
			ApplyFont         string `xml:"applyFont,attr"`
			ApplyFill         string `xml:"applyFill,attr"`
			ApplyAlignment    string `xml:"applyAlignment,attr"`
			ApplyNumberFormat string `xml:"applyNumberFormat,attr"`
			ApplyProtection   string `xml:"applyProtection,attr"`
			Alignment         struct {
				Text         string `xml:",chardata"`
				Horizontal   string `xml:"horizontal,attr"`
				Vertical     string `xml:"vertical,attr"`
				WrapText     string `xml:"wrapText,attr"`
				TextRotation string `xml:"textRotation,attr"`
				Indent       string `xml:"indent,attr"`
				ShrinkToFit  string `xml:"shrinkToFit,attr"`
			} `xml:"alignment"`
			Protection struct {
				Text   string `xml:",chardata"`
				Locked string `xml:"locked,attr"`
				Hidden string `xml:"hidden,attr"`
			} `xml:"protection"`
		} `xml:"xf"`
	} `xml:"cellXfs"`
	CellStyles struct {
		Text      string `xml:",chardata"`
		Count     string `xml:"count,attr"`
		CellStyle []struct {
			Text          string `xml:",chardata"`
			Name          string `xml:"name,attr"`
			XfId          string `xml:"xfId,attr"`
			BuiltinId     string `xml:"builtinId,attr"`
			CustomBuiltin string `xml:"customBuiltin,attr"`
		} `xml:"cellStyle"`
	} `xml:"cellStyles"`
	Colors struct {
		Text          string `xml:",chardata"`
		IndexedColors struct {
			Text     string `xml:",chardata"`
			RgbColor []struct {
				Text string `xml:",chardata"`
				Rgb  string `xml:"rgb,attr"`
			} `xml:"rgbColor"`
		} `xml:"indexedColors"`
	} `xml:"colors"`
}

StyleSheet was generated 2019-04-06 22:26:52 by rcir178 on rcir178-Latitude-E7470.

type Workbook

type Workbook struct {
	XMLName     xml.Name `xml:"workbook"`
	Text        string   `xml:",chardata"`
	Xmlns       string   `xml:"xmlns,attr"`
	R           string   `xml:"r,attr"`
	FileVersion struct {
		Text         string `xml:",chardata"`
		AppName      string `xml:"appName,attr"`
		LastEdited   string `xml:"lastEdited,attr"`
		LowestEdited string `xml:"lowestEdited,attr"`
		RupBuild     string `xml:"rupBuild,attr"`
	} `xml:"fileVersion"`
	WorkbookPr struct {
		Text                string `xml:",chardata"`
		DefaultThemeVersion string `xml:"defaultThemeVersion,attr"`
	} `xml:"workbookPr"`
	BookViews struct {
		Text         string `xml:",chardata"`
		WorkbookView struct {
			Text         string `xml:",chardata"`
			XWindow      string `xml:"xWindow,attr"`
			YWindow      string `xml:"yWindow,attr"`
			WindowWidth  string `xml:"windowWidth,attr"`
			WindowHeight string `xml:"windowHeight,attr"`
		} `xml:"workbookView"`
	} `xml:"bookViews"`
	Sheets struct {
		Text  string `xml:",chardata"`
		Sheet struct {
			Text    string `xml:",chardata"`
			Name    string `xml:"name,attr"`
			SheetId string `xml:"sheetId,attr"`
			ID      string `xml:"id,attr"`
		} `xml:"sheet"`
	} `xml:"sheets"`
	DefinedNames struct {
		Text        string `xml:",chardata"`
		DefinedName []struct {
			Text         string `xml:",chardata"` // Sheet5!$C$6:$C$7, 0.0001,...
			Name         string `xml:"name,attr"`
			LocalSheetId string `xml:"localSheetId,attr"`
			Hidden       string `xml:"hidden,attr"`
		} `xml:"definedName"`
	} `xml:"definedNames"`
	CalcPr struct {
		Text   string `xml:",chardata"`
		CalcId string `xml:"calcId,attr"`
	} `xml:"calcPr"`
}

Workbook was generated 2019-04-06 22:26:52 by rcir178 on rcir178-Latitude-E7470.

type Worksheet

type Worksheet struct {
	XMLName   xml.Name `xml:"worksheet"`
	Text      string   `xml:",chardata"`
	Xmlns     string   `xml:"xmlns,attr"`
	R         string   `xml:"r,attr"`
	Mc        string   `xml:"mc,attr"`
	X14ac     string   `xml:"x14ac,attr"`
	Ignorable string   `xml:"Ignorable,attr"`
	SortState []struct {
		Text          string `xml:",chardata"`
		Ref           string `xml:"ref,attr"`
		ColumnSort    string `xml:"columnSort,attr"`
		SortCondition []struct {
			Text       string `xml:",chardata"`
			SortBy     string `xml:"sortBy,attr"`
			Ref        string `xml:"ref,attr"`
			DxfId      string `xml:"dxfId,attr"`
			Descending string `xml:"descending,attr"`
			CustomList string `xml:"customList,attr"`
			IconSet    string `xml:"iconSet,attr"`
			IconId     string `xml:"iconId,attr"`
		} `xml:"sortCondition"`
	} `xml:"sortState"`
	AutoFilter []struct {
		Text         string `xml:",chardata"`
		Ref          string `xml:"ref,attr"`
		FilterColumn []struct {
			Text          string `xml:",chardata"`
			ColId         string `xml:"colId,attr"`
			CustomFilters struct {
				Text         string `xml:",chardata"`
				And          string `xml:"and,attr"`
				CustomFilter []struct {
					Text     string `xml:",chardata"`
					Val      string `xml:"val,attr"`
					Operator string `xml:"operator,attr"`
				} `xml:"customFilter"`
			} `xml:"customFilters"`
			Filters struct {
				Text   string `xml:",chardata"`
				Filter []struct {
					Text string `xml:",chardata"`
					Val  string `xml:"val,attr"`
				} `xml:"filter"`
				DateGroupItem []struct {
					Text             string `xml:",chardata"`
					Year             string `xml:"year,attr"`
					DateTimeGrouping string `xml:"dateTimeGrouping,attr"`
					Month            string `xml:"month,attr"`
					Day              string `xml:"day,attr"`
					Hour             string `xml:"hour,attr"`
					Minute           string `xml:"minute,attr"`
					Second           string `xml:"second,attr"`
				} `xml:"dateGroupItem"`
			} `xml:"filters"`
			Top10 struct {
				Text      string `xml:",chardata"`
				Val       string `xml:"val,attr"`
				FilterVal string `xml:"filterVal,attr"`
				Top       string `xml:"top,attr"`
			} `xml:"top10"`
			DynamicFilter struct {
				Text string `xml:",chardata"`
				Type string `xml:"type,attr"`
				Val  string `xml:"val,attr"`
			} `xml:"dynamicFilter"`
			ColorFilter struct {
				Text  string `xml:",chardata"`
				DxfId string `xml:"dxfId,attr"`
			} `xml:"colorFilter"`
		} `xml:"filterColumn"`
	} `xml:"autoFilter"`
	ConditionalFormatting []struct {
		Text   string `xml:",chardata"`
		Sqref  string `xml:"sqref,attr"`
		CfRule []struct {
			Text         string `xml:",chardata"`
			Type         string `xml:"type,attr"`
			DxfId        string `xml:"dxfId,attr"`
			Priority     string `xml:"priority,attr"`
			Operator     string `xml:"operator,attr"`
			AttrText     string `xml:"text,attr"`
			TimePeriod   string `xml:"timePeriod,attr"`
			AboveAverage string `xml:"aboveAverage,attr"`
			Percent      string `xml:"percent,attr"`
			Bottom       string `xml:"bottom,attr"`
			Rank         string `xml:"rank,attr"`
			Formula      []struct {
				Text string `xml:",chardata"` // 10, 20, 10, 20, 84, 99, 3...
			} `xml:"formula"`
			DataBar struct {
				Text string `xml:",chardata"`
				Cfvo []struct {
					Text string `xml:",chardata"`
					Type string `xml:"type,attr"`
				} `xml:"cfvo"`
				Color struct {
					Text string `xml:",chardata"`
					Rgb  string `xml:"rgb,attr"`
				} `xml:"color"`
			} `xml:"dataBar"`
			ExtLst struct {
				Text string `xml:",chardata"`
				Ext  struct {
					Text string `xml:",chardata"`
					X14  string `xml:"x14,attr"`
					URI  string `xml:"uri,attr"`
					ID   struct {
						Text string `xml:",chardata"` // {4D3A9FBE-0C2F-4905-AB07-...
					} `xml:"id"`
				} `xml:"ext"`
			} `xml:"extLst"`
			ColorScale struct {
				Text string `xml:",chardata"`
				Cfvo []struct {
					Text string `xml:",chardata"`
					Type string `xml:"type,attr"`
					Val  string `xml:"val,attr"`
				} `xml:"cfvo"`
				Color []struct {
					Text string `xml:",chardata"`
					Rgb  string `xml:"rgb,attr"`
				} `xml:"color"`
			} `xml:"colorScale"`
			IconSet struct {
				Text    string `xml:",chardata"`
				IconSet string `xml:"iconSet,attr"`
				Cfvo    []struct {
					Text string `xml:",chardata"`
					Type string `xml:"type,attr"`
					Val  string `xml:"val,attr"`
				} `xml:"cfvo"`
			} `xml:"iconSet"`
		} `xml:"cfRule"`
	} `xml:"conditionalFormatting"`
	PageMargins struct {
		Text   string `xml:",chardata"`
		Left   string `xml:"left,attr"`
		Right  string `xml:"right,attr"`
		Top    string `xml:"top,attr"`
		Bottom string `xml:"bottom,attr"`
		Header string `xml:"header,attr"`
		Footer string `xml:"footer,attr"`
	} `xml:"pageMargins"`
}

Worksheet was generated 2019-04-06 22:26:52 by rcir178 on rcir178-Latitude-E7470.