Fields

• _xlSheets :: [(Text, Worksheet)]
   
• _xlStyles :: Styles
   
• _xlDefinedNames :: DefinedNames
   
• _xlCustomProperties :: Map Text Variant
   
• _xlDateBase :: DateBase

  date base to use when converting serial value (i.e. 'CellDouble d') into date-time. Default value is DateBase1900

  See also 18.17.4.1 "Date Conversion for Serial Date-Times" (p. 2067)

Fields

• unStyles :: ByteString
   

Fields

• cpMin :: Int

  First column affected by this ColumnWidth record.

• cpMax :: Int

  Last column affected by this ColumnWidth record.

• cpWidth :: Maybe Double

  Column width measured as the number of characters of the maximum digit width of the numbers 0, 1, 2, ..., 9 as rendered in the normal style's font.

  See longer description in Section 18.3.1.13 "col (Column Width & Formatting)" (p. 1605)

• cpStyle :: Maybe Int

  Default style for the affected column(s). Affects cells not yet allocated in the column(s). In other words, this style applies to new columns.

• cpHidden :: Bool

  Flag indicating if the affected column(s) are hidden on this worksheet.

• cpCollapsed :: Bool

  Flag indicating if the outlining of the affected column(s) is in the collapsed state.

• cpBestFit :: Bool

  Flag indicating if the specified column(s) is set to 'best fit'.

Fields

• _pageSetupBlackAndWhite :: Maybe Bool

  Print black and white.

• _pageSetupCellComments :: Maybe CellComments

  This attribute specifies how to print cell comments.

• _pageSetupCopies :: Maybe Int

  Number of copies to print.

• _pageSetupDraft :: Maybe Bool

  Print without graphics.

• _pageSetupErrors :: Maybe PrintErrors

  Specifies how to print cell values for cells with errors.

• _pageSetupFirstPageNumber :: Maybe Int

  Page number for first printed page. If no value is specified, then automatic is assumed.

• _pageSetupFitToHeight :: Maybe Int

  Number of vertical pages to fit on.

• _pageSetupFitToWidth :: Maybe Int

  Number of horizontal pages to fit on.

• _pageSetupHorizontalDpi :: Maybe Int

  Horizontal print resolution of the device.

• _pageSetupId :: Maybe Text

  Relationship Id of the devMode printer settings part.

  (Explicit reference to a parent XML element.)

  See 22.8.2.1 "ST_RelationshipId (Explicit Relationship ID)" (p. 3784)

• _pageSetupOrientation :: Maybe Orientation

  Orientation of the page.

• _pageSetupPageOrder :: Maybe PageOrder

  Order of printed pages

• _pageSetupPaperHeight :: Maybe Text

  Height of custom paper as a number followed by a unit identifier.

  When paperHeight and paperWidth are specified, paperSize shall be ignored. Examples: "297mm", "11in".

  See 22.9.2.12 "ST_PositiveUniversalMeasure (Positive Universal Measurement)" (p. 3792)

• _pageSetupPaperSize :: Maybe PaperSize

  Pager size

  When paperHeight, paperWidth, and paperUnits are specified, paperSize should be ignored.

• _pageSetupPaperWidth :: Maybe Text

  Width of custom paper as a number followed by a unit identifier

  Examples: 21cm, 8.5in

  When paperHeight and paperWidth are specified, paperSize shall be ignored.

• _pageSetupScale :: Maybe Int

  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.

• _pageSetupUseFirstPageNumber :: Maybe Bool

  Use _pageSetupFirstPageNumber value for first page number, and do not auto number the pages.

• _pageSetupUsePrinterDefaults :: Maybe Bool

  Use 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.

• _pageSetupVerticalDpi :: Maybe Int

  Vertical print resolution of the device.

Fields

• _wsColumnsProperties :: [ColumnsProperties]

  column widths

• _wsRowPropertiesMap :: Map RowIndex RowProperties

  custom row properties (height, style) map

• _wsCells :: CellMap

  data mapped by (row, column) pairs

• _wsDrawing :: Maybe Drawing

  SpreadsheetML Drawing

• _wsMerges :: [Range]

  list of cell merges

• _wsSheetViews :: Maybe [SheetView]
   
• _wsPageSetup :: Maybe PageSetup
   
• _wsConditionalFormattings :: Map SqRef ConditionalFormatting
   
• _wsDataValidations :: Map SqRef DataValidation
   
• _wsPivotTables :: [PivotTable]
   
• _wsAutoFilter :: Maybe AutoFilter
   
• _wsTables :: [Table]
   
• _wsProtection :: Maybe SheetProtection
   
• _wsSharedFormulas :: Map SharedFormulaIndex SharedFormulaOptions
   
• _wsState :: SheetState
   

Fields

• _cellfExpression :: FormulaExpression
   
• _cellfAssignsToName :: Bool

  Specifies that this formula assigns a value to a name.

• _cellfCalculate :: Bool

  Indicates that this formula needs to be recalculated the next time calculation is performed. [Example: This is always set on volatile functions, like =RAND(), and circular references. end example]

Fields

• _sfoRef :: CellRef
   
• _sfoExpression :: Formula
   

Fields

• _cellStyle :: Maybe Int
   
• _cellValue :: Maybe CellValue
   
• _cellComment :: Maybe Comment
   
• _cellFormula :: Maybe CellFormula
   

Fields

• rowHeight :: Maybe RowHeight

  Row height in points

• rowStyle :: Maybe Int

  Style to be applied to row

• rowHidden :: Bool

  Whether row is visible or not