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

Safe HaskellNone
LanguageHaskell2010

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

Currently cell details include only cell values and style ids (e.g. formulas from <f> and inline strings from <is> subelements are ignored)

Constructors

Cell 

Instances

int2col :: Int -> Text Source

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

col2int :: Text -> Int Source

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)])] -> CellMap Source

reverse to toRows