Spread Windows Forms 10.0 Product Documentation
OpenSpreadFile Method (FpSpread)
Example 


Path and name of the Spread-compatible file from which to load the contents

Index of sheet into which to load the data.

Opens a saved Spread file.
Syntax
'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
Remarks
Set the SheetIndex to -1 to load all sheets from the file.
Example

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

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();
}
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
Requirements

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

See Also

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Opening Files
SS7 File Import

 

 


Copyright © GrapeCity, inc. All rights reserved.