Spread 8.0 Documentation
LoadTabFile Method
Support Options
ActiveX Reference > ActiveX Methods > LoadTabFile Method

Glossary Item Box

LoadTabFile Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Loads a tab-delimited data file.

Syntax

C++

BOOL CSpreadSheet::LoadTabFile (LPCTSTR FileName);

Visual Basic

fpSpread.LoadTabFile(ByVal FileName As String) As Boolean

Parameters

The following parameter is available:

Parameter Description
FileName Path and file name of file to load

Remarks

Use this method to load a tab-delimited data file. Use the LoadTextFile method to load a text file that uses multiple delimiters, or delimiters other than tab characters. Use the LoadFromFile method to load a Spread binary (.SS8) file.

This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.

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.

Note: When you load a tab-delimited file into the sheet, the settings for the MaxCols and MaxRows properties change 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 control only has 50 columns and rows.

Return Type

True if successful; otherwise, False.

See Also

Loading a Text File

MaxCols, MaxRows, Sheet properties

LoadFromFile, LoadTextFile, SaveTabFile methods

DLL Correspondence

SSLoadTabFile function

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