FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > FpSpread クラス > OpenExcel メソッド : OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList,String,Boolean) メソッド |
'Declaration Public Overloads Function OpenExcel( _ ByVal stream As Stream, _ ByVal openFlags As ExcelOpenFlags, _ ByVal warningList As ExcelWarningList, _ ByVal password As String, _ ByVal isClearInputMapKey As Boolean _ ) As Boolean
'使用法 Dim instance As FpSpread Dim stream As Stream Dim openFlags As ExcelOpenFlags Dim warningList As ExcelWarningList Dim password As String Dim isClearInputMapKey As Boolean Dim value As Boolean value = instance.OpenExcel(stream, openFlags, warningList, password, isClearInputMapKey)
public bool OpenExcel( Stream stream, ExcelOpenFlags openFlags, ExcelWarningList warningList, string password, bool isClearInputMapKey )
例外 | 説明 |
---|---|
System.ArgumentNullException | ストリームが指定されていないか、指定されたストリームがNullです。 |
System.ArgumentException | ストリームが指定されていないか、指定されたストリームが空です。 |
string f; f = "D:\\mptest.xls"; System.IO.FileStream s = new System.IO.FileStream(f, System.IO.FileMode.Open, System.IO.FileAccess.ReadWrite); fpSpread1.OpenExcel(s, FarPoint.Excel.ExcelOpenFlags.DataOnly, new FarPoint.Excel.ExcelWarningList(), "test", true);
Dim f As String f = "D:\mptest.xls" Dim s As New System.IO.FileStream(f, IO.FileMode.Open,IO.FileAccess.ReadWrite) FpSpread1.OpenExcel(s, FarPoint.Excel.ExcelOpenFlags.DataOnly, New FarPoint.Excel.ExcelWarningList(), "test", True)