| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235 | // Copyright 2016 - 2021 The excelize Authors. All rights reserved. Use of// this source code is governed by a BSD-style license that can be found in// the LICENSE file.//// Package excelize providing a set of functions that allow you to write to// and read from XLSX / XLSM / XLTM files. Supports reading and writing// spreadsheet documents generated by Microsoft Excel™ 2007 and later. Supports// complex components by high compatibility, and provided streaming API for// generating or reading data from a worksheet with huge amounts of data. This// library needs Go version 1.15 or later.package excelizeimport "encoding/xml"// decodeCellAnchor directly maps the oneCellAnchor (One Cell Anchor Shape// Size) and twoCellAnchor (Two Cell Anchor Shape Size). This element// specifies a two cell anchor placeholder for a group, a shape, or a drawing// element. It moves with cells and its extents are in EMU units.type decodeCellAnchor struct {	EditAs     string            `xml:"editAs,attr,omitempty"`	From       *decodeFrom       `xml:"from"`	To         *decodeTo         `xml:"to"`	Sp         *decodeSp         `xml:"sp"`	ClientData *decodeClientData `xml:"clientData"`	Content    string            `xml:",innerxml"`}// xdrSp (Shape) directly maps the sp element. This element specifies the// existence of a single shape. A shape can either be a preset or a custom// geometry, defined using the SpreadsheetDrawingML framework. In addition to// a geometry each shape can have both visual and non-visual properties// attached. Text and corresponding styling information can also be attached// to a shape. This shape is specified along with all other shapes within// either the shape tree or group shape elements.type decodeSp struct {	NvSpPr *decodeNvSpPr `xml:"nvSpPr"`	SpPr   *decodeSpPr   `xml:"spPr"`}// decodeSp (Non-Visual Properties for a Shape) directly maps the nvSpPr// element. This element specifies all non-visual properties for a shape. This// element is a container for the non-visual identification properties, shape// properties and application properties that are to be associated with a// shape. This allows for additional information that does not affect the// appearance of the shape to be stored.type decodeNvSpPr struct {	CNvPr   *decodeCNvPr   `xml:"cNvPr"`	ExtLst  *decodeExt     `xml:"extLst"`	CNvSpPr *decodeCNvSpPr `xml:"cNvSpPr"`}// decodeCNvSpPr (Connection Non-Visual Shape Properties) directly maps the// cNvSpPr element. This element specifies the set of non-visual properties// for a connection shape. These properties specify all data about the// connection shape which do not affect its display within a spreadsheet.type decodeCNvSpPr struct {	TxBox bool `xml:"txBox,attr"`}// decodeWsDr directly maps the root element for a part of this content type// shall wsDr. In order to solve the problem that the label structure is// changed after serialization and deserialization, two different structures// are defined. decodeWsDr just for deserialization.type decodeWsDr struct {	A             string              `xml:"xmlns a,attr"`	Xdr           string              `xml:"xmlns xdr,attr"`	R             string              `xml:"xmlns r,attr"`	OneCellAnchor []*decodeCellAnchor `xml:"oneCellAnchor,omitempty"`	TwoCellAnchor []*decodeCellAnchor `xml:"twoCellAnchor,omitempty"`	XMLName       xml.Name            `xml:"http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing wsDr,omitempty"`}// decodeTwoCellAnchor directly maps the oneCellAnchor (One Cell Anchor Shape// Size) and twoCellAnchor (Two Cell Anchor Shape Size). This element// specifies a two cell anchor placeholder for a group, a shape, or a drawing// element. It moves with cells and its extents are in EMU units.type decodeTwoCellAnchor struct {	From       *decodeFrom       `xml:"from"`	To         *decodeTo         `xml:"to"`	Pic        *decodePic        `xml:"pic,omitempty"`	ClientData *decodeClientData `xml:"clientData"`}// decodeCNvPr directly maps the cNvPr (Non-Visual Drawing Properties). This// element specifies non-visual canvas properties. This allows for additional// information that does not affect the appearance of the picture to be// stored.type decodeCNvPr struct {	ID    int    `xml:"id,attr"`	Name  string `xml:"name,attr"`	Descr string `xml:"descr,attr"`	Title string `xml:"title,attr,omitempty"`}// decodePicLocks directly maps the picLocks (Picture Locks). This element// specifies all locking properties for a graphic frame. These properties// inform the generating application about specific properties that have been// previously locked and thus should not be changed.type decodePicLocks struct {	NoAdjustHandles    bool `xml:"noAdjustHandles,attr,omitempty"`	NoChangeArrowheads bool `xml:"noChangeArrowheads,attr,omitempty"`	NoChangeAspect     bool `xml:"noChangeAspect,attr"`	NoChangeShapeType  bool `xml:"noChangeShapeType,attr,omitempty"`	NoCrop             bool `xml:"noCrop,attr,omitempty"`	NoEditPoints       bool `xml:"noEditPoints,attr,omitempty"`	NoGrp              bool `xml:"noGrp,attr,omitempty"`	NoMove             bool `xml:"noMove,attr,omitempty"`	NoResize           bool `xml:"noResize,attr,omitempty"`	NoRot              bool `xml:"noRot,attr,omitempty"`	NoSelect           bool `xml:"noSelect,attr,omitempty"`}// decodeBlip directly maps the blip element in the namespace// http://purl.oclc.org/ooxml/officeDoc ument/relationships - This element// specifies the existence of an image (binary large image or picture) and// contains a reference to the image data.type decodeBlip struct {	Embed  string `xml:"embed,attr"`	Cstate string `xml:"cstate,attr,omitempty"`	R      string `xml:"r,attr"`}// decodeStretch directly maps the stretch element. This element specifies// that a BLIP should be stretched to fill the target rectangle. The other// option is a tile where a BLIP is tiled to fill the available area.type decodeStretch struct {	FillRect string `xml:"fillRect"`}// decodeOff directly maps the colOff and rowOff element. This element is used// to specify the column offset within a cell.type decodeOff struct {	X int `xml:"x,attr"`	Y int `xml:"y,attr"`}// decodeExt directly maps the ext element.type decodeExt struct {	Cx int `xml:"cx,attr"`	Cy int `xml:"cy,attr"`}// decodePrstGeom directly maps the prstGeom (Preset geometry). This element// specifies when a preset geometric shape should be used instead of a custom// geometric shape. The generating application should be able to render all// preset geometries enumerated in the ST_ShapeType list.type decodePrstGeom struct {	Prst string `xml:"prst,attr"`}// decodeXfrm directly maps the xfrm (2D Transform for Graphic Frame). This// element specifies the transform to be applied to the corresponding graphic// frame. This transformation is applied to the graphic frame just as it would// be for a shape or group shape.type decodeXfrm struct {	Off decodeOff `xml:"off"`	Ext decodeExt `xml:"ext"`}// decodeCNvPicPr directly maps the cNvPicPr (Non-Visual Picture Drawing// Properties). This element specifies the non-visual properties for the picture// canvas. These properties are to be used by the generating application to// determine how certain properties are to be changed for the picture object in// question.type decodeCNvPicPr struct {	PicLocks decodePicLocks `xml:"picLocks"`}// directly maps the nvPicPr (Non-Visual Properties for a Picture). This// element specifies all non-visual properties for a picture. This element is// a container for the non-visual identification properties, shape properties// and application properties that are to be associated with a picture. This// allows for additional information that does not affect the appearance of// the picture to be stored.type decodeNvPicPr struct {	CNvPr    decodeCNvPr    `xml:"cNvPr"`	CNvPicPr decodeCNvPicPr `xml:"cNvPicPr"`}// decodeBlipFill directly maps the blipFill (Picture Fill). This element// specifies the kind of picture fill that the picture object has. Because a// picture has a picture fill already by default, it is possible to have two// fills specified for a picture object.type decodeBlipFill struct {	Blip    decodeBlip    `xml:"blip"`	Stretch decodeStretch `xml:"stretch"`}// decodeSpPr directly maps the spPr (Shape Properties). This element// specifies the visual shape properties that can be applied to a picture.// These are the same properties that are allowed to describe the visual// properties of a shape but are used here to describe the visual appearance// of a picture within a document.type decodeSpPr struct {	Xfrm     decodeXfrm     `xml:"xfrm"`	PrstGeom decodePrstGeom `xml:"prstGeom"`}// decodePic elements encompass the definition of pictures within the// DrawingML framework. While pictures are in many ways very similar to shapes// they have specific properties that are unique in order to optimize for// picture- specific scenarios.type decodePic struct {	NvPicPr  decodeNvPicPr  `xml:"nvPicPr"`	BlipFill decodeBlipFill `xml:"blipFill"`	SpPr     decodeSpPr     `xml:"spPr"`}// decodeFrom specifies the starting anchor.type decodeFrom struct {	Col    int `xml:"col"`	ColOff int `xml:"colOff"`	Row    int `xml:"row"`	RowOff int `xml:"rowOff"`}// decodeTo directly specifies the ending anchor.type decodeTo struct {	Col    int `xml:"col"`	ColOff int `xml:"colOff"`	Row    int `xml:"row"`	RowOff int `xml:"rowOff"`}// decodeClientData directly maps the clientData element. An empty element// which specifies (via attributes) certain properties related to printing and// selection of the drawing object. The fLocksWithSheet attribute (either true// or false) determines whether to disable selection when the sheet is// protected, and fPrintsWithSheet attribute (either true or false) determines// whether the object is printed when the sheet is printed.type decodeClientData struct {	FLocksWithSheet  bool `xml:"fLocksWithSheet,attr"`	FPrintsWithSheet bool `xml:"fPrintsWithSheet,attr"`}
 |