excel library

Enums

BorderStyle
ColorType
FontFamily
FontScheme
enum for setting font scheme
HorizontalAlign
enum for setting horizontal alignment
TextWrapping
enum for wrapping up the text
Underline
Underline
VerticalAlign
enum for setting vertical alignment

Extensions

BoolParsing on String
StringExt on String

Functions

getBorderStyleByName(String name) BorderStyle?
getCellId(int columnIndex, int rowIndex) String
getColumnAlphabet(int columnIndex) String
Returns Column based String alphabet when column index is passed
getColumnIndex(String columnAlphabet) int
Returns Column based int index when column alphabet is passed
getFontFamily(FontFamily fontFamily) String
returns the Font Family Name
getSpanCellId(int startColumn, int startRow, int endColumn, int endRow) String
return A2:B2 for spanning storage in unmerge list when 0,2 2,2 is passed
lettersToNumeric(String letters) int
Convert a character based column