LoadBlockFromBuffer Method
Applies To
fpSpread control
Description
Loads data into a block of cells from a buffer.
Syntax
C++
void CSpreadSheet::LoadBlockFromBuffer (long Col, long Row, long Col2, long Row2, VARIANT* Buff);
Visual Basic
fpSpread.LoadBlockFromBuffer(ByVal Col As Long, ByVal Row As Long, ByVal Col2 As Long, ByVal Row2 As Long, Buff As Variant)
Parameters
The following parameter is available:
| Parameter | Description |
| Col | Starting column index of block of cells |
| Row | Starting row index of block of cells |
| Col2 | Ending column index of block of cells |
| Row2 | Ending row index of block of cells |
| Buff | Pointer to the buffer |
Remarks
Use this method to load data into a specific block of cells from a buffer. Use the LoadTabFile or LoadTextFile method to load a delimited data file.
| Caution: Loading a Spread file into the control deletes the data currently in the control. The loaded file overwrites existing data. Also, if your sheet had more columns and rows than the loaded sheet, those columns and rows are removed. For example, if your sheet had 100 columns and rows of data, and the loaded sheet has 50 columns and rows of data, once the new sheet is loaded, the control only has 50 columns and rows. |
Return Type
Void
See Also
Sheet property
LoadTabFile, LoadTextFile, SaveTabFile, SaveToFile, SaveToBuffer methods
DLL Correspondence
SSLoadFromFile function