xlsx-0.1.2: 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

Eq Xlsx Source # 

Methods

(==) :: Xlsx -> Xlsx -> Bool #

(/=) :: Xlsx -> Xlsx -> Bool #

Show Xlsx Source # 

Methods

showsPrec :: Int -> Xlsx -> ShowS #

show :: Xlsx -> String #

showList :: [Xlsx] -> ShowS #

Default Xlsx Source # 

Methods

def :: Xlsx #

def :: Default a => a #

The default value for this type.

newtype Styles Source #

Constructors

Styles 

Fields

Instances

data ColumnsWidth Source #

Column range (from cwMin to cwMax) width

Constructors

ColumnsWidth 

Fields

data Worksheet Source #

Xlsx worksheet

Constructors

Worksheet 

Fields

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'

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

Eq Cell Source # 

Methods

(==) :: Cell -> Cell -> Bool #

(/=) :: Cell -> Cell -> Bool #

Show Cell Source # 

Methods

showsPrec :: Int -> Cell -> ShowS #

show :: Cell -> String #

showList :: [Cell] -> ShowS #

Default Cell Source # 

Methods

def :: Cell #

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