Classes
- XLSXFile
-
The entry point class that represents an open file handle to an existing
.xlsx
file on the user's filesystem.
Structures
- Comments
- CommentList
- Comment
- Text
- Path
- Relationships
-
An array of
Relationship
values. This type directly maps the internal XML structure of the.xlsx
format. - Relationship
-
Relationship to an entity stored in a given
.xlsx
archive. These can be worksheets, chartsheets, thumbnails and a few other internal entities. Most of the time users of CoreXLSX wouldn't need to handle relationships directly. - SharedStrings
-
Strings in spreadsheet internals are frequently represented as strings shared between multiple worksheets. To parse a string value from a cell you should use
stringValue(_: SharedStrings)
function onCell
together withparseSharedString()
on yourXLSXFile
instance. - SharedStrings.Item
- RichText
- RichText.Family
- RichText.Scheme
- RichText.Size
- RichText.Color
- RichText.Font
- RichText.Properties
- Styles
- Color
- NumberFormats
- NumberFormat
- Fonts
- Font
- Font.Size
- Font.Name
- Font.Bold
- Font.Italic
- Font.Strike
- Fills
- Fill
- PatternFill
- Borders
- Border
- Border.Value
- CellStyleFormats
- CellFormats
- Format
-
Storage for cell formatting properties. More details are available at datypic.com
- Format.Alignment
- CellStyles
- CellStyle
- DifferentialFormats
-
Specifies a subset of formatting instead of applying formatting globally. More details are available at officeopenxml.com.
- TableStyles
- TableStyle
- TableStyle.Element
- Colors
- Colors.Indexed
- Workbook
- Workbook.Views
- Workbook.View
- Workbook.Sheets
- Workbook.Sheet
- Cell
-
The representation of a spreadsheet cell. More details of how cells are encoded in
.xlsx
internals are available at wiki.ucl.ac.uk. - Cell.Formula
- CellReference
- ColumnReference
- Worksheet
- Worksheet.Properties
- Worksheet.Data
- Worksheet.FormatProperties
- Worksheet.Dimension
- PageSetUpProperties
- SheetViews
- SheetView
- Pane
- Columns
-
An array of
Column
values. This type directly maps the internal XML structure of the.xlsx
format. - Column
-
The styling information for a given column. Full specification for the internals of this type is available in Microsoft docs.
- Row
-
The primary storage for spreadsheet cells.
- MergeCells
- MergeCell
- InlineString
Enumerations
- Relationship.SchemaType
- CellType
-
The type of the value stored in a spreadsheet cell. The specification for the internals is available at datypic.com.
- CoreXLSXError
Typealiases
- SheetData
- SheetPr
- SheetFormatPr
- WorksheetDimension
- Cols
- Col
- XLSXReaderError