(G0U      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~                                                                                                                         ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s t uvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTNone!"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 U    U NoneNone0)required attribute parsing*parsing optional attributes3Add sml namespace to name#$%&'()*+,-./012V3456789:;#$%&'()*+,-./0123456'(3%&#$)*+,-./012645#$%&'()*+,-./012V3456789:;None!"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)A,A3 extra transverse paper (322 mm by 445 mm)B&A3 transverse paper (297 mm by 420 mm)CA4 paper (210 mm by 297 mm)D!A4 extra paper (236 mm by 322 mm)E A4 plus paper (210 mm by 330 mm)F!A4 small paper (210 mm by 297 mm)G&A4 transverse paper (210 mm by 297 mm)HA5 paper (148 mm by 210 mm)I!A5 extra paper (174 mm by 235 mm)J&A5 transverse paper (148 mm by 210 mm)KB4 paper (250 mm by 353 mm)LB5 paper (176 mm by 250 mm)MC paper (17 in. by 22 in.)ND paper (22 in. by 34 in.)OE paper (34 in. by 44 in.)P&Executive paper (7.25 in. by 10.5 in.)Q(German legal fanfold (8.5 in. by 13 in.)R+German standard fanfold (8.5 in. by 12 in.)S*US standard fanfold (14.875 in. by 11 in.)TFolio paper (8.5 in. by 13 in.)UISO B4 (250 mm by 353 mm)V%ISO B5 extra paper (201 mm by 276 mm)W+Japanese double postcard (200 mm by 148 mm)X*JIS B5 transverse paper (182 mm by 257 mm)YLedger paper (17 in. by 11 in.)ZLegal paper (8.5 in. by 14 in.)['Legal extra paper (9.275 in. by 15 in.)\ Letter paper (8.5 in. by 11 in.)](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.)a-Letter transverse paper (8.275 in. by 11 in.)bNote paper (8.5 in. by 11 in.)cQuarto paper (215 mm by 275 mm)d Standard paper (9 in. by 11 in.)e!Standard paper (10 in. by 11 in.)f!Standard paper (10 in. by 14 in.)g!Standard paper (11 in. by 17 in.)h!Standard paper (15 in. by 11 in.)i$Statement paper (5.5 in. by 8.5 in.)jSuperASuperAA4 paper (227 mm by 356 mm)kSuperBSuperBA3 paper (305 mm by 487 mm)l Tabloid paper (11 in. by 17 in.)m)Tabloid extra paper (11.69 in. by 18 in.)n%6 3/4 envelope (3.625 in. by 6.5 in.)o$#9 envelope (3.875 in. by 8.875 in.)p##10 envelope (4.125 in. by 9.5 in.)q$#11 envelope (4.5 in. by 10.375 in.)r!#12 envelope (4.75 in. by 11 in.)s #14 envelope (5 in. by 11.5 in.)tB4 envelope (250 mm by 353 mm)uB5 envelope (176 mm by 250 mm)vB6 envelope (176 mm by 125 mm)wC3 envelope (324 mm by 458 mm)xC4 envelope (229 mm by 324 mm)yC5 envelope (162 mm by 229 mm)zC6 envelope (114 mm by 162 mm){C65 envelope (114 mm by 229 mm)|DL envelope (110 mm by 220 mm)}"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 order4Order 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 applicableProportional 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 # ?/?0  13 # ??/??1  14 mm-dd-yy2  15 d-mmm-yy3 16 d-mmm4  17 mmm-yy5  18 h:mm AM/PM6 19 h:mm:ss AM/PM7 20 h:mm8  21 h:mm:ss9 22 m/d/yy h:mm: 37 #,##0 ;(#,##0); 38 #,##0 ;[Red](#,##0)< 39 #,##0.00;(#,##0.00)= 40 #,##0.00;[Red](#,##0.00)> 45 mm:ss?  46 [h]:mm:ss@  47 mmss.0A  48 ##0.0E+0B 49 @CEA single dxf record, expressing incremental formatting to be applied.-Section 18.8.14, "dxf (Formatting)" (p. 1765)JPThis element defines the properties for one of the fonts used in this workbook.'Section 18.2.22 "font (Font)" (p. 1769)L,Displays characters in bold face font style.M9This 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.NColorOMacintosh 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.P=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.QThe 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.RDisplays characters in italic font style. The italic style is defined by the font at a system level and is not specified by ECMA-376.S2This 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.TtThis element displays only the inner and outer borders of each character. This is very similar to Bold in behavior.UDefines 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.VMacintosh 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.WSThis element draws a strikethrough line through the horizontal middle of the text.X[This element represents the point size (1/72 of an inch) of the Latin and East Asian text.Y7This element represents the underline formatting style.ZThis 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.[This 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)`'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)c>One of the colors associated with the data bar or color scale.The WI attribute (used for backwards compatibility only) is not modelled here.0See 18.3.1.15 "color (Data Bar Color)" (p. 1608)eNA boolean value indicating the color is automatic and system color dependent.f1Standard 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).gA zero-based index into the  clrScheme2 collection (20.1.6.2), referencing a particular  sysClr or  srgbClr$ value expressed in the Theme part.h.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.iBorder style See  CT_BorderPr (p. 3934)mvExpresses 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)oA 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.pA 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.q~A boolean value indicating if left, right, top, and bottom borders should be applied only to outside borders of a cell range.r Bottom bordersDiagonaltTrailing edge border See also uHorizontal inner bordersv 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  .w 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 .xLeading edge border See also y Top borderzVertical inner border{ Alignment,See 18.8.1 "alignment (Alignment)" (p. 1754)}4Specifies the type of horizontal alignment in cells.~An 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.A 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.)An integer value indicating whether the reading order (bidirectionality) of the cell is leftto- right, right-to-left, or context dependent.An integer value (used only in a dxf element) to indicate the additional number of spaces of indentation to adjust for text in a cell.A 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.Text 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.Vertical 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 cellStyleXfscolorsextLstnumFmts 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)Differential formatting*This element contains the master differential formatting records (dxf's) which define formatting for all non-cell formatting in this workbook. Whereas xf records fully specify a particular aspect of formatting (e.g., cell borders) by referencing those formatting definitions elsewhere in the Styles part, dxf records specify incremental (or differential) aspects of formatting directly inline within the dxf element. The dxf formatting is to be applied on top of or in addition to any formatting already present on the object using the dxf record.+Section 18.8.15, "dxfs (Formats)" (p. 1765)'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. 4484,See CT_CellAlignment , p. 4482-See CT_Dxf , p. 3937.See CT_Xf , p. 44861See  CT_Border , p. 44833See CT_PatternFill , p. 44844See CT_Fill , p. 44848See CT_Color , p. 448494See 18.18.94 "ST_FontFamily (Font Family)" (p. 2517):See CT_Font , p. 4489;See  CT_Stylesheet , p. 4482ESee CT_CellProtection , p. 4484FSee CT_Font , p. 4489GSee CT_PatternFill , p. 4484HSee CT_Fill , p. 4484ISee CT_Color , p. 4484JSee  CT_BorderPr , p. 4483KSee  CT_Border , p. 4483LSee CT_CellAlignment , p. 4482MSee CT_Dxf , p. 3937NSee CT_Xf , p. 4486OSee  CT_Stylesheet , p. 4482F      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&''{|}~mnopqrstuvwxyzijklcdefghCDEFGHI`ab[\]^_JKLMNOPQRSTUVWXYZ&'()*+,-./0123456789:;<=>?@AB"#$% !           "!#$%&      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklm nopqrstuvwxyz{ |}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[None!"\Run properties0Section 18.4.7, "rPr (Run Properties)" (p. 1725)^,Displays characters in bold face font style.$Section 18.8.2, "b (Bold)" (p. 1757)_9This element defines the font character set of this font.3Section 18.4.1, "charset (Character Set)" (p. 1721)`>One of the colors associated with the data bar or color scale.5Section 18.3.1.15, "color (Data Bar Color)" (p. 1608)aMacintosh 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)bThis 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)cThe 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)dDisplays 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)etThis 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)fYThis element is a string representing the name of the font assigned to display this run.(Section 18.4.5, "rFont (Font)" (p. 1724)gDefines 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)hMacintosh 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)iSThis element draws a strikethrough line through the horizontal middle of the text.4Section 18.4.10, "strike (Strike Through)" (p. 1726)j[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)k7This element represents the underline formatting style.*Section 18.4.13, "u (Underline)" (p. 1728)lThis 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)m 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)o\This element represents a set of properties to apply to the contents of this rich text run.pCThis element represents the text content shown as part of a string.NOTE: m[ 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)Apply properties to a mIf the mg specifies its own properties, then these overrule the properties specified here. For example, adding bold to a m which is already italic will make the m both  bold and Qitalic@ but adding it to one that that is explicitly _not_ bold will leave the m unchanged.The X instance for \4 is biased: later properties override earlier ones.See  CT_RPrElt , p. 3903See CT_RElt , p. 3903See  CT_RPrElt , p. 3903See CT_RElt , p. 3903.\]^_`abcdefghijklmnopwxyz{|}~'\]^_`abcdefghijklmnopwxyz{|}~'mnop\]^_`abcdefghijklwxyz{|}~\]^_`abcdefghijklmnopwxyz{|}~None A formula-See 18.18.35 "ST_Formula (Formula)" (p. 2457)MCommon 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. 3903Excel cell reference (e.g. E3) See 18.18.62 ST_Ref (p. 2482)See  ST_Formula , p. 3873hA sequence of cell references, space delimited. See 18.18.76, "ST_Sqref (Reference Sequence)", p. 2488.See CT_Rst , p. 3903See  ST_Formula , p. 3873See CT_Rst , p. 3903    NoneUser 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!"(JThis collection represents a description of a conditional formatting rule.>See 18.3.1.10 "cfRule (Conditional Formatting Rule)" (p. 1602)This is an index to a dxf element in the Styles Part indicating which cell formatting to apply when the conditional formatting rule criteria is met.The priority of this conditional formatting rule. This value is used to determine which format should be evaluated and rendered. Lower numeric values are higher priority than higher numeric values, where 1 is the highest priority.vIf this flag is set, no rules with lower priority shall be applied over this rule, when this rule evaluates to true.9Conditions which could be used for conditional formatting<See 18.18.12 "ST_CfType (Conditional Format Type)" (p. 2443)This conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values.jThis conditional formatting rule compares a cell value to a formula calculated result, using an operator.This conditional formatting rule highlights cells that are completely blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text.This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.This conditional formatting rule highlights cells that do not contain given text. Equivalent to using the SEARCH() sheet function.This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.|This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted._This conditional formatting rule highlights cells containing dates in the specified time period. The underlying value of the cell is evaluated, therefore the cell does not need to be formatted as a date to be evaluated. For example, with a cell containing the value 38913 the conditional format shall be applied if the rule requires a value of 7142006.Used in a "contains dates" conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting is refreshed / applied.:See 18.18.82 "ST_TimePeriod (Time Period Types)" (p. 2508)A date in the last seven days.+A date occuring in the last calendar month.A date occuring last week.+A date occuring in the next calendar month.A date occuring next week.'A date occuring in this calendar month.A date occuring this week. Today's date.Tomorrow's date.Yesterday's date.Logical operation used in  conditionYSee 18.18.15 "ST_ConditionalFormattingOperator (Conditional Format Operators)" (p. 2446)'Begins with' operatorBetween operatorContains operator'Ends with' operator'Equal to' operator'Greater than' operator#'Greater than or equal to' operator'Less than' operator 'Less than or equal to' operator'Not between' operator'Does not contain' operator'Not equal to' operator9YZ[\]00   YZ[\] 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 elementsORender sheet views7The list should be non-empty to be conform to the spec.:See Section 18.3.1.88 "sheetViews (Sheet Views)" (p. 1704)PSee  ST_PaneState , p. 3929QSee ST_Pane , p. 3914RSee ST_SheetViewType , p. 3913SSee  CT_Selection , p. 3914TSee CT_Pane , p. 3913USee  CT_SheetView , p. 3913VSee  ST_PaneState , p. 3929WSee ST_Pane , p. 3914XSee ST_SheetViewType , p. 3913YSee CT_Pane , p. 3913ZSee  CT_Selection , p. 3914[See  CT_SheetView , p. 3913^ NOTE: The ^ instance for  sets the required attribute  to 0._     123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^P     123456789:;<=>?@ABCDEFGHIJKLMNOP     O1246789:;<=>?@ABCDE35FGHIJKLMN4     123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^ Noneh-Add doc props variant types namespace to name _`abcdefghijk _`abcdefghij _`abcdkefghij_`abcdefghijk NonenInternal helper type for parsing "conditionalFormatting recods TODO: pivot, extList Implementing those will need this implementation to be changedHSee 18.3.1.18 "conditionalFormatting (Conditional Formatting)" (p. 1610)nopqrnopnoprqnopqrNone!" uvwxyz{|}uvwxyz uvwxy}|{zuvwxyz{|}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 ConventionsHjoins relative URI (actually a file path as an internal relation target)*Add package relationship namespace to name2Add office document relationship namespace to nameNone!"SCurrently cell details include only cell values and style ids (e.g. formulas from <f> and inline strings from <is> subelements are ignored)Cell 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 itXlsx worksheet column widths)custom row properties (height, style) map"data mapped by (row, column) pairslist of cell mergesExcel range (e.g. D13:H14)(Column range (from cwMin to cwMax) widthMap 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 ' 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.KStructured representation of Xlsx file (currently a subset of its contents)Render $This is used to render a structured  into a raw XML  document. Actually  replacing  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  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"F=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'\]^_`abcdefghijklmnopwxyz{|}~     123456789:;<=>?@ABCDEFGHIJKLMNO_`abcdefghijW&NoneOT 'lens giving access to a worksheet from  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 worksheet Jlens to access cell in a worksheet using more traditional x+y coordinates Haccessor that can read, write or delete cell in a worksheet synonym of   so uses row+column index 1lens to read, write or delete cell in a worksheet alens to read, write or delete cell in a worksheet using more traditional x+y or row+column index blens 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  from raw data (lazy bytestring)a>Get xml cursor from the specified file inside the zip archive.bGet shared string tablec@readWorkbook pulls the names of the sheets and the defined namesdefghiabjklcmno defghiabjklcmnoNoneWrites  to raw data (lazy bytestring)pfully qualified XML nameq6fully qualified XML name from prefix to ns URL mappingrtCreates an element with the given name, attributes and children, if there is at least one child. Otherwise returns s.tXCreates an element with the given name, attributes and children. Always returns a node/u."vwxyz{|}~pqrtvwxyz{|}~pqrtNone!"OT In reverse order&Cell with formattingSee M for more details.TODOs:Add a number format (, )*Add references to the named style sheets ();The resulting stylesheet<?The final map of conditional formatting rules applied to ranges=Result of formattingSee M? The final ; see @The final stylesheet; see  (and )A#The final list of cell merges; see M1Higher 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 Js, ms, etc. (rather than font IDs, border IDs, etc.), and an initial stylesheet, it recovers all possible sharing, constructs IDs, and then constructs the final 6, 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.E&'()*+,-./01234569:;<=>?@ABCDEFGHIJKLMNOP'&'()*+,-./01234569:;<=>?@ABCDEFGHIJKLMN'&'()*+,-./012=>?@AM9:;<NBCEFGIHJLDK3456'& '()*+,-./01234569:;<=>?@ABCDEFGHIJKLMNOPNone=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'\]^_`abcdefghijklmnopwxyz{|}~     123456789:;<=>?@ABCDEFGHIJKLMNO_`abcdefghij      !"#$%&'()*+,-./01234567899:;<=>?@ABCCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\\]^_`abbcdefghijklmnopqrrstuvvwxxyz{|}}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijkklmnopqrstuvwxyz{{|}~                                                                                                                     ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k l m n o p q r s s t u v w xyyz{|}~{{      !"#$%&'()*++,-../0123456789:;<=>?@ABCDEFGHIJK L M N O PQFRSTUVWXXYZ[\]^_`abcdeIJfgIJhiijklmnopqrrstuvwxyz{|}~!xlsx-0.2.3-GoYoQh2ngr78gwfakQx5ULCodec.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.Comment&Codec.Xlsx.Types.ConditionalFormattingCodec.Xlsx.Types.SheetViewsCodec.Xlsx.Types.Variant Codec.Xlsx.Types.Internal.CfPair&Codec.Xlsx.Types.Internal.CommentTable*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'1data-default-class-0.1.2.0-FYQpjIylblBDctdkHAFeXAData.Default.Classdef ToAttrVal toAttrVal ToElement toElement ToDocument toDocumentdocumentFromElementdocumentFromNsElementcountedElementList elementListelementListSimpleelementContentelementContentPreserved elementValue.=.=?setAttraddNS mainNamespacetxtdtxtbtxti$fToAttrValBool$fToAttrValDouble$fToAttrValInt $fToAttrVal[]$fToAttrValTextRefIdunRefId$fToAttrValRefId $fShowRefId $fEqRefId $fOrdRefId FromAttrVal fromAttrVal FromCursor fromCursorParseException fromAttributemaybeAttributemaybeElementValuemaybeElementValueDefmaybeBoolElemValuemaybeFromElement 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 NfOptHMmSsNfMmSs1DecimalNfExponent1DecimalNfTextPlaceHolderDxf_dxfFont_dxfFill _dxfAlignment _dxfBorder_dxfProtectionFont _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_styleSheetFonts_styleSheetDxfsnumberFormatId $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$fEqDxf$fOrdDxf $fShowDxf $fShowCellXf $fEqCellXf $fOrdCellXf$fShowStyleSheet$fEqStyleSheet$fOrdStyleSheetstyleSheetBordersstyleSheetCellXfsstyleSheetDxfsstyleSheetFillsstyleSheetFontscellXfAlignmentcellXfApplyAlignmentcellXfApplyBordercellXfApplyFillcellXfApplyFontcellXfApplyNumberFormatcellXfApplyProtectioncellXfBorderId cellXfFillId cellXfFontIdcellXfIdcellXfNumFmtIdcellXfPivotButtoncellXfProtectioncellXfQuotePrefix dxfAlignment dxfBorderdxfFilldxfFont dxfProtectionalignmentHorizontalalignmentIndentalignmentJustifyLastLinealignmentReadingOrderalignmentRelativeIndentalignmentShrinkToFitalignmentTextRotationalignmentVerticalalignmentWrapText 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$fFromCursorDxf$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$fToElementDxf$fToElementCellXf$fToElementStyleSheet$fToDocumentStyleSheet$fDefaultProtection $fDefaultFont$fDefaultFillPattern $fDefaultFill$fDefaultColor$fDefaultBorderStyle$fDefaultBorder$fDefaultAlignment $fDefaultDxf$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$fDefaultRichTextRunFormula unFormulaXlsxText XlsxRichTextSqRefCellRef$fToElementFormula$fToAttrValSqRef$fToElementXlsxText$fFromCursorFormula$fFromAttrValSqRef$fFromCursorXlsxText $fEqSqRef $fOrdSqRef $fShowSqRef$fShowXlsxText $fEqXlsxText $fOrdXlsxText $fEqFormula $fOrdFormula $fShowFormulaComment _commentText_commentAuthor $fShowComment $fEqCommentCfRule _cfrCondition _cfrDxfId _cfrPriority_cfrStopIfTrue Condition BeginsWithCellIsContainsBlanksContainsErrors ContainsTextDoesNotContainErrorsDoesNotContainBlanksDoesNotContainTextEndsWith Expression InTimePeriod TimePeriod PerLast7Days PerLastMonth PerLastWeek PerNextMonth PerNextWeek PerThisMonth PerThisWeekPerToday PerTomorrow PerYesterdayOperatorExpression OpBeginsWith OpBetweenOpContainsText OpEndsWithOpEqual OpGreaterThanOpGreaterThanOrEqual OpLessThanOpLessThanOrEqual OpNotBetween OpNotContains OpNotEqual$fEqOperatorExpression$fOrdOperatorExpression$fShowOperatorExpression$fEqTimePeriod$fOrdTimePeriod$fShowTimePeriod $fEqCondition$fOrdCondition$fShowCondition $fEqCfRule $fOrdCfRule $fShowCfRuleConditionalFormatting cfrConditioncfrDxfId cfrPriority cfrStopIfTrue topCfPriority$fToAttrValTimePeriod$fToElementCfRule$fFromAttrValTimePeriod$fFromCursorCfRule 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 $fShowVariantCfPairunCfPair$fToElementCfPair$fFromCursorCfPair $fEqCfPair $fShowCfPair CommentTable_commentsTablefromList lookupComment parseComment$fFromCursorCommentTable$fToElementCommentTable$fToDocumentCommentTable$fShowCommentTable$fEqCommentTableCustomPropertyCustomPropertiesemptyparseCustomPropertyEntrycpr 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 _wsPageSetup_wsConditionalFormattingsRange ColumnsWidthcwMincwMaxcwWidthcwStyle RowPropertiesRowProps rowHeightrowStyleCellMap cellComment cellStyle cellValue$fFromCursorColumnsWidth $fDefaultCell$fReadRowProperties$fEqRowProperties$fShowRowProperties$fOrdRowProperties$fEqColumnsWidth$fShowColumnsWidth $fEqWorksheet$fShowWorksheet DefinedNamesXlsx _xlSheets _xlStyles_xlDefinedNames_xlCustomPropertiesStylesunStyleswsCells wsColumnswsConditionalFormattingswsMerges 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$fEqFormattedCondFmt$fShowFormattedCondFmt FormattedCell_formattedAlignment_formattedBorder_formattedFill_formattedFont_formattedNumberFormat_formattedProtection_formattedPivotButton_formattedQuotePrefix_formattedValue_formattedColSpan_formattedRowSpancondfmtCondition condfmtDxfcondfmtPrioritycondfmtStopIfTrue$fShowFormattedCell$fEqFormattedCell CondFormattedcondformattedStyleSheetcondformattedFormattings FormattedformattedCellMapformattedStyleSheetformattedMergesformattedAlignmentformattedBorderformattedColSpan formattedFill formattedFontformattedNumberFormatformattedPivotButtonformattedProtectionformattedQuotePrefixformattedRowSpanformattedValueconditionallyFormatted$fDefaultFormattedCondFmt$fDefaultFormattedCell $fEqFormatted$fShowFormatted$fEqCondFormatted$fShowCondFormattedelementContent0 runReader lens-4.14-HbKmk30vWcC3A6R3zZj5ZYControl.Lens.Internal.IndexedindexedbaseGHC.BaseMonoid readConditionreadOpExpression conditionDataoperatorExpressionData formulaNodeDefaultControl.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_formattingFontsFormattedCondFmt_condfmtCondition _condfmtDxf_condfmtPriority_condfmtStopIfTrueformattingBordersformattingCellXfsformattingFillsformattingFontsformattingMergesstateFromStyleSheet fromValueList toValueListupdateStyleSheetFromStategetId cellStyleIdcellXfmapDxf