E1      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQR 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 { | } ~          None35N )Set the namespace for the entire documentDThis follows the same policy that the rest of the xlsx package uses.The main namespace for Excel     SafeExcel cell reference (e.g. E3) see 18.18.62 ST_Ref (p. 2482)None+required attribute parsingparsing optional attributesAdd sml namespace to name    Noneo! Paper size"A2 paper (420 mm by 594 mm)#A3 paper (297 mm by 420 mm)$!A3 extra paper (322 mm by 445 mm)%,A3 extra transverse paper (322 mm by 445 mm)&&A3 transverse paper (297 mm by 420 mm)'A4 paper (210 mm by 297 mm)(!A4 extra paper (236 mm by 322 mm)) A4 plus paper (210 mm by 330 mm)*!A4 small paper (210 mm by 297 mm)+&A4 transverse paper (210 mm by 297 mm),A5 paper (148 mm by 210 mm)-!A5 extra paper (174 mm by 235 mm).&A5 transverse paper (148 mm by 210 mm)/B4 paper (250 mm by 353 mm)0B5 paper (176 mm by 250 mm)1C paper (17 in. by 22 in.)2D paper (22 in. by 34 in.)3E paper (34 in. by 44 in.)4&Executive paper (7.25 in. by 10.5 in.)5(German legal fanfold (8.5 in. by 13 in.)6+German standard fanfold (8.5 in. by 12 in.)7*US standard fanfold (14.875 in. by 11 in.)8Folio paper (8.5 in. by 13 in.)9ISO B4 (250 mm by 353 mm):%ISO B5 extra paper (201 mm by 276 mm);+Japanese double postcard (200 mm by 148 mm)<*JIS B5 transverse paper (182 mm by 257 mm)=Ledger 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.)A(Letter extra paper (9.275 in. by 12 in.)B3Letter extra transverse paper (9.275 in. by 12 in.)C(Letter plus paper (8.5 in. by 12.69 in.)D&Letter small paper (8.5 in. by 11 in.)E-Letter transverse paper (8.275 in. by 11 in.)FNote paper (8.5 in. by 11 in.)GQuarto paper (215 mm by 275 mm)H Standard paper (9 in. by 11 in.)I!Standard paper (10 in. by 11 in.)J!Standard paper (10 in. by 14 in.)K!Standard paper (11 in. by 17 in.)L!Standard paper (15 in. by 11 in.)M$Statement paper (5.5 in. by 8.5 in.)NSuperASuperAA4 paper (227 mm by 356 mm)OSuperBSuperBA3 paper (305 mm by 487 mm)P Tabloid paper (11 in. by 17 in.)Q)Tabloid extra paper (11.69 in. by 18 in.)R%6 3/4 envelope (3.625 in. by 6.5 in.)S$#9 envelope (3.875 in. by 8.875 in.)T##10 envelope (4.125 in. by 9.5 in.)U$#11 envelope (4.5 in. by 10.375 in.)V!#12 envelope (4.75 in. by 11 in.)W #14 envelope (5 in. by 11.5 in.)XB4 envelope (250 mm by 353 mm)YB5 envelope (176 mm by 250 mm)ZB6 envelope (176 mm by 125 mm)[C3 envelope (324 mm by 458 mm)\C4 envelope (229 mm by 324 mm)]C5 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)a"Invite envelope (220 mm by 220 mm)b!Italy envelope (110 mm by 230 mm)c(Monarch envelope (3.875 in. by 7.5 in.).dSpecifies printed page ordere4Order pages vertically first, then move horizontallyf4Order pages horizontally first, then move verticallyg Print orientation for this sheetk Print errorsYThis enumeration specifies how to display cells with errors when printing the worksheet.lDisplay cell errors as blankmDisplay cell errors as dashesn*Display cell errors as displayed on screenoDisplay cell errors as #N/Ap 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).q Print cell comments as displayedr&Print cell comments at end of documentsDo not print cell commentsvPrint black and white.w4This attribute specifies how to print cell comments.xNumber of copies to print.yPrint without graphics.z9Specifies 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!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~{!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~{tuvwxyz{|}~pqrsklmnoghijdef!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abc&!B"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~None;State of the sheet's pane.6Section 18.18.53 "ST_PaneState (Pane State)" (p. 2711)Panes are frozen, but were not split being frozen. In this state, when the panes are unfrozen again, a single pane results, with no split. In this state, the split bars are not adjustable.Panes are frozen and were split before being frozen. In this state, when the panes are unfrozen again, the split remains, but is adjustable.[Panes are split, but not frozen. In this state, the split bars are adjustable by the user. Pane type1Section 18.18.52 "ST_Pane (Pane Types)" (p. 2710)GBottom left pane, when both vertical and horizontal splits are applied.This value is also used when only a horizontal split has been applied, dividing the pane into upper and lower regions. In that case, this value specifies the bottom pane.DTop left pane, when both vertical and horizontal splits are applied.This value is also used when only a horizontal split has been applied, dividing the pane into upper and lower regions. In that case, this value specifies the top pane.This value is also used when only a vertical split has been applied, dividing the pane into right and left regions. In that case, this value specifies the left paneETop right pane, when both vertical and horizontal splits are applied.This value is also used when only a vertical split has been applied, dividing the pane into right and left regions. In that case, this value specifies the right pane.View setting of the sheet?Section 18.18.69 "ST_SheetViewType (Sheet View Type)" (p. 2726) Normal viewPage break previewPage layout viewWorksheet view pane.Section 18.3.1.66 "pane (View Pane)" (p. 1843)The pane that is active.bIndicates whether the pane has horizontal / vertical splits, and whether those splits are frozen.]Location of the top left visible cell in the bottom right pane (when in Left-To-Right mode).Horizontal position of the split, in 1/20th of a point; 0 (zero) if none. If the pane is frozen, this value indicates the number of columns visible in the top pane.Vertical position of the split, in 1/20th of a point; 0 (zero) if none. If the pane is frozen, this value indicates the number of rows visible in the left pane.Worksheet view selection.3Section 18.3.1.78 "selection (Selection)" (p. 1864)Location of the active cell0-based index of the range reference (in the array of references listed in sqref) containing the active cell. Only used when the selection in sqref is not contiguous. Therefore, this value needs to be aware of the order in which the range references are written in sqref.<When this value is out of range then activeCell can be used.)The pane to which this selection belongs.<Range of the selection. Can be non-contiguous set of ranges.Worksheet viewA single sheet view definition. When more than one sheet view is defined in the file, it means that when opening the workbook, each sheet view corresponds to a separate window within the spreadsheet application, where each window is showing the particular sheet containing the same workbookViewId value, the last sheetView definition is loaded, and the others are discarded. When multiple windows are viewing the same sheet, multiple sheetView elements (with corresponding workbookView entries) are saved. TODO: The pivotSelection and extLst child elements are unsupported.<See Section 18.3.1.87 "sheetView (Worksheet View)" (p. 1880)Index to the color value for row/column text headings and gridlines. This is an 'index color value' (ICV) rather than rgb value.Flag indicating that the consuming application should use the default grid lines color (system dependent). Overrides any color specified in colorId.Flag indicating whether the sheet is in 'right to left' display mode. When in this mode, Column A is on the far right, Column B ;is one column left of Column A, and so on. Also, information in cells is displayed in the Right to Left format.;Flag indicating whether this sheet should display formulas.<Flag indicating whether this sheet should display gridlines.Flag indicating whether the sheet has outline symbols visible. This flag shall always override SheetPr element's outlinePr child element whose attribute is named showOutlineSymbols when there is a conflict.IFlag indicating whether the sheet should display row and column headings.#Show the ruler in Page Layout View.Flag indicating whether page layout view shall display margins. False means do not display left, right, top (header), and bottom (footer) margins (even when there is data in the header or footer).Flag indicating whether the window should show 0 (zero) in cells containing zero value. When false, cells with zero value appear blank instead of showing the number zero.Flag indicating whether this sheet is selected. When only 1 sheet is selected and active, this value should be in synch with the activeTab value. In case of a conflict, the Start Part setting wins and sets the active sheet tab.QMultiple sheets can be selected, but only one sheet shall be active at one time.Location of the top left visible cell Location of the top left visible cell in the bottom right pane (when in Left-to-Right mode).Indicates the view type.Flag indicating whether the panes in the window are locked due to workbook protection. This is an option when the workbook structure is protected.hZero-based index of this workbook view, pointing to a workbookView element in the bookViews collection.!NOTE: This attribute is required.Window zoom magnification for current view representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.Zoom magnification to use when in normal view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.Zoom magnification to use when in page layout view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.Zoom magnification to use when in page break preview, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together.Worksheet view paneWorksheet view selection#Minimum of 0, maximum of 4 elementsRender sheet views7The list should be non-empty to be conform to the spec.:See Section 18.3.1.88 "sheetViews (Sheet Views)" (p. 1704)See  ST_PaneState , p. 3929See ST_Pane , p. 3914See ST_SheetViewType , p. 3913See  CT_Selection , p. 3914See CT_Pane , p. 3913See  CT_SheetView , p. 3913See  ST_PaneState , p. 3929See ST_Pane , p. 3914See ST_SheetViewType , p. 3913See CT_Pane , p. 3913See  CT_Selection , p. 3914See  CT_SheetView , p. 3913 NOTE: The  instance for  sets the required attribute  to 0._PP4None Reading order:See 18.8.1 "alignment (Alignment)" (p. 1754, esp. p. 1755)AIndicates the style of fill pattern being used for a cell format.:Section 18.18.55 "ST_PatternType (Pattern Type)" (p. 2472)Vertical alignmentMSee 22.9.2.17 "ST_VerticalAlignRun (Vertical Positioning Location)" (p. 3794)Font underline property#See 18.4.13 "u (Underline)", p 1728 Font scheme;See 18.18.33 "ST_FontScheme (Font scheme Styles)" (p. 2456)+This font is the major font for this theme.+This font is the minor font for this theme. This font is not a theme font.! Font familyhSee 18.8.18 "family (Font Family)" (p. 1766) and 17.18.30 "ST_FontFamily (Font Family Value)" (p. 1388)"Family is not applicable#Proportional font with serifs$ Proportional font without serifs%%Monospace font with or without serifs&;Script font designed to mimic the appearance of handwriting' Novelty font(Vertical 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)7Protection 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.00A 9 0%B 10 0.00%C  11 0.00E+00D 12 # ?/?E  13 # ??/??F  14 mm-dd-yyG  15 d-mmm-yyH 16 d-mmmI  17 mmm-yyJ  18 h:mm AM/PMK 19 h:mm:ss AM/PML 20 h:mmM  21 h:mm:ssN 22 m/d/yy h:mmO 37 #,##0 ;(#,##0)P 38 #,##0 ;[Red](#,##0)Q 39 #,##0.00;(#,##0.00)R 40 #,##0.00;[Red](#,##0.00)S 45 mm:ssT  46 [h]:mm:ssU  47 mmss.0V  48 ##0.0E+0W 49 @XPThis element defines the properties for one of the fonts used in this workbook.'Section 18.2.22 "font (Font)" (p. 1769)Z,Displays characters in bold face font style.[9This 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.\Color]Macintosh 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.^=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._The 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.`Displays characters in italic font style. The italic style is defined by the font at a system level and is not specified by ECMA-376.a2This 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.btThis element displays only the inner and outer borders of each character. This is very similar to Bold in behavior.cDefines 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.dMacintosh 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.eSThis element draws a strikethrough line through the horizontal middle of the text.f[This element represents the point size (1/72 of an inch) of the Latin and East Asian text.g7This element represents the underline formatting style.hThis 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.iThis 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)n'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)q>One of the colors associated with the data bar or color scale.The I attribute (used for backwards compatibility only) is not modelled here.0See 18.3.1.15 "color (Data Bar Color)" (p. 1608)sNA boolean value indicating the color is automatic and system color dependent.t1Standard 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).uA zero-based index into the  clrScheme2 collection (20.1.6.2), referencing a particular  sysClr or  srgbClr$ value expressed in the Theme part.v.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.wBorder style See  CT_BorderPr (p. 3934){vExpresses 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)}A 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.~A 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.~A boolean value indicating if left, right, top, and bottom borders should be applied only to outside borders of a cell range. Bottom borderDiagonalTrailing edge border See also Horizontal inner borders 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 . 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 .Leading edge border See also  Top borderVertical 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 cellStyleXfscolorsdxfsextLstnumFmts tableStyles9NOTE: You will probably want to base your style sheet on  . See also: to translate a  to Styles  for a higher level interface. to translate a raw  into StyleswThis element contains borders formatting information, specifying all border definitions for all cells in the workbook.-Section 18.8.5, "borders (Borders)" (p. 1760) Cell formatsThis element contains the master formatting records (xf) which define the formatting applied to cells in this workbook. These records are the starting point for determining the formatting for a cell. Cells in the Sheet Part reference the xf records by zero-based index.3Section 18.8.10, "cellXfs (Cell Formats)" (p. 1764)This element defines the cell fills portion of the Styles part, consisting of a sequence of fill records. A cell fill consists of a background color, foreground color, and pattern to be applied across the cell.*Section 18.8.21, "fills (Fills)" (p. 1768)=This element contains all font definitions for this workbook.)Section 18.8.23 "fonts (Fonts)" (p. 1769)Minimal style sheet~Excel expects some minimal definitions in the stylesheet; you probably want to define your own stylesheets based on this one.2This more-or-less follows the recommendations at  ]http://stackoverflow.com/questions/26050708/minimal-style-sheet-for-excel-open-xml-with-dates:, but with some additions based on experimental evidence.See CT_CellProtection , p. 4484See CT_CellAlignment , p. 4482See CT_Xf , p. 4486See  CT_Border , p. 4483See CT_PatternFill , p. 4484See CT_Fill , p. 4484See CT_Color , p. 4484See CT_Font , p. 4489See  CT_Stylesheet , p. 4482See CT_CellProtection , p. 4484See CT_Font , p. 4489See CT_PatternFill , p. 4484See CT_Fill , p. 4484See CT_Color , p. 4484See  CT_BorderPr , p. 4483See  CT_Border , p. 4483See CT_CellAlignment , p. 4482See CT_Xf , p. 4486See  CT_Stylesheet , p. 44825      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~{|}~wxyzqrstuvnopijklmXYZ[\]^_`abcdefgh;<=>?@ABCDEFGHIJKLMNOPQRSTUVW789:./0123456()*+,-!"#$%&'            !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{ |}~ NoneRun 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)Macintosh 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)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.,Section 18.8.17, "extend (Extend)" (p. 1766)The 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)Displays 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)tThis 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)YThis element is a string representing the name of the font assigned to display this run.(Section 18.4.5, "rFont (Font)" (p. 1724)Defines 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)Macintosh 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)SThis element draws a strikethrough line through the horizontal middle of the text.4Section 18.4.10, "strike (Strike Through)" (p. 1726)[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)7This element represents the underline formatting style.*Section 18.4.13, "u (Underline)" (p. 1728)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.;Section 18.4.14, "vertAlign (Vertical Alignment)" (p. 1728) 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)\This element represents a set of properties to apply to the contents of this rich text run.CThis element represents the text content shown as part of a string.NOTE: [ 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 If the g specifies its own properties, then these overrule the properties specified here. For example, adding bold to a  which is already italic will make the  both  bold and Qitalic@ but adding it to one that that is explicitly _not_ bold will leave the  unchanged.The  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.     '     '          NoneSCurrently 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 it Xlsx worksheet" column widths#)custom row properties (height, style) map$"data mapped by (row, column) pairs%list of cell merges(Excel range (e.g. D13:H14))(Column range (from cwMin to cwMax) width3Map 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 '6 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.8KStructured representation of Xlsx file (currently a subset of its contents)JRender $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).KParse 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 completedLKconvert column number (starting from 1) to its textual form (e.g. 3 -> "C")M reverse to LN~converts cells mapped by (row, column) into rows which contain row index and cells as pairs of column indices and cell valuesO reverse to NPRender position in  (row, col) format to an Excel reference. mkCellRef (2, 4) == "D2"Q Render range  mkRange (2, 4) (6, 8) == "D2:H6"@ !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQ3!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQQ89:;<GHF=>?IJK67)*+,-.tuvwxyz{|}~ !"#$%&'AD@BEC354/012(LMPQNO# !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQ NoneIN R'lens giving access to a worksheet from 8 object by its nameS variant of R lensTlens 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 UU"lens to access cell in a worksheetVJlens to access cell in a worksheet using more traditional x+y coordinatesWHaccessor that can read, write or delete cell in a worksheet synonym of X so uses row+column indexX1lens to read, write or delete cell in a worksheetYalens to read, write or delete cell in a worksheet using more traditional x+y or row+column indexZblens to read, write or delete cell value in a worksheet with row+column coordinates, synonym for  cellValueRC[blens to read, write or delete cell value in a worksheet using row+column coordinates of that cell\Zlens to read, write or delete cell value in a worksheet using traditional x+y coordinates RSTUVWXYZ[\ RSTUVWXYZ[\ RSTUVWXYZ[\ RSTUVWXYZ[\ None] String ItemWThis element is the representation of an individual string in the Shared String table.The 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)`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.dConstruct the SharedStringsTable from an existing document Internal generalization used by e and fSee CT_Rst , p. 3903See CT_Sst , p. 3902The optional attributes count and  uniqCount% are being ignored at least currentlySee CT_Rst , p. 3903See CT_Sst , p. 3902. TODO: The count and  uniqCount& attributes are currently unsupported.]^_`abcdefg ]^_`abcdefg `ab]^_defgc ]^_`abcdefg NoneFhReads 8 from raw data (lazy bytestring)2Add office document relationship namespace to name*Add package relationship namespace to name>Get xml cursor from the specified file inside the zip archive.Get shared string table@readWorkbook pulls the names of the sheets and the defined nameshhh h NoneiWrites 8 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/ ."    i !"#$%&ii    i !"#$%& NoneIN 'In reverse orderjCell with formattingSee  for more details.TODOs:Add a number format (, )*Add references to the named style sheets ()wResult of formattingSee y The final 3; see $zThe final stylesheet; see ; (and J){#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 (B") 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 js, which refer directly to Xs, {s, etc. (rather than font IDs, border IDs, etc.), and an initial stylesheet, it recovers all possible sharing, constructs IDs, and then constructs the final 36, 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 j A single jU might have a colspan or rowspan greater than 1. Although Excel obviously supports cell merges, it does not correctly apply borders to the cells covered by the rowspan or colspan. Therefore we create a block of cells in this function; the top-left is the cell proper, and the remaining cells are the cells covered by the rowspan/colspan.0Also returns the cell merge instruction, if any.2+,-./0'jklmnopqrstuv12345678wxyz{|}~)*9:;jklmnopqrstuvwxyz{|}~jklmnopqrstuvwxyz{|}~+,-./0'j klmnopqrstuv12345678wxyz{|}~)*9:;None@!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\hi< !"#$%&'())*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefgghijklmnopqrstuvwwxyz{{|}}~      !"##$%&'()*++,-./012345677889:;<<=>?@ABCDEFGHIJKLM N O P Q R S T U V W X Y Z [ \ \ ] ^ _ ` a b c d e e f g h i j k l m n o p q q r s t u v w x y z { | } ~                                                        !"#$ % & ' ' ( ) * + , - . / 0 1 2 3 4 5 67xlsx_K5PAfKaiDCQFZYNzqcMYX6Codec.Xlsx.TypesCodec.Xlsx.Writer.InternalCodec.Xlsx.Types.CommonCodec.Xlsx.Parser.InternalCodec.Xlsx.Types.PageSetupCodec.Xlsx.Types.SheetViewsCodec.Xlsx.Types.StyleSheetCodec.Xlsx.Types.RichTextCodec.Xlsx.Lens"Codec.Xlsx.Types.SharedStringTableCodec.Xlsx.ParserCodec.Xlsx.WriterCodec.Xlsx.FormattedrenderStyleSheet formattedparseStyleSheet Codec.XlsxLens'datad_K91y8NcZUJI9yaBI61rgdDData.Default.Classdef ToAttrVal toAttrVal ToElement toElement ToDocument toDocumentdocumentFromElement elementListelementContent elementValue.=.=?addNS mainNamespaceCellRef FromAttrVal fromAttrVal FromCursor fromCursorParseException fromAttributemaybeAttributemaybeElementValuemaybeFromElement readSuccess readFailure invalidTextdefaultReadFailurendecimalrational 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_pageSetupVerticalDpipageSetupBlackAndWhitepageSetupCellCommentspageSetupCopiespageSetupDraftpageSetupErrorspageSetupFirstPageNumberpageSetupFitToHeightpageSetupFitToWidthpageSetupHorizontalDpi pageSetupIdpageSetupOrientationpageSetupPageOrderpageSetupPaperHeightpageSetupPaperSizepageSetupPaperWidthpageSetupScalepageSetupUseFirstPageNumberpageSetupUsePrinterDefaultspageSetupVerticalDpi 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_sheetViewSelectionsheetViewColorIdsheetViewDefaultGridColor sheetViewPanesheetViewRightToLeftsheetViewSelectionsheetViewShowFormulassheetViewShowGridLinessheetViewShowOutlineSymbolssheetViewShowRowColHeaderssheetViewShowRulersheetViewShowWhiteSpacesheetViewShowZerossheetViewTabSelectedsheetViewTopLeftCell sheetViewTypesheetViewWindowProtectionsheetViewWorkbookViewIdsheetViewZoomScalesheetViewZoomScaleNormal sheetViewZoomScalePageLayoutView!sheetViewZoomScaleSheetLayoutViewselectionActiveCellselectionActiveCellId selectionPaneselectionSqrefpaneActivePane paneStatepaneTopLeftCell paneXSplit paneYSplitrenderSheetViews ReadingOrderReadingOrderContextDependentReadingOrderLeftToRightReadingOrderRightToLeft PatternTypePatternTypeDarkDownPatternTypeDarkGrayPatternTypeDarkGridPatternTypeDarkHorizontalPatternTypeDarkTrellisPatternTypeDarkUpPatternTypeDarkVerticalPatternTypeGray0625PatternTypeGray125PatternTypeLightDownPatternTypeLightGrayPatternTypeLightGridPatternTypeLightHorizontalPatternTypeLightTrellisPatternTypeLightUpPatternTypeLightVerticalPatternTypeMediumGrayPatternTypeNonePatternTypeSolid LineStyleLineStyleDashDotLineStyleDashDotDotLineStyleDashedLineStyleDottedLineStyleDouble LineStyleHairLineStyleMediumLineStyleMediumDashDotLineStyleMediumDashDotDotLineStyleMediumDashed LineStyleNoneLineStyleSlantDashDotLineStyleThick LineStyleThinFontVerticalAlignmentFontVerticalAlignmentBaselineFontVerticalAlignmentSubscript FontVerticalAlignmentSuperscript FontUnderlineFontUnderlineSingleFontUnderlineDoubleFontUnderlineSingleAccountingFontUnderlineDoubleAccountingFontUnderlineNone FontSchemeFontSchemeMajorFontSchemeMinorFontSchemeNone FontFamilyFontFamilyNotApplicableFontFamilyRomanFontFamilySwissFontFamilyModernFontFamilyScriptFontFamilyDecorativeCellVerticalAlignmentCellVerticalAlignmentBottomCellVerticalAlignmentCenter CellVerticalAlignmentDistributedCellVerticalAlignmentJustifyCellVerticalAlignmentTopCellHorizontalAlignmentCellHorizontalAlignmentCenter'CellHorizontalAlignmentCenterContinuous"CellHorizontalAlignmentDistributedCellHorizontalAlignmentFillCellHorizontalAlignmentGeneralCellHorizontalAlignmentJustifyCellHorizontalAlignmentLeftCellHorizontalAlignmentRight Protection_protectionHidden_protectionLocked NumberFormat NfGeneralNfZero Nf2Decimal NfMax3DecimalNfThousandSeparator2Decimal NfPercentNfPercent2DecimalNfExponent2DecimalNfSingleSpacedFractionNfDoubleSpacedFractionNfMmDdYyNfDMmmYyNfDMmmNfMmmYy NfHMm12Hr NfHMmSs12HrNfHMmNfHMmSsNfMdyHMmNfThousandsNegativeParensNfThousandsNegativeRed!NfThousands2DecimalNegativeParensNfTousands2DecimalNEgativeRedNfMmSs NfOptHMmSsNfMmSs1DecimalNfExponent1DecimalNfTextPlaceHolderFont _fontBold _fontCharset _fontColor _fontCondense _fontExtend _fontFamily _fontItalic _fontName _fontOutline _fontScheme _fontShadow_fontStrikeThrough _fontSize_fontUnderline_fontVertAlign FillPattern_fillPatternBgColor_fillPatternFgColor_fillPatternTypeFill _fillPatternColor_colorAutomatic _colorARGB _colorTheme _colorTint BorderStyle_borderStyleColor_borderStyleLineBorder_borderDiagonalDown_borderDiagonalUp_borderOutline _borderBottom_borderDiagonal _borderEnd_borderHorizontal _borderLeft _borderRight _borderStart _borderTop_borderVertical Alignment_alignmentHorizontal_alignmentIndent_alignmentJustifyLastLine_alignmentReadingOrder_alignmentRelativeIndent_alignmentShrinkToFit_alignmentTextRotation_alignmentVertical_alignmentWrapTextCellXf_cellXfApplyAlignment_cellXfApplyBorder_cellXfApplyFill_cellXfApplyFont_cellXfApplyNumberFormat_cellXfApplyProtection_cellXfBorderId _cellXfFillId _cellXfFontId_cellXfNumFmtId_cellXfPivotButton_cellXfQuotePrefix _cellXfId_cellXfAlignment_cellXfProtection StyleSheet_styleSheetBorders_styleSheetCellXfs_styleSheetFills_styleSheetFontsnumberFormatIdstyleSheetBordersstyleSheetCellXfsstyleSheetFillsstyleSheetFontscellXfAlignmentcellXfApplyAlignmentcellXfApplyBordercellXfApplyFillcellXfApplyFontcellXfApplyNumberFormatcellXfApplyProtectioncellXfBorderId cellXfFillId cellXfFontIdcellXfIdcellXfNumFmtIdcellXfPivotButtoncellXfProtectioncellXfQuotePrefixalignmentHorizontalalignmentIndentalignmentJustifyLastLinealignmentReadingOrderalignmentRelativeIndentalignmentShrinkToFitalignmentTextRotationalignmentVerticalalignmentWrapText borderBottomborderDiagonalborderDiagonalDownborderDiagonalUp borderEndborderHorizontal borderLeft borderOutline borderRight borderStart borderTopborderVerticalborderStyleColorborderStyleLine colorARGBcolorAutomatic colorTheme colorTint fillPatternfillPatternBgColorfillPatternFgColorfillPatternTypefontBold fontCharset fontColor fontCondense fontExtend fontFamily fontItalicfontName fontOutline fontScheme fontShadowfontSizefontStrikeThrough fontUnderline fontVertAlignprotectionHiddenprotectionLockedminimalStyleSheet RunProperties_runPropertiesBold_runPropertiesCharset_runPropertiesColor_runPropertiesCondense_runPropertiesExtend_runPropertiesFontFamily_runPropertiesItalic_runPropertiesOutline_runPropertiesFont_runPropertiesScheme_runPropertiesShadow_runPropertiesStrikeThrough_runPropertiesSize_runPropertiesUnderline_runPropertiesVertAlign RichTextRun_richTextRunProperties_richTextRunTextrichTextRunPropertiesrichTextRunTextrunPropertiesBoldrunPropertiesCharsetrunPropertiesColorrunPropertiesCondenserunPropertiesExtendrunPropertiesFontrunPropertiesFontFamilyrunPropertiesItalicrunPropertiesOutlinerunPropertiesSchemerunPropertiesShadowrunPropertiesSizerunPropertiesStrikeThroughrunPropertiesUnderlinerunPropertiesVertAlignapplyRunPropertiesCell _cellStyle _cellValue CellValueCellText CellDoubleCellBoolCellRich Worksheet _wsColumns_wsRowPropertiesMap_wsCells _wsMerges _wsSheetViews _wsPageSetupRange ColumnsWidthcwMincwMaxcwWidthcwStyle RowPropertiesRowProps rowHeightrowStyleCellMap cellStyle cellValue DefinedNamesXlsx _xlSheets _xlStyles_xlDefinedNamesStylesunStyleswsCells wsColumnswsMerges wsPageSetupwsRowPropertiesMap wsSheetViewsxlDefinedNamesxlSheetsxlStyles emptyStylesint2colcol2inttoRowsfromRows mkCellRefmkRangeixSheetatSheetixCellixCellRCixCellXYatCellatCellRCatCellXY cellValueAt cellValueAtRC cellValueAtXY StringItemStringItemTextStringItemRichSharedStringTable_sharedStringTablesharedStringTable sstConstruct sstLookupText sstLookupRichsstItemtoXlsxfromXlsx FormattedCell_formattedAlignment_formattedBorder_formattedFill_formattedFont_formattedNumberFormat_formattedProtection_formattedPivotButton_formattedQuotePrefix_formattedValue_formattedColSpan_formattedRowSpan FormattedformattedCellMapformattedStyleSheetformattedMergesformattedAlignmentformattedBorderformattedColSpan formattedFill formattedFontformattedNumberFormatformattedPivotButtonformattedProtectionformattedQuotePrefixformattedRowSpanformattedValue$fToAttrValBool$fToAttrValDouble$fToAttrValInt $fToAttrVal[]$fToAttrValText runReader$fFromAttrValBool$fFromAttrValDouble$fFromAttrValInt$fFromAttrValText$fExceptionParseException$fFromAttrValOrientation$fFromAttrValPrintErrors$fFromAttrValCellComments$fFromAttrValPageOrder$fFromAttrValPaperSize$fFromCursorPageSetup$fToAttrValPaperSize$fToAttrValPageOrder$fToAttrValOrientation$fToAttrValPrintErrors$fToAttrValCellComments$fToElementPageSetup$fDefaultPageSetup$fFromAttrValPaneState$fFromAttrValPaneType$fFromAttrValSheetViewType$fFromCursorSelection$fFromCursorPane$fFromCursorSheetView$fToAttrValPaneState$fToAttrValPaneType$fToAttrValSheetViewType$fToElementPane$fToElementSelection$fToElementSheetView$fDefaultSheetViewDefault $fDefaultPane$fDefaultSelectionlens_79QbjHWZNQl8FFi9qmurz7Control.Lens.Internal.Indexedindexed$fFromCursorProtection$fFromCursorAlignment$fFromCursorCellXf$fFromCursorBorder$fFromCursorFillPattern$fFromCursorFill$fFromCursorColor$fFromCursorFont$fFromCursorStyleSheet$fToElementProtection$fToElementFont$fToElementFillPattern$fToElementFill$fToElementColor$fToElementBorderStyle$fToElementBorder$fToElementAlignment$fToElementCellXf$fToElementStyleSheet$fFromAttrValReadingOrder"$fFromAttrValCellVerticalAlignment$$fFromAttrValCellHorizontalAlignment$fFromAttrValLineStyle$fFromCursorBorderStyle$fFromAttrValPatternType$fFromAttrValFontScheme"$fFromAttrValFontVerticalAlignment$fFromAttrValFontUnderline$fFromAttrValFontFamily$fToAttrValReadingOrder$fToAttrValPatternType$fToAttrValLineStyle $fToAttrValFontVerticalAlignment$fToAttrValFontUnderline$fToAttrValFontScheme$fToAttrValFontFamily $fToAttrValCellVerticalAlignment"$fToAttrValCellHorizontalAlignment$fToDocumentStyleSheet$fDefaultProtection $fDefaultFont$fDefaultFillPattern $fDefaultFill$fDefaultColor$fDefaultBorderStyle$fDefaultBorder$fDefaultAlignment$fDefaultCellXf$fDefaultStyleSheet$fMonoidRunPropertiesbaseGHC.BaseMonoid$fFromCursorRunProperties$fFromCursorRichTextRun$fToElementRunProperties$fToElementRichTextRun$fDefaultRunProperties$fDefaultRichTextRun$fFromCursorColumnsWidth $fDefaultCell$fDefaultWorksheet$fDefaultDefinedNames $fDefaultXlsxControl.Lens.AtAt sstLookup$fFromCursorStringItem$fFromCursorSharedStringTable$fToElementStringItem$fToElementSharedStringTable$fToDocumentSharedStringTableodrpr xmlCursorgetSharedStrings readWorkbook WorksheetFilewfNamewfPath extractSheetextractCellValue getStyles getWbRelsintqNamensName nonEmptyNmElNothingjustNmElJustXlsxCell xlsxCellStyle xlsxCellValue XlsxCellDataXlsxSS XlsxDoubleXlsxBoolFileDatafdName fdContentType fdContentscoreXmlappXml xlsxCellTypevaluetransformSheetDatasheetXmlbookXmlssXml bookRelXml rootRelXmlcontentTypesXmlnmnEltxtitxtdtxtb_formattingMergesghc-prim GHC.TypesInt formatCell cellBlockFormattingState_formattingBorders_formattingCellXfs_formattingFills_formattingFontsformattingBordersformattingCellXfsformattingFillsformattingFontsformattingMergesstateFromStyleSheetstateToStyleSheetgetId cellStyleIdcellXf$fDefaultFormattedCell