Safe Haskell | None |
---|---|
Language | Haskell2010 |
- data Xlsx = Xlsx {}
- xlSheets :: Lens' Xlsx (Map Text Worksheet)
- xlStyles :: Lens' Xlsx Styles
- def :: Default a => a
- newtype Styles = Styles {}
- emptyStyles :: Styles
- data ColumnsWidth = ColumnsWidth {}
- data Worksheet = Worksheet {
- _wsColumns :: [ColumnsWidth]
- _wsRowPropertiesMap :: Map Int RowProperties
- _wsCells :: CellMap
- _wsMerges :: [Text]
- wsColumns :: Lens' Worksheet [ColumnsWidth]
- wsRowPropertiesMap :: Lens' Worksheet (Map Int RowProperties)
- wsCells :: Lens' Worksheet CellMap
- wsMerges :: Lens' Worksheet [Text]
- type CellMap = Map (Int, Int) Cell
- data CellValue
- data Cell = Cell {}
- cellValue :: Lens' Cell (Maybe CellValue)
- cellStyle :: Lens' Cell (Maybe Int)
- data RowProperties = RowProps {}
- int2col :: Int -> Text
- col2int :: Text -> Int
- toRows :: CellMap -> [(Int, [(Int, Cell)])]
- fromRows :: [(Int, [(Int, Cell)])] -> CellMap
Documentation
Structured representation of Xlsx file (currently a subset of its contents)
emptyStyles :: Styles Source #
data ColumnsWidth Source #
Column range (from cwMin to cwMax) width
Xlsx worksheet
Worksheet | |
|
type CellMap = Map (Int, Int) Cell Source #
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'
Cell values include text, numbers and booleans, standard includes date format also but actually dates are represented by numbers with a date format assigned to a cell containing it
Currently cell details include only cell values and style ids
(e.g. formulas from <f>
and inline strings from <is>
subelements are ignored)
Cell | |
|
data RowProperties Source #
int2col :: Int -> Text Source #
convert column number (starting from 1) to its textual form (e.g. 3 -> "C")