xlsx-1.1.2.2: Simple and incomplete Excel file parser/writer

Safe Haskell | Safe-Inferred
Language | Haskell2010

Codec.Xlsx.Types.StyleSheet

Contents

- The main two types
- Supporting record types
- Supporting enumerations
- Lenses
  - StyleSheet
  - CellXf
  - Dxf
  - Alignment
  - Border
  - BorderStyle
  - Color
  - Fill
  - FillPattern
  - Font
  - Protection
- Helpers
  - Number formats

Description

Support for writing (but not reading) style sheets

Synopsis

- data StyleSheet = StyleSheet {
  - _styleSheetBorders :: [Border]
  - _styleSheetCellXfs :: [CellXf]
  - _styleSheetFills :: [Fill]
  - _styleSheetFonts :: [Font]
  - _styleSheetDxfs :: [Dxf]
  - _styleSheetNumFmts :: Map Int FormatCode
  }
- data CellXf = CellXf {
  - _cellXfApplyAlignment :: Maybe Bool
  - _cellXfApplyBorder :: Maybe Bool
  - _cellXfApplyFill :: Maybe Bool
  - _cellXfApplyFont :: Maybe Bool
  - _cellXfApplyNumberFormat :: Maybe Bool
  - _cellXfApplyProtection :: Maybe Bool
  - _cellXfBorderId :: Maybe Int
  - _cellXfFillId :: Maybe Int
  - _cellXfFontId :: Maybe Int
  - _cellXfNumFmtId :: Maybe Int
  - _cellXfPivotButton :: Maybe Bool
  - _cellXfQuotePrefix :: Maybe Bool
  - _cellXfId :: Maybe Int
  - _cellXfAlignment :: Maybe Alignment
  - _cellXfProtection :: Maybe Protection
  }
- minimalStyleSheet :: StyleSheet
- data Alignment = Alignment {
  - _alignmentHorizontal :: Maybe CellHorizontalAlignment
  - _alignmentIndent :: Maybe Int
  - _alignmentJustifyLastLine :: Maybe Bool
  - _alignmentReadingOrder :: Maybe ReadingOrder
  - _alignmentRelativeIndent :: Maybe Int
  - _alignmentShrinkToFit :: Maybe Bool
  - _alignmentTextRotation :: Maybe Int
  - _alignmentVertical :: Maybe CellVerticalAlignment
  - _alignmentWrapText :: Maybe Bool
  }
- data Border = Border {
  - _borderDiagonalDown :: Maybe Bool
  - _borderDiagonalUp :: Maybe Bool
  - _borderOutline :: Maybe Bool
  - _borderBottom :: Maybe BorderStyle
  - _borderDiagonal :: Maybe BorderStyle
  - _borderEnd :: Maybe BorderStyle
  - _borderHorizontal :: Maybe BorderStyle
  - _borderLeft :: Maybe BorderStyle
  - _borderRight :: Maybe BorderStyle
  - _borderStart :: Maybe BorderStyle
  - _borderTop :: Maybe BorderStyle
  - _borderVertical :: Maybe BorderStyle
  }
- data BorderStyle = BorderStyle {
  - _borderStyleColor :: Maybe Color
  - _borderStyleLine :: Maybe LineStyle
  }
- data Color = Color {
  - _colorAutomatic :: Maybe Bool
  - _colorARGB :: Maybe Text
  - _colorTheme :: Maybe Int
  - _colorTint :: Maybe Double
  }
- data Dxf = Dxf {
  - _dxfFont :: Maybe Font
  - _dxfNumFmt :: Maybe NumFmt
  - _dxfFill :: Maybe Fill
  - _dxfAlignment :: Maybe Alignment
  - _dxfBorder :: Maybe Border
  - _dxfProtection :: Maybe Protection
  }
- data Fill = Fill {
  - _fillPattern :: Maybe FillPattern
  }
- data FillPattern = FillPattern {
  - _fillPatternBgColor :: Maybe Color
  - _fillPatternFgColor :: Maybe Color
  - _fillPatternType :: Maybe PatternType
  }
- data Font = Font {
  - _fontBold :: Maybe Bool
  - _fontCharset :: Maybe Int
  - _fontColor :: Maybe Color
  - _fontCondense :: Maybe Bool
  - _fontExtend :: Maybe Bool
  - _fontFamily :: Maybe FontFamily
  - _fontItalic :: Maybe Bool
  - _fontName :: Maybe Text
  - _fontOutline :: Maybe Bool
  - _fontScheme :: Maybe FontScheme
  - _fontShadow :: Maybe Bool
  - _fontStrikeThrough :: Maybe Bool
  - _fontSize :: Maybe Double
  - _fontUnderline :: Maybe FontUnderline
  - _fontVertAlign :: Maybe FontVerticalAlignment
  }
- data NumberFormat
  - = StdNumberFormat ImpliedNumberFormat
  - | UserNumberFormat FormatCode
- data NumFmt = NumFmt {
  - _numFmtId :: Int
  - _numFmtCode :: FormatCode
  }
- data ImpliedNumberFormat
  - = NfGeneral
  - | NfZero
  - | Nf2Decimal
  - | NfMax3Decimal
  - | NfThousandSeparator2Decimal
  - | NfPercent
  - | NfPercent2Decimal
  - | NfExponent2Decimal
  - | NfSingleSpacedFraction
  - | NfDoubleSpacedFraction
  - | NfMmDdYy
  - | NfDMmmYy
  - | NfDMmm
  - | NfMmmYy
  - | NfHMm12Hr
  - | NfHMmSs12Hr
  - | NfHMm
  - | NfHMmSs
  - | NfMdyHMm
  - | NfThousandsNegativeParens
  - | NfThousandsNegativeRed
  - | NfThousands2DecimalNegativeParens
  - | NfThousands2DecimalNegativeRed
  - | NfMmSs
  - | NfOptHMmSs
  - | NfMmSs1Decimal
  - | NfExponent1Decimal
  - | NfTextPlaceHolder
  - | NfOtherImplied Int
- type FormatCode = Text
- data Protection = Protection {
  - _protectionHidden :: Maybe Bool
  - _protectionLocked :: Maybe Bool
  }
- data CellHorizontalAlignment
  - = CellHorizontalAlignmentCenter
  - | CellHorizontalAlignmentCenterContinuous
  - | CellHorizontalAlignmentDistributed
  - | CellHorizontalAlignmentFill
  - | CellHorizontalAlignmentGeneral
  - | CellHorizontalAlignmentJustify
  - | CellHorizontalAlignmentLeft
  - | CellHorizontalAlignmentRight
- data CellVerticalAlignment
  - = CellVerticalAlignmentBottom
  - | CellVerticalAlignmentCenter
  - | CellVerticalAlignmentDistributed
  - | CellVerticalAlignmentJustify
  - | CellVerticalAlignmentTop
- data FontFamily
  - = FontFamilyNotApplicable
  - | FontFamilyRoman
  - | FontFamilySwiss
  - | FontFamilyModern
  - | FontFamilyScript
  - | FontFamilyDecorative
- data FontScheme
  - = FontSchemeMajor
  - | FontSchemeMinor
  - | FontSchemeNone
- data FontUnderline
  - = FontUnderlineSingle
  - | FontUnderlineDouble
  - | FontUnderlineSingleAccounting
  - | FontUnderlineDoubleAccounting
  - | FontUnderlineNone
- data FontVerticalAlignment
  - = FontVerticalAlignmentBaseline
  - | FontVerticalAlignmentSubscript
  - | FontVerticalAlignmentSuperscript
- data LineStyle
  - = LineStyleDashDot
  - | LineStyleDashDotDot
  - | LineStyleDashed
  - | LineStyleDotted
  - | LineStyleDouble
  - | LineStyleHair
  - | LineStyleMedium
  - | LineStyleMediumDashDot
  - | LineStyleMediumDashDotDot
  - | LineStyleMediumDashed
  - | LineStyleNone
  - | LineStyleSlantDashDot
  - | LineStyleThick
  - | LineStyleThin
- data PatternType
  - = PatternTypeDarkDown
  - | PatternTypeDarkGray
  - | PatternTypeDarkGrid
  - | PatternTypeDarkHorizontal
  - | PatternTypeDarkTrellis
  - | PatternTypeDarkUp
  - | PatternTypeDarkVertical
  - | PatternTypeGray0625
  - | PatternTypeGray125
  - | PatternTypeLightDown
  - | PatternTypeLightGray
  - | PatternTypeLightGrid
  - | PatternTypeLightHorizontal
  - | PatternTypeLightTrellis
  - | PatternTypeLightUp
  - | PatternTypeLightVertical
  - | PatternTypeMediumGray
  - | PatternTypeNone
  - | PatternTypeSolid
- data ReadingOrder
  - = ReadingOrderContextDependent
  - | ReadingOrderLeftToRight
  - | ReadingOrderRightToLeft
