FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class > OpenExcel Method : OpenExcel(Stream,String,String,ExcelOpenFlags,String) Method |
'Declaration Public Overloads Function OpenExcel( _ ByVal stream As Stream, _ ByVal spreadSheetName As String, _ ByVal excelSheetName As String, _ ByVal excelOpenFlags As ExcelOpenFlags, _ ByVal password As String _ ) As Boolean
'Usage Dim instance As FpSpread Dim stream As Stream Dim spreadSheetName As String Dim excelSheetName As String Dim excelOpenFlags As ExcelOpenFlags Dim password As String Dim value As Boolean value = instance.OpenExcel(stream, spreadSheetName, excelSheetName, excelOpenFlags, password)
public bool OpenExcel( Stream stream, string spreadSheetName, string excelSheetName, ExcelOpenFlags excelOpenFlags, string password )
string f; f = "C:\\savedinexcel.xls"; System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.Read); FpSpread1.OpenExcel(s, "Sheet1", "PCREPORT.RPT", FarPoint.Excel.ExcelOpenFlags.DataOnly, "test");
Dim f As String f = "C:\savedinexcel.xls" Dim s As New System.IO.FileStream(f, IO.FileMode.Open,IO.FileAccess.Read) FpSpread1.OpenExcel(s, "Sheet1", "PCREPORT.RPT", FarPoint.Excel.ExcelOpenFlags.DataOnly, "test")
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6