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

Safe HaskellNone

Codec.Xlsx.Types

Synopsis

Documentation

data Xlsx Source

Structured representation of Xlsx file (currently a subset of its contents)

Constructors

Xlsx 

Instances

def :: Default a => a

The default value for this type.

newtype Styles Source

Constructors

Styles 

Fields

unStyles :: ByteString
 

Instances

data ColumnsWidth Source

Column range (from cwMin to cwMax) width

Constructors

ColumnsWidth 

Fields

cwMin :: Int
 
cwMax :: Int
 
cwWidth :: Double
 
cwStyle :: Int
 

data Worksheet Source

Xlsx worksheet

Constructors

Worksheet 

Fields

_wsColumns :: [ColumnsWidth]

column widths

_wsRowPropertiesMap :: Map Int RowProperties

custom row properties (height, style) map

_wsCells :: CellMap

data mapped by (row, column) pairs

_wsMerges :: [Text]
 

data CellValue Source

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

data Cell Source

Constructors

Cell 

Instances

int2col :: Int -> TextSource

convert column number (starting from 1) to its textual form (e.g. 3 -> C)

col2int :: Text -> IntSource

reverse to int2col

toRows :: CellMap -> [(Int, [(Int, Cell)])]Source

converts cells mapped by (row, column) into rows which contain row index and cells as pairs of column indices and cell values

fromRows :: [(Int, [(Int, Cell)])] -> CellMapSource

reverse to toRows