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

ixCell :: (Int, Int) -> 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 :: (Int, Int) -> Traversal' Worksheet Cell

lens to access cell in a worksheet

ixCellXY :: (Int, Int) -> Traversal' Worksheet Cell

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

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

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

atCellRC :: (Int, Int) -> Lens' Worksheet (Maybe Cell)

lens to read, write or delete cell in a worksheet

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

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

cellValueAt :: (Int, Int) -> Lens' Worksheet (Maybe CellValue)

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

cellValueAtRC :: (Int, Int) -> Lens' Worksheet (Maybe CellValue)

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

cellValueAtXY :: (Int, Int) -> Lens' Worksheet (Maybe CellValue)

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