OpenSpreadFile Method (SheetView)

Opens a saved Spread file into this sheet.

Syntax

Visual Basic
C#

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

'Usage
 
Dim instance As SheetView
Dim fileName As String
Dim value As Boolean
 
value = instance.OpenSpreadFile(fileName)

public bool OpenSpreadFile( 
   string fileName
)

Parameters

fileName: Path and name of the file to open

Example

This example opens a saved Spread COM file and loads it in the active sheet.

OpenFileDialog ofd = new OpenFileDialog();
string s;
ofd.Filter = "SS6 files (*.ss6)|*.ss6";
ofd.FilterIndex = 2;
ofd.RestoreDirectory = true;
ofd.InitialDirectory = Application.StartupPath;
if (ofd.ShowDialog() == DialogResult.OK) 
{
    s = ofd.FileName;
    fpSpread1.ActiveSheet.OpenSpreadFile(s);
}

Visual Basic

Dim s As String
Dim ofd As New OpenFileDialog()
ofd.Filter = "SS6 files (*.ss6)|*.ss6"
ofd.FilterIndex = 2
ofd.RestoreDirectory = True
ofd.InitialDirectory = Application.StartupPath
If ofd.ShowDialog() = DialogResult.OK Then
    s = ofd.FileName
    FpSpread1.ActiveSheet.OpenSpreadFile(s)
End If

Requirements

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

Reference

SheetView Class
SheetView Members

User-Task Documentation

Opening a Spread COM File