Imports Infragistics.Documents.Excel
...
' Load workbook with data
Dim workbook1 As Workbook = Workbook.Load("filename.xls")
In addition to creating Microsoft® Excel® files, the Infragistics Excel Engine can also read them. You can create a Workbook object from an existing Excel file, make some changes, and save a new file containing the modified workbook. When you read an Excel file using the Workbook object’s static Load method, a Workbook object is created and its object model is populated with all the features supported by the Infragistics Excel Engine. Cell values and formats, as well as workbook and worksheet options are all accessible and modifiable from the parsed workbook.
The following example code demonstrates how to load an existing workbook.
In Visual Basic:
Imports Infragistics.Documents.Excel
...
' Load workbook with data
Dim workbook1 As Workbook = Workbook.Load("filename.xls")In C#:
using Infragistics.Documents.Excel;
...
// Load workbook with data
Workbook workbook1 = Workbook.Load("filename.xls");