- styleSheetBorders :: Lens' StyleSheet [Border]
- styleSheetFonts :: Lens' StyleSheet [Font]
- styleSheetFills :: Lens' StyleSheet [Fill]
- styleSheetCellXfs :: Lens' StyleSheet [CellXf]
- styleSheetDxfs :: Lens' StyleSheet [Dxf]
- styleSheetNumFmts :: Lens' StyleSheet (Map Int FormatCode)
- cellXfApplyAlignment :: Lens' CellXf (Maybe Bool)
- cellXfApplyBorder :: Lens' CellXf (Maybe Bool)
- cellXfApplyFill :: Lens' CellXf (Maybe Bool)
- cellXfApplyFont :: Lens' CellXf (Maybe Bool)
- cellXfApplyNumberFormat :: Lens' CellXf (Maybe Bool)
- cellXfApplyProtection :: Lens' CellXf (Maybe Bool)
- cellXfBorderId :: Lens' CellXf (Maybe Int)
- cellXfFillId :: Lens' CellXf (Maybe Int)
- cellXfFontId :: Lens' CellXf (Maybe Int)
- cellXfNumFmtId :: Lens' CellXf (Maybe Int)
- cellXfPivotButton :: Lens' CellXf (Maybe Bool)
- cellXfQuotePrefix :: Lens' CellXf (Maybe Bool)
- cellXfId :: Lens' CellXf (Maybe Int)
- cellXfAlignment :: Lens' CellXf (Maybe Alignment)
- cellXfProtection :: Lens' CellXf (Maybe Protection)
- dxfAlignment :: Lens' Dxf (Maybe Alignment)
- dxfBorder :: Lens' Dxf (Maybe Border)
- dxfFill :: Lens' Dxf (Maybe Fill)
- dxfFont :: Lens' Dxf (Maybe Font)
- dxfNumFmt :: Lens' Dxf (Maybe NumFmt)
- dxfProtection :: Lens' Dxf (Maybe Protection)
- alignmentHorizontal :: Lens' Alignment (Maybe CellHorizontalAlignment)
- alignmentIndent :: Lens' Alignment (Maybe Int)
- alignmentJustifyLastLine :: Lens' Alignment (Maybe Bool)
- alignmentReadingOrder :: Lens' Alignment (Maybe ReadingOrder)
- alignmentRelativeIndent :: Lens' Alignment (Maybe Int)
- alignmentShrinkToFit :: Lens' Alignment (Maybe Bool)
- alignmentTextRotation :: Lens' Alignment (Maybe Int)
- alignmentVertical :: Lens' Alignment (Maybe CellVerticalAlignment)
- alignmentWrapText :: Lens' Alignment (Maybe Bool)
- borderDiagonalDown :: Lens' Border (Maybe Bool)
- borderDiagonalUp :: Lens' Border (Maybe Bool)
- borderOutline :: Lens' Border (Maybe Bool)
- borderBottom :: Lens' Border (Maybe BorderStyle)
- borderDiagonal :: Lens' Border (Maybe BorderStyle)
- borderEnd :: Lens' Border (Maybe BorderStyle)
- borderHorizontal :: Lens' Border (Maybe BorderStyle)
- borderStart :: Lens' Border (Maybe BorderStyle)
- borderTop :: Lens' Border (Maybe BorderStyle)
- borderVertical :: Lens' Border (Maybe BorderStyle)
- borderLeft :: Lens' Border (Maybe BorderStyle)
- borderRight :: Lens' Border (Maybe BorderStyle)
- borderStyleColor :: Lens' BorderStyle (Maybe Color)
- borderStyleLine :: Lens' BorderStyle (Maybe LineStyle)
- colorAutomatic :: Lens' Color (Maybe Bool)
- colorARGB :: Lens' Color (Maybe Text)
- colorTheme :: Lens' Color (Maybe Int)
- colorTint :: Lens' Color (Maybe Double)
- fillPattern :: Iso' Fill (Maybe FillPattern)
- fillPatternBgColor :: Lens' FillPattern (Maybe Color)
- fillPatternFgColor :: Lens' FillPattern (Maybe Color)
- fillPatternType :: Lens' FillPattern (Maybe PatternType)
- fontBold :: Lens' Font (Maybe Bool)
- fontCharset :: Lens' Font (Maybe Int)
- fontColor :: Lens' Font (Maybe Color)
- fontCondense :: Lens' Font (Maybe Bool)
- fontExtend :: Lens' Font (Maybe Bool)
- fontFamily :: Lens' Font (Maybe FontFamily)
- fontItalic :: Lens' Font (Maybe Bool)
- fontName :: Lens' Font (Maybe Text)
- fontOutline :: Lens' Font (Maybe Bool)
- fontScheme :: Lens' Font (Maybe FontScheme)
- fontShadow :: Lens' Font (Maybe Bool)
- fontStrikeThrough :: Lens' Font (Maybe Bool)
- fontSize :: Lens' Font (Maybe Double)
- fontUnderline :: Lens' Font (Maybe FontUnderline)
- fontVertAlign :: Lens' Font (Maybe FontVerticalAlignment)
- protectionHidden :: Lens' Protection (Maybe Bool)
- protectionLocked :: Lens' Protection (Maybe Bool)
- fmtDecimals :: Int -> NumberFormat
- fmtDecimalsZeroes :: Int -> NumberFormat
- stdNumberFormatId :: ImpliedNumberFormat -> Int
- idToStdNumberFormat :: Int -> Maybe ImpliedNumberFormat
- firstUserNumFmtId :: Int

# The main two types

data StyleSheet Source #

StyleSheet for an XML document

Relevant parts of the EMCA standard (4th edition, part 1, https://ecma-international.org/publications-and-standards/standards/ecma-376/), page numbers refer to the page in the PDF rather than the page number as printed on the page):

- Chapter 12, "SpreadsheetML" (p. 74) In particular Section 12.3.20, "Styles Part" (p. 104)
- Chapter 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
- cellStyleXfs
- colors
- extLst
- tableStyles

NOTE: Because of undocumented Excel requirements you will probably want to base your style sheet on `minimalStyleSheet` (a proper style sheet should have some contents for details see SO post). `def` for `StyleSheet` includes no contents at all and this could be a problem for Excel.

See also:

- `renderStyleSheet` to translate a `StyleSheet` to `Styles`
- `formatted` for a higher level interface.
- `parseStyleSheet` to translate a raw `StyleSheet` into `Styles`

Constructors

StyleSheet |

Fields

- _styleSheetBorders :: [Border]

  This element contains borders formatting information, specifying all border definitions for all cells in the workbook.

  Section 18.8.5, "borders (Borders)" (p. 1760)

- _styleSheetCellXfs :: [CellXf]

  Cell formats

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

  Section 18.8.10, "cellXfs (Cell Formats)" (p. 1764)

- _styleSheetFills :: [Fill]

  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)

- _styleSheetFonts :: [Font]

  This element contains all font definitions for this workbook.

  Section 18.8.23 "fonts (Fonts)" (p. 1769)

- _styleSheetDxfs :: [Dxf]

  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)

- _styleSheetNumFmts :: Map Int FormatCode

  Number formats

  This element contains custom number formats defined in this style sheet

  Section 18.8.31, "numFmts (Number Formats)" (p. 1784)

#### Instances

Instances details

Generic StyleSheet Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep StyleSheet :: Type -> Type Source # Methods from :: StyleSheet -> Rep StyleSheet x Source # to :: Rep StyleSheet x -> StyleSheet Source #
Show StyleSheet Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> StyleSheet -> ShowS Source # show :: StyleSheet -> String Source # showList :: [StyleSheet] -> ShowS Source #
Default StyleSheet Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: StyleSheet #
NFData StyleSheet Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: StyleSheet -> () Source #
Eq StyleSheet Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: StyleSheet -> StyleSheet -> Bool Source # (/=) :: StyleSheet -> StyleSheet -> Bool Source #
Ord StyleSheet Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: StyleSheet -> StyleSheet -> Ordering Source #

(<) :: StyleSheet -> StyleSheet -> Bool Source #

(<=) :: StyleSheet -> StyleSheet -> Bool Source #

(>) :: StyleSheet -> StyleSheet -> Bool Source #

(>=) :: StyleSheet -> StyleSheet -> Bool Source #

max :: StyleSheet -> StyleSheet -> StyleSheet Source #

min :: StyleSheet -> StyleSheet -> StyleSheet Source #

