FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class > OpenExcel Method : OpenExcel(Stream,Int32,Int32,ExcelOpenFlags,ExcelWarningList,String) Method |
'Declaration Public Overloads Function OpenExcel( _ ByVal stream As Stream, _ ByVal spreadSheetIndex As Integer, _ ByVal excelSheetIndex As Integer, _ ByVal excelOpenFlags As ExcelOpenFlags, _ ByVal warningList As ExcelWarningList, _ ByVal password As String _ ) As Boolean
'Usage Dim instance As FpSpread Dim stream As Stream Dim spreadSheetIndex As Integer Dim excelSheetIndex As Integer Dim excelOpenFlags As ExcelOpenFlags Dim warningList As ExcelWarningList Dim password As String Dim value As Boolean value = instance.OpenExcel(stream, spreadSheetIndex, excelSheetIndex, excelOpenFlags, warningList, password)
public bool OpenExcel( Stream stream, int spreadSheetIndex, int excelSheetIndex, ExcelOpenFlags excelOpenFlags, ExcelWarningList warningList, 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, 0, 0, FarPoint.Excel.ExcelOpenFlags.DataOnly, new FarPoint.Excel.ExcelWarningList,"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, 0, 0, FarPoint.Excel.ExcelOpenFlags.DataOnly, New FarPoint.Excel.ExcelWarningList, "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