f      !"#$%&'()*+,-./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 u v w x y z { | } ~                              !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdeNone!"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" f !   f !None0(required attribute parsing))parsing optional attributes with defaults*parsing optional attributes3Add sml namespace to name"#$%&'()*+,-./012g3456789:;<"#$%&'()*+,-./0123456&'3$%"#()*+,-./012645"#$%&'()*+,-./012g3456789:;<None!"o> Paper size?A2 paper (420 mm by 594 mm)@A3 paper (297 mm by 420 mm)A!A3 extra paper (322 mm by 445 mm)B,A3 extra transverse paper (322 mm by 445 mm)C&A3 transverse paper (297 mm by 420 mm)DA4 paper (210 mm by 297 mm)E!A4 extra paper (236 mm by 322 mm)F A4 plus paper (210 mm by 330 mm)G!A4 small paper (210 mm by 297 mm)H&A4 transverse paper (210 mm by 297 mm)IA5 paper (148 mm by 210 mm)J!A5 extra paper (174 mm by 235 mm)K&A5 transverse paper (148 mm by 210 mm)LB4 paper (250 mm by 353 mm)MB5 paper (176 mm by 250 mm)NC paper (17 in. by 22 in.)OD paper (22 in. by 34 in.)PE paper (34 in. by 44 in.)Q&Executive paper (7.25 in. by 10.5 in.)R(German legal fanfold (8.5 in. by 13 in.)S+German standard fanfold (8.5 in. by 12 in.)T*US standard fanfold (14.875 in. by 11 in.)UFolio paper (8.5 in. by 13 in.)VISO B4 (250 mm by 353 mm)W%ISO B5 extra paper (201 mm by 276 mm)X+Japanese double postcard (200 mm by 148 mm)Y*JIS B5 transverse paper (182 mm by 257 mm)ZLedger paper (17 in. by 11 in.)[Legal 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.)a&Letter small paper (8.5 in. by 11 in.)b-Letter transverse paper (8.275 in. by 11 in.)cNote paper (8.5 in. by 11 in.)dQuarto paper (215 mm by 275 mm)e Standard paper (9 in. by 11 in.)f!Standard paper (10 in. by 11 in.)g!Standard paper (10 in. by 14 in.)h!Standard paper (11 in. by 17 in.)i!Standard paper (15 in. by 11 in.)j$Statement paper (5.5 in. by 8.5 in.)kSuperASuperAA4 paper (227 mm by 356 mm)lSuperBSuperBA3 paper (305 mm by 487 mm)m Tabloid paper (11 in. by 17 in.)n)Tabloid extra paper (11.69 in. by 18 in.)o%6 3/4 envelope (3.625 in. by 6.5 in.)p$#9 envelope (3.875 in. by 8.875 in.)q##10 envelope (4.125 in. by 9.5 in.)r$#11 envelope (4.5 in. by 10.375 in.)s!#12 envelope (4.75 in. by 11 in.)t #14 envelope (5 in. by 11.5 in.)uB4 envelope (250 mm by 353 mm)vB5 envelope (176 mm by 250 mm)wB6 envelope (176 mm by 125 mm)xC3 envelope (324 mm by 458 mm)yC4 envelope (229 mm by 324 mm)zC5 envelope (162 mm by 229 mm){C6 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+000 12 # ?/?1  13 # ??/??2  14 mm-dd-yy3  15 d-mmm-yy4 16 d-mmm5  17 mmm-yy6  18 h:mm AM/PM7 19 h:mm:ss AM/PM8 20 h:mm9  21 h:mm:ss: 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:ssA  47 mmss.0B  48 ##0.0E+0C 49 @DEA single dxf record, expressing incremental formatting to be applied.-Section 18.8.14, "dxf (Formatting)" (p. 1765)KPThis element defines the properties for one of the fonts used in this workbook.'Section 18.2.22 "font (Font)" (p. 1769)M,Displays characters in bold face font style.N9This 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.OColorPMacintosh 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.Q=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.RThe 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.SDisplays characters in italic font style. The italic style is defined by the font at a system level and is not specified by ECMA-376.T2This 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.UtThis element displays only the inner and outer borders of each character. This is very similar to Bold in behavior.VDefines 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.WMacintosh 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.XSThis element draws a strikethrough line through the horizontal middle of the text.Y[This element represents the point size (1/72 of an inch) of the Latin and East Asian text.Z7This element represents the underline formatting style.[This 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)a'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)d>One of the colors associated with the data bar or color scale.The hI attribute (used for backwards compatibility only) is not modelled here.0See 18.3.1.15 "color (Data Bar Color)" (p. 1608)fNA boolean value indicating the color is automatic and system color dependent.g1Standard 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).hA zero-based index into the  clrScheme2 collection (20.1.6.2), referencing a particular  sysClr or  srgbClr$ value expressed in the Theme part.i.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.jBorder style See  CT_BorderPr (p. 3934)nvExpresses 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)pA 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.qA 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.r~A boolean value indicating if left, right, top, and bottom borders should be applied only to outside borders of a cell range.s Bottom bordertDiagonaluTrailing edge border See also  vHorizontal inner bordersw 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  .x 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 .yLeading edge border See also z Top border{Vertical 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. 39370See CT_Xf , p. 44863See  CT_Border , p. 44835See CT_PatternFill , p. 44846See CT_Fill , p. 4484:See CT_Color , p. 4484;4See 18.18.94 "ST_FontFamily (Font Family)" (p. 2517)<See CT_Font , p. 4489=See  CT_Stylesheet , p. 4482GSee CT_CellProtection , p. 4484HSee CT_Font , p. 4489ISee CT_PatternFill , p. 4484JSee CT_Fill , p. 4484KSee CT_Color , p. 4484LSee  CT_BorderPr , p. 4483MSee  CT_Border , p. 4483NSee CT_CellAlignment , p. 4482OSee CT_Dxf , p. 3937PSee CT_Xf , p. 4486QSee  CT_Stylesheet , p. 4482G      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'())|}~nopqrstuvwxyz{jklmdefghiDEFGHIJabc\]^_`KLMNOPQRSTUVWXYZ['()*+,-./0123456789:;<=>?@ABC#$%& !"           !"$#%&'(      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmn opqrstuvwxyz{| }~      !"#$%&'()*+,-./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)a9This element defines the font character set of this font.3Section 18.4.1, "charset (Character Set)" (p. 1721)b>One of the colors associated with the data bar or color scale.5Section 18.3.1.15, "color (Data Bar Color)" (p. 1608)cMacintosh 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)dThis 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)eThe 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)fDisplays 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)gtThis 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)hYThis element is a string representing the name of the font assigned to display this run.(Section 18.4.5, "rFont (Font)" (p. 1724)iDefines 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)jMacintosh 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)kSThis element draws a strikethrough line through the horizontal middle of the text.4Section 18.4.10, "strike (Strike Through)" (p. 1726)l[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)m7This element represents the underline formatting style.*Section 18.4.13, "u (Underline)" (p. 1728)nThis 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)o 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)q\This element represents a set of properties to apply to the contents of this rich text run.rCThis element represents the text content shown as part of a string.NOTE: o[ 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 oIf the og specifies its own properties, then these overrule the properties specified here. For example, adding bold to a o which is already italic will make the o both  bold and Qitalic@ but adding it to one that that is explicitly _not_ bold will leave the o unchanged.The i 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.^_`abcdefghijklmnopqryz{|}~'^_`abcdefghijklmnopqryz{|}~'opqr^_`abcdefghijklmnyz{|}~^_`abcdefghijklmnopqryz{|}~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' operator9jklmn00   jklmn 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 pane Worksheet view selection#Minimum of 0, maximum of 4 elementsQRender sheet views7The list should be non-empty to be conform to the spec.:See Section 18.3.1.88 "sheetViews (Sheet Views)" (p. 1704)RSee  ST_PaneState , p. 3929SSee ST_Pane , p. 3914TSee ST_SheetViewType , p. 3913USee  CT_Selection , p. 3914VSee CT_Pane , p. 3913WSee  CT_SheetView , p. 3913XSee  ST_PaneState , p. 3929YSee ST_Pane , p. 3914ZSee ST_SheetViewType , p. 3913[See CT_Pane , p. 3913\See  CT_Selection , p. 3914]See  CT_SheetView , p. 3913` NOTE: The o instance for   sets the required attribute  to 0._      3456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`P      3456789:;<=>?@ABCDEFGHIJKLMNOPQP      Q34689:;<=>?@ABCDEFG57HIJKLMNOP4      3456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_` Nonej-Add doc props variant types namespace to name abcdefghijklm abcdefghijkl abcdefmghijklabcdefghijklm Nonepqrstpqrpqrtspqrst None!"x>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 namexyz{|}~xyz{|}~{|}~xyzxyz{|}~None!"9;,Specifies the rotation of the Graphic Frame.Specifies a horizontal flip. When true, this attribute defines that the shape is flipped horizontally about the center of its bounding box.Specifies a vertical flip. When true, this attribute defines that the shape is flipped vetically about the center of its bounding box.%See 20.1.7.4 "off (Offset)" (p. 2847)SSee 20.1.7.3 "ext (Extents)" (p. 2846) or 20.5.2.14 "ext (Shape Extent)" (p. 3165)RSpecifies a unique identifier for the current DrawingML object within the current6TODO: make ids internal and consistent by constructionpSpecifies the name of the object. Typically, this is used to store the original file name of a picture object.Alternative Text for ObjectsThis element is used to set certain properties related to a drawing element on the client spreadsheet application.1see 20.5.2.3 "clientData (Client Data)" (p. 3156)gThis attribute indicates whether to disable selection on drawing elements when the sheet is protected.TThis attribute indicates whether to print drawing elements when printing the sheet.This simple type represents an angle in 60,000ths of a degree. Positive angles are clockwise (i.e., towards the positive y axis); negative angles are counter-clockwise (i.e., towards the negative y axis).Positive position or length in EMUs, maximu allowed value is 27273042316900. see 20.1.10.41 "ST_PositiveCoordinate (Positive Coordinate)" (p. 2942)tUnits used in "Universal measure" coordinates see 22.9.2.15 "ST_UniversalMeasure (Universal Measurement)" (p. 3793)@This simple type represents a one dimensional position or length5See 20.1.10.16 "ST_Coordinate (Coordinate)" (p. 2921)@see 20.1.10.19 "ST_CoordinateUnqualified (Coordinate)" (p. 2922)Esee 22.9.2.15 "ST_UniversalMeasure (Universal Measurement)" (p. 3793)2information about image file as a par of a drawing>image filename, images are assumed to be stored under path "xlmedia"2image content type, ECMA-376 advises to use "imagepng" or "image$jpeg" if interoperability is wantedimage file contentsHAdd DrawingML namespace to nameJ+Add Spreadsheet DrawingML namespace to name0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmno0123456789:;<=>?@ABCDEFGHIJK2107654398:onml;<kj=ihgfe>dc?ba`_^]\@A[ZBCYDXWVEUTFSGRQPONMLHIJK[ 0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnoNonepInternal 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)pqrstpqrpqrtspqrstNone!" wxyz{|}~wxyz{| wxyz{~}|wxyz{|}~None!"*Add package relationship namespace to name   None'Add custom properties namespace to nameFMTID_UserDefinedProperties  None!"SCurrently cell details include only cell values and style ids (e.g. formulas from <f> and inline strings from <is> subelements are ignored)Formula for the cell.7TODO: array. dataTable and shared formula types support%See 18.3.1.40 "f (Formula)" (p. 1636)6Specifies that this formula assigns a value to a name.`Indicates that this formula needs to be recalculated the next time calculation is performed. [ExampleT: This is always set on volatile functions, like =RAND(), and circular references.  end example]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) pairsSpreadsheetML Drawinglist 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" reverse to Warning:U the function isn't total and will throw an error if incorrect value will get passed Render range  mkRange (2, 4) (6, 8) == "D2:H6" reverse to Warning:U the function isn't total and will throw an error if incorrect value will get passedUp #>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()^_`abcdefghijklmnopqryz{|}~      3456789:;<=>?@ABCDEFGHIJKLMNOPQabcdefghijkl0123456789:;<=>?@ABCDEFGHIJKc/ p NoneOT  'lens giving access to a worksheet from  object by its name q variant of   lens lens 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 documentr 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. r rNoneLT(Reads  from raw data (lazy bytestring))Reads B from raw data (lazy bytestring), failing with Left on parse errors>Get xml cursor from the specified file inside the zip archive.tJGet xml cursor from the given file, failing with MissingFile if not found.uGet shared string tablev@readWorkbook pulls the names of the sheets and the defined nameswxyz"#$%&'(){|stu}~v"#$%&'()()#$%&'"wxyz"#$%&'(){|stu}~vNone!"-Writes  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 order4Cell with formattingSee ] for more details.TODOs:Add a number format (, )*Add references to the named style sheets ()JThe resulting stylesheetK?The final map of conditional formatting rules applied to rangesLResult of formattingSee ]N The final ; see OThe final stylesheet; see  (and )P#The final list of cell merges; see ]1Higher 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 4s, which refer directly to Ks, ns, 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.^ reverse to ]h which allows to get a map of formatted cells from an existing worksheet and its workbook's style sheet3Format a cell with (potentially) rowspan or colspan%Cell block corresponding to a single 4 A single 4U 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.H456789:;<=>?@ABCDEHIJKLMNOPQRSTUVWXYZ[\]^_`a*456789:;<=>?@ABCDEHIJKLMNOPQRSTUVWXYZ[\]^_*456789:;<=>?@ALMNOP]^HIJK_QRTUWYXZ\VS[BCDE)4 56789:;<=>?@ABCDEHIJKLMNOPQRSTUVWXYZ[\]^_`aNone7>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()^_`abcdefghijklmnopqryz{|}~      3456789:;<=>?@ABCDEFGHIJKLMNOPQabcdefghijkl0123456789:;<=>?@ABCDEFGHIJK    "#$%&'()- !"#$%&'()*+,-./0123456789:;<=>?@ABCDEEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_``abcdeffghijklmnopqrstuvvwxyzz{||}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnoppqrstuvwxyz{|}~                                                                                                          ! " # $ % & ' ( ) * + , - . / 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 u v w x x y z { | } ~                                    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdeffghijkllmnopqrstuuvwwxyz{|}~      !"#$%&'()**+,--./0123456789:;<=>?@ABCDEFGHIJKL M N O P QRSGTUVWXYZ[[\]^_`abcdefghijJKklJKmnnopqrstuvwxxyz{|}~!xlsx-0.2.4-7cgxz6Gqoe8BO7HcsROvqzCodec.Xlsx.TypesCodec.Xlsx.Writer.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.VariantCodec.Xlsx.Types.Internal'Codec.Xlsx.Types.Internal.RelationshipsCodec.Xlsx.Types.Drawing Codec.Xlsx.Types.Internal.CfPair&Codec.Xlsx.Types.Internal.CommentTable&Codec.Xlsx.Types.Internal.ContentTypes*Codec.Xlsx.Types.Internal.CustomPropertiesCodec.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 elementListelementListSimple leafElement emptyElementelementContentelementContentPreserved elementValue.=.=?setAttraddNS mainNamespacetxtdtxtbtxti justNonDef justFalsejustTrue$fToAttrValBool$fToAttrValDouble$fToAttrValInteger$fToAttrValInt $fToAttrVal[]$fToAttrValText FromAttrVal fromAttrVal FromCursor fromCursorParseException fromAttributefromAttributeDefmaybeAttributemaybeElementValuemaybeElementValueDefmaybeBoolElemValuemaybeFromElement readSuccess readFailure invalidTextdefaultReadFailurendecimalrationalboolean$fFromAttrValBool$fFromAttrValDouble$fFromAttrValInteger$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_styleSheetDxfsnumberFormatIdidToStdNumberFormat $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 $fShowVariantRefIdunRefId$fFromAttrValRefId$fToAttrValRefId $fShowRefId $fEqRefId $fOrdRefId RelationshipsrelMap RelationshiprelType relTargetfromListemptyrelEntrylookupsetTargetsFromjoinRelrelFrom findRelByType parseRelEntryprodrodRelNspkgRelNs stdRelType$fFromCursorRelationship$fFromCursorRelationships$fToElementRelationship$fToElementRelationships$fToDocumentRelationships$fShowRelationship$fEqRelationship$fShowRelationships$fEqRelationshipsUnresolvedDrawingDrawingGenericDrawing _xdrAnchorsAnchor_anchAnchoring _anchObject_anchClientDataLineFill LineNoFillLineProperties_lnFillGeometryPresetGeometry Transform2D_trRot_trFlipH_trFlipV _trOffset _trExtentsShapeProperties_spXfrm _spGeometry _spOutlineFillModeFillTile FillStretchBlipFillProperties _bfpImageInfo _bfpFillModePicDrawingNonVisual_pdnvId _pdnvName_pdnvDescription _pdnvHidden _pdnvTitle PicNonVisual_pnvDrawingProps ClientData_cldLcksWithSheet_cldPrintsWithSheet DrawingObjectPicture _picMacro _picPublished _picNonVisual _picBlipFill_picShapeProperties AnchoringAbsoluteAnchor OneCellAnchor TwoCellAnchorabsaPosabsaExt onecaFromonecaExttcaFromtcaTo tcaEditAsEditAs EditAsTwoCell EditAsOneCellEditAsAbsoluteMarker_mrkCol _mrkColOff_mrkRow _mrkRowOffPositiveSize2D_ps2dX_ps2dYAnglePositiveCoordinatePoint2D_pt2dX_pt2dYUnitIdentifierUnitCmUnitMmUnitInUnitPtUnitPcUnitPi Coordinate UnqCoordinateUniversalMeasureFileInfo _fiFilename_fiContentType _fiContents unqPoint2D unqMarker $fEqFileInfo$fShowFileInfo$fEqUnitIdentifier$fShowUnitIdentifier$fEqCoordinate$fShowCoordinate $fEqPoint2D $fShowPoint2D$fEqPositiveCoordinate$fOrdPositiveCoordinate$fShowPositiveCoordinate $fEqAngle $fShowAngle$fEqPositiveSize2D$fShowPositiveSize2D $fEqMarker $fShowMarker $fEqEditAs $fShowEditAs $fEqAnchoring$fShowAnchoring$fEqClientData$fShowClientData$fEqPicDrawingNonVisual$fShowPicDrawingNonVisual$fEqPicNonVisual$fShowPicNonVisual $fEqFillMode$fShowFillMode$fEqBlipFillProperties$fShowBlipFillProperties$fEqTransform2D$fShowTransform2D $fEqGeometry$fShowGeometry $fEqLineFill$fShowLineFill$fEqLineProperties$fShowLineProperties$fEqShapeProperties$fShowShapeProperties$fEqDrawingObject$fShowDrawingObject $fEqAnchor $fShowAnchor$fEqGenericDrawing$fShowGenericDrawing anchAnchoringanchClientData anchObject picBlipFillpicMacro picNonVisual picPublishedpicShapeProperties bfpFillMode bfpImageInfo xdrAnchorsanchoringFromNode nodeElNameIsdrawingObjectFromNodefillModeFromNodegeometryFromNodelineFillFromNode coordinateanchorToElementanchoringToElementdrawingObjToElementfillModeToElementgeometryToElementlineFillToElementa drawingNsxdr xlDrawingNs$fToAttrValAngle$fToAttrValEditAs$fToAttrValPositiveCoordinate$fToAttrValCoordinate$fToElementPositiveSize2D$fToElementPoint2D$fToElementClientData$fToElementLineProperties$fToElementTransform2D$fToElementShapeProperties$fToElementBlipFillProperties$fToElementPicDrawingNonVisual$fToElementPicNonVisual$fToElementMarker$fToElementGenericDrawing$fToDocumentGenericDrawing$fFromCursorLineFill$fFromAttrValEditAs$fFromAttrValAngle$fFromCursorPositiveSize2D$fFromCursorPoint2D$fFromCursorClientData$fFromCursorLineProperties$fFromCursorGeometry$fFromCursorTransform2D$fFromCursorFillMode$fFromCursorShapeProperties$fFromCursorBlipFillProperties$fFromCursorPicDrawingNonVisual$fFromCursorPicNonVisual$fFromCursorDrawingObject$fFromCursorMarker$fFromCursorAnchoring$fFromCursorAnchor$fFromCursorGenericDrawing$fDefaultClientDataCfPairunCfPair$fToElementCfPair$fFromCursorCfPair $fEqCfPair $fShowCfPair CommentTable_commentsTable lookupComment parseComment$fFromCursorCommentTable$fToElementCommentTable$fToDocumentCommentTable$fShowCommentTable$fEqCommentTable ContentTypesctTypesOverride ovrPartNameovrContentTypectcontentTypesNs$fFromCursorOverride$fFromCursorContentTypes $fEqOverride$fShowOverride$fEqContentTypes$fShowContentTypesCustomPropertyCustomPropertiesparseCustomPropertyEntrycpr custPropNsuserDefinedFmtID$fToElementCustomProperty$fToElementCustomProperties$fToDocumentCustomProperties$fFromCursorCustomProperties$fShowCustomProperties$fEqCustomPropertiesCell _cellStyle _cellValue _cellComment _cellFormula CellFormulaNormalCellFormula_cellfExpression_cellfAssignsToName_cellfCalculate CellValueCellText CellDoubleCellBoolCellRichsimpleCellFormula $fEqCellValue$fShowCellValue$fEqCellFormula$fShowCellFormula$fEqCell $fShowCell Worksheet _wsColumns_wsRowPropertiesMap_wsCells _wsDrawing _wsMerges _wsSheetViews _wsPageSetup_wsConditionalFormattingsRange ColumnsWidthcwMincwMaxcwWidthcwStyle RowPropertiesRowProps rowHeightrowStyleCellMap cellComment cellFormula cellStyle cellValue$fFromCursorColumnsWidth $fDefaultCell$fReadRowProperties$fEqRowProperties$fShowRowProperties$fOrdRowProperties$fEqColumnsWidth$fShowColumnsWidth $fEqWorksheet$fShowWorksheet DefinedNamesXlsx _xlSheets _xlStyles_xlDefinedNames_xlCustomPropertiesStylesunStyleswsCells wsColumnswsConditionalFormattings wsDrawingwsMerges wsPageSetupwsRowPropertiesMap wsSheetViews$fDefaultWorksheet $fEqStyles $fShowStyles$fEqDefinedNames$fShowDefinedNames$fEqXlsx $fShowXlsxxlCustomPropertiesxlDefinedNamesxlSheetsxlStyles emptyStylesint2colcol2inttoRowsfromRows mkCellRef fromCellRefmkRange fromRange$fToElementCellFormula$fFromCursorCellFormula$fDefaultDefinedNames $fDefaultXlsxixSheetatSheetixCellixCellRCixCellXYatCellatCellRCatCellXY cellValueAt cellValueAtRC cellValueAtXYSharedStringTablesstTable sstConstruct sstLookupText sstLookupRichsstItem$fFromCursorSharedStringTable$fToElementSharedStringTable$fToDocumentSharedStringTable$fShowSharedStringTable$fEqSharedStringTable$fOrdSharedStringTableParser ParseErrorInvalidZipArchive MissingFile InvalidFile InvalidReftoXlsx toXlsxEither$fShowParseError$fEqParseError$fShowWorksheetFilefromXlsx$fShowXlsxCellData$fEqXlsxCellData$fShowXlsxCell $fEqXlsxCell$fEqFormattedCondFmt$fShowFormattedCondFmt FormattedCell_formattedAlignment_formattedBorder_formattedFill_formattedFont_formattedNumberFormat_formattedProtection_formattedPivotButton_formattedQuotePrefix_formattedValue_formattedFormula_formattedColSpan_formattedRowSpancondfmtCondition condfmtDxfcondfmtPrioritycondfmtStopIfTrue$fShowFormattedCell$fEqFormattedCell CondFormattedcondformattedStyleSheetcondformattedFormattings FormattedformattedCellMapformattedStyleSheetformattedMergesformattedAlignmentformattedBorderformattedColSpan formattedFill formattedFontformattedFormulaformattedNumberFormatformattedPivotButtonformattedProtectionformattedQuotePrefixformattedRowSpanformattedValuetoFormattedCellsconditionallyFormatted$fDefaultFormattedCondFmt$fDefaultFormattedCell $fEqFormatted$fShowFormatted$fEqCondFormatted$fShowCondFormattedelementContent0 runReader lens-4.14-Bb4ekaqwx8nBHtxVG4rt2mControl.Lens.Internal.IndexedindexedbaseGHC.BaseMonoid readConditionreadOpExpression conditionDataoperatorExpressionData formulaNodeDefaulttypedCellFormulaControl.Lens.AtAt sstLookupxmlCursorOptionalxmlCursorRequiredgetSharedStrings readWorkbook WorksheetFilewfNamewfPath extractSheetextractCellValuegetContentTypes getStyles getCommentsgetCustomProperties getDrawing worksheetFilegetRelsintqNamensName nonEmptyNmElNothingjustNmElJustXlsxCell xlsxCellStyle xlsxCellValue xlsxCommentxlsxCellFormula XlsxCellDataXlsxSS XlsxDoubleXlsxBoolCellsFileDatafdPath fdContentType fdRelType fdContentssingleSheetFiles commentsFiles drawingFilescoreXmlappXml xlsxCellTypevaluetransformSheetDatasheetXmlbookXmlssXmlcustomPropsXmlbookRelscontentTypesXmlnmnEl_formattingMergesghc-prim GHC.TypesInt formatCell cellBlockFormattingState_formattingBorders_formattingCellXfs_formattingFills_formattingFontsFormattedCondFmt_condfmtCondition _condfmtDxf_condfmtPriority_condfmtStopIfTrueformattingBordersformattingCellXfsformattingFillsformattingFontsformattingMergesstateFromStyleSheet fromValueList toValueListupdateStyleSheetFromStategetId cellStyleIdcellXfmapDxf