| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
Codec.Xlsx.Types
- data Xlsx = Xlsx {}
- xlSheets :: Lens' Xlsx (Map Text Worksheet)
- xlStyles :: Lens' Xlsx Styles
- xlDefinedNames :: Lens' Xlsx DefinedNames
- def :: Default a => a
- newtype Styles = Styles {}
- emptyStyles :: Styles
- renderStyleSheet :: StyleSheet -> Styles
- parseStyleSheet :: Styles -> Either SomeException StyleSheet
- newtype DefinedNames = DefinedNames [(Text, Maybe Text, Text)]
- data ColumnsWidth = ColumnsWidth {}
- data PageSetup = PageSetup {
- _pageSetupBlackAndWhite :: Maybe Bool
- _pageSetupCellComments :: Maybe CellComments
- _pageSetupCopies :: Maybe Int
- _pageSetupDraft :: Maybe Bool
- _pageSetupErrors :: Maybe PrintErrors
- _pageSetupFirstPageNumber :: Maybe Int
- _pageSetupFitToHeight :: Maybe Int
- _pageSetupFitToWidth :: Maybe Int
- _pageSetupHorizontalDpi :: Maybe Int
- _pageSetupId :: Maybe Text
- _pageSetupOrientation :: Maybe Orientation
- _pageSetupPageOrder :: Maybe PageOrder
- _pageSetupPaperHeight :: Maybe Text
- _pageSetupPaperSize :: Maybe PaperSize
- _pageSetupPaperWidth :: Maybe Text
- _pageSetupScale :: Maybe Int
- _pageSetupUseFirstPageNumber :: Maybe Bool
- _pageSetupUsePrinterDefaults :: Maybe Bool
- _pageSetupVerticalDpi :: Maybe Int
- data Worksheet = Worksheet {}
- wsColumns :: Lens' Worksheet [ColumnsWidth]
- wsRowPropertiesMap :: Lens' Worksheet (Map Int RowProperties)
- wsCells :: Lens' Worksheet CellMap
- wsMerges :: Lens' Worksheet [Range]
- wsSheetViews :: Lens' Worksheet (Maybe [SheetView])
- wsPageSetup :: Lens' Worksheet (Maybe PageSetup)
- type CellMap = Map (Int, Int) Cell
- data CellValue
- data Cell = Cell {}
- cellValue :: Lens' Cell (Maybe CellValue)
- cellStyle :: Lens' Cell (Maybe Int)
- data RowProperties = RowProps {}
- type Range = Text
- int2col :: Int -> Text
- col2int :: Text -> Int
- mkCellRef :: (Int, Int) -> CellRef
- mkRange :: (Int, Int) -> (Int, Int) -> Range
- toRows :: CellMap -> [(Int, [(Int, Cell)])]
- fromRows :: [(Int, [(Int, Cell)])] -> CellMap
Documentation
Structured representation of Xlsx file (currently a subset of its contents)
Constructors
| Xlsx | |
Fields | |
Constructors
| Styles | |
Fields | |
renderStyleSheet :: StyleSheet -> Styles Source
Render StyleSheet
This is used to render a structured StyleSheet into a raw XML Styles
document. Actually replacing Styles with StyleSheet would mean we
would need to write a parser for StyleSheet as well (and would moreover
require that we support the full style sheet specification, which is still
quite a bit of work).
parseStyleSheet :: Styles -> Either SomeException StyleSheet Source
Parse StyleSheet
This is used to parse raw Styles into structured StyleSheet
currently not all of the style sheet specification is supported
so parser (and the data model) is to be completed
newtype DefinedNames Source
Defined names
Each defined name consists of a name, an optional local sheet ID, and a value.
This element defines the collection of defined names for this workbook. Defined names are descriptive names to represent cells, ranges of cells, formulas, or constant values. Defined names can be used to represent a range on any worksheet.
Excel also defines a number of reserved names with a special interpretation:
_xlnm.Print_Areaspecifies the workbook's print area. Example value:SheetName!$A:$A,SheetName!$1:$4_xlnm.Print_Titlesspecifies the row(s) or column(s) to repeat at the top of each printed page._xlnm.Sheet_Title:refers to a sheet title.
and others. See Section 18.2.6, "definedNames (Defined Names)" (p. 1728) of the spec (second edition).
NOTE: Right now this is only a minimal implementation of defined names.
Constructors
| DefinedNames [(Text, Maybe Text, Text)] |
Instances
data ColumnsWidth Source
Column range (from cwMin to cwMax) width
Constructors
| PageSetup | |
Fields
| |
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'
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
Constructors
| CellText Text | |
| CellDouble Double | |
| CellBool Bool | |
| CellRich [RichTextRun] |
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 | |
Fields
| |
data RowProperties Source
convert column number (starting from 1) to its textual form (e.g. 3 -> "C")
mkCellRef :: (Int, Int) -> CellRef Source
Render position in (row, col) format to an Excel reference.
mkCellRef (2, 4) == "D2"