Dim workbook As Infragistics.Documents.Excel.Workbook = _
Infragistics.Documents.Excel.Workbook.Load("C:\ExistingWorkbook.xls")
workbook.Worksheets.Item(0).Rows.Item(0).Cells.Item(0).Value = 19
workbook.Save("C:\ModifiedWorkbook.xls")
In addition to writing out Microsoft® Excel® files, the Infragistics.Documents.Excel assembly 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 an Excel file is read with the static Load method, a Workbook object is created and its entire object model is populated with all supported information from the file. Cell values, formats, and images, as well as workbook and worksheet options are all accessible and modifiable from the parsed Workbook.
The following code demonstrates how to read in an existing workbook, make a change, and write the workbook to a new file:
In Visual Basic:
Dim workbook As Infragistics.Documents.Excel.Workbook = _
Infragistics.Documents.Excel.Workbook.Load("C:\ExistingWorkbook.xls")
workbook.Worksheets.Item(0).Rows.Item(0).Cells.Item(0).Value = 19
workbook.Save("C:\ModifiedWorkbook.xls")
In C#:
Infragistics.Documents.Excel.Workbook workbook = Infragistics.Documents.Excel.Workbook.Load( "C:\\ExistingWorkbook.xls" ); workbook.Worksheets[0].Rows[0].Cells[0].Value = 19; workbook.Save( "C:\\ModifiedWorkbook.xls" );