Spread 8.0 Documentation
SSLoadTabFile Function
Support Options
DLL Reference > DLL Functions > SSLoadTabFile Function

Glossary Item Box

SSLoadTabFile Function


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Loads a tab-delimited data file.

Syntax

C

BOOL SSLoadTabFile(HWND hWnd, LPCTSTR lpszFileName);

C++

BOOL TSpread::LoadTabFile(LPCTSTR lpszFileName);

Parameters

The following parameters are available:

Parameter Description
hWnd Window handle of the fpSpread control
lpszFileName Path and file name of tab-delimited file to load

Remarks

This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.

Call this function to load a tab-delimited data file. Call the SSLoadTextFile function to load a text file that uses multiple delimiters, or delimiters other than tab characters. Call the SSLoadFromFile function to load a binary data file.

Tab-delimited data files contain data separated by tabs and carriage returns. Tab-delimited data files can be opened, modified, and saved using any standard text editor.

The file being loaded should have been created using the SSSaveTabFile function, the Spread Designer, or be an existing tab-delimited file.

Note: When you load a tab-delimited file into the sheet, the maximum number of columns and rows change (as set by calling the SSSetMaxCols and SSSetMaxRows functions) to the number of columns and rows in the tab-delimited file.

Caution: Loading a text 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 sheet only has 50 columns and rows.

Return Value

TRUE if the function completes successfully; FALSE otherwise.

See Also

Loading a Text File

SSLoadFromBuffer, SSLoadFromFile, SSLoadTextFile, SSSaveTabFile, SSSaveToBuffer, SSSaveToFile, SSSetMaxCols, SSSetMaxRows, SSSetSheet functions

ActiveX Correspondence

LoadTabFile method

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.