Index (bx-spreadsheet 1.0.0 API)

A B C D E F G H I K L M N O P Q R S T U V W X Y _
All Classes and Interfaces|All Packages|Constant Field Values

A

ACTION - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ACTIVEPANE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
addAutofilter(int, int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds autofilter to a range in the active sheet
addFreezePane(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds a freeze pane to the active sheet
addFreezePane(int, int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds a freeze pane to the active sheet with end boundaries
addImage(String, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds an image to the active sheet at the specified cell position
addImage(String, int, int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds an image to the active sheet with custom anchor dimensions
addImage(Sheet, String, int, int, int, int, Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Adds an image with custom anchor coordinates
addImage(Sheet, String, int, int, Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Adds an image to a sheet at a specified cell location
addPrintGridlines() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds print gridlines to the active sheet (gridlines will print)
addPrintGridlines(Sheet) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Adds print gridlines to the sheet (gridlines will print when document is printed).
addRow(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds a new row with the specified data at the end of the active sheet
addRow(String, Array) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds a new row with the specified data at the end of the specified sheet
addRow(Array) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds a new row with the specified data at the end of the active sheet
addRow(Array, int, int, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds a new row with the specified data at the specified position in the active sheet
addRows(Array) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets all data for the active sheet from a 2D array We won't include column names by default, this means, row 1 of data will be skipped
addRows(Array, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets all data for the active sheet from a 2D array
addRows(Array, int, int, boolean, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets all data for the active sheet from a 2D array starting at specified row and column
addRows(Array, int, int, boolean, boolean, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets all data for the active sheet from a 2D array starting at specified row and column
addRows(Array, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets all data for the active sheet from a 2D array We won't include column names by default, this means, row 1 of data will be skipped
addRows(Array, String, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets all data for the active sheet from a 2D array We won't include column names by default, this means, row 1 of data will be skipped
addSplitPane(int, int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds a split pane to the active sheet with default active pane (LOWER_RIGHT)
addSplitPane(int, int, int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Adds a split pane to the active sheet
ALIGNMENT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ANCHOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
Author - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
AUTHOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
AUTOCALCULATE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
autoCloseOnSave(boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets whether to auto close the workbook when saving
autoSizeColumn(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Auto-sizes a specific column in the active sheet
autoSizeColumn(String, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Auto-sizes a specific column in the specified sheet
autoSizeColumn(Sheet, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Auto-sizes a specific column in the specified sheet
autoSizeColumn(Workbook, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Auto-sizes a specific column in the active sheet
autoSizeColumns() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Auto-sizes all columns in the active sheet
autoSizeColumns(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Auto-sizes all columns in the specified sheet
autoSizeColumns(Sheet) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Auto-sizes all columns in the specified sheet
autoSizeColumns(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Auto-sizes all columns in the active sheet

B

BOLD - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
BOTTOMBORDER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
BOTTOMBORDERCOLOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

C

CATEGORY - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
CENTER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
clearCell(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Clears the specified cell of all styles and values in the active sheet
clearCell(Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Clears the specified cell of all styles and values
clearCellRange(int, int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Clears a range of cells of all styles and values in the active sheet
clearCellRange(Sheet, int, int, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Clears a range of cells of all styles and values
clearSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Clears all data from the specified sheet
close() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Closes the workbook and releases resources
COLLAPSE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
COLOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
Column - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
COLUMN - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
COLUMNNAMES - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
COLUMNS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
Comment - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
COMMENT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
COMMENTS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
COMPANY - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
CONSUMER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
copySheet(String, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Copies a sheet with a new name Creates a complete copy of the source sheet including all data, formatting, and structure
createAndSelectSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new sheet and makes it the active sheet
createAndSelectSheet(String, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new sheet and makes it the active sheet
createSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new sheet with the specified name
createSheet(String, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new sheet with the specified name
createSplitPane(Sheet, int, int, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Creates a split pane in a sheet with default active pane
createSplitPane(Sheet, int, int, int, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Creates a split pane in a sheet
createWorkbook(boolean, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Creates a new workbook based on the specified format
createXlsWorkbook(String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Creates a new .xls workbook
createXlsxWorkbook(String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Creates a new .xlsx workbook
CREATIONDATE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

D

DATA - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
DATAFORMAT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
DATATYPE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
DEFAULT_SHEET_NAME - Static variable in class ortus.boxlang.spreadsheet.SpreadsheetFile: ------------------------------------------------------------------------ Constants ------------------------------------------------------------------------
deleteColumn(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Deletes a column by clearing all cells in that column
deleteColumn(String, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Deletes a column by clearing all cells in that column from the specified sheet
deleteColumn(Sheet, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Deletes a column by clearing all cells in that column Note: Apache POI doesn't support true column deletion, so we clear the column content
deleteColumns(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Deletes multiple columns by clearing all cells in those columns
deleteColumns(String, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Deletes multiple columns by clearing all cells in those columns from the specified sheet
deleteColumns(Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Deletes multiple columns by clearing all cells in those columns
DELIMITER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
DISPLAYROWANDCOLUMNHEADINGS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
DISPLAYSFORMULAS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
DISPLAYSGRIDLINES - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
DISPLAYSZEROS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

E

END - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ENDCOLUMN - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ENDROW - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

F

FGCOLOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
FILENAME - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
filePath - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
FILLPATTERN - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
FITTOPAGE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
FONT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
FONTSIZE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
FOOTER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
FORMAT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
formatCell(int, int, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats a cell in the active sheet
formatCell(String, int, int, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats a cell in the specified sheet
formatCell(Cell, IStruct) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Applies formatting to a specific cell based on a format structure
formatCellRange(Sheet, IStruct, int, int, int, int, Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Formats a range of cells with a single format struct
formatCellRange(IStruct, int, int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats a range of cells in the active sheet with a single format struct
formatColumn(int, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats all cells in a single column in the active sheet
formatColumn(String, int, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats all cells in a single column in the specified sheet
formatColumn(Sheet, int, IStruct) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Formats all cells in a single column
formatColumns(String, String, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats multiple columns in the specified sheet Column specification format: "1,3,5" or "1-5,7-10" or combinations
formatColumns(String, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats multiple columns in the active sheet Column specification format: "1,3,5" or "1-5,7-10" or combinations
formatColumns(Sheet, String, IStruct) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Formats all cells in multiple columns specified by a comma-separated string or range Format: "1,3,5" or "1-5,7-10" or combinations like "1-3,5,7-10"
formatRow(int, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats all cells in a single row in the active sheet
formatRow(String, int, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats all cells in a single row in the specified sheet
formatRow(Sheet, int, IStruct) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Formats all cells in a single row
formatRows(String, String, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats multiple rows in the specified sheet Row specification format: "1,3,5" or "1-5,7-10" or combinations
formatRows(String, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Formats multiple rows in the active sheet Row specification format: "1,3,5" or "1-5,7-10" or combinations
formatRows(Sheet, String, IStruct) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Formats all cells in multiple rows specified by a comma-separated string or range Format: "1,3,5" or "1-5,7-10" or combinations like "1-3,5,7-10"
FORMATSTRUCT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
FORMULA - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
fromArray(Array) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new SpreadsheetFile from an array of structs The first struct's keys will be used as column headers in row 1 Each struct represents a data row
fromJson(String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new SpreadsheetFile from JSON string data The JSON should be an array of objects where each object represents a row The keys of the first object will be used as column headers
fromQuery(Query) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new SpreadsheetFile from query-like data (array of structs) Alias for fromArray() to match the fluent API pattern
fromWorkbook(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new SpreadsheetFile from an existing workbook

G

getActiveCell() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the currently active/selected cell in the active sheet
getActiveCell(Sheet) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the currently active/selected cell in a sheet
getActiveSheet() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the active sheet
getActiveSheet(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the active sheet from the workbook
getActiveSheetName() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the name of the active sheet
getAllCellComments() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets all comments from the active sheet
getAllCellComments(Sheet) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Get all cell comments from a sheet as an array of structs
getAllData() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets all data from the active sheet as a 2D array
getAllData(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets all data from the specified sheet as a 2D array
getAllFormulas() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets all cell formulas from the active sheet as a 2D array with each value being a struct with the following keys: - formula : The cell formula as a string - row : The row number (1-based) - column : The column number (1-based)
getAutoCalculate() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets whether formulas automatically calculate
getAutoCalculate(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets whether formulas automatically calculate
getCell(Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets a cell at the specified row and column, returning null if it doesn't exist
getCellAddress(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the cell address string for a given row and column (e.g., "A1", "B5")
getCellAddress(Workbook, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the cell address (e.g., "A1", "B5") for a given row and column
getCellComment(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets a comment from a cell in the active sheet
getCellComment(Cell) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets a comment from a cell
getCellCommentAsStruct(Cell) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Get cell comment as a struct with Author, Column, Comment, Row keys
getCellFormat(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the formatting information of the specified cell in the active sheet
getCellFormat(Cell) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the formatting information of a cell
getCellFormula(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets cell formula from the active sheet and a specified cell
getCellHyperlink(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the hyperlink from a cell in the active sheet
getCellHyperlink(Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the hyperlink from a cell
getCellType(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the Excel cell type of the specified cell in the active sheet
getCellType(Cell) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the Excel cell type of a cell
getCellValue(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets a cell value at the specified row and column in the active sheet
getCellValue(String, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets a cell value at the specified row and column in the specified sheet
getCellValue(Cell) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the cell value as an Object, handling different cell types
getColumnCount() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the number of columns in the active sheet
getColumnCount(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the number of columns in the specified sheet
getColumnCount(Sheet) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the number of columns that contain data in the specified sheet
getColumnCount(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the number of columns that contain data in the active sheet
getColumnNames() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the column names for the active sheet.
getColumnNames(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the column names for the specified sheet.
getColumnTypes() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the column types for the active sheet by analyzing the data in the second row (assuming first row is headers).
getColumnTypes(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the column types for the specified sheet by analyzing the data in the second row (assuming first row is headers).
getColumnWidth(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the width of a column in the active sheet (defaults to pixels).
getColumnWidth(int, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the width of a column in the active sheet.
getColumnWidth(Sheet, int, boolean) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the width of a column.
getDataAsQuery() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets data from the active sheet as an array of structs (first row as headers)
getDataAsQuery(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets data from the specified sheet as an array of structs (first row as headers)
getInfo(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets information about the spreadsheet as a struct
getLastRowNumber() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the last row number with data in the active sheet.
getLastRowNumber(Sheet) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the last row number with data in the sheet.
getOrCreateCell(Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets a cell at the specified row and column, creating it if it doesn't exist
getOrCreateSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Get a sheet by name or create it if it doesn't exist
getPath() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the file path
getPrintOrientation() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the print orientation of the active sheet.
getPrintOrientation(Sheet) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the print orientation of the sheet.
getRecalculateFormulasOnNextOpen() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets whether formulas will be recalculated when the file is opened
getRecalculateFormulasOnNextOpen(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets whether formulas will be recalculated when the file is opened
getRowCount() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the number of rows in the active sheet
getRowCount(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the number of rows in the specified sheet
getRowCount(Sheet) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the number of rows that contain data in the specified sheet
getRowCount(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the number of rows that contain data in the active sheet
getRowData(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets all cell values from a row
getRowData(String, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets all cell values from a row in the specified sheet
getSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Get a sheet by name
getSheetCount() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the number of sheets in the workbook
getSheetNames() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets all sheet names
getSheetNames(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the names of all sheets in the workbook
getSheetsVisibility() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Get all the sheet visibility information as a Struct
getSheetsVisibility(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the visibility status of all sheets in the workbook
getWorkbook() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the underlying Apache POI workbook
groupColumns(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Groups columns together in the active sheet (expanded by default)
groupColumns(int, int, Boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Groups columns together in the active sheet for outline/collapse functionality
groupColumns(Sheet, int, int, Boolean) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Groups columns together in the active sheet
groupRows(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Groups rows together in the active sheet (expanded by default)
groupRows(int, int, Boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Groups rows together in the active sheet for outline/collapse functionality
groupRows(Sheet, int, int, Boolean) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Groups rows together in the active sheet

H

HASCOMMENTS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
HASMERGEDREGIONS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
hasSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Checks if a sheet exists
hasSheet(Workbook, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Checks if a sheet with the given name exists in the workbook
HEADER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
HEADERROW - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
HEIGHT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
HIDE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
hideColumn(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Hides a column on the active sheet (fluent API)
hideRow(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Hides a row on the active sheet (fluent API)
hideSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Hides a sheet from view
hideSheet(Workbook, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Hides a sheet from view
HYPERLINK - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

I

IMAGE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
INCLUDECOLUMNNAMES - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
INCLUDEHEADERS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
INDENT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
info() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Returns properties of a spreadsheet as a struct.
INFO - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
INSERT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
isAutoCloseOnSave() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Is auto close on save enabled
isBinaryFormat() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets whether the spreadsheet is in binary format (.xls)
isBinaryFormat(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Determines if a workbook is in binary format (.xls)
isClosed() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Checks if the workbook has been closed
isColumnHidden(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the hidden state of a column on the active sheet
isColumnHidden(Sheet, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the hidden state of a column
ISCURRENTACTIVESHEET - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ISHIDDEN - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
isOverwriteEnabled() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets whether overwrite is enabled
ISRIGHTTOLEFT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
isRowHidden(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Gets the hidden state of a row on the active sheet
isRowHidden(Sheet, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Gets the hidden state of a row
isSpreadsheetFile(String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Determines if a file is a valid spreadsheet file
IsSpreadsheetFile - Class in ortus.boxlang.spreadsheet.bifs
IsSpreadsheetFile() - Constructor for class ortus.boxlang.spreadsheet.bifs.IsSpreadsheetFile: Constructor
IsSpreadsheetObject - Class in ortus.boxlang.spreadsheet.bifs
IsSpreadsheetObject() - Constructor for class ortus.boxlang.spreadsheet.bifs.IsSpreadsheetObject: Constructor
isValidLicense - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
isXmlFormat() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Checks if the workbook is in XML format (.xlsx)
isXmlFormat(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Determines if a workbook is in XML format (.xlsx)
ITALIC - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

K

KeyDictionary - Class in ortus.boxlang.spreadsheet.util: This class is used to store all the keys used in the dictionary for this module.
KeyDictionary() - Constructor for class ortus.boxlang.spreadsheet.util.KeyDictionary
KEYWORDS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

L

LABEL - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
LASTAUTHOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
LASTEDITED - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
LASTSAVED - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
LEFT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
LEFTBORDER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
LEFTBORDERCOLOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
LEFTMOSTCOLUMN - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
LicenseInterceptor - Class in ortus.boxlang.spreadsheet.interceptors
LicenseInterceptor() - Constructor for class ortus.boxlang.spreadsheet.interceptors.LicenseInterceptor
LINESEPARATOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
load(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Loads a spreadsheet file from the specified path
load(String, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Loads a spreadsheet file from the specified path with optional password

M

MANAGER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
mergeCells(int, int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Merges cells in the active sheet
moduleName - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
moveSheet(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Moves a sheet to a new position by index
moveSheet(String, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Moves a sheet to a new position by name
moveSheet(Workbook, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Moves a sheet to a new position by sheet index
moveSheet(Workbook, String, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Moves a sheet to a new position by sheet name

N

NAME - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
NEWNAME - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
NUMBEROFMERGEDREGIONS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
NUMCOLUMNS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
NUMROWS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

O

OBJECT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
OLDNAME - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
onRuntimeStart(IStruct) - Method in class ortus.boxlang.spreadsheet.interceptors.LicenseInterceptor: Interceptor to check for Boxlang+ (bx-plus) license on runtime start.
ORIENTATION - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ortus.boxlang.spreadsheet - package ortus.boxlang.spreadsheet
ortus.boxlang.spreadsheet.bifs - package ortus.boxlang.spreadsheet.bifs
ortus.boxlang.spreadsheet.components - package ortus.boxlang.spreadsheet.components
ortus.boxlang.spreadsheet.interceptors - package ortus.boxlang.spreadsheet.interceptors
ortus.boxlang.spreadsheet.util - package ortus.boxlang.spreadsheet.util
overwrite(boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets whether to overwrite existing files when saving
OVERWRITE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

P

PAGESHIGH - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
PAGESWIDE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
PASSWORD - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
POSITION - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
process(String, String, Consumer<Array>) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Stream rows from a specific sheet in a spreadsheet file on disk using true streaming.
process(String, Consumer<Array>) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Stream rows from a spreadsheet file on disk using true streaming (memory efficient).
process(Consumer<Array>) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Stream rows from the currently-loaded workbook (this.workbook).

Q

QUERY - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

R

readWorkbook(String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Reads a spreadsheet file from the given path
readWorkbook(String, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Reads a spreadsheet file from the given path with optional password
RECALCULATE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
recalculateAllFormulas() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Recalculates all formulas in the workbook
recalculateAllFormulas(Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Recalculates all formulas in the workbook
RECALCULATEFORMULASONNEXTOPEN - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
removeColumnBreak(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Removes a page (column) break at the specified 1-based column index on the active sheet.
removeColumnBreak(Sheet, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Removes a page (column) break on the specified 0-based column index on the sheet.
removePrintGridlines() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Removes print gridlines from the active sheet (gridlines will not print)
removePrintGridlines(Sheet) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Removes print gridlines from the sheet (gridlines will not print when document is printed).
removeRow(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Removes a row from the active sheet
removeRowBreak(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Removes a page (row) break at the specified 1-based row index on the active sheet.
removeRowBreak(Sheet, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Removes a page (row) break on the specified 0-based row index on the sheet.
removeSheet(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Removes a sheet by number (1-based index)
removeSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Removes a sheet by name
removeSheetByNumber(Workbook, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Removes a sheet by index (1-based)
renameSheet(String, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Renames an existing sheet
renameSheet(Workbook, String, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Renames an existing sheet
RESULT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
RETURNWIDTHINPIXELS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
RIGHT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
RIGHTBORDER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
RIGHTBORDERCOLOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ROTATION - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
Row - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ROW - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ROWS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

S

save() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Saves the spreadsheet to the currently loaded path
save(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Saves the spreadsheet to the specified path
save(String, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Saves the spreadsheet to the specified path with password protection
saveAndClose() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Saves the spreadsheet to the currently loaded path and closes the workbook
saveAndClose(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Saves the spreadsheet to the currently loaded path and closes the workbook
saveAndClose(String, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Saves the spreadsheet to the specified path with password protection and closes the workbook
selectSheet(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Selects (activates) a sheet by index (1-based)
selectSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Selects (activates) a sheet by name
setActiveCell(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the active/selected cell in the active sheet
setActiveCell(Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the active/selected cell in a sheet
setActiveSheet(Workbook, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the active sheet by index (0-based)
setActiveSheet(Workbook, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the active sheet by name
setAutoCalculate(boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets whether formulas automatically calculate
setAutoCalculate(Workbook, boolean) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets whether formulas automatically calculate
setCellComment(int, int, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets a comment on a cell in the active sheet
setCellComment(int, int, String, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets a comment on a cell in the active sheet with an author
setCellComment(int, int, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets a comment on a cell in the active sheet from a struct with formatting options
setCellComment(Cell, Object, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets a comment on a cell with optional formatting
setCellFormula(int, int, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets cell formula in the active sheet
setCellHyperlink(int, int, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets a hyperlink on a cell in the active sheet (without a custom label)
setCellHyperlink(int, int, String, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets a hyperlink on a cell in the active sheet
setCellHyperlink(Sheet, int, int, String, String, Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets a hyperlink on a cell
setCellRangeValue(Object, int, int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the same value to a range of cells in the active sheet
setCellRangeValue(Sheet, Object, int, int, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the same value to a range of cells
setCellValue(int, int, Object) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets a cell value at the specified row and column in the active sheet
setCellValue(String, int, int, Object) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets a cell value at the specified row and column in the specified sheet
setCellValue(Cell, Object) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets a cell value, automatically determining the appropriate cell type
setColumnBreak(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets a page (column) break at the specified 1-based column index on the active sheet.
setColumnBreak(Sheet, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets a page (column) break on the specified 0-based column index on the sheet.
setColumnHidden(int, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the hidden state of a column on the active sheet
setColumnHidden(Sheet, int, boolean) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the hidden state of a column
setColumnWidth(int, double) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the width of a column in the active sheet
setDocumentProperties(Workbook, IStruct) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets document properties/metadata for a workbook
setFitToPage(boolean, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the fit-to-page print option for the active sheet
setFitToPage(Sheet, boolean, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the fit-to-page print option for a sheet
setFooter(Sheet, IStruct) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the footer text for the specified sheet.
setFooter(IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the footer for the active sheet using a struct with optional keys: left, center, right
setFooterImage(String, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets an image in the footer of the active sheet
setFooterImage(Sheet, String, String, Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets an image in the footer of the specified sheet
setHeader(Sheet, IStruct) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the header text for the specified sheet.
setHeader(IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the header for the active sheet using a struct with optional keys: left, center, right
setHeaderImage(String, String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets an image in the header of the active sheet
setHeaderImage(Sheet, String, String, Workbook) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets an image in the header of the specified sheet
setInfo(IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets document properties/metadata for the workbook (alias for addInfo)
setPath(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the file path for this spreadsheet
setRecalculateFormulasOnNextOpen(boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets whether formulas should be recalculated when the file is opened
setRecalculateFormulasOnNextOpen(Workbook, boolean) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets whether formulas should be recalculated when the file is opened
setRepeatingColumns(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets columns to repeat on every printed page for the active sheet
setRepeatingColumns(Workbook, Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets columns to repeat on every printed page
setRepeatingRows(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets rows to repeat on every printed page for the active sheet
setRepeatingRows(Workbook, Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets rows to repeat on every printed page
setRowBreak(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets a page (row) break at the specified 1-based row index on the active sheet.
setRowBreak(Sheet, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets a page (row) break on the specified 0-based row index on the sheet.
setRowData(int, Array) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets multiple cell values from a row of data
setRowData(String, int, Array) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets multiple cell values from a row of data in the specified sheet
setRowHeight(int, double) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the height of a row in the active sheet
setRowHidden(int, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the hidden state of a row on the active sheet
setRowHidden(Sheet, int, boolean) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the hidden state of a row
setSheetPrintOrientation(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Sets the print orientation for the active sheet
setSheetPrintOrientation(Sheet, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Sets the sheet print orientation
SHEET - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
SHEETINDEX - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
SHEETINDEXATTRIBUTE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
sheetName - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
SHEETNAME - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
SHEETNAMES - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
SHEETNUMBER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
SHEETS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
shiftColumns(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Shifts columns left or right in the active sheet (single column, default shift right by 1)
shiftColumns(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Shifts columns left or right in the active sheet (single column with shift amount)
shiftColumns(int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Shifts columns left or right in the active sheet
shiftColumns(Sheet, int, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Shifts columns left or right in a sheet Note: Apache POI doesn't provide a native column shift operation, so we implement it manually by copying cell data from the source columns to the destination columns.
shiftRows(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Shifts rows up or down in the active sheet (single row, default shift down by 1)
shiftRows(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Shifts rows up or down in the active sheet (single row with shift amount)
shiftRows(int, int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Shifts rows up or down in the active sheet
showColumn(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Shows a hidden column on the active sheet (fluent API)
showRow(int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Shows a hidden row on the active sheet (fluent API)
SIZE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
Spreadsheet - Class in ortus.boxlang.spreadsheet.bifs
Spreadsheet - Class in ortus.boxlang.spreadsheet.components: The Spreadsheet component provides functionality to work with Excel spreadsheet files.
Spreadsheet() - Constructor for class ortus.boxlang.spreadsheet.bifs.Spreadsheet: Constructor
Spreadsheet() - Constructor for class ortus.boxlang.spreadsheet.components.Spreadsheet: Constructor
SpreadsheetAddAutofilter - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddAutofilter() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddAutofilter: Constructor
SpreadsheetAddColumn - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddColumn() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddColumn: Constructor
SpreadsheetAddFreezePane - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddFreezePane() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddFreezePane: Constructor
SpreadsheetAddImage - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddImage() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddImage: Constructor
SpreadsheetAddInfo - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddInfo() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddInfo: Constructor
SpreadsheetAddPageBreaks - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddPageBreaks() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddPageBreaks
SpreadsheetAddPrintGridlines - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddPrintGridlines() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddPrintGridlines: Constructor
SpreadsheetAddRow - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddRow() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddRow: Constructor
SpreadsheetAddRows - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddRows() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddRows: Constructor
SpreadsheetAddSplitPane - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetAddSplitPane() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddSplitPane: Constructor
SpreadsheetClearCell - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetClearCell() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetClearCell: Constructor
SpreadsheetClearCellRange - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetClearCellRange() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetClearCellRange: Constructor
SpreadsheetCreateSheet - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetCreateSheet() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetCreateSheet: Constructor
SpreadsheetDeleteColumn - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetDeleteColumn() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetDeleteColumn: Constructor
SpreadsheetDeleteColumns - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetDeleteColumns() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetDeleteColumns: Constructor
SpreadsheetDeleteRow - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetDeleteRow() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetDeleteRow: Constructor
SpreadsheetDeleteRows - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetDeleteRows() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetDeleteRows: Constructor
SpreadsheetFile - Class in ortus.boxlang.spreadsheet: A fluent API for managing spreadsheet files in BoxLang using Apache POI.
SpreadsheetFile() - Constructor for class ortus.boxlang.spreadsheet.SpreadsheetFile: Constructor - initializes a new SpreadsheetFile instance Creates a new workbook with a default sheet named "Sheet1" and using the xlsx format
SpreadsheetFile(boolean) - Constructor for class ortus.boxlang.spreadsheet.SpreadsheetFile: Constructor with format specification
SpreadsheetFile(boolean, String) - Constructor for class ortus.boxlang.spreadsheet.SpreadsheetFile: Constructor with format specification and sheet name
SpreadsheetFormatCell - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetFormatCell() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatCell: Constructor
SpreadsheetFormatCellRange - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetFormatCellRange() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatCellRange: Constructor
SpreadsheetFormatColumn - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetFormatColumn() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatColumn: Constructor
SpreadsheetFormatColumns - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetFormatColumns() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatColumns: Constructor
SpreadsheetFormatRow - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetFormatRow() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatRow: Constructor
SpreadsheetFormatRows - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetFormatRows() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatRows: Constructor
SpreadsheetGetActiveCell - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetActiveCell() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetActiveCell: Constructor
SpreadsheetGetAutoCalculate - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetAutoCalculate() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetAutoCalculate
SpreadsheetGetCellComment - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetCellComment() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellComment: Constructor
SpreadsheetGetCellFormat - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetCellFormat() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellFormat: Constructor
SpreadsheetGetCellFormula - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetCellFormula() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellFormula: Constructor
SpreadsheetGetCellHyperlink - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetCellHyperlink() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellHyperlink: Constructor
SpreadsheetGetCellType - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetCellType() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellType: Constructor
SpreadsheetGetCellValue - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetCellValue() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellValue: Constructor
SpreadsheetGetColumnCount - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetColumnCount() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetColumnCount: Constructor
SpreadsheetGetColumnWidth - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetColumnWidth() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetColumnWidth: Constructor
SpreadsheetGetForceFormulaRecalculation - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetForceFormulaRecalculation() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetForceFormulaRecalculation
SpreadsheetGetLastRowNumber - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetLastRowNumber() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetLastRowNumber: Constructor
SpreadsheetGetPrintOrientation - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGetPrintOrientation() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetPrintOrientation: Constructor
SpreadsheetGroupColumns - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGroupColumns() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGroupColumns: Constructor
SpreadsheetGroupRows - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetGroupRows() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetGroupRows: Constructor
SpreadsheetInfo - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetInfo() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetInfo: Constructor
SpreadsheetIsBinaryFormat - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetIsBinaryFormat() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetIsBinaryFormat: Constructor
SpreadsheetisColumnHidden - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetisColumnHidden() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetisColumnHidden: Constructor
SpreadsheetisRowHidden - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetisRowHidden() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetisRowHidden: Constructor
SpreadsheetIsXMLFormat - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetIsXMLFormat() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetIsXMLFormat: Constructor
SpreadsheetMergeCells - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetMergeCells() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetMergeCells: Constructor
SpreadsheetNew - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetNew() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetNew: Constructor
SPREADSHEETOBJ - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
SpreadsheetRead - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetRead() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetRead: Constructor
SpreadsheetReadBinary - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetReadBinary() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetReadBinary: Constructor
SpreadsheetRemoveColumnBreak - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetRemoveColumnBreak() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemoveColumnBreak
SpreadsheetRemovePrintGridlines - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetRemovePrintGridlines() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemovePrintGridlines: Constructor
SpreadsheetRemoveRowBreak - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetRemoveRowBreak() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemoveRowBreak
SpreadsheetRemoveSheet - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetRemoveSheet() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemoveSheet: Constructor
SpreadsheetRemoveSheetNumber - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetRemoveSheetNumber() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemoveSheetNumber: Constructor
SpreadsheetRenameSheet - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetRenameSheet() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetRenameSheet: Constructor
SpreadsheetSetActiveCell - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetActiveCell() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetActiveCell: Constructor
SpreadsheetSetActiveSheet - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetActiveSheet() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetActiveSheet: Constructor
SpreadsheetSetActiveSheetNumber - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetActiveSheetNumber() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetActiveSheetNumber: Constructor
SpreadsheetSetAutoCalculate - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetAutoCalculate() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetAutoCalculate
SpreadsheetSetCellComment - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetCellComment() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellComment: Constructor
SpreadsheetSetCellFormula - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetCellFormula() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellFormula: Constructor
SpreadsheetSetCellHyperlink - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetCellHyperlink() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellHyperlink: Constructor
SpreadsheetSetCellRangeValue - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetCellRangeValue() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellRangeValue: Constructor
SpreadsheetSetCellValue - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetCellValue() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellValue: Constructor
SpreadsheetSetColumnBreak - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetColumnBreak() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetColumnBreak
SpreadsheetSetColumnHidden - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetColumnHidden() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetColumnHidden: Constructor
SpreadsheetSetColumnWidth - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetColumnWidth() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetColumnWidth: Constructor
SpreadsheetSetFitToPage - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetFitToPage() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetFitToPage
SpreadsheetSetFooter - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetFooter() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetFooter: Constructor
SpreadsheetSetFooterImage - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetFooterImage() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetFooterImage: Constructor
SpreadsheetSetForceFormulaRecalculation - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetForceFormulaRecalculation() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetForceFormulaRecalculation
SpreadsheetSetHeader - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetHeader() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetHeader: Constructor
SpreadsheetSetHeaderImage - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetHeaderImage() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetHeaderImage: Constructor
SpreadsheetSetPrintOrientation - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetPrintOrientation() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetPrintOrientation: Constructor
SpreadsheetSetRepeatingColumns - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetRepeatingColumns() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRepeatingColumns: Constructor
SpreadsheetSetRepeatingRows - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetRepeatingRows() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRepeatingRows: Constructor
SpreadsheetSetRowBreak - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetRowBreak() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRowBreak
SpreadsheetSetRowHeight - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetRowHeight() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRowHeight: Constructor
SpreadsheetSetRowHidden - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetSetRowHidden() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRowHidden: Constructor
SpreadsheetShiftColumns - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetShiftColumns() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetShiftColumns: Constructor
SpreadsheetShiftRows - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetShiftRows() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetShiftRows: Constructor
SPREADSHEETTYPE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
SpreadsheetUngroupColumns - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetUngroupColumns() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetUngroupColumns: Constructor
SpreadsheetUngroupRows - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetUngroupRows() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetUngroupRows: Constructor
SpreadsheetUtil - Class in ortus.boxlang.spreadsheet: This class provides spreadsheet utilities for the BoxLang runtime using Apache POI
SpreadsheetUtil() - Constructor for class ortus.boxlang.spreadsheet.SpreadsheetUtil
SpreadsheetWrite - Class in ortus.boxlang.spreadsheet.bifs
SpreadsheetWrite() - Constructor for class ortus.boxlang.spreadsheet.bifs.SpreadsheetWrite: Constructor
SRC - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
START - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
STARTCOLUMN - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
STARTROW - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
STRIKEOUT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
SUBJECT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

T

TEXTWRAP - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
TITLE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
toArray() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the active sheet data to an array of structs (first row as headers) Alias for getDataAsQuery() to match the fluent API pattern
toArray(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the specified sheet data to an array of structs (first row as headers) Alias for getDataAsQuery() to match the fluent API pattern
toCSV() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the active sheet data to CSV format with default options Default options: comma delimiter, includes headers, CRLF line separator
toCSV(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the specified sheet data to CSV format with default options
toCSV(String, IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the specified sheet data to CSV format with custom options
toCSV(IStruct) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the active sheet data to CSV format with custom options
toJson() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the active sheet data to JSON string
toJson(boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the active sheet data to JSON string
toJson(String, boolean) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the specified sheet data to JSON string
toMatrix() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the active sheet data to a 2D array matrix (including headers) Returns all rows including the header row as arrays
toMatrix(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the specified sheet data to a 2D array matrix (including headers) Returns all rows including the header row as arrays
TOPBORDER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
TOPBORDERCOLOR - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
TOPROW - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
toQuery() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the active sheet data to query format (array of structs with first row as headers) Alias for getDataAsQuery() to match the fluent API pattern
toQuery(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Converts the specified sheet data to query format (array of structs with first row as headers) Alias for getDataAsQuery() to match the fluent API pattern
toString() - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: String representation of the spreadsheet file
TYPE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

U

UNDERLINE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
ungroupColumns(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Ungroups columns in the active sheet
ungroupColumns(Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Ungroups columns in the active sheet
ungroupRows(int, int) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Ungroups rows in the active sheet
ungroupRows(Sheet, int, int) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Ungroups rows in the active sheet
unhideSheet(String) - Method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Unhides a sheet to make it visible
unhideSheet(Workbook, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Unhides a sheet to make it visible
URL - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

V

VALUE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
VARIABLES - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
VERTICALALIGNMENT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
VISIBILITY - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
VISIBLE - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

W

WIDTH - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
WORKER - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
writeWorkbook(Workbook, String, boolean) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Writes a workbook to the specified file path
writeWorkbook(Workbook, String, boolean, String) - Static method in class ortus.boxlang.spreadsheet.SpreadsheetUtil: Writes a workbook to the specified file path with optional password protection

X

xls() - Static method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new SpreadsheetFile with .xls format
xlsx() - Static method in class ortus.boxlang.spreadsheet.SpreadsheetFile: Creates a new SpreadsheetFile with .xlsx format
XMLFORMAT - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary
XSPLITPOS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

Y

YSPLITPOS - Static variable in class ortus.boxlang.spreadsheet.util.KeyDictionary

_

_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.IsSpreadsheetFile: Determines whether a file is a spreadsheet file.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.IsSpreadsheetObject: Determines whether an object is a BoxLang spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.Spreadsheet: Get a fluent SpreadsheetFile object that can be used to read or write properties to a loaded spreadsheet file or a new one.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddAutofilter: Adds auto filters to a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddColumn: Adds columns to a spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddFreezePane: Adds freeze pane to a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddImage: Adds an image to a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddInfo: Adds metadata information to a spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddPageBreaks: Adds multiple page breaks (rows and/or columns) to the active sheet
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddPrintGridlines: Adds print gridlines to the active sheet or specified sheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddRow: Adds a row to an Excel spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddRows: Adds multiple rows from a query to an Excel spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetAddSplitPane: Adds a split pane to a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetClearCell: Clears the specified cell of all styles and values.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetClearCellRange: Clears the specified cell range of all styles and values.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetCreateSheet: Creates a new sheet in the given spreadsheet object and selects it automatically for you.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetDeleteColumn: Deletes a column in a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetDeleteColumns: Deletes multiple columns in a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetDeleteRow: Deletes a row data in a spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetDeleteRows: Deletes multiple rows in a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatCell: Formats the contents of a single cell of an Excel spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatCellRange: Formats a range of cells in a spreadsheet with a single format struct.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatColumn: Formats a column of an Excel spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatColumns: Formats multiple columns of an Excel spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatRow: Formats a row of an Excel spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetFormatRows: Formats multiple rows of an Excel spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetActiveCell: Gets the currently active/selected cell.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetAutoCalculate
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellComment: Gets the comment from a cell in a spreadsheet or all comments if row/column not provided.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellFormat: Gets the formatting information of a cell.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellFormula: Gets the formula for a for an Excel spreadsheet object cell, or all formulas for the object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellHyperlink: Gets the hyperlink from a cell in a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellType: Gets the Excel data type of a cell.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetCellValue: Gets the value for a for an Excel spreadsheet object cell.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetColumnCount: Gets the number of columns in a worksheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetColumnWidth: Retrieves the width of a column in the active sheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetForceFormulaRecalculation
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetLastRowNumber: Retrieves the row number of the last row with data in the active sheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGetPrintOrientation: Retrieves the print orientation of the active sheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGroupColumns: Groups columns in a spreadsheet
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetGroupRows: Groups rows in a spreadsheet
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetInfo: Returns the properties of a spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetIsBinaryFormat: Checks if a spreadsheet is in binary format (.xls).
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetisColumnHidden: Checks if a column is hidden.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetisRowHidden: Checks if a row is hidden.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetIsXMLFormat: Checks if a spreadsheet is in XML format (.xlsx).
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetMergeCells: Merges a rectangular block of two or more Excel spreadsheet object cells.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetNew: Creates a new BoxLang spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetRead: Reads a sheet from a spreadsheet file and stores it in a BoxLang spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetReadBinary: Reads a spreadsheet file into a binary object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemoveColumnBreak: Removes a page (column) break on the active sheet at the given column
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemovePrintGridlines: Removes print gridlines from the active sheet or specified sheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemoveRowBreak: Removes a page (row) break on the active sheet at the given row
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemoveSheet: Deletes a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetRemoveSheetNumber: Removes a sheet from a spreadsheet by sheet number.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetRenameSheet: Renames a sheet in a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetActiveCell: Sets the active/selected cell.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetActiveSheet: Sets a sheet in a spreadsheet as active.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetActiveSheetNumber: Sets a sheet number in a spreadsheet as active.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetAutoCalculate
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellComment: Sets a comment on a cell in a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellFormula: Specifies the formula for an Excel spreadsheet object cell.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellHyperlink: Sets a hyperlink on a cell in a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellRangeValue: Sets the same value to a range of cells.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetCellValue: Specifies the value of an Excel spreadsheet object cell.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetColumnBreak: Sets a page (column) break on the active sheet at the given column
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetColumnHidden: Sets the hidden state of a column.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetColumnWidth: Sets the width of a column in a spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetFitToPage: Toggles the fit-to-page print option on the active sheet
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetFooter: Sets a footer in a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetFooterImage: Adds an image to the footer of a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetForceFormulaRecalculation
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetHeader: Sets a header in a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetHeaderImage: Adds an image to the header of a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetPrintOrientation: Sets the print orientation for a spreadsheet sheet (portrait or landscape).
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRepeatingColumns: Sets columns to repeat on every printed page of a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRepeatingRows: Sets rows to repeat on every printed page of a spreadsheet.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRowBreak: Sets a page (row) break on the active sheet at the given row
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRowHeight: Sets the height of a row in a spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetSetRowHidden: Sets the hidden state of a row.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetShiftColumns: Shifts columns in a spreadsheet left or right.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetShiftRows: Shifts one or multiple rows up or down in a spreadsheet object.
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetUngroupColumns: Removes column grouping in a spreadsheet
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetUngroupRows: Removes row grouping in a spreadsheet
_invoke(IBoxContext, ArgumentsScope) - Method in class ortus.boxlang.spreadsheet.bifs.SpreadsheetWrite: Writes a spreadsheet object into a file.
_invoke(IBoxContext, IStruct, Component.ComponentBody, IStruct) - Method in class ortus.boxlang.spreadsheet.components.Spreadsheet: Main component execution method

A B C D E F G H I K L M N O P Q R S T U V W X Y _
All Classes and Interfaces|All Packages|Constant Field Values