FromCursor StyleSheet Source # | See `CT_Stylesheet`, p. 4482
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [StyleSheet] Source #
ToDocument StyleSheet Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toDocument :: StyleSheet -> Document Source #
ToElement StyleSheet Source # | See `CT_Stylesheet`, p. 4482
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> StyleSheet -> Element Source #
type Rep StyleSheet Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep StyleSheet = D1 ('MetaData "StyleSheet" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "StyleSheet" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_styleSheetBorders") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [Border]) :*: (S1 ('MetaSel ('Just "_styleSheetCellXfs") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [CellXf]) :*: S1 ('MetaSel ('Just "_styleSheetFills") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [Fill]))) :*: (S1 ('MetaSel ('Just "_styleSheetFonts") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [Font]) :*: (S1 ('MetaSel ('Just "_styleSheetDxfs") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 [Dxf]) :*: S1 ('MetaSel ('Just "_styleSheetNumFmts") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Map Int FormatCode))))))

data CellXf Source #

Cell formatting

TODO: The `extLst` field is currently unsupported.

Section 18.8.45 "xf (Format)" (p. 1800)

Constructors

CellXf |

Fields

- _cellXfApplyAlignment :: Maybe Bool

  A boolean value indicating whether the alignment formatting specified for this xf should be applied.

- _cellXfApplyBorder :: Maybe Bool

  A boolean value indicating whether the border formatting specified for this xf should be applied.

- _cellXfApplyFill :: Maybe Bool

  A boolean value indicating whether the fill formatting specified for this xf should be applied.

- _cellXfApplyFont :: Maybe Bool

  A boolean value indicating whether the font formatting specified for this xf should be applied.

- _cellXfApplyNumberFormat :: Maybe Bool

  A boolean value indicating whether the number formatting specified for this xf should be applied.

- _cellXfApplyProtection :: Maybe Bool

  A boolean value indicating whether the protection formatting specified for this xf should be applied.

- _cellXfBorderId :: Maybe Int

  Zero-based index of the border record used by this cell format.

  (18.18.2, p. 2437).

- _cellXfFillId :: Maybe Int

  Zero-based index of the fill record used by this cell format.

  (18.18.30, p. 2455)

- _cellXfFontId :: Maybe Int

  Zero-based index of the font record used by this cell format.

  An integer that represents a zero based index into the `styleSheetFonts` collection in the style sheet (18.18.32, p. 2456).

- _cellXfNumFmtId :: Maybe Int

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

- _cellXfPivotButton :: Maybe Bool

  A boolean value indicating whether the cell rendering includes a pivot table dropdown button.

- _cellXfQuotePrefix :: Maybe Bool

  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.

- _cellXfId :: Maybe Int

  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.

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

- _cellXfAlignment :: Maybe Alignment

  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.

- _cellXfProtection :: Maybe Protection

  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.

#### Instances

Instances details

Generic CellXf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep CellXf :: Type -> Type Source # Methods from :: CellXf -> Rep CellXf x Source # to :: Rep CellXf x -> CellXf Source #
Show CellXf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> CellXf -> ShowS Source # show :: CellXf -> String Source # showList :: [CellXf] -> ShowS Source #
Default CellXf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: CellXf #
NFData CellXf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: CellXf -> () Source #
Eq CellXf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: CellXf -> CellXf -> Bool Source # (/=) :: CellXf -> CellXf -> Bool Source #
Ord CellXf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods compare :: CellXf -> CellXf -> Ordering Source # (<) :: CellXf -> CellXf -> Bool Source # (<=) :: CellXf -> CellXf -> Bool Source # (>) :: CellXf -> CellXf -> Bool Source # (>=) :: CellXf -> CellXf -> Bool Source # max :: CellXf -> CellXf -> CellXf Source # min :: CellXf -> CellXf -> CellXf Source #
FromCursor CellXf Source # | See `CT_Xf`, p. 4486
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [CellXf] Source #
ToElement CellXf Source # | See `CT_Xf`, p. 4486
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> CellXf -> Element Source #
type Rep CellXf Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep CellXf = D1 ('MetaData "CellXf" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "CellXf" 'PrefixI 'True) (((S1 ('MetaSel ('Just "_cellXfApplyAlignment") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: (S1 ('MetaSel ('Just "_cellXfApplyBorder") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_cellXfApplyFill") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)))) :*: ((S1 ('MetaSel ('Just "_cellXfApplyFont") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_cellXfApplyNumberFormat") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool))) :*: (S1 ('MetaSel ('Just "_cellXfApplyProtection") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_cellXfBorderId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int))))) :*: (((S1 ('MetaSel ('Just "_cellXfFillId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: S1 ('MetaSel ('Just "_cellXfFontId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int))) :*: (S1 ('MetaSel ('Just "_cellXfNumFmtId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: S1 ('MetaSel ('Just "_cellXfPivotButton") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)))) :*: ((S1 ('MetaSel ('Just "_cellXfQuotePrefix") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_cellXfId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int))) :*: (S1 ('MetaSel ('Just "_cellXfAlignment") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Alignment)) :*: S1 ('MetaSel ('Just "_cellXfProtection") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Protection)))))))

minimalStyleSheet :: StyleSheet Source #

Minimal style sheet

Excel expects some minimal definitions in the stylesheet; you probably want to define your own stylesheets based on this one.

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

# Supporting record types

data Alignment Source #

Alignment

See 18.8.1 "alignment (Alignment)" (p. 1754)

Constructors

Alignment |

Fields

- _alignmentHorizontal :: Maybe CellHorizontalAlignment

  Specifies the type of horizontal alignment in cells.

- _alignmentIndent :: Maybe Int

  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.

- _alignmentJustifyLastLine :: Maybe Bool

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

- _alignmentReadingOrder :: Maybe ReadingOrder

  An integer value indicating whether the reading order (bidirectionality) of the cell is leftto- right, right-to-left, or context dependent.

- _alignmentRelativeIndent :: Maybe Int

  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.

- _alignmentShrinkToFit :: Maybe Bool

  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.

- _alignmentTextRotation :: Maybe Int

  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.

- _alignmentVertical :: Maybe CellVerticalAlignment

  Vertical alignment in cells.

- _alignmentWrapText :: Maybe Bool

  A boolean value indicating if the text in a cell should be line-wrapped within the cell.

#### Instances

Instances details

Generic Alignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep Alignment :: Type -> Type Source # Methods from :: Alignment -> Rep Alignment x Source # to :: Rep Alignment x -> Alignment Source #
Show Alignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> Alignment -> ShowS Source # show :: Alignment -> String Source # showList :: [Alignment] -> ShowS Source #
Default Alignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: Alignment #
NFData Alignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: Alignment -> () Source #
Eq Alignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: Alignment -> Alignment -> Bool Source # (/=) :: Alignment -> Alignment -> Bool Source #
Ord Alignment Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: Alignment -> Alignment -> Ordering Source #

(<) :: Alignment -> Alignment -> Bool Source #

(<=) :: Alignment -> Alignment -> Bool Source #

(>) :: Alignment -> Alignment -> Bool Source #

(>=) :: Alignment -> Alignment -> Bool Source #

max :: Alignment -> Alignment -> Alignment Source #

min :: Alignment -> Alignment -> Alignment Source #

FromCursor Alignment Source # | See `CT_CellAlignment`, p. 4482
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [Alignment] Source #
ToElement Alignment Source # | See `CT_CellAlignment`, p. 4482
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> Alignment -> Element Source #
type Rep Alignment Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep Alignment = D1 ('MetaData "Alignment" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "Alignment" 'PrefixI 'True) (((S1 ('MetaSel ('Just "_alignmentHorizontal") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe CellHorizontalAlignment)) :*: S1 ('MetaSel ('Just "_alignmentIndent") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int))) :*: (S1 ('MetaSel ('Just "_alignmentJustifyLastLine") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_alignmentReadingOrder") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe ReadingOrder)))) :*: ((S1 ('MetaSel ('Just "_alignmentRelativeIndent") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: S1 ('MetaSel ('Just "_alignmentShrinkToFit") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool))) :*: (S1 ('MetaSel ('Just "_alignmentTextRotation") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: (S1 ('MetaSel ('Just "_alignmentVertical") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe CellVerticalAlignment)) :*: S1 ('MetaSel ('Just "_alignmentWrapText") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)))))))

data Border Source #

Expresses 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)

Constructors

Border |

Fields

- _borderDiagonalDown :: Maybe Bool

  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.

- _borderDiagonalUp :: Maybe Bool

  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.

- _borderOutline :: Maybe Bool

  A boolean value indicating if left, right, top, and bottom borders should be applied only to outside borders of a cell range.

- _borderBottom :: Maybe BorderStyle

  Bottom border

- _borderDiagonal :: Maybe BorderStyle

  Diagonal

- _borderEnd :: Maybe BorderStyle

  Trailing edge border

  See also `borderRight`

- _borderHorizontal :: Maybe BorderStyle

  Horizontal inner borders

- _borderLeft :: Maybe BorderStyle

  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 `borderStart`.

- _borderRight :: Maybe BorderStyle

  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 `borderEnd`.

- _borderStart :: Maybe BorderStyle

  Leading edge border

  See also `borderLeft`

- _borderTop :: Maybe BorderStyle

  Top border

- _borderVertical :: Maybe BorderStyle

  Vertical inner border

#### Instances

Instances details

Generic Border Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep Border :: Type -> Type Source # Methods from :: Border -> Rep Border x Source # to :: Rep Border x -> Border Source #
Show Border Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> Border -> ShowS Source # show :: Border -> String Source # showList :: [Border] -> ShowS Source #
Default Border Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: Border #
NFData Border Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: Border -> () Source #
Eq Border Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: Border -> Border -> Bool Source # (/=) :: Border -> Border -> Bool Source #
Ord Border Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods compare :: Border -> Border -> Ordering Source # (<) :: Border -> Border -> Bool Source # (<=) :: Border -> Border -> Bool Source # (>) :: Border -> Border -> Bool Source # (>=) :: Border -> Border -> Bool Source # max :: Border -> Border -> Border Source # min :: Border -> Border -> Border Source #
FromCursor Border Source # | See `CT_Border`, p. 4483
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [Border] Source #
ToElement Border Source # | See `CT_Border`, p. 4483
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> Border -> Element Source #
type Rep Border Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep Border = D1 ('MetaData "Border" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "Border" 'PrefixI 'True) (((S1 ('MetaSel ('Just "_borderDiagonalDown") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: (S1 ('MetaSel ('Just "_borderDiagonalUp") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_borderOutline") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)))) :*: (S1 ('MetaSel ('Just "_borderBottom") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe BorderStyle)) :*: (S1 ('MetaSel ('Just "_borderDiagonal") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe BorderStyle)) :*: S1 ('MetaSel ('Just "_borderEnd") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe BorderStyle))))) :*: ((S1 ('MetaSel ('Just "_borderHorizontal") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe BorderStyle)) :*: (S1 ('MetaSel ('Just "_borderLeft") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe BorderStyle)) :*: S1 ('MetaSel ('Just "_borderRight") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe BorderStyle)))) :*: (S1 ('MetaSel ('Just "_borderStart") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe BorderStyle)) :*: (S1 ('MetaSel ('Just "_borderTop") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe BorderStyle)) :*: S1 ('MetaSel ('Just "_borderVertical") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe BorderStyle)))))))

data BorderStyle Source #

Border style See `CT_BorderPr` (p. 3934)

Constructors

BorderStyle |

Fields

- _borderStyleColor :: Maybe Color
- _borderStyleLine :: Maybe LineStyle

#### Instances

Instances details

Generic BorderStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep BorderStyle :: Type -> Type Source # Methods from :: BorderStyle -> Rep BorderStyle x Source # to :: Rep BorderStyle x -> BorderStyle Source #
Show BorderStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> BorderStyle -> ShowS Source # show :: BorderStyle -> String Source # showList :: [BorderStyle] -> ShowS Source #
Default BorderStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: BorderStyle #
NFData BorderStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: BorderStyle -> () Source #
Eq BorderStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: BorderStyle -> BorderStyle -> Bool Source # (/=) :: BorderStyle -> BorderStyle -> Bool Source #
Ord BorderStyle Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: BorderStyle -> BorderStyle -> Ordering Source #

(<) :: BorderStyle -> BorderStyle -> Bool Source #

(<=) :: BorderStyle -> BorderStyle -> Bool Source #

(>) :: BorderStyle -> BorderStyle -> Bool Source #

(>=) :: BorderStyle -> BorderStyle -> Bool Source #

max :: BorderStyle -> BorderStyle -> BorderStyle Source #

min :: BorderStyle -> BorderStyle -> BorderStyle Source #

FromCursor BorderStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [BorderStyle] Source #
ToElement BorderStyle Source # | See `CT_BorderPr`, p. 4483
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> BorderStyle -> Element Source #
type Rep BorderStyle Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep BorderStyle = D1 ('MetaData "BorderStyle" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "BorderStyle" 'PrefixI 'True) (S1 ('MetaSel ('Just "_borderStyleColor") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Color)) :*: S1 ('MetaSel ('Just "_borderStyleLine") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe LineStyle))))

data Color Source #

One of the colors associated with the data bar or color scale.

The `indexed` attribute (used for backwards compatibility only) is not modelled here.

See 18.3.1.15 "color (Data Bar Color)" (p. 1608)

Constructors

Color |

Fields

- _colorAutomatic :: Maybe Bool

  A boolean value indicating the color is automatic and system color dependent.

- _colorARGB :: Maybe Text

  Standard 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).

- _colorTheme :: Maybe Int

  A zero-based index into the clrScheme collection (20.1.6.2), referencing a particular sysClr or srgbClr value expressed in the Theme part.

- _colorTint :: Maybe Double

  Specifies the tint value applied to the color.

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

#### Instances

Instances details

Generic Color Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep Color :: Type -> Type Source # Methods from :: Color -> Rep Color x Source # to :: Rep Color x -> Color Source #
Show Color Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> Color -> ShowS Source # show :: Color -> String Source # showList :: [Color] -> ShowS Source #
Default Color Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: Color #
NFData Color Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: Color -> () Source #
Eq Color Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: Color -> Color -> Bool Source # (/=) :: Color -> Color -> Bool Source #
Ord Color Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods compare :: Color -> Color -> Ordering Source # (<) :: Color -> Color -> Bool Source # (<=) :: Color -> Color -> Bool Source # (>) :: Color -> Color -> Bool Source # (>=) :: Color -> Color -> Bool Source # max :: Color -> Color -> Color Source # min :: Color -> Color -> Color Source #
FromCursor Color Source # | See `CT_Color`, p. 4484
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [Color] Source #
FromXenoNode Color Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromXenoNode :: Node -> Either Text Color Source #
ToElement Color Source # | See `CT_Color`, p. 4484
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> Color -> Element Source #
type Rep Color Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep Color = D1 ('MetaData "Color" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "Color" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_colorAutomatic") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_colorARGB") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Text))) :*: (S1 ('MetaSel ('Just "_colorTheme") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: S1 ('MetaSel ('Just "_colorTint") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Double)))))

data Dxf Source #

A single dxf record, expressing incremental formatting to be applied.

Section 18.8.14, "dxf (Formatting)" (p. 1765)

Constructors

Dxf |

Fields

- _dxfFont :: Maybe Font
- _dxfNumFmt :: Maybe NumFmt

  It seems to be required that this number format entry is duplicated in `_styleSheetNumFmts` of the style sheet, though the spec says nothing explicitly about it.

- _dxfFill :: Maybe Fill
- _dxfAlignment :: Maybe Alignment
- _dxfBorder :: Maybe Border
- _dxfProtection :: Maybe Protection

#### Instances

Instances details

Generic Dxf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep Dxf :: Type -> Type Source # Methods from :: Dxf -> Rep Dxf x Source # to :: Rep Dxf x -> Dxf Source #
Show Dxf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> Dxf -> ShowS Source # show :: Dxf -> String Source # showList :: [Dxf] -> ShowS Source #
Default Dxf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: Dxf #
NFData Dxf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: Dxf -> () Source #
Eq Dxf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: Dxf -> Dxf -> Bool Source # (/=) :: Dxf -> Dxf -> Bool Source #
Ord Dxf Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods compare :: Dxf -> Dxf -> Ordering Source # (<) :: Dxf -> Dxf -> Bool Source # (<=) :: Dxf -> Dxf -> Bool Source # (>) :: Dxf -> Dxf -> Bool Source # (>=) :: Dxf -> Dxf -> Bool Source # max :: Dxf -> Dxf -> Dxf Source # min :: Dxf -> Dxf -> Dxf Source #
FromCursor Dxf Source # | See `CT_Dxf`, p. 3937
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [Dxf] Source #
ToElement Dxf Source # | See `CT_Dxf`, p. 3937
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> Dxf -> Element Source #
type Rep Dxf Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep Dxf = D1 ('MetaData "Dxf" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "Dxf" 'PrefixI 'True) ((S1 ('MetaSel ('Just "_dxfFont") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Font)) :*: (S1 ('MetaSel ('Just "_dxfNumFmt") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe NumFmt)) :*: S1 ('MetaSel ('Just "_dxfFill") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Fill)))) :*: (S1 ('MetaSel ('Just "_dxfAlignment") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Alignment)) :*: (S1 ('MetaSel ('Just "_dxfBorder") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Border)) :*: S1 ('MetaSel ('Just "_dxfProtection") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Protection))))))

data Fill Source #

This element specifies fill formatting.

TODO: Gradient fills (18.8.4) are currently unsupported. If we add them, then the spec says (`CT_Fill`, p. 3935), _either_ a gradient _or_ a solid fill pattern should be specified.

Section 18.8.20, "fill (Fill)" (p. 1768)

Constructors

Fill |

Fields

- _fillPattern :: Maybe FillPattern

#### Instances

Instances details

Generic Fill Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep Fill :: Type -> Type Source # Methods from :: Fill -> Rep Fill x Source # to :: Rep Fill x -> Fill Source #
Show Fill Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> Fill -> ShowS Source # show :: Fill -> String Source # showList :: [Fill] -> ShowS Source #
Default Fill Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: Fill #
NFData Fill Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: Fill -> () Source #
Eq Fill Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: Fill -> Fill -> Bool Source # (/=) :: Fill -> Fill -> Bool Source #
Ord Fill Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods compare :: Fill -> Fill -> Ordering Source # (<) :: Fill -> Fill -> Bool Source # (<=) :: Fill -> Fill -> Bool Source # (>) :: Fill -> Fill -> Bool Source # (>=) :: Fill -> Fill -> Bool Source # max :: Fill -> Fill -> Fill Source # min :: Fill -> Fill -> Fill Source #
FromCursor Fill Source # | See `CT_Fill`, p. 4484
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [Fill] Source #
ToElement Fill Source # | See `CT_Fill`, p. 4484
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> Fill -> Element Source #
type Rep Fill Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet type Rep Fill = D1 ('MetaData "Fill" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "Fill" 'PrefixI 'True) (S1 ('MetaSel ('Just "_fillPattern") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe FillPattern))))

data FillPattern Source #

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.

Section 18.8.32 "patternFill (Pattern)" (p. 1793)

Constructors

FillPattern |

Fields

- _fillPatternBgColor :: Maybe Color
- _fillPatternFgColor :: Maybe Color
- _fillPatternType :: Maybe PatternType

#### Instances

Instances details

Generic FillPattern Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep FillPattern :: Type -> Type Source # Methods from :: FillPattern -> Rep FillPattern x Source # to :: Rep FillPattern x -> FillPattern Source #
Show FillPattern Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> FillPattern -> ShowS Source # show :: FillPattern -> String Source # showList :: [FillPattern] -> ShowS Source #
Default FillPattern Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: FillPattern #
NFData FillPattern Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: FillPattern -> () Source #
Eq FillPattern Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: FillPattern -> FillPattern -> Bool Source # (/=) :: FillPattern -> FillPattern -> Bool Source #
Ord FillPattern Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: FillPattern -> FillPattern -> Ordering Source #

(<) :: FillPattern -> FillPattern -> Bool Source #

(<=) :: FillPattern -> FillPattern -> Bool Source #

(>) :: FillPattern -> FillPattern -> Bool Source #

(>=) :: FillPattern -> FillPattern -> Bool Source #

max :: FillPattern -> FillPattern -> FillPattern Source #

min :: FillPattern -> FillPattern -> FillPattern Source #

FromCursor FillPattern Source # | See `CT_PatternFill`, p. 4484
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [FillPattern] Source #
ToElement FillPattern Source # | See `CT_PatternFill`, p. 4484
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> FillPattern -> Element Source #
type Rep FillPattern Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep FillPattern = D1 ('MetaData "FillPattern" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "FillPattern" 'PrefixI 'True) (S1 ('MetaSel ('Just "_fillPatternBgColor") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Color)) :*: (S1 ('MetaSel ('Just "_fillPatternFgColor") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Color)) :*: S1 ('MetaSel ('Just "_fillPatternType") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe PatternType)))))

data Font Source #

This element defines the properties for one of the fonts used in this workbook.

Section 18.2.22 "font (Font)" (p. 1769)

Constructors

Font |

Fields

- _fontBold :: Maybe Bool

  Displays characters in bold face font style.

- _fontCharset :: Maybe Int

  This element defines the font character set of this font.

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

  Section 18.4.1 "charset (Character Set)" provides some example values.

- _fontColor :: Maybe Color

  Color

- _fontCondense :: Maybe Bool

  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.

- _fontExtend :: Maybe Bool

  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.

- _fontFamily :: Maybe FontFamily

  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.

- _fontItalic :: Maybe Bool

  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.

- _fontName :: Maybe Text

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

  The string length for this attribute shall be 0 to 31 characters.

- _fontOutline :: Maybe Bool

  This element displays only the inner and outer borders of each character. This is very similar to Bold in behavior.

- _fontScheme :: Maybe FontScheme

  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.

- _fontShadow :: Maybe Bool

  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. SpreadsheetML applications are not required to render according to this flag.

- _fontStrikeThrough :: Maybe Bool

  This element draws a strikethrough line through the horizontal middle of the text.

- _fontSize :: Maybe Double

  This element represents the point size (1/72 of an inch) of the Latin and East Asian text.

- _fontUnderline :: Maybe FontUnderline

  This element represents the underline formatting style.

- _fontVertAlign :: Maybe FontVerticalAlignment

  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 `subscript` texts, and shall reduce the font size (if a smaller size is available) accordingly.

#### Instances

Instances details

Generic Font Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep Font :: Type -> Type Source # Methods from :: Font -> Rep Font x Source # to :: Rep Font x -> Font Source #
Show Font Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> Font -> ShowS Source # show :: Font -> String Source # showList :: [Font] -> ShowS Source #
Default Font Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: Font #
NFData Font Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: Font -> () Source #
Eq Font Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: Font -> Font -> Bool Source # (/=) :: Font -> Font -> Bool Source #
Ord Font Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods compare :: Font -> Font -> Ordering Source # (<) :: Font -> Font -> Bool Source # (<=) :: Font -> Font -> Bool Source # (>) :: Font -> Font -> Bool Source # (>=) :: Font -> Font -> Bool Source # max :: Font -> Font -> Font Source # min :: Font -> Font -> Font Source #
FromCursor Font Source # | See `CT_Font`, p. 4489
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [Font] Source #
ToElement Font Source # | See `CT_Font`, p. 4489
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> Font -> Element Source #
type Rep Font Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep Font = D1 ('MetaData "Font" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "Font" 'PrefixI 'True) (((S1 ('MetaSel ('Just "_fontBold") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: (S1 ('MetaSel ('Just "_fontCharset") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Int)) :*: S1 ('MetaSel ('Just "_fontColor") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Color)))) :*: ((S1 ('MetaSel ('Just "_fontCondense") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_fontExtend") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool))) :*: (S1 ('MetaSel ('Just "_fontFamily") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe FontFamily)) :*: S1 ('MetaSel ('Just "_fontItalic") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool))))) :*: (((S1 ('MetaSel ('Just "_fontName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Text)) :*: S1 ('MetaSel ('Just "_fontOutline") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool))) :*: (S1 ('MetaSel ('Just "_fontScheme") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe FontScheme)) :*: S1 ('MetaSel ('Just "_fontShadow") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)))) :*: ((S1 ('MetaSel ('Just "_fontStrikeThrough") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_fontSize") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Double))) :*: (S1 ('MetaSel ('Just "_fontUnderline") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe FontUnderline)) :*: S1 ('MetaSel ('Just "_fontVertAlign") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe FontVerticalAlignment)))))))

data NumberFormat Source #

This type gives a high-level version of representation of number format used in `Format`.

Constructors

StdNumberFormat ImpliedNumberFormat |
UserNumberFormat FormatCode |

#### Instances

Instances details

Generic NumberFormat Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep NumberFormat :: Type -> Type Source # Methods from :: NumberFormat -> Rep NumberFormat x Source # to :: Rep NumberFormat x -> NumberFormat Source #
Show NumberFormat Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> NumberFormat -> ShowS Source # show :: NumberFormat -> String Source # showList :: [NumberFormat] -> ShowS Source #
NFData NumberFormat Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: NumberFormat -> () Source #
Eq NumberFormat Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: NumberFormat -> NumberFormat -> Bool Source # (/=) :: NumberFormat -> NumberFormat -> Bool Source #
Ord NumberFormat Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: NumberFormat -> NumberFormat -> Ordering Source #

(<) :: NumberFormat -> NumberFormat -> Bool Source #

(<=) :: NumberFormat -> NumberFormat -> Bool Source #

(>) :: NumberFormat -> NumberFormat -> Bool Source #

(>=) :: NumberFormat -> NumberFormat -> Bool Source #

max :: NumberFormat -> NumberFormat -> NumberFormat Source #

min :: NumberFormat -> NumberFormat -> NumberFormat Source #

type Rep NumberFormat Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep NumberFormat = D1 ('MetaData "NumberFormat" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "StdNumberFormat" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 ImpliedNumberFormat)) :+: C1 ('MetaCons "UserNumberFormat" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 FormatCode)))

data NumFmt Source #

This element specifies number format properties which indicate how to format and render the numeric value of a cell.

Section 18.8.30 "numFmt (Number Format)" (p. 1777)

Constructors

NumFmt |

Fields

- _numFmtId :: Int
- _numFmtCode :: FormatCode

#### Instances

Instances details

Generic NumFmt Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep NumFmt :: Type -> Type Source # Methods from :: NumFmt -> Rep NumFmt x Source # to :: Rep NumFmt x -> NumFmt Source #
Show NumFmt Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> NumFmt -> ShowS Source # show :: NumFmt -> String Source # showList :: [NumFmt] -> ShowS Source #
NFData NumFmt Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: NumFmt -> () Source #
Eq NumFmt Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: NumFmt -> NumFmt -> Bool Source # (/=) :: NumFmt -> NumFmt -> Bool Source #
Ord NumFmt Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods compare :: NumFmt -> NumFmt -> Ordering Source # (<) :: NumFmt -> NumFmt -> Bool Source # (<=) :: NumFmt -> NumFmt -> Bool Source # (>) :: NumFmt -> NumFmt -> Bool Source # (>=) :: NumFmt -> NumFmt -> Bool Source # max :: NumFmt -> NumFmt -> NumFmt Source # min :: NumFmt -> NumFmt -> NumFmt Source #
FromCursor NumFmt Source # | See `CT_NumFmt`, p. 3936
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [NumFmt] Source #
ToElement NumFmt Source # | See `CT_NumFmt`, p. 3936
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> NumFmt -> Element Source #
type Rep NumFmt Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep NumFmt = D1 ('MetaData "NumFmt" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "NumFmt" 'PrefixI 'True) (S1 ('MetaSel ('Just "_numFmtId") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int) :*: S1 ('MetaSel ('Just "_numFmtCode") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 FormatCode)))

data ImpliedNumberFormat Source #

Implied number formats

Note: This only implements the predefined values for 18.2.30 "All Languages", other built-in format ids (with id < `firstUserNumFmtId`) are stored in `NfOtherBuiltin`

Constructors

NfGeneral

    0 General

NfZero

    1 0

Nf2Decimal

    2 0.00

NfMax3Decimal

    3 #,##0

NfThousandSeparator2Decimal

    4 #,##0.00

NfPercent

    9 0%

NfPercent2Decimal

    10 0.00%

NfExponent2Decimal

    11 0.00E+00

NfSingleSpacedFraction

    12 # ?/?

NfDoubleSpacedFraction

    13 # ??/??

NfMmDdYy

    14 mm-dd-yy

NfDMmmYy

    15 d-mmm-yy

NfDMmm

    16 d-mmm

NfMmmYy

    17 mmm-yy

NfHMm12Hr

    18 h:mm AM/PM

NfHMmSs12Hr

    19 h:mm:ss AM/PM

NfHMm

    20 h:mm

NfHMmSs

    21 h:mm:ss

NfMdyHMm

    22 m/d/yy h:mm

NfThousandsNegativeParens

    37 #,##0 ;(#,##0)

NfThousandsNegativeRed

    38 #,##0 ;[Red](#,##0)

NfThousands2DecimalNegativeParens

    39 #,##0.00;(#,##0.00)

NfThousands2DecimalNegativeRed

    40 #,##0.00;[Red](#,##0.00)

NfMmSs

    45 mm:ss

NfOptHMmSs

    46 [h]:mm:ss

NfMmSs1Decimal

    47 mmss.0

NfExponent1Decimal

    48 ##0.0E+0

NfTextPlaceHolder

    49 @

NfOtherImplied Int | other (non local-neutral?) built-in format (id < 164)

#### Instances

Instances details

Generic ImpliedNumberFormat Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep ImpliedNumberFormat :: Type -> Type Source # Methods from :: ImpliedNumberFormat -> Rep ImpliedNumberFormat x Source # to :: Rep ImpliedNumberFormat x -> ImpliedNumberFormat Source #
Show ImpliedNumberFormat Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> ImpliedNumberFormat -> ShowS Source # show :: ImpliedNumberFormat -> String Source # showList :: [ImpliedNumberFormat] -> ShowS Source #
NFData ImpliedNumberFormat Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: ImpliedNumberFormat -> () Source #
Eq ImpliedNumberFormat Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool Source # (/=) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool Source #
Ord ImpliedNumberFormat Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: ImpliedNumberFormat -> ImpliedNumberFormat -> Ordering Source #

(<) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool Source #

(<=) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool Source #

(>) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool Source #

(>=) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool Source #

max :: ImpliedNumberFormat -> ImpliedNumberFormat -> ImpliedNumberFormat Source #

min :: ImpliedNumberFormat -> ImpliedNumberFormat -> ImpliedNumberFormat Source #

type Rep ImpliedNumberFormat Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep ImpliedNumberFormat = D1 ('MetaData "ImpliedNumberFormat" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) ((((C1 ('MetaCons "NfGeneral" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "NfZero" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "Nf2Decimal" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "NfMax3Decimal" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfThousandSeparator2Decimal" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "NfPercent" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfPercent2Decimal" 'PrefixI 'False) (U1 :: Type -> Type)))) :+: ((C1 ('MetaCons "NfExponent2Decimal" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "NfSingleSpacedFraction" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfDoubleSpacedFraction" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "NfMmDdYy" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfDMmmYy" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "NfDMmm" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfMmmYy" 'PrefixI 'False) (U1 :: Type -> Type))))) :+: (((C1 ('MetaCons "NfHMm12Hr" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "NfHMmSs12Hr" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfHMm" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "NfHMmSs" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfMdyHMm" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "NfThousandsNegativeParens" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfThousandsNegativeRed" 'PrefixI 'False) (U1 :: Type -> Type)))) :+: (((C1 ('MetaCons "NfThousands2DecimalNegativeParens" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfThousands2DecimalNegativeRed" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "NfMmSs" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfOptHMmSs" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "NfMmSs1Decimal" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfExponent1Decimal" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "NfTextPlaceHolder" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "NfOtherImplied" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Int)))))))

type FormatCode = Text Source #

A number format code.

Section 18.8.30, "numFmt (Number Format)" (p. 1777)

data Protection Source #

Protection properties

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.

Section 18.8.33, "protection (Protection Properties)", p. 1793

Constructors

Protection |

Fields

- _protectionHidden :: Maybe Bool
- _protectionLocked :: Maybe Bool

#### Instances

Instances details

Generic Protection Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep Protection :: Type -> Type Source # Methods from :: Protection -> Rep Protection x Source # to :: Rep Protection x -> Protection Source #
Show Protection Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> Protection -> ShowS Source # show :: Protection -> String Source # showList :: [Protection] -> ShowS Source #
Default Protection Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods def :: Protection #
NFData Protection Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: Protection -> () Source #
Eq Protection Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: Protection -> Protection -> Bool Source # (/=) :: Protection -> Protection -> Bool Source #
Ord Protection Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: Protection -> Protection -> Ordering Source #

(<) :: Protection -> Protection -> Bool Source #

(<=) :: Protection -> Protection -> Bool Source #

(>) :: Protection -> Protection -> Bool Source #

(>=) :: Protection -> Protection -> Bool Source #

max :: Protection -> Protection -> Protection Source #

min :: Protection -> Protection -> Protection Source #

FromCursor Protection Source # | See `CT_CellProtection`, p. 4484
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromCursor :: Cursor -> [Protection] Source #
ToElement Protection Source # | See `CT_CellProtection`, p. 4484
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toElement :: Name -> Protection -> Element Source #
type Rep Protection Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep Protection = D1 ('MetaData "Protection" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "Protection" 'PrefixI 'True) (S1 ('MetaSel ('Just "_protectionHidden") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "_protectionLocked") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 (Maybe Bool))))

# Supporting enumerations

data CellHorizontalAlignment Source #

Horizontal alignment in cells

See 18.18.40 "ST_HorizontalAlignment (Horizontal Alignment Type)" (p. 2459)

Constructors

CellHorizontalAlignmentCenter |
CellHorizontalAlignmentCenterContinuous |
CellHorizontalAlignmentDistributed |
CellHorizontalAlignmentFill |
CellHorizontalAlignmentGeneral |
CellHorizontalAlignmentJustify |
CellHorizontalAlignmentLeft |
CellHorizontalAlignmentRight |

#### Instances

Instances details

Generic CellHorizontalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep CellHorizontalAlignment :: Type -> Type Source # Methods from :: CellHorizontalAlignment -> Rep CellHorizontalAlignment x Source # to :: Rep CellHorizontalAlignment x -> CellHorizontalAlignment Source #
Show CellHorizontalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> CellHorizontalAlignment -> ShowS Source # show :: CellHorizontalAlignment -> String Source # showList :: [CellHorizontalAlignment] -> ShowS Source #
NFData CellHorizontalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: CellHorizontalAlignment -> () Source #
Eq CellHorizontalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool Source # (/=) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool Source #
Ord CellHorizontalAlignment Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: CellHorizontalAlignment -> CellHorizontalAlignment -> Ordering Source #

(<) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool Source #

(<=) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool Source #

(>) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool Source #

(>=) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool Source #

max :: CellHorizontalAlignment -> CellHorizontalAlignment -> CellHorizontalAlignment Source #

min :: CellHorizontalAlignment -> CellHorizontalAlignment -> CellHorizontalAlignment Source #

FromAttrVal CellHorizontalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrVal :: Reader CellHorizontalAlignment Source #
ToAttrVal CellHorizontalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toAttrVal :: CellHorizontalAlignment -> Text Source #
type Rep CellHorizontalAlignment Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep CellHorizontalAlignment = D1 ('MetaData "CellHorizontalAlignment" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (((C1 ('MetaCons "CellHorizontalAlignmentCenter" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "CellHorizontalAlignmentCenterContinuous" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "CellHorizontalAlignmentDistributed" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "CellHorizontalAlignmentFill" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "CellHorizontalAlignmentGeneral" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "CellHorizontalAlignmentJustify" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "CellHorizontalAlignmentLeft" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "CellHorizontalAlignmentRight" 'PrefixI 'False) (U1 :: Type -> Type))))

data CellVerticalAlignment Source #

Vertical alignment in cells

See 18.18.88 "ST_VerticalAlignment (Vertical Alignment Types)" (p. 2512)

Constructors

CellVerticalAlignmentBottom |
CellVerticalAlignmentCenter |
CellVerticalAlignmentDistributed |
CellVerticalAlignmentJustify |
CellVerticalAlignmentTop |

#### Instances

Instances details

Generic CellVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep CellVerticalAlignment :: Type -> Type Source # Methods from :: CellVerticalAlignment -> Rep CellVerticalAlignment x Source # to :: Rep CellVerticalAlignment x -> CellVerticalAlignment Source #
Show CellVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> CellVerticalAlignment -> ShowS Source # show :: CellVerticalAlignment -> String Source # showList :: [CellVerticalAlignment] -> ShowS Source #
NFData CellVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: CellVerticalAlignment -> () Source #
Eq CellVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool Source # (/=) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool Source #
Ord CellVerticalAlignment Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: CellVerticalAlignment -> CellVerticalAlignment -> Ordering Source #

(<) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool Source #

(<=) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool Source #

(>) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool Source #

(>=) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool Source #

max :: CellVerticalAlignment -> CellVerticalAlignment -> CellVerticalAlignment Source #

min :: CellVerticalAlignment -> CellVerticalAlignment -> CellVerticalAlignment Source #

FromAttrVal CellVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrVal :: Reader CellVerticalAlignment Source #
ToAttrVal CellVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toAttrVal :: CellVerticalAlignment -> Text Source #
type Rep CellVerticalAlignment Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep CellVerticalAlignment = D1 ('MetaData "CellVerticalAlignment" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) ((C1 ('MetaCons "CellVerticalAlignmentBottom" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "CellVerticalAlignmentCenter" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "CellVerticalAlignmentDistributed" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "CellVerticalAlignmentJustify" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "CellVerticalAlignmentTop" 'PrefixI 'False) (U1 :: Type -> Type))))

data FontFamily Source #

Font family

See 18.8.18 "family (Font Family)" (p. 1766) and 17.18.30 "ST_FontFamily (Font Family Value)" (p. 1388)

Constructors

FontFamilyNotApplicable | Family is not applicable
FontFamilyRoman | Proportional font with serifs
FontFamilySwiss | Proportional font without serifs
FontFamilyModern | Monospace font with or without serifs
FontFamilyScript | Script font designed to mimic the appearance of handwriting
FontFamilyDecorative | Novelty font

#### Instances

Instances details

Generic FontFamily Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep FontFamily :: Type -> Type Source # Methods from :: FontFamily -> Rep FontFamily x Source # to :: Rep FontFamily x -> FontFamily Source #
Show FontFamily Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> FontFamily -> ShowS Source # show :: FontFamily -> String Source # showList :: [FontFamily] -> ShowS Source #
NFData FontFamily Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: FontFamily -> () Source #
Eq FontFamily Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: FontFamily -> FontFamily -> Bool Source # (/=) :: FontFamily -> FontFamily -> Bool Source #
Ord FontFamily Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: FontFamily -> FontFamily -> Ordering Source #

(<) :: FontFamily -> FontFamily -> Bool Source #

(<=) :: FontFamily -> FontFamily -> Bool Source #

(>) :: FontFamily -> FontFamily -> Bool Source #

(>=) :: FontFamily -> FontFamily -> Bool Source #

max :: FontFamily -> FontFamily -> FontFamily Source #

min :: FontFamily -> FontFamily -> FontFamily Source #

FromAttrVal FontFamily Source # | See 18.18.94 "ST_FontFamily (Font Family)" (p. 2517)
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrVal :: Reader FontFamily Source #
FromAttrBs FontFamily Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrBs :: ByteString -> Either Text FontFamily Source #
ToAttrVal FontFamily Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toAttrVal :: FontFamily -> Text Source #
type Rep FontFamily Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep FontFamily = D1 ('MetaData "FontFamily" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) ((C1 ('MetaCons "FontFamilyNotApplicable" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "FontFamilyRoman" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "FontFamilySwiss" 'PrefixI 'False) (U1 :: Type -> Type))) :+: (C1 ('MetaCons "FontFamilyModern" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "FontFamilyScript" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "FontFamilyDecorative" 'PrefixI 'False) (U1 :: Type -> Type))))

data FontScheme Source #

Font scheme

See 18.18.33 "ST_FontScheme (Font scheme Styles)" (p. 2456)

Constructors

FontSchemeMajor | This font is the major font for this theme.
FontSchemeMinor | This font is the minor font for this theme.
FontSchemeNone | This font is not a theme font.

#### Instances

Instances details

Generic FontScheme Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep FontScheme :: Type -> Type Source # Methods from :: FontScheme -> Rep FontScheme x Source # to :: Rep FontScheme x -> FontScheme Source #
Show FontScheme Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> FontScheme -> ShowS Source # show :: FontScheme -> String Source # showList :: [FontScheme] -> ShowS Source #
NFData FontScheme Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: FontScheme -> () Source #
Eq FontScheme Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: FontScheme -> FontScheme -> Bool Source # (/=) :: FontScheme -> FontScheme -> Bool Source #
Ord FontScheme Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: FontScheme -> FontScheme -> Ordering Source #

(<) :: FontScheme -> FontScheme -> Bool Source #

(<=) :: FontScheme -> FontScheme -> Bool Source #

(>) :: FontScheme -> FontScheme -> Bool Source #

(>=) :: FontScheme -> FontScheme -> Bool Source #

max :: FontScheme -> FontScheme -> FontScheme Source #

min :: FontScheme -> FontScheme -> FontScheme Source #

FromAttrVal FontScheme Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrVal :: Reader FontScheme Source #
FromAttrBs FontScheme Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrBs :: ByteString -> Either Text FontScheme Source #
ToAttrVal FontScheme Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toAttrVal :: FontScheme -> Text Source #
type Rep FontScheme Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep FontScheme = D1 ('MetaData "FontScheme" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "FontSchemeMajor" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "FontSchemeMinor" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "FontSchemeNone" 'PrefixI 'False) (U1 :: Type -> Type)))

data FontUnderline Source #

Font underline property

See 18.4.13 "u (Underline)", p 1728

Constructors

FontUnderlineSingle |
FontUnderlineDouble |
FontUnderlineSingleAccounting |
FontUnderlineDoubleAccounting |
FontUnderlineNone |

#### Instances

Instances details

Generic FontUnderline Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep FontUnderline :: Type -> Type Source # Methods from :: FontUnderline -> Rep FontUnderline x Source # to :: Rep FontUnderline x -> FontUnderline Source #
Show FontUnderline Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> FontUnderline -> ShowS Source # show :: FontUnderline -> String Source # showList :: [FontUnderline] -> ShowS Source #
NFData FontUnderline Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: FontUnderline -> () Source #
Eq FontUnderline Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: FontUnderline -> FontUnderline -> Bool Source # (/=) :: FontUnderline -> FontUnderline -> Bool Source #
Ord FontUnderline Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: FontUnderline -> FontUnderline -> Ordering Source #

(<) :: FontUnderline -> FontUnderline -> Bool Source #

(<=) :: FontUnderline -> FontUnderline -> Bool Source #

(>) :: FontUnderline -> FontUnderline -> Bool Source #

(>=) :: FontUnderline -> FontUnderline -> Bool Source #

max :: FontUnderline -> FontUnderline -> FontUnderline Source #

min :: FontUnderline -> FontUnderline -> FontUnderline Source #

FromAttrVal FontUnderline Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrVal :: Reader FontUnderline Source #
FromAttrBs FontUnderline Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrBs :: ByteString -> Either Text FontUnderline Source #
ToAttrVal FontUnderline Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toAttrVal :: FontUnderline -> Text Source #
type Rep FontUnderline Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep FontUnderline = D1 ('MetaData "FontUnderline" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) ((C1 ('MetaCons "FontUnderlineSingle" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "FontUnderlineDouble" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "FontUnderlineSingleAccounting" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "FontUnderlineDoubleAccounting" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "FontUnderlineNone" 'PrefixI 'False) (U1 :: Type -> Type))))

data FontVerticalAlignment Source #

Vertical alignment

See 22.9.2.17 "ST_VerticalAlignRun (Vertical Positioning Location)" (p. 3794)

Constructors

FontVerticalAlignmentBaseline |
FontVerticalAlignmentSubscript |
FontVerticalAlignmentSuperscript |

#### Instances

Instances details

Generic FontVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep FontVerticalAlignment :: Type -> Type Source # Methods from :: FontVerticalAlignment -> Rep FontVerticalAlignment x Source # to :: Rep FontVerticalAlignment x -> FontVerticalAlignment Source #
Show FontVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> FontVerticalAlignment -> ShowS Source # show :: FontVerticalAlignment -> String Source # showList :: [FontVerticalAlignment] -> ShowS Source #
NFData FontVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: FontVerticalAlignment -> () Source #
Eq FontVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool Source # (/=) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool Source #
Ord FontVerticalAlignment Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: FontVerticalAlignment -> FontVerticalAlignment -> Ordering Source #

(<) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool Source #

(<=) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool Source #

(>) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool Source #

(>=) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool Source #

max :: FontVerticalAlignment -> FontVerticalAlignment -> FontVerticalAlignment Source #

min :: FontVerticalAlignment -> FontVerticalAlignment -> FontVerticalAlignment Source #

FromAttrVal FontVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrVal :: Reader FontVerticalAlignment Source #
FromAttrBs FontVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrBs :: ByteString -> Either Text FontVerticalAlignment Source #
ToAttrVal FontVerticalAlignment Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toAttrVal :: FontVerticalAlignment -> Text Source #
type Rep FontVerticalAlignment Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep FontVerticalAlignment = D1 ('MetaData "FontVerticalAlignment" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "FontVerticalAlignmentBaseline" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "FontVerticalAlignmentSubscript" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "FontVerticalAlignmentSuperscript" 'PrefixI 'False) (U1 :: Type -> Type)))

data LineStyle Source #

Constructors

LineStyleDashDot |
LineStyleDashDotDot |
LineStyleDashed |
LineStyleDotted |
LineStyleDouble |
LineStyleHair |
LineStyleMedium |
LineStyleMediumDashDot |
LineStyleMediumDashDotDot |
LineStyleMediumDashed |
LineStyleNone |
LineStyleSlantDashDot |
LineStyleThick |
LineStyleThin |

#### Instances

Instances details

Generic LineStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep LineStyle :: Type -> Type Source # Methods from :: LineStyle -> Rep LineStyle x Source # to :: Rep LineStyle x -> LineStyle Source #
Show LineStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> LineStyle -> ShowS Source # show :: LineStyle -> String Source # showList :: [LineStyle] -> ShowS Source #
NFData LineStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: LineStyle -> () Source #
Eq LineStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: LineStyle -> LineStyle -> Bool Source # (/=) :: LineStyle -> LineStyle -> Bool Source #
Ord LineStyle Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: LineStyle -> LineStyle -> Ordering Source #

(<) :: LineStyle -> LineStyle -> Bool Source #

(<=) :: LineStyle -> LineStyle -> Bool Source #

(>) :: LineStyle -> LineStyle -> Bool Source #

(>=) :: LineStyle -> LineStyle -> Bool Source #

max :: LineStyle -> LineStyle -> LineStyle Source #

min :: LineStyle -> LineStyle -> LineStyle Source #

FromAttrVal LineStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrVal :: Reader LineStyle Source #
ToAttrVal LineStyle Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toAttrVal :: LineStyle -> Text Source #
type Rep LineStyle Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep LineStyle = D1 ('MetaData "LineStyle" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (((C1 ('MetaCons "LineStyleDashDot" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "LineStyleDashDotDot" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "LineStyleDashed" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "LineStyleDotted" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "LineStyleDouble" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "LineStyleHair" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "LineStyleMedium" 'PrefixI 'False) (U1 :: Type -> Type)))) :+: ((C1 ('MetaCons "LineStyleMediumDashDot" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "LineStyleMediumDashDotDot" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "LineStyleMediumDashed" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "LineStyleNone" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "LineStyleSlantDashDot" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "LineStyleThick" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "LineStyleThin" 'PrefixI 'False) (U1 :: Type -> Type)))))

data PatternType Source #

Indicates the style of fill pattern being used for a cell format.

Section 18.18.55 "ST_PatternType (Pattern Type)" (p. 2472)

Constructors

PatternTypeDarkDown |
PatternTypeDarkGray |
PatternTypeDarkGrid |
PatternTypeDarkHorizontal |
PatternTypeDarkTrellis |
PatternTypeDarkUp |
PatternTypeDarkVertical |
PatternTypeGray0625 |
PatternTypeGray125 |
PatternTypeLightDown |
PatternTypeLightGray |
PatternTypeLightGrid |
PatternTypeLightHorizontal |
PatternTypeLightTrellis |
PatternTypeLightUp |
PatternTypeLightVertical |
PatternTypeMediumGray |
PatternTypeNone |
PatternTypeSolid |

#### Instances

Instances details

Generic PatternType Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep PatternType :: Type -> Type Source # Methods from :: PatternType -> Rep PatternType x Source # to :: Rep PatternType x -> PatternType Source #
Show PatternType Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> PatternType -> ShowS Source # show :: PatternType -> String Source # showList :: [PatternType] -> ShowS Source #
NFData PatternType Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: PatternType -> () Source #
Eq PatternType Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: PatternType -> PatternType -> Bool Source # (/=) :: PatternType -> PatternType -> Bool Source #
Ord PatternType Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: PatternType -> PatternType -> Ordering Source #

(<) :: PatternType -> PatternType -> Bool Source #

(<=) :: PatternType -> PatternType -> Bool Source #

(>) :: PatternType -> PatternType -> Bool Source #

(>=) :: PatternType -> PatternType -> Bool Source #

max :: PatternType -> PatternType -> PatternType Source #

min :: PatternType -> PatternType -> PatternType Source #

FromAttrVal PatternType Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrVal :: Reader PatternType Source #
ToAttrVal PatternType Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toAttrVal :: PatternType -> Text Source #
type Rep PatternType Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep PatternType = D1 ('MetaData "PatternType" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) ((((C1 ('MetaCons "PatternTypeDarkDown" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PatternTypeDarkGray" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "PatternTypeDarkGrid" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PatternTypeDarkHorizontal" 'PrefixI 'False) (U1 :: Type -> Type))) :+: ((C1 ('MetaCons "PatternTypeDarkTrellis" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PatternTypeDarkUp" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "PatternTypeDarkVertical" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "PatternTypeGray0625" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PatternTypeGray125" 'PrefixI 'False) (U1 :: Type -> Type))))) :+: (((C1 ('MetaCons "PatternTypeLightDown" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PatternTypeLightGray" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "PatternTypeLightGrid" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "PatternTypeLightHorizontal" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PatternTypeLightTrellis" 'PrefixI 'False) (U1 :: Type -> Type)))) :+: ((C1 ('MetaCons "PatternTypeLightUp" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PatternTypeLightVertical" 'PrefixI 'False) (U1 :: Type -> Type)) :+: (C1 ('MetaCons "PatternTypeMediumGray" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "PatternTypeNone" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "PatternTypeSolid" 'PrefixI 'False) (U1 :: Type -> Type))))))

data ReadingOrder Source #

Reading order

See 18.8.1 "alignment (Alignment)" (p. 1754, esp. p. 1755)

Constructors

ReadingOrderContextDependent |
ReadingOrderLeftToRight |
ReadingOrderRightToLeft |

#### Instances

Instances details

Generic ReadingOrder Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Associated Types type Rep ReadingOrder :: Type -> Type Source # Methods from :: ReadingOrder -> Rep ReadingOrder x Source # to :: Rep ReadingOrder x -> ReadingOrder Source #
Show ReadingOrder Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods showsPrec :: Int -> ReadingOrder -> ShowS Source # show :: ReadingOrder -> String Source # showList :: [ReadingOrder] -> ShowS Source #
NFData ReadingOrder Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods rnf :: ReadingOrder -> () Source #
Eq ReadingOrder Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods (==) :: ReadingOrder -> ReadingOrder -> Bool Source # (/=) :: ReadingOrder -> ReadingOrder -> Bool Source #
Ord ReadingOrder Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

Methods

compare :: ReadingOrder -> ReadingOrder -> Ordering Source #

(<) :: ReadingOrder -> ReadingOrder -> Bool Source #

(<=) :: ReadingOrder -> ReadingOrder -> Bool Source #

(>) :: ReadingOrder -> ReadingOrder -> Bool Source #

(>=) :: ReadingOrder -> ReadingOrder -> Bool Source #

max :: ReadingOrder -> ReadingOrder -> ReadingOrder Source #

min :: ReadingOrder -> ReadingOrder -> ReadingOrder Source #

FromAttrVal ReadingOrder Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods fromAttrVal :: Reader ReadingOrder Source #
ToAttrVal ReadingOrder Source # |
Instance details Defined in Codec.Xlsx.Types.StyleSheet Methods toAttrVal :: ReadingOrder -> Text Source #
type Rep ReadingOrder Source # |

Instance details

Defined in Codec.Xlsx.Types.StyleSheet

type Rep ReadingOrder = D1 ('MetaData "ReadingOrder" "Codec.Xlsx.Types.StyleSheet" "xlsx-1.1.2.2-DopzEu8STPN4igxHgE9OUe" 'False) (C1 ('MetaCons "ReadingOrderContextDependent" 'PrefixI 'False) (U1 :: Type -> Type) :+: (C1 ('MetaCons "ReadingOrderLeftToRight" 'PrefixI 'False) (U1 :: Type -> Type) :+: C1 ('MetaCons "ReadingOrderRightToLeft" 'PrefixI 'False) (U1 :: Type -> Type)))

# Lenses

## StyleSheet

styleSheetBorders :: Lens' StyleSheet [Border] Source #

styleSheetFonts :: Lens' StyleSheet [Font] Source #

styleSheetFills :: Lens' StyleSheet [Fill] Source #

styleSheetCellXfs :: Lens' StyleSheet [CellXf] Source #

styleSheetDxfs :: Lens' StyleSheet [Dxf] Source #

styleSheetNumFmts :: Lens' StyleSheet (Map Int FormatCode) Source #

## CellXf

cellXfApplyAlignment :: Lens' CellXf (Maybe Bool) Source #

cellXfApplyBorder :: Lens' CellXf (Maybe Bool) Source #

cellXfApplyFill :: Lens' CellXf (Maybe Bool) Source #

cellXfApplyFont :: Lens' CellXf (Maybe Bool) Source #

cellXfApplyNumberFormat :: Lens' CellXf (Maybe Bool) Source #

cellXfApplyProtection :: Lens' CellXf (Maybe Bool) Source #

cellXfBorderId :: Lens' CellXf (Maybe Int) Source #

cellXfFillId :: Lens' CellXf (Maybe Int) Source #

cellXfFontId :: Lens' CellXf (Maybe Int) Source #

cellXfNumFmtId :: Lens' CellXf (Maybe Int) Source #

cellXfPivotButton :: Lens' CellXf (Maybe Bool) Source #

cellXfQuotePrefix :: Lens' CellXf (Maybe Bool) Source #

cellXfId :: Lens' CellXf (Maybe Int) Source #

cellXfAlignment :: Lens' CellXf (Maybe Alignment) Source #

cellXfProtection :: Lens' CellXf (Maybe Protection) Source #

## Dxf

dxfAlignment :: Lens' Dxf (Maybe Alignment) Source #

dxfBorder :: Lens' Dxf (Maybe Border) Source #

dxfFill :: Lens' Dxf (Maybe Fill) Source #

dxfFont :: Lens' Dxf (Maybe Font) Source #

dxfNumFmt :: Lens' Dxf (Maybe NumFmt) Source #

dxfProtection :: Lens' Dxf (Maybe Protection) Source #

## Alignment

alignmentHorizontal :: Lens' Alignment (Maybe CellHorizontalAlignment) Source #

alignmentIndent :: Lens' Alignment (Maybe Int) Source #

alignmentJustifyLastLine :: Lens' Alignment (Maybe Bool) Source #

alignmentReadingOrder :: Lens' Alignment (Maybe ReadingOrder) Source #

alignmentRelativeIndent :: Lens' Alignment (Maybe Int) Source #

alignmentShrinkToFit :: Lens' Alignment (Maybe Bool) Source #

alignmentTextRotation :: Lens' Alignment (Maybe Int) Source #

alignmentVertical :: Lens' Alignment (Maybe CellVerticalAlignment) Source #

alignmentWrapText :: Lens' Alignment (Maybe Bool) Source #

## Border

borderDiagonalDown :: Lens' Border (Maybe Bool) Source #

borderDiagonalUp :: Lens' Border (Maybe Bool) Source #

borderOutline :: Lens' Border (Maybe Bool) Source #

borderBottom :: Lens' Border (Maybe BorderStyle) Source #

borderDiagonal :: Lens' Border (Maybe BorderStyle) Source #

borderEnd :: Lens' Border (Maybe BorderStyle) Source #

borderHorizontal :: Lens' Border (Maybe BorderStyle) Source #

borderStart :: Lens' Border (Maybe BorderStyle) Source #

borderTop :: Lens' Border (Maybe BorderStyle) Source #

borderVertical :: Lens' Border (Maybe BorderStyle) Source #

borderLeft :: Lens' Border (Maybe BorderStyle) Source #

borderRight :: Lens' Border (Maybe BorderStyle) Source #

## BorderStyle

borderStyleColor :: Lens' BorderStyle (Maybe Color) Source #

borderStyleLine :: Lens' BorderStyle (Maybe LineStyle) Source #

## Color

colorAutomatic :: Lens' Color (Maybe Bool) Source #

colorARGB :: Lens' Color (Maybe Text) Source #

colorTheme :: Lens' Color (Maybe Int) Source #

colorTint :: Lens' Color (Maybe Double) Source #

## Fill

fillPattern :: Iso' Fill (Maybe FillPattern) Source #

## FillPattern

fillPatternBgColor :: Lens' FillPattern (Maybe Color) Source #

fillPatternFgColor :: Lens' FillPattern (Maybe Color) Source #

fillPatternType :: Lens' FillPattern (Maybe PatternType) Source #

## Font

fontBold :: Lens' Font (Maybe Bool) Source #

fontCharset :: Lens' Font (Maybe Int) Source #

fontColor :: Lens' Font (Maybe Color) Source #

fontCondense :: Lens' Font (Maybe Bool) Source #

fontExtend :: Lens' Font (Maybe Bool) Source #

fontFamily :: Lens' Font (Maybe FontFamily) Source #

fontItalic :: Lens' Font (Maybe Bool) Source #

fontName :: Lens' Font (Maybe Text) Source #

fontOutline :: Lens' Font (Maybe Bool) Source #

fontScheme :: Lens' Font (Maybe FontScheme) Source #

fontShadow :: Lens' Font (Maybe Bool) Source #

fontStrikeThrough :: Lens' Font (Maybe Bool) Source #

fontSize :: Lens' Font (Maybe Double) Source #

fontUnderline :: Lens' Font (Maybe FontUnderline) Source #

fontVertAlign :: Lens' Font (Maybe FontVerticalAlignment) Source #

## Protection

protectionHidden :: Lens' Protection (Maybe Bool) Source #

protectionLocked :: Lens' Protection (Maybe Bool) Source #

# Helpers

## Number formats

fmtDecimals :: Int -> NumberFormat Source #

Basic number format with predefined number of decimals as format code of number format in xlsx should be less than 255 characters number of decimals shouldn't be more than 253

fmtDecimalsZeroes :: Int -> NumberFormat Source #

Basic number format with predefined number of decimals. Works like `fmtDecimals` with the only difference that extra zeroes are displayed when number of digits after the point is less than the number of digits specified in the format

stdNumberFormatId :: ImpliedNumberFormat -> Int Source #

idToStdNumberFormat :: Int -> Maybe ImpliedNumberFormat Source #

firstUserNumFmtId :: Int Source #