| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
Codec.Xlsx.Types.Common
- newtype CellRef = CellRef {}
- singleCellRef :: (Int, Int) -> CellRef
- fromSingleCellRef :: CellRef -> Maybe (Int, Int)
- fromSingleCellRefNoting :: CellRef -> (Int, Int)
- type Range = CellRef
- mkRange :: (Int, Int) -> (Int, Int) -> Range
- fromRange :: Range -> Maybe ((Int, Int), (Int, Int))
- newtype SqRef = SqRef [CellRef]
- data XlsxText
- newtype Formula = Formula {}
- data CellValue
- int2col :: Int -> Text
- col2int :: Text -> Int
Documentation
Excel cell or cell range reference (e.g. E3)
See 18.18.62 ST_Ref (p. 2482)
singleCellRef :: (Int, Int) -> CellRef Source #
Render position in (row, col) format to an Excel reference.
mkCellRef (2, 4) == "D2"
fromSingleCellRefNoting :: CellRef -> (Int, Int) Source #
reverse to mkCellRef expecting valid reference and failig with
a standard error message like "Bad cell reference XXX"
A sequence of cell references
See 18.18.76 "ST_Sqref (Reference Sequence)" (p.2488)
Common type containing either simple string or rich formatted text.
Used in si, comment and is elements
E.g. si spec says: "If the string is just a simple string with formatting applied
at the cell level, then the String Item (si) should contain a single text
element used to express the string. However, if the string in the cell is
more complex - i.e., has formatting applied at the character level - then the
string item shall consist of multiple rich text runs which collectively are
used to express the string.". So we have either a single Text field, or
else a list of RichTextRuns, each of which is some Text with layout
properties.
TODO: Currently we do not support phoneticPr (Phonetic Properties, 18.4.3,
p. 1723) or rPh (Phonetic Run, 18.4.6, p. 1725).
Section 18.4.8, "si (String Item)" (p. 1725)
See CT_Rst, p. 3903
Constructors
| XlsxText Text | |
| XlsxRichText [RichTextRun] |
A formula
See 18.18.35 "ST_Formula (Formula)" (p. 2457)
Cell values include text, numbers and booleans, standard includes date format also but actually dates are represented by numbers with a date format assigned to a cell containing it
Constructors
| CellText Text | |
| CellDouble Double | |
| CellBool Bool | |
| CellRich [RichTextRun] |