OpenSpreadFile Method (FpSpread)

Visual Basic
C#

'Declaration
 
Public Function OpenSpreadFile( _
   ByVal fileName As String, _
   ByVal sheetIndex As Integer _
) As Boolean

'Usage
 
Dim instance As FpSpread
Dim fileName As String
Dim sheetIndex As Integer
Dim value As Boolean
 
value = instance.OpenSpreadFile(fileName, sheetIndex)

public bool OpenSpreadFile( 
   string fileName,
   int sheetIndex
)

Parameters

fileName: Path and name of the Spread-compatible file from which to load the contents
sheetIndex: Index of sheet into which to load the data.

Return Value

Boolean: true if successful; false otherwise

Set the SheetIndex to -1 to load all sheets from the file.

This example opens the specified file and determines if it meets the minimal requirements to be considered a Spread SS7 file.

C#

bool b;
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
b = fpSpread1.IsSpreadSSFile(Application.StartupPath + "\\data.ss6");
label1.Visible = true;
label1.ForeColor = Color.Red;
if (b == true)
{
     fpSpread1.OpenSpreadFile(Application.StartupPath + "\\data.ss6", 0);
     label1.Text = "Is the file a Spread file = " + b.ToString();
}

Visual Basic

Dim b As Boolean
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
b = fpSpread1.IsSpreadSSFile(Application.StartupPath & "\data.ss6")
Label1.Visible = True
Label1.ForeColor = Color.Red
If b = True Then
     fpSpread1.OpenSpreadFile(Application.StartupPath & "\data.ss6", 0)
     Label1.Text = "Is the file a Spread file = " & b.ToString()
End If

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Opening Files
SS7 File Import