Opens an Excel file and loads the specified sheet (by name) from that file into this sheet.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim fileName As String
Dim excelSheetName As String
Dim value As Boolean
value = instance.OpenExcel(fileName, excelSheetName) |
Parameters
- fileName
- Path and name of the file to open
- excelSheetName
- Name of the sheet to load from the file
Return Value
Boolean:
true if successful;
false otherwise
Example
This example open an Excel file and loads it in the active sheet.
| C# | Copy Code |
|---|
OpenFileDialog ofd = new OpenFileDialog();
string s;
ofd.Filter = "Excel files (*.xls)|*.xls";
ofd.FilterIndex = 2;
ofd.InitialDirectory = Application.StartupPath;
ofd.RestoreDirectory = true;
if (ofd.ShowDialog() == DialogResult.OK)
{
s = ofd.FileName;
fpSpread1.ActiveSheet.OpenExcel(s, "Sheet1");
} |
| Visual Basic | Copy Code |
|---|
Dim s As String
Dim ofd As New OpenFileDialog()
ofd.Filter = "Excel files (*.xls)|*.xls"
ofd.FilterIndex = 2
ofd.InitialDirectory = Application.StartupPath
ofd.RestoreDirectory = True
If ofd.ShowDialog() = DialogResult.OK Then
s = ofd.FileName
FpSpread1.ActiveSheet.OpenExcel(s, "Sheet1")
End If |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
