Codec.Xlsx.Formatted

Higher level interface for creating styled worksheets

Documentation

data FormattedCell

Cell with formatting. _cellStyle property of _formattedCell is ignored

See formatted for more details.

Constructors

FormattedCell

Fields

• _formattedCell :: Cell
• _formattedFormat :: Format
• _formattedColSpan :: Int
• _formattedRowSpan :: Int

Instances

Eq FormattedCell

Methods

(==) :: FormattedCell -> FormattedCell -> Bool

(/=) :: FormattedCell -> FormattedCell -> Bool

Show FormattedCell

Methods

showsPrec :: Int -> FormattedCell -> ShowS

show :: FormattedCell -> String

showList :: [FormattedCell] -> ShowS

Default FormattedCell

Methods

def :: FormattedCell

data Formatted

Result of formatting

See formatted

Constructors

Formatted

Fields

• formattedCellMap :: CellMap

  The final CellMap; see _wsCells

• formattedStyleSheet :: StyleSheet

  The final stylesheet; see _xlStyles (and renderStyleSheet)

• formattedMerges :: [Range]

  The final list of cell merges; see _wsMerges

Instances

Eq Formatted

Methods

(==) :: Formatted -> Formatted -> Bool

(/=) :: Formatted -> Formatted -> Bool

Show Formatted

Methods

showsPrec :: Int -> Formatted -> ShowS

show :: Formatted -> String

showList :: [Formatted] -> ShowS

formatted :: Map (Int, Int) FormattedCell -> StyleSheet -> Formatted

Higher level API for creating formatted documents

Creating formatted Excel spreadsheets using the Cell datatype directly, even with the support for the StyleSheet datatype, is fairly painful. This has a number of causes:

• The Cell datatype wants an Int for the style, which is supposed to point into the _styleSheetCellXfs part of a stylesheet. However, this can be difficult to work with, as it requires manual tracking of cell style IDs, which in turns requires manual tracking of font IDs, border IDs, etc.
• Row-span and column-span properties are set on the worksheet as a whole (wsMerges) rather than on individual cells.
• Excel does not correctly deal with borders on cells that span multiple columns or rows. Instead, these rows must be set on all the edge cells in the block. Again, this means that this becomes a global property of the spreadsheet rather than properties of individual cells.

This function deals with all these problems. Given a map of FormattedCells, which refer directly to Fonts, Borders, etc. (rather than font IDs, border IDs, etc.), and an initial stylesheet, it recovers all possible sharing, constructs IDs, and then constructs the final CellMap, as well as the final stylesheet and list of merges.

If you don't already have a StyleSheet you want to use as starting point then minimalStyleSheet is a good choice.

toFormattedCells :: CellMap -> [Range] -> StyleSheet -> Map (Int, Int) FormattedCell

reverse to formatted which allows to get a map of formatted cells from an existing worksheet and its workbook's style sheet

data CondFormatted

Constructors

CondFormatted

Fields

• condformattedStyleSheet :: StyleSheet

  The resulting stylesheet

• condformattedFormattings :: Map SqRef ConditionalFormatting

  The final map of conditional formatting rules applied to ranges

Instances

Eq CondFormatted

Methods

(==) :: CondFormatted -> CondFormatted -> Bool

(/=) :: CondFormatted -> CondFormatted -> Bool

Show CondFormatted

Methods

showsPrec :: Int -> CondFormatted -> ShowS

show :: CondFormatted -> String

showList :: [CondFormatted] -> ShowS

conditionallyFormatted :: Map CellRef [FormattedCondFmt] -> StyleSheet -> CondFormatted

Lenses

Format

formatAlignment :: Lens' Format (Maybe Alignment)

formatBorder :: Lens' Format (Maybe Border)

formatFill :: Lens' Format (Maybe Fill)

formatFont :: Lens' Format (Maybe Font)

formatNumberFormat :: Lens' Format (Maybe NumberFormat)

formatProtection :: Lens' Format (Maybe Protection)

formatPivotButton :: Lens' Format (Maybe Bool)

formatQuotePrefix :: Lens' Format (Maybe Bool)

FormattedCell

formattedCell :: Lens' FormattedCell Cell

formattedFormat :: Lens' FormattedCell Format

formattedColSpan :: Lens' FormattedCell Int

formattedRowSpan :: Lens' FormattedCell Int

FormattedCondFmt

condfmtCondition :: Lens' FormattedCondFmt Condition

condfmtDxf :: Lens' FormattedCondFmt Dxf

condfmtPriority :: Lens' FormattedCondFmt Int

condfmtStopIfTrue :: Lens' FormattedCondFmt (Maybe Bool)