Methods
The following methods are defined in the SSpread class.
| Name | Description |
|---|---|
| AddCellSpan | Add a merged cell |
| AddSelection | Select a cell block |
| ClearRange | Erase data |
| ClearSelection | Clear all selected cells |
| ClipboardCopy | Copy the selected cell block to the clipboard |
| ClipboardCut | Cut the selected cell block and stores it in the clipboard |
| ClipboardPaste | Paste the contents of the clipboard into the active cell |
| ColLetterToNumber | Convert the characters in the column header to the corresponding column number |
| ColNumberToLetter | Get the alphabet corresponding to the column number |
| CopyColRange | Copy the column range to the specified position |
| CopyRange | Copy the cell block to the specified location |
| CopyRowRange | Copy the row range to the specified location |
| DeleteCols | Delete a column or column range |
| DeleteRows | Delete a row or range |
| ExportExcelBook | Export to Excel format file |
| ExportExcelBookEx | Export to Excel format file |
| ExportRangeToHTML | Export cell range to HTML file |
| ExportRangeToHTMLEx | Export cell range to HTML file |
| ExportRangeToTextFile | Export cell range to text file |
| ExportRangeToTextFileU | Export cell range to Unicode text file |
| ExportRangeToXML | Export cell range to XML file |
| ExportToExcel | Export to sheet in Excel format file |
| ExportToExcelEx | Export to sheet in Excel format file |
| ExportToHTML | Export to HTML file |
| ExportToHTMLEx | Export to HTML file |
| ExportToTextFile | Export to text file |
| ExportToTextFileU | Export to a Unicode text file |
| ExportToXML | Export to XML file |
| FindCellTag | Search for the tag set in the CellTag property Added since Ver.5.0.3 |
| GetActionKey | Get the action shortcut key |
| GetBottomRightCell | Get the column number and row number of the lower right cell |
| GetCellBorder | Get the border color and linetype around the cell |
| GetCellFromScreenCoord | Get the column number and row number of the cell displayed in the screen coordinates (x, y) |
| GetCellPos | Get the position and size of the cell |
| GetCellSpan | Find out if a cell is contained within a merged cell |
| GetClientArea | Get the size of the area excluding the scroll bar |
| GetColFromID | Get the number of the column with the specified identification string |
| GetColItemData | Gets the individual numerical data set for the column |
| GetExcelSheetList | Get the sheet name list from the Excel file |
| GetFirstValidCell | Get the column number and row number of the first valid cell |
| GetFloat | Get floating point value from cell |
| GetInteger | Get an integer value from a cell |
| GetLastValidCell | Get the column number and row number of the last valid cell |
| GetMultiSelItem | Get the number of the selected line in multiple selection mode |
| GetOddEvenRowColor | Get the background color and text color set for odd and even lines |
| GetRefStyle | Get the formula cell reference style |
| GetRowItemData | Get the individual numerical data set in the row |
| GetSelection | Return one of the selected cell blocks |
| GetText | Get the cell value as a string |
| ImportExcelSheet | Import the specified sheet in the Excel file |
| InsertCols | Insert a column |
| InsertRows | Insert a row |
| IsCellSelected | Find out if a cell is selected |
| IsExcel2007File | Check if the file is in Excel 2007 format Added since Ver.5.0.2 |
| IsFormulaValid | Check if the formula format is valid |
| IsHorizontalScrollBarVisible | Check if the horizontal scroll bar is displayed |
| IsVerticalScrollBarVisible | Check if the vertical scroll bar is displayed |
| IsVisible | Check if the cell is visible in the display area |
| LoadBlockFromBuffer | Read the cell information stored in ByteArray into the specified range Added since Ver.5.0.3 |
| LoadFromBuffer | Read binary format data from ByteArray Added since Ver.5.0.3 |
| LoadFromFile | Read the data file saved in binary format |
| LoadTabFile | Read tab-separated data files |
| LoadTextFile | Read a text file |
| MoveColRange | Moves the column range to the specified position |
| MoveRange | Move the cell block to the specified position |
| MoveRowRange | Move the row range to the specified location |
| OpenExcel2007File | Import the specified sheet in the Excel 2007 format file Added since Ver.5.0.2 |
| ReCalc | Recalculate the formula |
| ReCalcCell | ReCalcCell |
| RemoveCellSpan | Unmerge cell |
| Reset | Initialize the entire spreadsheet |
| SaveBlockToBuffer | Save the specified range of cell information in ByteArray Added since Ver.5.0.3 |
| SaveExcel2007File | Export to a sheet of Excel 2007 format file Added since Ver.5.0.2 |
| SaveTabFile | Save to tab separated file |
| SaveTabFileU | Save to a Unicode tab separated file |
| SaveToBuffer | Save to ByteArray in binary format Added since Ver.5.0.2 |
| SaveToFile | Save in binary format |
| SetActionKey | Set the action shortcut key |
| SetActiveCell | Set the active cell |
| SetCellBorder | Set the border color and line type around the cell |
| SetColItemData | Set individual numerical data for the column |
| SetFloat | Set the floating point value in the cell |
| SetInteger | Set an integer value in the cell |
| SetOddEvenRowColor | Set the background color and text color for the odd and even lines, respectively. |
| SetRefStyle | Set the cell reference style of the formula |
| SetRowItemData | Set individual numerical data for each row |
| SetSelection | Select a cell block |
| SetText | Set the string in the cell |
| ShowCell | Scrolls the cell to appear in the specified position |
| Sort | Sort the data |
| SwapColRange | Swap the specified column range with another column range |
| SwapRange | Swap the specified cell range with another cell range |
| SwapRowRange | Swap the specified line range with another line range |
| TypeComboBoxClear | Remove all list items from the combo box cell |
| TypeComboBoxRemoveItem | Delete one list item from the combo box cell |