excel library
Classes
Enums
- CellType
-
Cell Type
- FontFamily
- HorizontalAlign
-
enum for setting
horizontal alignment
- TextWrapping
-
enum for
wrapping
up the text - Underline
-
Underline
- VerticalAlign
-
enum for setting
vertical alignment
Extensions
Functions
-
getCellId(
int colI, int rowI) → String -
getColumnAlphabet(
int collIndex) → 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