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

Safe Haskell | Safe-Inferred
Language | Haskell2010

Codec.Xlsx.Lens

Description

lenses to access sheets, cells and values of `Xlsx`

Synopsis

- ixSheet :: Text -> Traversal' Xlsx Worksheet
- atSheet :: Text -> Lens' Xlsx (Maybe Worksheet)
- ixCell :: (RowIndex, ColumnIndex) -> Traversal' Worksheet Cell
- ixCellRC :: (RowIndex, ColumnIndex) -> Traversal' Worksheet Cell
- ixCellXY :: (ColumnIndex, RowIndex) -> Traversal' Worksheet Cell
- atCell :: (RowIndex, ColumnIndex) -> Lens' Worksheet (Maybe Cell)
- atCellRC :: (RowIndex, ColumnIndex) -> Lens' Worksheet (Maybe Cell)
- atCellXY :: (ColumnIndex, RowIndex) -> Lens' Worksheet (Maybe Cell)
- cellValueAt :: (RowIndex, ColumnIndex) -> Lens' Worksheet (Maybe CellValue)
- cellValueAtRC :: (RowIndex, ColumnIndex) -> Lens' Worksheet (Maybe CellValue)
- cellValueAtXY :: (ColumnIndex, RowIndex) -> Lens' Worksheet (Maybe CellValue)

# Documentation

ixSheet :: Text -> Traversal' Xlsx Worksheet Source #

lens giving access to a worksheet from `Xlsx` object by its name

atSheet :: Text -> Lens' Xlsx (Maybe Worksheet) Source #

`At` variant of `ixSheet` lens

Note: if there is no such sheet in this workbook then new sheet will be added as the last one to the sheet list

ixCell :: (RowIndex, ColumnIndex) -> Traversal' Worksheet Cell Source #

lens giving access to a cell in some worksheet by its position, by default row+column index is used so this lens is a synonym of `ixCellRC`

ixCellRC :: (RowIndex, ColumnIndex) -> Traversal' Worksheet Cell Source #

lens to access cell in a worksheet

ixCellXY :: (ColumnIndex, RowIndex) -> Traversal' Worksheet Cell Source #

lens to access cell in a worksheet using more traditional x+y coordinates

atCell :: (RowIndex, ColumnIndex) -> Lens' Worksheet (Maybe Cell) Source #

accessor that can read, write or delete cell in a worksheet synonym of `atCellRC` so uses row+column index

atCellRC :: (RowIndex, ColumnIndex) -> Lens' Worksheet (Maybe Cell) Source #

lens to read, write or delete cell in a worksheet

atCellXY :: (ColumnIndex, RowIndex) -> Lens' Worksheet (Maybe Cell) Source #

lens to read, write or delete cell in a worksheet using more traditional x+y or row+column index

cellValueAt :: (RowIndex, ColumnIndex) -> Lens' Worksheet (Maybe CellValue) Source #

lens to read, write or delete cell value in a worksheet with row+column coordinates, synonym for `cellValueRC`

cellValueAtRC :: (RowIndex, ColumnIndex) -> Lens' Worksheet (Maybe CellValue) Source #

lens to read, write or delete cell value in a worksheet using row+column coordinates of that cell

cellValueAtXY :: (ColumnIndex, RowIndex) -> Lens' Worksheet (Maybe CellValue) Source #

lens to read, write or delete cell value in a worksheet using traditional x+y coordinates