=      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~                                                                                                                                                               ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~None!"9;T)Set the namespace for the entire documentDThis follows the same policy that the rest of the xlsx package uses.The main namespace for Excel        NoneNone0(required attribute parsing)parsing optional attributes0Add sml namespace to name"#$%&'()*+,-./012345678"#$%&'()*+,-./0123&'0$%"#()*+,-./312"#$%&'()*+,-./012345678None!"o: Paper size;A2 paper (420 mm by 594 mm)<A3 paper (297 mm by 420 mm)=!A3 extra paper (322 mm by 445 mm)>,A3 extra transverse paper (322 mm by 445 mm)?&A3 transverse paper (297 mm by 420 mm)@A4 paper (210 mm by 297 mm)A!A4 extra paper (236 mm by 322 mm)B A4 plus paper (210 mm by 330 mm)C!A4 small paper (210 mm by 297 mm)D&A4 transverse paper (210 mm by 297 mm)EA5 paper (148 mm by 210 mm)F!A5 extra paper (174 mm by 235 mm)G&A5 transverse paper (148 mm by 210 mm)HB4 paper (250 mm by 353 mm)IB5 paper (176 mm by 250 mm)JC paper (17 in. by 22 in.)KD paper (22 in. by 34 in.)LE paper (34 in. by 44 in.)M&Executive paper (7.25 in. by 10.5 in.)N(German legal fanfold (8.5 in. by 13 in.)O+German standard fanfold (8.5 in. by 12 in.)P*US standard fanfold (14.875 in. by 11 in.)QFolio paper (8.5 in. by 13 in.)RISO B4 (250 mm by 353 mm)S%ISO B5 extra paper (201 mm by 276 mm)T+Japanese double postcard (200 mm by 148 mm)U*JIS B5 transverse paper (182 mm by 257 mm)VLedger paper (17 in. by 11 in.)WLegal paper (8.5 in. by 14 in.)X'Legal extra paper (9.275 in. by 15 in.)Y Letter paper (8.5 in. by 11 in.)Z(Letter extra paper (9.275 in. by 12 in.)[3Letter extra transverse paper (9.275 in. by 12 in.)\(Letter plus paper (8.5 in. by 12.69 in.)]&Letter small paper (8.5 in. by 11 in.)^-Letter transverse paper (8.275 in. by 11 in.)_Note paper (8.5 in. by 11 in.)`Quarto paper (215 mm by 275 mm)a Standard paper (9 in. by 11 in.)b!Standard paper (10 in. by 11 in.)c!Standard paper (10 in. by 14 in.)d!Standard paper (11 in. by 17 in.)e!Standard paper (15 in. by 11 in.)f$Statement paper (5.5 in. by 8.5 in.)gSuperASuperAA4 paper (227 mm by 356 mm)hSuperBSuperBA3 paper (305 mm by 487 mm)i Tabloid paper (11 in. by 17 in.)j)Tabloid extra paper (11.69 in. by 18 in.)k%6 3/4 envelope (3.625 in. by 6.5 in.)l$#9 envelope (3.875 in. by 8.875 in.)m##10 envelope (4.125 in. by 9.5 in.)n$#11 envelope (4.5 in. by 10.375 in.)o!#12 envelope (4.75 in. by 11 in.)p #14 envelope (5 in. by 11.5 in.)qB4 envelope (250 mm by 353 mm)rB5 envelope (176 mm by 250 mm)sB6 envelope (176 mm by 125 mm)tC3 envelope (324 mm by 458 mm)uC4 envelope (229 mm by 324 mm)vC5 envelope (162 mm by 229 mm)wC6 envelope (114 mm by 162 mm)xC65 envelope (114 mm by 229 mm)yDL envelope (110 mm by 220 mm)z"Invite envelope (220 mm by 220 mm){!Italy envelope (110 mm by 230 mm)|(Monarch envelope (3.875 in. by 7.5 in.).}Specifies printed page order~4Order pages vertically first, then move horizontally4Order pages horizontally first, then move vertically Print orientation for this sheet Print errorsYThis enumeration specifies how to display cells with errors when printing the worksheet.Display cell errors as blankDisplay cell errors as dashes*Display cell errors as displayed on screenDisplay cell errors as #N/A Cell comments]These enumerations specify how cell comments shall be displayed for paper printing purposes.8See 18.18.5 "ST_CellComments (Cell Comments)" (p. 2441). Print cell comments as displayed&Print cell comments at end of documentDo not print cell commentsPrint black and white.4This attribute specifies how to print cell comments.Number of copies to print.Print without graphics.9Specifies how to print cell values for cells with errors.DPage number for first printed page. If no value is specified, then  automatic is assumed.#Number of vertical pages to fit on.%Number of horizontal pages to fit on.*Horizontal print resolution of the device.5Relationship Id of the devMode printer settings part.-(Explicit reference to a parent XML element.)ESee 22.8.2.1 "ST_RelationshipId (Explicit Relationship ID)" (p. 3784)Orientation of the page.Order of printed pagesAHeight of custom paper as a number followed by a unit identifier.VWhen paperHeight and paperWidth are specified, paperSize shall be ignored. Examples: "297mm", "11in".VSee 22.9.2.12 "ST_PositiveUniversalMeasure (Positive Universal Measurement)" (p. 3792) Pager sizeYWhen paperHeight, paperWidth, and paperUnits are specified, paperSize should be ignored.?Width of custom paper as a number followed by a unit identifier Examples: 21cm, 8.5inKWhen paperHeight and paperWidth are specified, paperSize shall be ignored.Print scaling.This attribute is restricted to values ranging from 10 to 400. This setting is overridden when fitToWidth and/or fitToHeight are in use.Use @ value for first page number, and do not auto number the pages.tUse the printer s defaults settings for page setup values and don't use the default values specified in the schema.Example: If dpi is not present or specified in the XML, the application must not assume 600dpi as specified in the schema as a default and instead must let the printer specify the default dpi.(Vertical print resolution of the device.See ST_Orientation , p. 3923See  ST_PrintError , p. 3923See ST_CellComments , p. 3923See  ST_PageOrder , p. 3923See  paperSize (attribute of  pageSetup ), p. 1659See  CT_PageSetup , p. 3922See  paperSize (attribute of  pageSetup ), p. 1659See  ST_PageOrder , p. 3923See ST_Orientation , p. 3923See  ST_PrintError , p. 3923See ST_CellComments , p. 3923See  CT_PageSetup , p. 3922:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~{:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~{}~:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|&:B;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~None!" Reading order:See 18.8.1 "alignment (Alignment)" (p. 1754, esp. p. 1755)AIndicates the style of fill pattern being used for a cell format.:Section 18.18.55 "ST_PatternType (Pattern Type)" (p. 2472)Vertical alignmentMSee 22.9.2.17 "ST_VerticalAlignRun (Vertical Positioning Location)" (p. 3794)Font underline property#See 18.4.13 "u (Underline)", p 1728 Font scheme;See 18.18.33 "ST_FontScheme (Font scheme Styles)" (p. 2456)+This font is the major font for this theme.+This font is the minor font for this theme.This font is not a theme font.  Font familyhSee 18.8.18 "family (Font Family)" (p. 1766) and 17.18.30 "ST_FontFamily (Font Family Value)" (p. 1388) Family is not applicable Proportional font with serifs  Proportional font without serifs %Monospace font with or without serifs;Script font designed to mimic the appearance of handwriting Novelty fontVertical alignment in cellsHSee 18.18.88 "ST_VerticalAlignment (Vertical Alignment Types)" (p. 2512)Horizontal alignment in cellsKSee 18.18.40 "ST_HorizontalAlignment (Horizontal Alignment Type)" (p. 2459)Protection propertiesContains protection properties associated with the cell. Each cell has protection properties that can be set. The cell protection properties do not take effect unless the sheet has been protected.>Section 18.8.33, "protection (Protection Properties)", p. 1793$  0 General% 1 0& 2 0.00' 3 #,##0(  4 #,##0.00) 9 0%* 10 0.00%+  11 0.00E+00, 12 # ?/?-  13 # ??/??.  14 mm-dd-yy/  15 d-mmm-yy0 16 d-mmm1  17 mmm-yy2  18 h:mm AM/PM3 19 h:mm:ss AM/PM4 20 h:mm5  21 h:mm:ss6 22 m/d/yy h:mm7 37 #,##0 ;(#,##0)8 38 #,##0 ;[Red](#,##0)9 39 #,##0.00;(#,##0.00): 40 #,##0.00;[Red](#,##0.00); 45 mm:ss<  46 [h]:mm:ss=  47 mmss.0>  48 ##0.0E+0? 49 @@PThis element defines the properties for one of the fonts used in this workbook.'Section 18.2.22 "font (Font)" (p. 1769)B,Displays characters in bold face font style.C9This element defines the font character set of this font.7This field is used in font creation and selection if a font of the given facename is not available on the system. Although it is not required to have around when resolving font facename, the information can be stored for when needed to help resolve which font face to use of all available fonts on a system.Charset represents the basic set of characters associated with a font (that it can display), and roughly corresponds to the ANSI codepage (8-bit or DBCS) of that character set used by a given language. Given more common use of Unicode where many fonts support more than one of the traditional charset categories, and the use of font linking, using charset to resolve font name is less and less common, but still can be useful.,These are operating-system-dependent values.FSection 18.4.1 "charset (Character Set)" provides some example values.DColorEMacintosh compatibility setting. Represents special word/character rendering on Macintosh, when this flag is set. The effect is to condense the text (squeeze it together). SpreadsheetML applications are not required to render according to this flag.F=This element specifies a compatibility setting used for previous spreadsheet applications, resulting in special word/character rendering on those legacy applications, when this flag is set. The effect extends or stretches out the text. SpreadsheetML applications are not required to render according to this flag.GThe font family this font belongs to. A font family is a set of fonts having common stroke width and serif characteristics. This is system level font information. The font name overrides when there are conflicting values.HDisplays characters in italic font style. The italic style is defined by the font at a system level and is not specified by ECMA-376.I2This element specifies the face name of this font.A string representing the name of the font. If the font doesn't exist (because it isn't installed on the system), or the charset not supported by that font, then another font should be substituted.AThe string length for this attribute shall be 0 to 31 characters.JtThis element displays only the inner and outer borders of each character. This is very similar to Bold in behavior.KDefines the font scheme, if any, to which this font belongs. When a font definition is part of a theme definition, then the font is categorized as either a major or minor font scheme component. When a new theme is chosen, every font that is part of a theme definition is updated to use the new major or minor font definition for that theme. Usually major fonts are used for styles like headings, and minor fonts are used for body and paragraph text.LMacintosh compatibility setting. Represents special word/character rendering on Macintosh, when this flag is set. The effect is to render a shadow behind, beneath and to the right of the text. SpreadsheetML applications are not required to render according to this flag.MSThis element draws a strikethrough line through the horizontal middle of the text.N[This element represents the point size (1/72 of an inch) of the Latin and East Asian text.O7This element represents the underline formatting style.PThis element adjusts the vertical position of the text relative to the text's default appearance for this run. It is used to get  superscript or  subscriptU texts, and shall reduce the font size (if a smaller size is available) accordingly.QThis element is used to specify cell fill information for pattern and solid color cell fills. For solid cell fills (no pattern), fgColor is used. For cell fills with patterns specified, then the cell fill color is specified by the bgColor element.1Section 18.8.32 "patternFill (Pattern)" (p. 1793)V'This element specifies fill formatting.^TODO: Gradient fills (18.8.4) are currently unsupported. If we add them, then the spec says (CT_FillO, p. 3935), _either_ a gradient _or_ a solid fill pattern should be specified.(Section 18.8.20, "fill (Fill)" (p. 1768)Y>One of the colors associated with the data bar or color scale.The I attribute (used for backwards compatibility only) is not modelled here.0See 18.3.1.15 "color (Data Bar Color)" (p. 1608)[NA boolean value indicating the color is automatic and system color dependent.\1Standard Alpha Red Green Blue color value (ARGB).This simple type's contents have a length of exactly 8 hexadecimal digit(s); see "18.18.86 ST_UnsignedIntHex (Hex Unsigned Integer)" (p. 2511).]A zero-based index into the  clrScheme2 collection (20.1.6.2), referencing a particular  sysClr or  srgbClr$ value expressed in the Theme part.^.Specifies the tint value applied to the color.lIf tint is supplied, then it is applied to the RGB value of the color to determine the final color applied.The tint value is stored as a double from -1.0 .. 1.0, where -1.0 means 100% darken and 1.0 means 100% lighten. Also, 0.0 means no change._Border style See  CT_BorderPr (p. 3934)cvExpresses a single set of cell border formats (left, right, top, bottom, diagonal). Color is optional. When missing,  automatic is implied.&See 18.8.4 "border (Border)" (p. 1759)eA boolean value indicating if the cell's diagonal border includes a diagonal line, starting at the top left corner of the cell and moving down to the bottom right corner of the cell.fA boolean value indicating if the cell's diagonal border includes a diagonal line, starting at the bottom left corner of the cell and moving up to the top right corner of the cell.g~A boolean value indicating if left, right, top, and bottom borders should be applied only to outside borders of a cell range.h Bottom borderiDiagonaljTrailing edge border See also kHorizontal inner bordersl Left border(NOTE: The spec does not formally list a left. border element, but the examples do mention left* and the scheme contains it too. See also .m Right border(NOTE: The spec does not formally list a right. border element, but the examples do mention right* and the scheme contains it too. See also .nLeading edge border See also o Top borderpVertical inner borderq Alignment,See 18.8.1 "alignment (Alignment)" (p. 1754)s4Specifies the type of horizontal alignment in cells.tAn integer value, where an increment of 1 represents 3 spaces. Indicates the number of spaces (of the normal style font) of indentation for text in a cell.uA boolean value indicating if the cells justified or distributed alignment should be used on the last line of text. (This is typical for East Asian alignments but not typical in other contexts.)vAn integer value indicating whether the reading order (bidirectionality) of the cell is leftto- right, right-to-left, or context dependent.wAn integer value (used only in a dxf element) to indicate the additional number of spaces of indentation to adjust for text in a cell.xA boolean value indicating if the displayed text in the cell should be shrunk to fit the cell width. Not applicable when a cell contains multiple lines of text.yText rotation in cells. Expressed in degrees. Values range from 0 to 180. The first letter of the text is considered the center-point of the arc.zVertical alignment in cells.{YA boolean value indicating if the text in a cell should be line-wrapped within the cell.|Cell formatting TODO: The extLst field is currently unsupported.'Section 18.8.45 "xf (Format)" (p. 1800)~eA boolean value indicating whether the alignment formatting specified for this xf should be applied.bA boolean value indicating whether the border formatting specified for this xf should be applied.`A boolean value indicating whether the fill formatting specified for this xf should be applied.`A boolean value indicating whether the font formatting specified for this xf should be applied.bA boolean value indicating whether the number formatting specified for this xf should be applied.fA boolean value indicating whether the protection formatting specified for this xf should be applied.?Zero-based index of the border record used by this cell format.(18.18.2, p. 2437).=Zero-based index of the fill record used by this cell format.(18.18.30, p. 2455)=Zero-based index of the font record used by this cell format.7An integer that represents a zero based index into the 4 collection in the style sheet (18.18.32, p. 2456).AId of the number format (numFmt) record used by this cell format.This simple type defines the identifier to a style sheet number format entry in CT_NumFmts. Number formats are written to the styles part (18.18.47, p. 2468). See also 18.8.31 (p. 1784) for more information on number formats.GTODO: The numFmts part of the style sheet is currently not implemented.^A boolean value indicating whether the cell rendering includes a pivot table dropdown button.A boolean value indicating whether the text string in a cell should be prefixed by a single quote mark (e.g., 'text). In these cases, the quote is not stored in the Shared Strings Part.For xf records contained in cellXfs this is the zero-based index of an xf record contained in cellStyleXfs corresponding to the cell style applied to the cell.5Not present for xf records contained in cellStyleXfs.Used by xf records and cellStyle records to reference xf records defined in the cellStyleXfs collection. (18.18.10, p. 2442) TODO: the cellStyleXfs field of a style sheet not currently implemented.Formatting information pertaining to text alignment in cells. There are a variety of choices for how text is aligned both horizontally and vertically, as well as indentation settings, and so on.Contains protection properties associated with the cell. Each cell has protection properties that can be set. The cell protection properties do not take effect unless the sheet has been protected.StyleSheet for an XML document;Relevant parts of the EMCA standard (4th edition, part 1,  Ehttp://www.ecma-international.org/publications/standards/Ecma-376.htmc), page numbers refer to the page in the PDF rather than the page number as printed on the page): Chapter 12,  SpreadsheetMLA (p. 74) In particular Section 12.3.20, "Styles Part" (p. 104)XChapter 18, "SpreadsheetML Reference Material" (p. 1528) In particular Section 18.8, Styles (p. 1754) and Section 18.8.39 "styleSheet" (Style Sheet)" (p. 1796); it is the latter section that specifies the top-level style sheet format.#TODO: the following child elements: cellStyles cellStyleXfscolorsdxfsextLstnumFmts tableStyles9NOTE: You will probably want to base your style sheet on  . See also: to translate a  to Styles for a higher level interface. to translate a raw  into StyleswThis element contains borders formatting information, specifying all border definitions for all cells in the workbook.-Section 18.8.5, "borders (Borders)" (p. 1760) Cell formatsThis element contains the master formatting records (xf) which define the formatting applied to cells in this workbook. These records are the starting point for determining the formatting for a cell. Cells in the Sheet Part reference the xf records by zero-based index.3Section 18.8.10, "cellXfs (Cell Formats)" (p. 1764)This element defines the cell fills portion of the Styles part, consisting of a sequence of fill records. A cell fill consists of a background color, foreground color, and pattern to be applied across the cell.*Section 18.8.21, "fills (Fills)" (p. 1768)=This element contains all font definitions for this workbook.)Section 18.8.23 "fonts (Fonts)" (p. 1769)Minimal style sheet~Excel expects some minimal definitions in the stylesheet; you probably want to define your own stylesheets based on this one.2This more-or-less follows the recommendations at  ]http://stackoverflow.com/questions/26050708/minimal-style-sheet-for-excel-open-xml-with-dates:, but with some additions based on experimental evidence.See CT_CellProtection , p. 4484See CT_CellAlignment , p. 4482See CT_Xf , p. 4486See  CT_Border , p. 4483See CT_PatternFill , p. 4484See CT_Fill , p. 4484#See CT_Color , p. 4484%See CT_Font , p. 4489&See  CT_Stylesheet , p. 44820See CT_CellProtection , p. 44841See CT_Font , p. 44892See CT_PatternFill , p. 44843See CT_Fill , p. 44844See CT_Color , p. 44845See  CT_BorderPr , p. 44836See  CT_Border , p. 44837See CT_CellAlignment , p. 44828See CT_Xf , p. 44869See  CT_Stylesheet , p. 44825      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCD      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~     |}~qrstuvwxyz{cdefghijklmnop_`abYZ[\]^VWXQRSTU@ABCDEFGHIJKLMNOP#$%&'()*+,-./0123456789:;<=>? !"                !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abc defghijklmnopq rstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDNone!"ERun properties0Section 18.4.7, "rPr (Run Properties)" (p. 1725)G,Displays characters in bold face font style.$Section 18.8.2, "b (Bold)" (p. 1757)H9This element defines the font character set of this font.3Section 18.4.1, "charset (Character Set)" (p. 1721)I>One of the colors associated with the data bar or color scale.5Section 18.3.1.15, "color (Data Bar Color)" (p. 1608)JMacintosh compatibility setting. Represents special word/character rendering on Macintosh, when this flag is set. The effect is to condense the text (squeeze it together).0Section 18.8.12, "condense (Condense)" (p. 1764)KThis element specifies a compatibility setting used for previous spreadsheet applications, resulting in special word/character rendering on those legacy applications, when this flag is set. The effect extends or stretches out the text.,Section 18.8.17, "extend (Extend)" (p. 1766)LThe font family this font belongs to. A font family is a set of fonts having common stroke width and serif characteristics. This is system level font information. The font name overrides when there are conflicting values.1Section 18.8.18, "family (Font Family)" (p. 1766)MDisplays characters in italic font style. The italic style is defined by the font at a system level and is not specified by ECMA-376.'Section 18.8.26, "i (Italic)" (p. 1773)NtThis element displays only the inner and outer borders of each character. This is very similar to Bold in behavior.-Section 18.4.2, "outline (Outline)" (p. 1722)OYThis element is a string representing the name of the font assigned to display this run.(Section 18.4.5, "rFont (Font)" (p. 1724)PDefines the font scheme, if any, to which this font belongs. When a font definition is part of a theme definition, then the font is categorized as either a major or minor font scheme component. When a new theme is chosen, every font that is part of a theme definition is updated to use the new major or minor font definition for that theme. Usually major fonts are used for styles like headings, and minor fonts are used for body and paragraph text.,Section 18.8.35, "scheme (Scheme)" (p. 1794)QMacintosh compatibility setting. Represents special word/character rendering on Macintosh, when this flag is set. The effect is to render a shadow behind, beneath and to the right of the text.,Section 18.8.36, "shadow (Shadow)" (p. 1795)RSThis element draws a strikethrough line through the horizontal middle of the text.4Section 18.4.10, "strike (Strike Through)" (p. 1726)S[This element represents the point size (1/72 of an inch) of the Latin and East Asian text.+Section 18.4.11, "sz (Font Size)" (p. 1727)T7This element represents the underline formatting style.*Section 18.4.13, "u (Underline)" (p. 1728)UThis element adjusts the vertical position of the text relative to the text's default appearance for this run. It is used to get  superscript or  subscriptU texts, and shall reduce the font size (if a smaller size is available) accordingly.;Section 18.4.14, "vertAlign (Vertical Alignment)" (p. 1728)V Rich Text RunThis element represents a run of rich text. A rich text run is a region of text that share a common set of properties, such as formatting properties.-Section 18.4.4, "r (Rich Text Run)" (p. 1724)X\This element represents a set of properties to apply to the contents of this rich text run.YCThis element represents the text content shown as part of a string.NOTE: V[ elements with an empty text field will result in an error when opening the file in Excel.%Section 18.4.12, "t (Text)" (p. 1727)qApply properties to a VIf the Vg specifies its own properties, then these overrule the properties specified here. For example, adding bold to a V which is already italic will make the V both  bold and Qitalic@ but adding it to one that that is explicitly _not_ bold will leave the V unchanged.rThe  instance for E4 is biased: later properties override earlier ones.sSee  CT_RPrElt , p. 3903tSee CT_RElt , p. 3903uSee  CT_RPrElt , p. 3903vSee CT_RElt , p. 3903.EFGHIJKLMNOPQRSTUVWXY`abcdefghijklmnopqrstuvwx'EFGHIJKLMNOPQRSTUVWXY`abcdefghijklmnopq'VWXYEFGHIJKLMNOPQRSTUq`abcdefhijgklnmopEFGHIJKLMNOPQRSTUVWXY`abcdefghijklmnopqrstuvwxNoneyMCommon type containing either simple string or rich formatted text. Used in si, comment and is elementsE.g. si spec says: "If the string is just a simple string with formatting applied at the cell level, then the String Item (si) should contain a single text element used to express the string. However, if the string in the cell is more complex - i.e., has formatting applied at the character level - then the string item shall consist of multiple rich text runs which collectively are used to express the string.". So we have either a single Text field, or else a list of  RichTextRuns, each of which is some Text with layout properties."TODO: Currently we do not support  phoneticPr, (Phonetic Properties, 18.4.3, p. 1723) or rPh! (Phonetic Run, 18.4.6, p. 1725).,Section 18.4.8, "si (String Item)" (p. 1725)See CT_Rst , p. 3903|Excel cell reference (e.g. E3) see 18.18.62 ST_Ref (p. 2482)}See CT_Rst , p. 3903~See CT_Rst , p. 3903yz{|}~yz{||yz{yz{|}~ None!"User comment for a cellCTODO: the following child elements: * guid * shapeId * commentPr,Section 18.7.3 "comment (Comment)" (p. 1749)Rcell comment text, maybe formatted Section 18.7.7 "text (Comment Text)" (p. 1754)comment author    None!";State of the sheet's pane.6Section 18.18.53 "ST_PaneState (Pane State)" (p. 2711)Panes are frozen, but were not split being frozen. In this state, when the panes are unfrozen again, a single pane results, with no split. In this state, the split bars are not adjustable.Panes are frozen and were split before being frozen. In this state, when the panes are unfrozen again, the split remains, but is adjustable.[Panes are split, but not frozen. In this state, the split bars are adjustable by the user. Pane type1Section 18.18.52 "ST_Pane (Pane Types)" (p. 2710)GBottom left pane, when both vertical and horizontal splits are applied.This value is also used when only a horizontal split has been applied, dividing the pane into upper and lower regions. In that case, this value specifies the bottom pane.DTop left pane, when both vertical and horizontal splits are applied.This value is also used when only a horizontal split has been applied, dividing the pane into upper and lower regions. In that case, this value specifies the top pane.This value is also used when only a vertical split has been applied, dividing the pane into right and left regions. In that case, this value specifies the left paneETop right pane, when both vertical and horizontal splits are applied.This value is also used when only a vertical split has been applied, dividing the pane into right and left regions. In that case, this value specifies the right pane.View setting of the sheet?Section 18.18.69 "ST_SheetViewType (Sheet View Type)" (p. 2726) Normal viewPage break previewPage layout viewWorksheet view pane.Section 18.3.1.66 "pane (View Pane)" (p. 1843)The pane that is active.bIndicates whether the pane has horizontal / vertical splits, and whether those splits are frozen.]Location of the top left visible cell in the bottom right pane (when in Left-To-Right mode).Horizontal position of the split, in 1/20th of a point; 0 (zero) if none. If the pane is frozen, this value indicates the number of columns visible in the top pane.Vertical position of the split, in 1/20th of a point; 0 (zero) if none. If the pane is frozen, this value indicates the number of rows visible in the left pane.Worksheet view selection.3Section 18.3.1.78 "selection (Selection)" (p. 1864)Location of the active cell0-based index of the range reference (in the array of references listed in sqref) containing the active cell. Only used when the selection in sqref is not contiguous. Therefore, this value needs to be aware of the order in which the range references are written in sqref.<When this value is out of range then activeCell can be used.)The pane to which this selection belongs.<Range of the selection. Can be non-contiguous set of ranges.Worksheet viewA single sheet view definition. When more than one sheet view is defined in the file, it means that when opening the workbook, each sheet view corresponds to a separate window within the spreadsheet application, where each window is showing the particular sheet containing the same workbookViewId value, the last sheetView definition is loaded, and the others are discarded. When multiple windows are viewing the same sheet, multiple sheetView elements (with corresponding workbookView entries) are saved. TODO: The pivotSelection and extLst child elements are unsupported.<See Section 18.3.1.87 "sheetView (Worksheet View)" (p. 1880)Index to the color value for row/column text headings and gridlines. This is an 'index color value' (ICV) rather than rgb value.Flag indicating that the consuming application should use the default grid lines color (system dependent). Overrides any color specified in colorId.Flag indicating whether the sheet is in 'right to left' display mode. When in this mode, Column A is on the far right, Column B ;is one column left of Column A, and so on. Also, information in cells is displayed in the Right to Left format.;Flag indicating whether this sheet should display formulas.<Flag indicating whether this sheet should display gridlines.Flag indicating whether the sheet has outline symbols visible. This flag shall always override SheetPr element's outlinePr child element whose attribute is named showOutlineSymbols when there is a conflict.IFlag indicating whether the sheet should display row and column headings.#Show the ruler in Page Layout View.Flag indicating whether page layout view shall display margins. False means do not display left, right, top (header), and bottom (footer) margins (even when there is data in the header or footer).Flag indicating whether the window should show 0 (zero) in cells containing zero value. When false, cells with zero value appear blank instead of showing the number zero.Flag indicating whether this sheet is selected. When only 1 sheet is selected and active, this value should be in synch with the activeTab value. In case of a conflict, the Start Part setting wins and sets the active sheet tab.QMultiple sheets can be selected, but only one sheet shall be active at one time.Location of the top left visible cell Location of the top left visible cell in the bottom right pane (when in Left-to-Right mode).Indicates the view type.Flag indicating whether the panes in the window are locked due to workbook protection. This is an option when the workbook structure is protected.hZero-based index of this workbook view, pointing to a workbookView element in the bookViews collection.!NOTE: This attribute is required.Window zoom magnification for current view representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.Zoom magnification to use when in normal view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.Zoom magnification to use when in page layout view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.Zoom magnification to use when in page break preview, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.Worksheet view paneWorksheet view selection#Minimum of 0, maximum of 4 elementsRender sheet views7The list should be non-empty to be conform to the spec.:See Section 18.3.1.88 "sheetViews (Sheet Views)" (p. 1704)See  ST_PaneState , p. 3929See ST_Pane , p. 3914See ST_SheetViewType , p. 3913See  CT_Selection , p. 3914See CT_Pane , p. 3913See  CT_SheetView , p. 3913See  ST_PaneState , p. 3929See ST_Pane , p. 3914See ST_SheetViewType , p. 3913See CT_Pane , p. 3913See  CT_Selection , p. 3914See  CT_SheetView , p. 3913 NOTE: The  instance for  sets the required attribute  to 0._PP4 None -Add doc props variant types namespace to name                        None'Add custom properties namespace to nameFMTID_UserDefinedProperties    None!"#>Describes relationships according to Open Packaging ConventionTSee ECMA-376, 4th Edition Office Open XML File Formats  Open Packaging Conventions/Hjoins relative URI (actually a file path as an internal relation target)2*Add package relationship namespace to name32Add office document relationship namespace to name#$%&'()*+,-./0123456789:;#$%&'()*+,-./0123456&'()#$%*+,-./0;:981723456#$%&'()*+,-./0123456789:;None!"@SCurrently cell details include only cell values and style ids (e.g. formulas from <f> and inline strings from <is> subelements are ignored)ECell values include text, numbers and booleans, standard includes date format also but actually dates are represented by numbers with a date format assigned to a cell containing itNXlsx worksheetP column widthsQ)custom row properties (height, style) mapR"data mapped by (row, column) pairsSlist of cell mergesVExcel range (e.g. D13:H14)W(Column range (from cwMin to cwMax) widthaMap containing cell values which are indexed by row and column if you need to use more traditional (x,y) indexing please you could use corresponding accessors from 'o Defined namesNEach defined name consists of a name, an optional local sheet ID, and a value.This element defines the collection of defined names for this workbook. Defined names are descriptive names to represent cells, ranges of cells, formulas, or constant values. Defined names can be used to represent a range on any worksheet.LExcel also defines a number of reserved names with a special interpretation:_xlnm.Print_Area8 specifies the workbook's print area. Example value: SheetName!$A:$A,SheetName!$1:$4_xlnm.Print_TitlesP specifies the row(s) or column(s) to repeat at the top of each printed page._xlnm.Sheet_Title:refers to a sheet title.gand others. See Section 18.2.6, "definedNames (Defined Names)" (p. 1728) of the spec (second edition).GNOTE: Right now this is only a minimal implementation of defined names.qKStructured representation of Xlsx file (currently a subset of its contents)Render $This is used to render a structured  into a raw XML w document. Actually  replacing w with & would mean we would need to write a parser for  as well (and would moreover require that we support the full style sheet specification, which is still quite a bit of work).Parse This is used to parse raw w into structured t currently not all of the style sheet specification is supported so parser (and the data model) is to be completedKconvert column number (starting from 1) to its textual form (e.g. 3 -> "C") reverse to ~converts cells mapped by (row, column) into rows which contain row index and cells as pairs of column indices and cell values reverse to Render position in  (row, col) format to an Excel reference. mkCellRef (2, 4) == "D2" Render range  mkRange (2, 4) (6, 8) == "D2:H6"D@ABCDEFGHINOPQRSTUVWXYZ[\]^_`abcdefopqrstuvwxyz{|}~P:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~     EFGHIJKLMNOPQRSTUVWXY`abcdefghijklmnopqyz{|     @ABCDEFGHINOPQRSTUVWXYZ[\]^_`abcdopqrstuvwxyz{|}~UqrstuvwxyopWXYZ[\NOPQRSTU{~z|}aEFGHI@ABCDdcb]^_`V%@ABCDEFGHINOPQRSTUVWXYZ[\]^_`abcdefopqrstuvwxyz{|}~NoneOT 'lens giving access to a worksheet from q object by its name variant of  lenslens giving access to a cell in some worksheet by its position, by default row+column index is used so this lens is a synonym of "lens to access cell in a worksheetJlens to access cell in a worksheet using more traditional x+y coordinatesHaccessor that can read, write or delete cell in a worksheet synonym of  so uses row+column index1lens to read, write or delete cell in a worksheetalens to read, write or delete cell in a worksheet using more traditional x+y or row+column indexblens to read, write or delete cell value in a worksheet with row+column coordinates, synonym for  cellValueRCblens to read, write or delete cell value in a worksheet using row+column coordinates of that cellZlens to read, write or delete cell value in a worksheet using traditional x+y coordinates    None!"Shared string tablelA workbook can contain thousands of cells containing string (non-numeric) data. Furthermore this data is very likely to be repeated across many rows or columns. The goal of implementing a single string table that is shared across the workbook is to improve performance in opening and saving the file by only reading and writing the repetitive information once.;Relevant parts of the EMCA standard (2nd edition, part 1,  Ehttp://www.ecma-international.org/publications/standards/Ecma-376.htmc), page numbers refer to the page in the PDF rather than the page number as printed on the page):wSection 18.4, "Shared String Table" (p. 1712) in particular subsection 18.4.9, "sst (Shared String Table)" (p. 1726) TODO: The extLst( child element is currently unsupported.Construct the SharedStringsTable from an existing document Internal generalization used by  and See CT_Sst , p. 3902The optional attributes count and  uniqCount% are being ignored at least currentlySee CT_Sst , p. 3902. TODO: The count and  uniqCount& attributes are currently unsupported.  NoneLReads q from raw data (lazy bytestring)>Get xml cursor from the specified file inside the zip archive.Get shared string table@readWorkbook pulls the names of the sheets and the defined names NoneWrites q to raw data (lazy bytestring)fully qualified XML name6fully qualified XML name from prefix to ns URL mappingtCreates an element with the given name, attributes and children, if there is at least one child. Otherwise returns .XCreates an element with the given name, attributes and children. Always returns a node/."          None!"OT In reverse orderCell with formattingSee  for more details.TODOs:Add a number format (, )*Add references to the named style sheets ()Result of formattingSee  The final a; see RThe final stylesheet; see t (and )#The final list of cell merges; see S1Higher level API for creating formatted documents0Creating formatted Excel spreadsheets using the @3 datatype directly, even with the support for the ; datatype, is fairly painful. This has a number of causes:The @ datatype wants an 7 for the style, which is supposed to point into the  part of a stylesheet. However, this can be difficult to work with, as it requires manual tracking of cell style IDs, which in turns requires manual tracking of font IDs, border IDs, etc.LRow-span and column-span properties are set on the worksheet as a whole (|") rather than on individual cells.Excel does not correctly deal with borders on cells that span multiple columns or rows. Instead, these rows must be set on all the edge cells in the block. Again, this means that this becomes a global property of the spreadsheet rather than properties of individual cells.<This function deals with all these problems. Given a map of s, which refer directly to @s, cs, etc. (rather than font IDs, border IDs, etc.), and an initial stylesheet, it recovers all possible sharing, constructs IDs, and then constructs the final a6, as well as the final stylesheet and list of merges.If you don't already have a ) you want to use as starting point then  is a good choice.3Format a cell with (potentially) rowspan or colspan%Cell block corresponding to a single  A single U might have a colspan or rowspan greater than 1. Although Excel obviously supports cell merges, it does not correctly apply borders to the cells covered by the rowspan or colspan. Therefore we create a block of cells in this function; the top-left is the cell proper, and the remaining cells are the cells covered by the rowspan/colspan.0Also returns the cell merge instruction, if any.2 !"#  !"#None]:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~     EFGHIJKLMNOPQRSTUVWXY`abcdefghijklmnopqyz{|     @ABCDEFGHINOPQRSTUVWXYZ[\]^_`abcdopqrstuvwxyz{|}~$ !"#$%&'()*+,-./01234556789:;<=>??@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./01234566789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVVWXYZ[\]^_`abcdeffghijjkllmnopqqrsttuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRRSTUVWXYZ[\]^_`abbcdefghijklmnopqrstuvwxyz{|}~                                                                                                                                                              ! " # $ % % & ' ' ( )   * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < =>>?@ABCDEFGHIJKKLMNOPQRSSTUVWXYZ[\]^_`abcdefghijjkklmnoppqrstuvwxyz{|}~      !xlsx-0.2.2-8J53s6dWTjNJQDrM3qwIAXCodec.Xlsx.TypesCodec.Xlsx.Writer.InternalCodec.Xlsx.Types.InternalCodec.Xlsx.Parser.InternalCodec.Xlsx.Types.PageSetupCodec.Xlsx.Types.StyleSheetCodec.Xlsx.Types.RichTextCodec.Xlsx.Types.CommonCodec.Xlsx.Types.CommentsCodec.Xlsx.Types.SheetViewsCodec.Xlsx.Types.Variant*Codec.Xlsx.Types.Internal.CustomProperties'Codec.Xlsx.Types.Internal.RelationshipsCodec.Xlsx.Lens+Codec.Xlsx.Types.Internal.SharedStringTableCodec.Xlsx.ParserCodec.Xlsx.WriterCodec.Xlsx.FormattedrenderStyleSheet formattedparseStyleSheet Codec.XlsxLens'.data-default-class-0.1.0-ZjH3KaYloVKL0hubzEvlkData.Default.Classdef ToAttrVal toAttrVal ToElement toElement ToDocument toDocumentdocumentFromElementdocumentFromNsElementcountedElementListelementListSimpleelementContentelementContentPreserved elementValue.=.=?setAttraddNS mainNamespacetxtdtxtbtxti$fToAttrValBool$fToAttrValDouble$fToAttrValInt $fToAttrVal[]$fToAttrValTextRefIdunRefId$fToAttrValRefId $fShowRefId $fEqRefId $fOrdRefId FromAttrVal fromAttrVal FromCursor fromCursorParseException fromAttributemaybeAttributemaybeElementValuemaybeFromElement readSuccess readFailure invalidTextdefaultReadFailurendecimalrationalboolean$fFromAttrValBool$fFromAttrValDouble$fFromAttrValInt$fFromAttrValText$fExceptionParseException$fShowParseException PaperSizePaperA2PaperA3 PaperA3ExtraPaperA3ExtraTransversePaperA3TransversePaperA4 PaperA4Extra PaperA4Plus PaperA4SmallPaperA4TransversePaperA5 PaperA5ExtraPaperA5TransversePaperB4PaperB5PaperCPaperDPaperEPaperExecutivePaperFanfoldGermanLegalPaperFanfoldGermanStandardPaperFanfoldUsStandard PaperFolio PaperIsoB4PaperIsoB5ExtraPaperJapaneseDoublePostcardPaperJisB5Transverse PaperLedger PaperLegalPaperLegalExtra PaperLetterPaperLetterExtraPaperLetterExtraTransversePaperLetterPlusPaperLetterSmallPaperLetterTransverse PaperNote PaperQuartoPaperStandard9_11PaperStandard10_11PaperStandard10_14PaperStandard11_17PaperStandard15_11PaperStatement PaperSuperA PaperSuperB PaperTabloidPaperTabloidExtra Envelope6_3_4 Envelope9 Envelope10 Envelope11 Envelope12 Envelope14 EnvelopeB4 EnvelopeB5 EnvelopeB6 EnvelopeC3 EnvelopeC4 EnvelopeC5 EnvelopeC6 EnvelopeC65 EnvelopeDLEnvelopeInvite EnvelopeItalyEnvelopeMonarch PageOrderPageOrderDownThenOverPageOrderOverThenDown OrientationOrientationDefaultOrientationLandscapeOrientationPortrait PrintErrorsPrintErrorsBlankPrintErrorsDashPrintErrorsDisplayed PrintErrorsNA CellCommentsCellCommentsAsDisplayedCellCommentsAtEndCellCommentsNone PageSetup_pageSetupBlackAndWhite_pageSetupCellComments_pageSetupCopies_pageSetupDraft_pageSetupErrors_pageSetupFirstPageNumber_pageSetupFitToHeight_pageSetupFitToWidth_pageSetupHorizontalDpi _pageSetupId_pageSetupOrientation_pageSetupPageOrder_pageSetupPaperHeight_pageSetupPaperSize_pageSetupPaperWidth_pageSetupScale_pageSetupUseFirstPageNumber_pageSetupUsePrinterDefaults_pageSetupVerticalDpi$fDefaultPageSetup$fShowCellComments$fEqCellComments$fOrdCellComments$fShowPrintErrors$fEqPrintErrors$fOrdPrintErrors$fShowOrientation$fEqOrientation$fOrdOrientation$fShowPageOrder $fEqPageOrder$fOrdPageOrder$fShowPaperSize $fEqPaperSize$fOrdPaperSize$fShowPageSetup $fEqPageSetup$fOrdPageSetuppageSetupBlackAndWhitepageSetupCellCommentspageSetupCopiespageSetupDraftpageSetupErrorspageSetupFirstPageNumberpageSetupFitToHeightpageSetupFitToWidthpageSetupHorizontalDpi pageSetupIdpageSetupOrientationpageSetupPageOrderpageSetupPaperHeightpageSetupPaperSizepageSetupPaperWidthpageSetupScalepageSetupUseFirstPageNumberpageSetupUsePrinterDefaultspageSetupVerticalDpi$fFromAttrValOrientation$fFromAttrValPrintErrors$fFromAttrValCellComments$fFromAttrValPageOrder$fFromAttrValPaperSize$fFromCursorPageSetup$fToAttrValPaperSize$fToAttrValPageOrder$fToAttrValOrientation$fToAttrValPrintErrors$fToAttrValCellComments$fToElementPageSetup ReadingOrderReadingOrderContextDependentReadingOrderLeftToRightReadingOrderRightToLeft PatternTypePatternTypeDarkDownPatternTypeDarkGrayPatternTypeDarkGridPatternTypeDarkHorizontalPatternTypeDarkTrellisPatternTypeDarkUpPatternTypeDarkVerticalPatternTypeGray0625PatternTypeGray125PatternTypeLightDownPatternTypeLightGrayPatternTypeLightGridPatternTypeLightHorizontalPatternTypeLightTrellisPatternTypeLightUpPatternTypeLightVerticalPatternTypeMediumGrayPatternTypeNonePatternTypeSolid LineStyleLineStyleDashDotLineStyleDashDotDotLineStyleDashedLineStyleDottedLineStyleDouble LineStyleHairLineStyleMediumLineStyleMediumDashDotLineStyleMediumDashDotDotLineStyleMediumDashed LineStyleNoneLineStyleSlantDashDotLineStyleThick LineStyleThinFontVerticalAlignmentFontVerticalAlignmentBaselineFontVerticalAlignmentSubscript FontVerticalAlignmentSuperscript FontUnderlineFontUnderlineSingleFontUnderlineDoubleFontUnderlineSingleAccountingFontUnderlineDoubleAccountingFontUnderlineNone FontSchemeFontSchemeMajorFontSchemeMinorFontSchemeNone FontFamilyFontFamilyNotApplicableFontFamilyRomanFontFamilySwissFontFamilyModernFontFamilyScriptFontFamilyDecorativeCellVerticalAlignmentCellVerticalAlignmentBottomCellVerticalAlignmentCenter CellVerticalAlignmentDistributedCellVerticalAlignmentJustifyCellVerticalAlignmentTopCellHorizontalAlignmentCellHorizontalAlignmentCenter'CellHorizontalAlignmentCenterContinuous"CellHorizontalAlignmentDistributedCellHorizontalAlignmentFillCellHorizontalAlignmentGeneralCellHorizontalAlignmentJustifyCellHorizontalAlignmentLeftCellHorizontalAlignmentRight Protection_protectionHidden_protectionLocked NumberFormat NfGeneralNfZero Nf2Decimal NfMax3DecimalNfThousandSeparator2Decimal NfPercentNfPercent2DecimalNfExponent2DecimalNfSingleSpacedFractionNfDoubleSpacedFractionNfMmDdYyNfDMmmYyNfDMmmNfMmmYy NfHMm12Hr NfHMmSs12HrNfHMmNfHMmSsNfMdyHMmNfThousandsNegativeParensNfThousandsNegativeRed!NfThousands2DecimalNegativeParensNfTousands2DecimalNEgativeRedNfMmSs NfOptHMmSsNfMmSs1DecimalNfExponent1DecimalNfTextPlaceHolderFont _fontBold _fontCharset _fontColor _fontCondense _fontExtend _fontFamily _fontItalic _fontName _fontOutline _fontScheme _fontShadow_fontStrikeThrough _fontSize_fontUnderline_fontVertAlign FillPattern_fillPatternBgColor_fillPatternFgColor_fillPatternTypeFill _fillPatternColor_colorAutomatic _colorARGB _colorTheme _colorTint BorderStyle_borderStyleColor_borderStyleLineBorder_borderDiagonalDown_borderDiagonalUp_borderOutline _borderBottom_borderDiagonal _borderEnd_borderHorizontal _borderLeft _borderRight _borderStart _borderTop_borderVertical Alignment_alignmentHorizontal_alignmentIndent_alignmentJustifyLastLine_alignmentReadingOrder_alignmentRelativeIndent_alignmentShrinkToFit_alignmentTextRotation_alignmentVertical_alignmentWrapTextCellXf_cellXfApplyAlignment_cellXfApplyBorder_cellXfApplyFill_cellXfApplyFont_cellXfApplyNumberFormat_cellXfApplyProtection_cellXfBorderId _cellXfFillId _cellXfFontId_cellXfNumFmtId_cellXfPivotButton_cellXfQuotePrefix _cellXfId_cellXfAlignment_cellXfProtection StyleSheet_styleSheetBorders_styleSheetCellXfs_styleSheetFills_styleSheetFontsnumberFormatId $fShowColor $fEqColor $fOrdColor$fShowNumberFormat$fEqNumberFormat$fOrdNumberFormat$fShowProtection$fEqProtection$fOrdProtection$fShowCellHorizontalAlignment$fEqCellHorizontalAlignment$fOrdCellHorizontalAlignment$fShowCellVerticalAlignment$fEqCellVerticalAlignment$fOrdCellVerticalAlignment$fShowFontFamily$fEqFontFamily$fOrdFontFamily$fShowFontScheme$fEqFontScheme$fOrdFontScheme$fShowFontUnderline$fEqFontUnderline$fOrdFontUnderline$fShowFontVerticalAlignment$fEqFontVerticalAlignment$fOrdFontVerticalAlignment $fShowFont$fEqFont $fOrdFont$fShowLineStyle $fEqLineStyle$fOrdLineStyle$fShowBorderStyle$fEqBorderStyle$fOrdBorderStyle $fShowBorder $fEqBorder $fOrdBorder$fShowPatternType$fEqPatternType$fOrdPatternType$fShowFillPattern$fEqFillPattern$fOrdFillPattern $fShowFill$fEqFill $fOrdFill$fShowReadingOrder$fEqReadingOrder$fOrdReadingOrder$fShowAlignment $fEqAlignment$fOrdAlignment $fShowCellXf $fEqCellXf $fOrdCellXf$fShowStyleSheet$fEqStyleSheet$fOrdStyleSheetstyleSheetBordersstyleSheetCellXfsstyleSheetFillsstyleSheetFontscellXfAlignmentcellXfApplyAlignmentcellXfApplyBordercellXfApplyFillcellXfApplyFontcellXfApplyNumberFormatcellXfApplyProtectioncellXfBorderId cellXfFillId cellXfFontIdcellXfIdcellXfNumFmtIdcellXfPivotButtoncellXfProtectioncellXfQuotePrefixalignmentHorizontalalignmentIndentalignmentJustifyLastLinealignmentReadingOrderalignmentRelativeIndentalignmentShrinkToFitalignmentTextRotationalignmentVerticalalignmentWrapText borderBottomborderDiagonalborderDiagonalDownborderDiagonalUp borderEndborderHorizontal borderLeft borderOutline borderRight borderStart borderTopborderVerticalborderStyleColorborderStyleLine colorARGBcolorAutomatic colorTheme colorTint fillPatternfillPatternBgColorfillPatternFgColorfillPatternTypefontBold fontCharset fontColor fontCondense fontExtend fontFamily fontItalicfontName fontOutline fontScheme fontShadowfontSizefontStrikeThrough fontUnderline fontVertAlignprotectionHiddenprotectionLockedminimalStyleSheet$fFromCursorProtection$fFromAttrValReadingOrder"$fFromAttrValCellVerticalAlignment$$fFromAttrValCellHorizontalAlignment$fFromCursorAlignment$fFromCursorCellXf$fFromAttrValLineStyle$fFromCursorBorderStyle$fFromCursorBorder$fFromAttrValPatternType$fFromCursorFillPattern$fFromCursorFill$fFromAttrValFontScheme"$fFromAttrValFontVerticalAlignment$fFromAttrValFontUnderline$fFromCursorColor$fFromAttrValFontFamily$fFromCursorFont$fFromCursorStyleSheet$fToAttrValReadingOrder$fToAttrValPatternType$fToAttrValLineStyle $fToAttrValFontVerticalAlignment$fToAttrValFontUnderline$fToAttrValFontScheme$fToAttrValFontFamily $fToAttrValCellVerticalAlignment"$fToAttrValCellHorizontalAlignment$fToElementProtection$fToElementFont$fToElementFillPattern$fToElementFill$fToElementColor$fToElementBorderStyle$fToElementBorder$fToElementAlignment$fToElementCellXf$fToElementStyleSheet$fToDocumentStyleSheet$fDefaultProtection $fDefaultFont$fDefaultFillPattern $fDefaultFill$fDefaultColor$fDefaultBorderStyle$fDefaultBorder$fDefaultAlignment$fDefaultCellXf$fDefaultStyleSheet RunProperties_runPropertiesBold_runPropertiesCharset_runPropertiesColor_runPropertiesCondense_runPropertiesExtend_runPropertiesFontFamily_runPropertiesItalic_runPropertiesOutline_runPropertiesFont_runPropertiesScheme_runPropertiesShadow_runPropertiesStrikeThrough_runPropertiesSize_runPropertiesUnderline_runPropertiesVertAlign RichTextRun_richTextRunProperties_richTextRunText$fShowRunProperties$fEqRunProperties$fOrdRunProperties$fShowRichTextRun$fEqRichTextRun$fOrdRichTextRunrichTextRunPropertiesrichTextRunTextrunPropertiesBoldrunPropertiesCharsetrunPropertiesColorrunPropertiesCondenserunPropertiesExtendrunPropertiesFontrunPropertiesFontFamilyrunPropertiesItalicrunPropertiesOutlinerunPropertiesSchemerunPropertiesShadowrunPropertiesSizerunPropertiesStrikeThroughrunPropertiesUnderlinerunPropertiesVertAlignapplyRunProperties$fMonoidRunProperties$fFromCursorRunProperties$fFromCursorRichTextRun$fToElementRunProperties$fToElementRichTextRun$fDefaultRunProperties$fDefaultRichTextRunXlsxText XlsxRichTextCellRef$fFromCursorXlsxText$fToElementXlsxText$fShowXlsxText $fEqXlsxText $fOrdXlsxText CommentsTable_commentsTableComment _commentText_commentAuthorfromList lookupComment parseComment$fFromCursorCommentsTable$fToElementCommentsTable$fToDocumentCommentsTable $fShowComment $fEqComment$fShowCommentsTable$fEqCommentsTable PaneStatePaneStateFrozenPaneStateFrozenSplitPaneStateSplitPaneTypePaneTypeBottomLeftPaneTypeBottomRightPaneTypeTopLeftPaneTypeTopRight SheetViewTypeSheetViewTypeNormalSheetViewTypePageBreakPreviewSheetViewTypePageLayoutPane_paneActivePane _paneState_paneTopLeftCell _paneXSplit _paneYSplit Selection_selectionActiveCell_selectionActiveCellId_selectionPane_selectionSqref SheetView_sheetViewColorId_sheetViewDefaultGridColor_sheetViewRightToLeft_sheetViewShowFormulas_sheetViewShowGridLines_sheetViewShowOutlineSymbols_sheetViewShowRowColHeaders_sheetViewShowRuler_sheetViewShowWhiteSpace_sheetViewShowZeros_sheetViewTabSelected_sheetViewTopLeftCell_sheetViewType_sheetViewWindowProtection_sheetViewWorkbookViewId_sheetViewZoomScale_sheetViewZoomScaleNormal!_sheetViewZoomScalePageLayoutView"_sheetViewZoomScaleSheetLayoutView_sheetViewPane_sheetViewSelection$fShowSheetViewType$fEqSheetViewType$fOrdSheetViewType $fEqPaneType$fShowPaneType $fOrdPaneType$fShowSelection $fEqSelection$fOrdSelection $fEqPaneState$fShowPaneState$fOrdPaneState $fShowPane$fEqPane $fOrdPane$fShowSheetView $fEqSheetView$fOrdSheetViewsheetViewColorIdsheetViewDefaultGridColor sheetViewPanesheetViewRightToLeftsheetViewSelectionsheetViewShowFormulassheetViewShowGridLinessheetViewShowOutlineSymbolssheetViewShowRowColHeaderssheetViewShowRulersheetViewShowWhiteSpacesheetViewShowZerossheetViewTabSelectedsheetViewTopLeftCell sheetViewTypesheetViewWindowProtectionsheetViewWorkbookViewIdsheetViewZoomScalesheetViewZoomScaleNormal sheetViewZoomScalePageLayoutView!sheetViewZoomScaleSheetLayoutViewselectionActiveCellselectionActiveCellId selectionPaneselectionSqrefpaneActivePane paneStatepaneTopLeftCell paneXSplit paneYSplitrenderSheetViews$fFromAttrValPaneState$fFromAttrValPaneType$fFromAttrValSheetViewType$fFromCursorSelection$fFromCursorPane$fFromCursorSheetView$fToAttrValPaneState$fToAttrValPaneType$fToAttrValSheetViewType$fToElementPane$fToElementSelection$fToElementSheetView $fDefaultPane$fDefaultSelection$fDefaultSheetViewVariantVtBlobVtBool VtDecimalVtLpwstrVtIntvariantFromNodekillWhitespace decodeBase64vt docPropsVtNsvariantToElement$fFromCursorVariant $fEqVariant $fShowVariantCustomPropertyCustomPropertiesemptyparseCustomPropertyEntrycpr custPropNsuserDefinedFmtID$fToElementCustomProperty$fToElementCustomProperties$fToDocumentCustomProperties$fFromCursorCustomProperties$fShowCustomProperties$fEqCustomProperties RelationshipsrelMap RelationshiprelType relTargetrelEntrylookupsetTargetsFromjoinRel findRelByType parseRelEntryprodrodRelNspkgRelNs stdRelType$fFromCursorRelationship$fFromCursorRelationships$fToElementRelationship$fToElementRelationships$fToDocumentRelationships$fShowRelationship$fEqRelationship$fShowRelationships$fEqRelationshipsCell _cellStyle _cellValue _cellComment CellValueCellText CellDoubleCellBoolCellRich $fEqCellValue$fShowCellValue$fEqCell $fShowCell Worksheet _wsColumns_wsRowPropertiesMap_wsCells _wsMerges _wsSheetViews _wsPageSetupRange ColumnsWidthcwMincwMaxcwWidthcwStyle RowPropertiesRowProps rowHeightrowStyleCellMap cellComment cellStyle cellValue$fFromCursorColumnsWidth $fDefaultCell$fReadRowProperties$fEqRowProperties$fShowRowProperties$fOrdRowProperties$fEqColumnsWidth$fShowColumnsWidth $fEqWorksheet$fShowWorksheet DefinedNamesXlsx _xlSheets _xlStyles_xlDefinedNames_xlCustomPropertiesStylesunStyleswsCells wsColumnswsMerges wsPageSetupwsRowPropertiesMap wsSheetViews$fDefaultWorksheet $fEqStyles $fShowStyles$fEqDefinedNames$fShowDefinedNames$fEqXlsx $fShowXlsxxlCustomPropertiesxlDefinedNamesxlSheetsxlStyles emptyStylesint2colcol2inttoRowsfromRows mkCellRefmkRange$fDefaultDefinedNames $fDefaultXlsxixSheetatSheetixCellixCellRCixCellXYatCellatCellRCatCellXY cellValueAt cellValueAtRC cellValueAtXYSharedStringTablesstTable sstConstruct sstLookupText sstLookupRichsstItem$fFromCursorSharedStringTable$fToElementSharedStringTable$fToDocumentSharedStringTable$fShowSharedStringTable$fEqSharedStringTable$fOrdSharedStringTabletoXlsx$fShowWorksheetFilefromXlsx$fShowXlsxCellData$fEqXlsxCellData$fShowXlsxCell $fEqXlsxCell FormattedCell_formattedAlignment_formattedBorder_formattedFill_formattedFont_formattedNumberFormat_formattedProtection_formattedPivotButton_formattedQuotePrefix_formattedValue_formattedColSpan_formattedRowSpan$fShowFormattedCell$fEqFormattedCell FormattedformattedCellMapformattedStyleSheetformattedMergesformattedAlignmentformattedBorderformattedColSpan formattedFill formattedFontformattedNumberFormatformattedPivotButtonformattedProtectionformattedQuotePrefixformattedRowSpanformattedValue$fDefaultFormattedCell elementList0elementContent0 runReader lens-4.14-CmVK2r2d4Cq7eJoc4bbSvjControl.Lens.Internal.IndexedindexedbaseGHC.BaseMonoidDefaultControl.Lens.AtAt sstLookup xmlCursorgetSharedStrings readWorkbook WorksheetFilewfNamewfPath extractSheetextractCellValue getStyles getCommentsgetCustomProperties worksheetFilegetRelsintqNamensName nonEmptyNmElNothingjustNmElJustXlsxCell xlsxCellStyle xlsxCellValue xlsxComment XlsxCellDataXlsxSS XlsxDoubleXlsxBoolCellsFileDatafdName fdContentType fdContentssingleSheelFilescoreXmlappXml xlsxCellTypevaluetransformSheetDatasheetXmlbookXmlssXmlcustomPropsXmlbookRelscontentTypesXmlnmnEl_formattingMergesghc-prim GHC.TypesInt formatCell cellBlockFormattingState_formattingBorders_formattingCellXfs_formattingFills_formattingFontsformattingBordersformattingCellXfsformattingFillsformattingFontsformattingMergesstateFromStyleSheetstateToStyleSheetgetId cellStyleIdcellXf