Codec.Xlsx.Types.Cell

Documentation

data CellFormula

Formula for the cell.

TODO: array. dataTable and shared formula types support

See 18.3.1.40 "f (Formula)" (p. 1636)

Constructors

NormalCellFormula

Fields

• _cellfExpression :: Formula
• _cellfAssignsToName :: Bool

  Specifies that this formula assigns a value to a name.

• _cellfCalculate :: Bool

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

Instances

Eq CellFormula

Methods

(==) :: CellFormula -> CellFormula -> Bool

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

Show CellFormula

Methods

showsPrec :: Int -> CellFormula -> ShowS

show :: CellFormula -> String

showList :: [CellFormula] -> ShowS

ToElement CellFormula

Methods

toElement :: Name -> CellFormula -> Element

FromCursor CellFormula

Methods

fromCursor :: Cursor -> [CellFormula]

simpleCellFormula :: Text -> CellFormula

data Cell

Currently cell details include cell values, style ids and cell formulas (inline strings from <is> subelements are ignored)

Constructors

Cell

Fields

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

Instances

Eq Cell

Methods

(==) :: Cell -> Cell -> Bool

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

Show Cell

Methods

showsPrec :: Int -> Cell -> ShowS

show :: Cell -> String

showList :: [Cell] -> ShowS

Default Cell

Methods

def :: Cell

cellStyle :: Lens' Cell (Maybe Int)

cellValue :: Lens' Cell (Maybe CellValue)

cellComment :: Lens' Cell (Maybe Comment)

cellFormula :: Lens' Cell (Maybe CellFormula)

type CellMap = Map (Int, Int) Cell

Map containing cell values which are indexed by row and column if you need to use more traditional (x,y) indexing please you could use corresponding accessors from 'Lens'