xlsx-1.1.2.2: Simple and incomplete Excel file parser/writer
Safe HaskellSafe-Inferred
LanguageHaskell2010

Codec.Xlsx.Lens

Description

lenses to access sheets, cells and values of Xlsx

Synopsis

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