cfExcelProxy | Methods
Please note that this method list is for version 0.3, available via the subversion repository. Information can be found on the project site.
newWorkbook ( string file )
Returns: cfExcelProxy
Description: Creates an empty workbook, or reads in from a file.
newSheet ( string name )
Returns: cfExcelProxy
Description: Creates a new sheet.
selectSheet ( string name )
Returns: cfExcelProxy
Description: Selects the sheet and makes it the currently active one.
setCell ( string value , numeric row , numeric column , string cell , string class )
Returns: cfExcelProxy
Description: Sets a cell
setCellsFromQuery ( query query , numeric row , numeric column , string cell , string columnList , string headerList , boolean showHeaderRow , string headerClass , string bodyClass , string altRowClass )
Returns: cfExcelProxy
Description: Dumps a query into the active sheet, at the provided location.
getCellValue ( numeric row , numeric column , string cell )
Returns: string
Description: Returns a cell
getQueryFromCells ( numeric row , numeric column , string cell , boolean header )
Returns: query
Description: Attempts to reconstruct a query from the starting position.
getCellRangeValueAsArray ( numeric startRow , numeric startColumn , string startCell , numeric endRow , numeric endColumn , string endCell )
Returns: array
Description: Returns an array of cell values, spanning the provided start and end coordinates.
mergeCells ( numeric startRow , numeric startColumn , string startCell , numeric endRow , numeric endColumn , string endCell )
Returns: cfExcelProxy
Description: Merges a range of cells.
shiftRows ( numeric startRow , numeric endRow , numeric numRows , boolean copyRowHeight , boolean resetOriginalRowHeight )
Returns: cfExcelProxy
Description: Shifts n number of rows between the start and end rows.
autoAdjustWidth ( numeric row )
Returns: cfExcelProxy
Description: Adjusts the column widths of the selected sheet. The row argument helps find the available columns.
newClass ( string name , struct props )
Returns: cfExcelProxy
Description: Create a class for future use.
getClasses ( )
Returns: array
Description: Returns an array of all available classes.
drawClasses ( string class )
Returns: string
Description: Returns a formatted HTML representation of all available classes.
getBinary ( )
Returns: binary
Description: Returns a binary stream of the current workbook.
save ( string'' file )
Returns: cfExcelProxy
Description: Saves the workbook to file. If it was originally read from a file and no argument is provided, the workbook is saved to it.