'Declaration Public Overloads Function OpenExcel( _ ByVal fileName As String, _ 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 fileName As String 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(fileName, spreadSheetIndex, excelSheetIndex, excelOpenFlags, warningList, password)
public bool OpenExcel( string fileName, int spreadSheetIndex, int excelSheetIndex, ExcelOpenFlags excelOpenFlags, ExcelWarningList warningList, string password )
Parameters
- fileName
- Path and name of the file to open
- spreadSheetIndex
- Index of the sheet in the Spread component into which to load the Excel sheet
- excelSheetIndex
- Index of the Excel sheet to load
- excelOpenFlags
- Which parts of the spreadsheet to load
- warningList
- List of warning messages that occur during this operation
- password
- The password