LoadBlockFromBuffer Method

---

See Also    DLL    Example

Applies To

fpSpread control

Description

Loads data into a block of cells from a buffer.

Syntax

void CSpreadSheet::LoadBlockFromBuffer (long Col, long Row, long Col2, long Row2, VARIANT* Buff);

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

Loading Data from a Buffer

Sheet property

LoadTabFile, LoadTextFile, SaveTabFile, SaveToFile, SaveToBuffer methods

DLL Correspondence

SSLoadFromFile function