FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class > OpenExcel Method : OpenExcel(Stream,String) Method |
'Declaration Public Overloads Function OpenExcel( _ ByVal stream As Stream, _ ByVal sheetName As String _ ) As Boolean
System.IO.Stream s; s = System.IO.File.Open("C:\\controls\\book1.xlsx", System.IO.FileMode.Open); //FpSpread1.Sheets[0].OpenExcel(s, "Sheet1"); //FpSpread1.Sheets[0].OpenExcel(s, 0); //FpSpread1.Sheets[0].OpenExcel(s, "Sheet1", FarPoint.Excel.ExcelOpenFlags.DataOnly); //FpSpread1.Sheets[0].OpenExcel(s, "Sheet1", FarPoint.Excel.ExcelOpenFlags.DataOnly, "123*"); //FpSpread1.Sheets[0].OpenExcel(s, 0, FarPoint.Excel.ExcelOpenFlags.DataOnly); FpSpread1.Sheets[0].OpenExcel(s, 0, FarPoint.Excel.ExcelOpenFlags.DataOnly, "123*");
Dim s As System.IO.Stream s = System.IO.File.Open("C:\controls\book1.xlsx", System.IO.FileMode.Open) 'FpSpread1.Sheets(0).OpenExcel(s, "Sheet1") 'FpSpread1.Sheets(0).OpenExcel(s, 0) FpSpread1.Sheets(0).OpenExcel(s, "Sheet1", FarPoint.Excel.ExcelOpenFlags.DataOnly) 'FpSpread1.Sheets(0).OpenExcel(s, "Sheet1", FarPoint.Excel.ExcelOpenFlags.DataOnly, "123*") 'FpSpread1.Sheets(0).OpenExcel(s, 0, FarPoint.Excel.ExcelOpenFlags.DataOnly) 'FpSpread1.Sheets(0).OpenExcel(s, 0, FarPoint.Excel.ExcelOpenFlags.DataOnly, "123*")
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