xmlDrawing.go 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486
  1. // Copyright 2016 - 2021 The excelize Authors. All rights reserved. Use of
  2. // this source code is governed by a BSD-style license that can be found in
  3. // the LICENSE file.
  4. //
  5. // Package excelize providing a set of functions that allow you to write to
  6. // and read from XLSX / XLSM / XLTM files. Supports reading and writing
  7. // spreadsheet documents generated by Microsoft Excel™ 2007 and later. Supports
  8. // complex components by high compatibility, and provided streaming API for
  9. // generating or reading data from a worksheet with huge amounts of data. This
  10. // library needs Go version 1.15 or later.
  11. package excelize
  12. import (
  13. "encoding/xml"
  14. "sync"
  15. )
  16. // Source relationship and namespace list, associated prefixes and schema in which it was
  17. // introduced.
  18. var (
  19. SourceRelationship = xml.Attr{Name: xml.Name{Local: "r", Space: "xmlns"}, Value: "http://schemas.openxmlformats.org/officeDocument/2006/relationships"}
  20. SourceRelationshipCompatibility = xml.Attr{Name: xml.Name{Local: "mc", Space: "xmlns"}, Value: "http://schemas.openxmlformats.org/markup-compatibility/2006"}
  21. SourceRelationshipChart20070802 = xml.Attr{Name: xml.Name{Local: "c14", Space: "xmlns"}, Value: "http://schemas.microsoft.com/office/drawing/2007/8/2/chart"}
  22. SourceRelationshipChart2014 = xml.Attr{Name: xml.Name{Local: "c16", Space: "xmlns"}, Value: "http://schemas.microsoft.com/office/drawing/2014/chart"}
  23. SourceRelationshipChart201506 = xml.Attr{Name: xml.Name{Local: "c16r2", Space: "xmlns"}, Value: "http://schemas.microsoft.com/office/drawing/2015/06/chart"}
  24. NameSpaceSpreadSheet = xml.Attr{Name: xml.Name{Local: "xmlns"}, Value: "http://schemas.openxmlformats.org/spreadsheetml/2006/main"}
  25. NameSpaceSpreadSheetX14 = xml.Attr{Name: xml.Name{Local: "x14", Space: "xmlns"}, Value: "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"}
  26. NameSpaceDrawingML = xml.Attr{Name: xml.Name{Local: "a", Space: "xmlns"}, Value: "http://schemas.openxmlformats.org/drawingml/2006/main"}
  27. NameSpaceDrawingMLChart = xml.Attr{Name: xml.Name{Local: "c", Space: "xmlns"}, Value: "http://schemas.openxmlformats.org/drawingml/2006/chart"}
  28. NameSpaceDrawingMLSpreadSheet = xml.Attr{Name: xml.Name{Local: "xdr", Space: "xmlns"}, Value: "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"}
  29. NameSpaceSpreadSheetX15 = xml.Attr{Name: xml.Name{Local: "x15", Space: "xmlns"}, Value: "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"}
  30. NameSpaceSpreadSheetExcel2006Main = xml.Attr{Name: xml.Name{Local: "xne", Space: "xmlns"}, Value: "http://schemas.microsoft.com/office/excel/2006/main"}
  31. NameSpaceMacExcel2008Main = xml.Attr{Name: xml.Name{Local: "mx", Space: "xmlns"}, Value: "http://schemas.microsoft.com/office/mac/excel/2008/main"}
  32. )
  33. // Source relationship and namespace.
  34. const (
  35. SourceRelationshipOfficeDocument = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument"
  36. SourceRelationshipChart = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart"
  37. SourceRelationshipComments = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments"
  38. SourceRelationshipImage = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/image"
  39. SourceRelationshipTable = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/table"
  40. SourceRelationshipDrawingML = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing"
  41. SourceRelationshipDrawingVML = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing"
  42. SourceRelationshipHyperLink = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink"
  43. SourceRelationshipWorkSheet = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet"
  44. SourceRelationshipChartsheet = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/chartsheet"
  45. SourceRelationshipDialogsheet = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/dialogsheet"
  46. SourceRelationshipPivotTable = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotTable"
  47. SourceRelationshipPivotCache = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotCacheDefinition"
  48. SourceRelationshipSharedStrings = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings"
  49. SourceRelationshipVBAProject = "http://schemas.microsoft.com/office/2006/relationships/vbaProject"
  50. NameSpaceXML = "http://www.w3.org/XML/1998/namespace"
  51. NameSpaceXMLSchemaInstance = "http://www.w3.org/2001/XMLSchema-instance"
  52. StrictSourceRelationship = "http://purl.oclc.org/ooxml/officeDocument/relationships"
  53. StrictSourceRelationshipOfficeDocument = "http://purl.oclc.org/ooxml/officeDocument/relationships/officeDocument"
  54. StrictSourceRelationshipChart = "http://purl.oclc.org/ooxml/officeDocument/relationships/chart"
  55. StrictSourceRelationshipComments = "http://purl.oclc.org/ooxml/officeDocument/relationships/comments"
  56. StrictSourceRelationshipImage = "http://purl.oclc.org/ooxml/officeDocument/relationships/image"
  57. StrictNameSpaceSpreadSheet = "http://purl.oclc.org/ooxml/spreadsheetml/main"
  58. NameSpaceDublinCore = "http://purl.org/dc/elements/1.1/"
  59. NameSpaceDublinCoreTerms = "http://purl.org/dc/terms/"
  60. NameSpaceDublinCoreMetadataIntiative = "http://purl.org/dc/dcmitype/"
  61. ContentTypeDrawing = "application/vnd.openxmlformats-officedocument.drawing+xml"
  62. ContentTypeDrawingML = "application/vnd.openxmlformats-officedocument.drawingml.chart+xml"
  63. ContentTypeMacro = "application/vnd.ms-excel.sheet.macroEnabled.main+xml"
  64. ContentTypeSpreadSheetMLChartsheet = "application/vnd.openxmlformats-officedocument.spreadsheetml.chartsheet+xml"
  65. ContentTypeSpreadSheetMLComments = "application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml"
  66. ContentTypeSpreadSheetMLPivotCacheDefinition = "application/vnd.openxmlformats-officedocument.spreadsheetml.pivotCacheDefinition+xml"
  67. ContentTypeSpreadSheetMLPivotTable = "application/vnd.openxmlformats-officedocument.spreadsheetml.pivotTable+xml"
  68. ContentTypeSpreadSheetMLSharedStrings = "application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"
  69. ContentTypeSpreadSheetMLTable = "application/vnd.openxmlformats-officedocument.spreadsheetml.table+xml"
  70. ContentTypeSpreadSheetMLWorksheet = "application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"
  71. ContentTypeVBA = "application/vnd.ms-office.vbaProject"
  72. ContentTypeVML = "application/vnd.openxmlformats-officedocument.vmlDrawing"
  73. // ExtURIConditionalFormattings is the extLst child element
  74. // ([ISO/IEC29500-1:2016] section 18.2.10) of the worksheet element
  75. // ([ISO/IEC29500-1:2016] section 18.3.1.99) is extended by the addition of
  76. // new child ext elements ([ISO/IEC29500-1:2016] section 18.2.7)
  77. ExtURIConditionalFormattings = "{78C0D931-6437-407D-A8EE-F0AAD7539E65}"
  78. ExtURIDataValidations = "{CCE6A557-97BC-4B89-ADB6-D9C93CAAB3DF}"
  79. ExtURISparklineGroups = "{05C60535-1F16-4fd2-B633-F4F36F0B64E0}"
  80. ExtURISlicerListX14 = "{A8765BA9-456A-4DAB-B4F3-ACF838C121DE}"
  81. ExtURISlicerCachesListX14 = "{BBE1A952-AA13-448e-AADC-164F8A28A991}"
  82. ExtURISlicerListX15 = "{3A4CF648-6AED-40f4-86FF-DC5316D8AED3}"
  83. ExtURIProtectedRanges = "{FC87AEE6-9EDD-4A0A-B7FB-166176984837}"
  84. ExtURIIgnoredErrors = "{01252117-D84E-4E92-8308-4BE1C098FCBB}"
  85. ExtURIWebExtensions = "{F7C9EE02-42E1-4005-9D12-6889AFFD525C}"
  86. ExtURITimelineRefs = "{7E03D99C-DC04-49d9-9315-930204A7B6E9}"
  87. ExtURIDrawingBlip = "{28A0092B-C50C-407E-A947-70E740481C1C}"
  88. ExtURIMacExcelMX = "{64002731-A6B0-56B0-2670-7721B7C09600}"
  89. )
  90. // Excel specifications and limits
  91. const (
  92. StreamChunkSize = 1 << 24
  93. MaxFontFamilyLength = 31
  94. MaxFontSize = 409
  95. MaxFileNameLength = 207
  96. MaxColumnWidth = 255
  97. MaxRowHeight = 409
  98. TotalRows = 1048576
  99. TotalColumns = 16384
  100. TotalSheetHyperlinks = 65529
  101. TotalCellChars = 32767
  102. // pivotTableVersion should be greater than 3. One or more of the
  103. // PivotTables chosen are created in a version of Excel earlier than
  104. // Excel 2007 or in compatibility mode. Slicer can only be used with
  105. // PivotTables created in Excel 2007 or a newer version of Excel.
  106. pivotTableVersion = 3
  107. )
  108. var supportImageTypes = map[string]string{".gif": ".gif", ".jpg": ".jpeg", ".jpeg": ".jpeg", ".png": ".png", ".tif": ".tiff", ".tiff": ".tiff"}
  109. // xlsxCNvPr directly maps the cNvPr (Non-Visual Drawing Properties). This
  110. // element specifies non-visual canvas properties. This allows for additional
  111. // information that does not affect the appearance of the picture to be stored.
  112. type xlsxCNvPr struct {
  113. ID int `xml:"id,attr"`
  114. Name string `xml:"name,attr"`
  115. Descr string `xml:"descr,attr"`
  116. Title string `xml:"title,attr,omitempty"`
  117. HlinkClick *xlsxHlinkClick `xml:"a:hlinkClick"`
  118. }
  119. // xlsxHlinkClick (Click Hyperlink) Specifies the on-click hyperlink
  120. // information to be applied to a run of text. When the hyperlink text is
  121. // clicked the link is fetched.
  122. type xlsxHlinkClick struct {
  123. R string `xml:"xmlns:r,attr,omitempty"`
  124. RID string `xml:"r:id,attr,omitempty"`
  125. InvalidURL string `xml:"invalidUrl,attr,omitempty"`
  126. Action string `xml:"action,attr,omitempty"`
  127. TgtFrame string `xml:"tgtFrame,attr,omitempty"`
  128. Tooltip string `xml:"tooltip,attr,omitempty"`
  129. History bool `xml:"history,attr,omitempty"`
  130. HighlightClick bool `xml:"highlightClick,attr,omitempty"`
  131. EndSnd bool `xml:"endSnd,attr,omitempty"`
  132. }
  133. // xlsxPicLocks directly maps the picLocks (Picture Locks). This element
  134. // specifies all locking properties for a graphic frame. These properties inform
  135. // the generating application about specific properties that have been
  136. // previously locked and thus should not be changed.
  137. type xlsxPicLocks struct {
  138. NoAdjustHandles bool `xml:"noAdjustHandles,attr,omitempty"`
  139. NoChangeArrowheads bool `xml:"noChangeArrowheads,attr,omitempty"`
  140. NoChangeAspect bool `xml:"noChangeAspect,attr"`
  141. NoChangeShapeType bool `xml:"noChangeShapeType,attr,omitempty"`
  142. NoCrop bool `xml:"noCrop,attr,omitempty"`
  143. NoEditPoints bool `xml:"noEditPoints,attr,omitempty"`
  144. NoGrp bool `xml:"noGrp,attr,omitempty"`
  145. NoMove bool `xml:"noMove,attr,omitempty"`
  146. NoResize bool `xml:"noResize,attr,omitempty"`
  147. NoRot bool `xml:"noRot,attr,omitempty"`
  148. NoSelect bool `xml:"noSelect,attr,omitempty"`
  149. }
  150. // xlsxBlip directly maps the blip element in the namespace
  151. // http://purl.oclc.org/ooxml/officeDoc ument/relationships - This element
  152. // specifies the existence of an image (binary large image or picture) and
  153. // contains a reference to the image data.
  154. type xlsxBlip struct {
  155. Embed string `xml:"r:embed,attr"`
  156. Cstate string `xml:"cstate,attr,omitempty"`
  157. R string `xml:"xmlns:r,attr"`
  158. }
  159. // xlsxStretch directly maps the stretch element. This element specifies that a
  160. // BLIP should be stretched to fill the target rectangle. The other option is a
  161. // tile where a BLIP is tiled to fill the available area.
  162. type xlsxStretch struct {
  163. FillRect string `xml:"a:fillRect"`
  164. }
  165. // xlsxOff directly maps the colOff and rowOff element. This element is used to
  166. // specify the column offset within a cell.
  167. type xlsxOff struct {
  168. X int `xml:"x,attr"`
  169. Y int `xml:"y,attr"`
  170. }
  171. // xlsxExt directly maps the ext element.
  172. type xlsxExt struct {
  173. Cx int `xml:"cx,attr"`
  174. Cy int `xml:"cy,attr"`
  175. }
  176. // xlsxPrstGeom directly maps the prstGeom (Preset geometry). This element
  177. // specifies when a preset geometric shape should be used instead of a custom
  178. // geometric shape. The generating application should be able to render all
  179. // preset geometries enumerated in the ST_ShapeType list.
  180. type xlsxPrstGeom struct {
  181. Prst string `xml:"prst,attr"`
  182. }
  183. // xlsxXfrm directly maps the xfrm (2D Transform for Graphic Frame). This
  184. // element specifies the transform to be applied to the corresponding graphic
  185. // frame. This transformation is applied to the graphic frame just as it would
  186. // be for a shape or group shape.
  187. type xlsxXfrm struct {
  188. Off xlsxOff `xml:"a:off"`
  189. Ext xlsxExt `xml:"a:ext"`
  190. }
  191. // xlsxCNvPicPr directly maps the cNvPicPr (Non-Visual Picture Drawing
  192. // Properties). This element specifies the non-visual properties for the picture
  193. // canvas. These properties are to be used by the generating application to
  194. // determine how certain properties are to be changed for the picture object in
  195. // question.
  196. type xlsxCNvPicPr struct {
  197. PicLocks xlsxPicLocks `xml:"a:picLocks"`
  198. }
  199. // directly maps the nvPicPr (Non-Visual Properties for a Picture). This element
  200. // specifies all non-visual properties for a picture. This element is a
  201. // container for the non-visual identification properties, shape properties and
  202. // application properties that are to be associated with a picture. This allows
  203. // for additional information that does not affect the appearance of the picture
  204. // to be stored.
  205. type xlsxNvPicPr struct {
  206. CNvPr xlsxCNvPr `xml:"xdr:cNvPr"`
  207. CNvPicPr xlsxCNvPicPr `xml:"xdr:cNvPicPr"`
  208. }
  209. // xlsxBlipFill directly maps the blipFill (Picture Fill). This element
  210. // specifies the kind of picture fill that the picture object has. Because a
  211. // picture has a picture fill already by default, it is possible to have two
  212. // fills specified for a picture object.
  213. type xlsxBlipFill struct {
  214. Blip xlsxBlip `xml:"a:blip"`
  215. Stretch xlsxStretch `xml:"a:stretch"`
  216. }
  217. // xlsxSpPr directly maps the spPr (Shape Properties). This element specifies
  218. // the visual shape properties that can be applied to a picture. These are the
  219. // same properties that are allowed to describe the visual properties of a shape
  220. // but are used here to describe the visual appearance of a picture within a
  221. // document.
  222. type xlsxSpPr struct {
  223. Xfrm xlsxXfrm `xml:"a:xfrm"`
  224. PrstGeom xlsxPrstGeom `xml:"a:prstGeom"`
  225. }
  226. // xlsxPic elements encompass the definition of pictures within the DrawingML
  227. // framework. While pictures are in many ways very similar to shapes they have
  228. // specific properties that are unique in order to optimize for picture-
  229. // specific scenarios.
  230. type xlsxPic struct {
  231. NvPicPr xlsxNvPicPr `xml:"xdr:nvPicPr"`
  232. BlipFill xlsxBlipFill `xml:"xdr:blipFill"`
  233. SpPr xlsxSpPr `xml:"xdr:spPr"`
  234. }
  235. // xlsxFrom specifies the starting anchor.
  236. type xlsxFrom struct {
  237. Col int `xml:"xdr:col"`
  238. ColOff int `xml:"xdr:colOff"`
  239. Row int `xml:"xdr:row"`
  240. RowOff int `xml:"xdr:rowOff"`
  241. }
  242. // xlsxTo directly specifies the ending anchor.
  243. type xlsxTo struct {
  244. Col int `xml:"xdr:col"`
  245. ColOff int `xml:"xdr:colOff"`
  246. Row int `xml:"xdr:row"`
  247. RowOff int `xml:"xdr:rowOff"`
  248. }
  249. // xdrClientData directly maps the clientData element. An empty element which
  250. // specifies (via attributes) certain properties related to printing and
  251. // selection of the drawing object. The fLocksWithSheet attribute (either true
  252. // or false) determines whether to disable selection when the sheet is
  253. // protected, and fPrintsWithSheet attribute (either true or false) determines
  254. // whether the object is printed when the sheet is printed.
  255. type xdrClientData struct {
  256. FLocksWithSheet bool `xml:"fLocksWithSheet,attr"`
  257. FPrintsWithSheet bool `xml:"fPrintsWithSheet,attr"`
  258. }
  259. // xdrCellAnchor directly maps the oneCellAnchor (One Cell Anchor Shape Size)
  260. // and twoCellAnchor (Two Cell Anchor Shape Size). This element specifies a two
  261. // cell anchor placeholder for a group, a shape, or a drawing element. It moves
  262. // with cells and its extents are in EMU units.
  263. type xdrCellAnchor struct {
  264. EditAs string `xml:"editAs,attr,omitempty"`
  265. Pos *xlsxPoint2D `xml:"xdr:pos"`
  266. From *xlsxFrom `xml:"xdr:from"`
  267. To *xlsxTo `xml:"xdr:to"`
  268. Ext *xlsxExt `xml:"xdr:ext"`
  269. Sp *xdrSp `xml:"xdr:sp"`
  270. Pic *xlsxPic `xml:"xdr:pic,omitempty"`
  271. GraphicFrame string `xml:",innerxml"`
  272. ClientData *xdrClientData `xml:"xdr:clientData"`
  273. }
  274. // xlsxPoint2D describes the position of a drawing element within a spreadsheet.
  275. type xlsxPoint2D struct {
  276. XMLName xml.Name `xml:"xdr:pos"`
  277. X int `xml:"x,attr"`
  278. Y int `xml:"y,attr"`
  279. }
  280. // xlsxWsDr directly maps the root element for a part of this content type shall
  281. // wsDr.
  282. type xlsxWsDr struct {
  283. sync.Mutex
  284. XMLName xml.Name `xml:"xdr:wsDr"`
  285. AbsoluteAnchor []*xdrCellAnchor `xml:"xdr:absoluteAnchor"`
  286. OneCellAnchor []*xdrCellAnchor `xml:"xdr:oneCellAnchor"`
  287. TwoCellAnchor []*xdrCellAnchor `xml:"xdr:twoCellAnchor"`
  288. A string `xml:"xmlns:a,attr,omitempty"`
  289. Xdr string `xml:"xmlns:xdr,attr,omitempty"`
  290. R string `xml:"xmlns:r,attr,omitempty"`
  291. }
  292. // xlsxGraphicFrame (Graphic Frame) directly maps the xdr:graphicFrame element.
  293. // This element specifies the existence of a graphics frame. This frame contains
  294. // a graphic that was generated by an external source and needs a container in
  295. // which to be displayed on the slide surface.
  296. type xlsxGraphicFrame struct {
  297. XMLName xml.Name `xml:"xdr:graphicFrame"`
  298. Macro string `xml:"macro,attr"`
  299. NvGraphicFramePr xlsxNvGraphicFramePr `xml:"xdr:nvGraphicFramePr"`
  300. Xfrm xlsxXfrm `xml:"xdr:xfrm"`
  301. Graphic *xlsxGraphic `xml:"a:graphic"`
  302. }
  303. // xlsxNvGraphicFramePr (Non-Visual Properties for a Graphic Frame) directly
  304. // maps the xdr:nvGraphicFramePr element. This element specifies all non-visual
  305. // properties for a graphic frame. This element is a container for the non-
  306. // visual identification properties, shape properties and application properties
  307. // that are to be associated with a graphic frame. This allows for additional
  308. // information that does not affect the appearance of the graphic frame to be
  309. // stored.
  310. type xlsxNvGraphicFramePr struct {
  311. CNvPr *xlsxCNvPr `xml:"xdr:cNvPr"`
  312. ChicNvGraphicFramePr string `xml:"xdr:cNvGraphicFramePr"`
  313. }
  314. // xlsxGraphic (Graphic Object) directly maps the a:graphic element. This
  315. // element specifies the existence of a single graphic object. Document authors
  316. // should refer to this element when they wish to persist a graphical object of
  317. // some kind. The specification for this graphical object is provided entirely
  318. // by the document author and referenced within the graphicData child element.
  319. type xlsxGraphic struct {
  320. GraphicData *xlsxGraphicData `xml:"a:graphicData"`
  321. }
  322. // xlsxGraphicData (Graphic Object Data) directly maps the a:graphicData
  323. // element. This element specifies the reference to a graphic object within the
  324. // document. This graphic object is provided entirely by the document authors
  325. // who choose to persist this data within the document.
  326. type xlsxGraphicData struct {
  327. URI string `xml:"uri,attr"`
  328. Chart *xlsxChart `xml:"c:chart,omitempty"`
  329. }
  330. // xlsxChart (Chart) directly maps the c:chart element.
  331. type xlsxChart struct {
  332. C string `xml:"xmlns:c,attr"`
  333. RID string `xml:"r:id,attr"`
  334. R string `xml:"xmlns:r,attr"`
  335. }
  336. // xdrSp (Shape) directly maps the xdr:sp element. This element specifies the
  337. // existence of a single shape. A shape can either be a preset or a custom
  338. // geometry, defined using the SpreadsheetDrawingML framework. In addition to a
  339. // geometry each shape can have both visual and non-visual properties attached.
  340. // Text and corresponding styling information can also be attached to a shape.
  341. // This shape is specified along with all other shapes within either the shape
  342. // tree or group shape elements.
  343. type xdrSp struct {
  344. Macro string `xml:"macro,attr"`
  345. Textlink string `xml:"textlink,attr"`
  346. NvSpPr *xdrNvSpPr `xml:"xdr:nvSpPr"`
  347. SpPr *xlsxSpPr `xml:"xdr:spPr"`
  348. Style *xdrStyle `xml:"xdr:style"`
  349. TxBody *xdrTxBody `xml:"xdr:txBody"`
  350. }
  351. // xdrNvSpPr (Non-Visual Properties for a Shape) directly maps the xdr:nvSpPr
  352. // element. This element specifies all non-visual properties for a shape. This
  353. // element is a container for the non-visual identification properties, shape
  354. // properties and application properties that are to be associated with a shape.
  355. // This allows for additional information that does not affect the appearance of
  356. // the shape to be stored.
  357. type xdrNvSpPr struct {
  358. CNvPr *xlsxCNvPr `xml:"xdr:cNvPr"`
  359. CNvSpPr *xdrCNvSpPr `xml:"xdr:cNvSpPr"`
  360. }
  361. // xdrCNvSpPr (Connection Non-Visual Shape Properties) directly maps the
  362. // xdr:cNvSpPr element. This element specifies the set of non-visual properties
  363. // for a connection shape. These properties specify all data about the
  364. // connection shape which do not affect its display within a spreadsheet.
  365. type xdrCNvSpPr struct {
  366. TxBox bool `xml:"txBox,attr"`
  367. }
  368. // xdrStyle (Shape Style) directly maps the xdr:style element. The element
  369. // specifies the style that is applied to a shape and the corresponding
  370. // references for each of the style components such as lines and fills.
  371. type xdrStyle struct {
  372. LnRef *aRef `xml:"a:lnRef"`
  373. FillRef *aRef `xml:"a:fillRef"`
  374. EffectRef *aRef `xml:"a:effectRef"`
  375. FontRef *aFontRef `xml:"a:fontRef"`
  376. }
  377. // aRef directly maps the a:lnRef, a:fillRef and a:effectRef element.
  378. type aRef struct {
  379. Idx int `xml:"idx,attr"`
  380. ScrgbClr *aScrgbClr `xml:"a:scrgbClr"`
  381. SchemeClr *attrValString `xml:"a:schemeClr"`
  382. SrgbClr *attrValString `xml:"a:srgbClr"`
  383. }
  384. // aScrgbClr (RGB Color Model - Percentage Variant) directly maps the a:scrgbClr
  385. // element. This element specifies a color using the red, green, blue RGB color
  386. // model. Each component, red, green, and blue is expressed as a percentage from
  387. // 0% to 100%. A linear gamma of 1.0 is assumed.
  388. type aScrgbClr struct {
  389. R float64 `xml:"r,attr"`
  390. G float64 `xml:"g,attr"`
  391. B float64 `xml:"b,attr"`
  392. }
  393. // aFontRef (Font Reference) directly maps the a:fontRef element. This element
  394. // represents a reference to a themed font. When used it specifies which themed
  395. // font to use along with a choice of color.
  396. type aFontRef struct {
  397. Idx string `xml:"idx,attr"`
  398. SchemeClr *attrValString `xml:"a:schemeClr"`
  399. }
  400. // xdrTxBody (Shape Text Body) directly maps the xdr:txBody element. This
  401. // element specifies the existence of text to be contained within the
  402. // corresponding shape. All visible text and visible text related properties are
  403. // contained within this element. There can be multiple paragraphs and within
  404. // paragraphs multiple runs of text.
  405. type xdrTxBody struct {
  406. BodyPr *aBodyPr `xml:"a:bodyPr"`
  407. P []*aP `xml:"a:p"`
  408. }
  409. // formatPicture directly maps the format settings of the picture.
  410. type formatPicture struct {
  411. FPrintsWithSheet bool `json:"print_obj"`
  412. FLocksWithSheet bool `json:"locked"`
  413. NoChangeAspect bool `json:"lock_aspect_ratio"`
  414. Autofit bool `json:"autofit"`
  415. OffsetX int `json:"x_offset"`
  416. OffsetY int `json:"y_offset"`
  417. XScale float64 `json:"x_scale"`
  418. YScale float64 `json:"y_scale"`
  419. Hyperlink string `json:"hyperlink"`
  420. HyperlinkType string `json:"hyperlink_type"`
  421. Positioning string `json:"positioning"`
  422. }
  423. // formatShape directly maps the format settings of the shape.
  424. type formatShape struct {
  425. Type string `json:"type"`
  426. Width int `json:"width"`
  427. Height int `json:"height"`
  428. Format formatPicture `json:"format"`
  429. Color formatShapeColor `json:"color"`
  430. Paragraph []formatShapeParagraph `json:"paragraph"`
  431. }
  432. // formatShapeParagraph directly maps the format settings of the paragraph in
  433. // the shape.
  434. type formatShapeParagraph struct {
  435. Font Font `json:"font"`
  436. Text string `json:"text"`
  437. }
  438. // formatShapeColor directly maps the color settings of the shape.
  439. type formatShapeColor struct {
  440. Line string `json:"line"`
  441. Fill string `json:"fill"`
  442. Effect string `json:"effect"`
  443. }