Codec.Xlsx.Lens

lenses to access sheets, cells and values of Xlsx

Documentation

ixSheet :: Text -> Traversal' Xlsx Worksheet

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

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

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

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

lens to access cell in a worksheet

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

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

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

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)

lens to read, write or delete cell in a worksheet

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

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)

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)

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)

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