Environment:
Infragistics2.Excel.v9.2
Infragistics2.Documents.v9.2
Visual Studio 2008 - VB
Windows 7 and Windows XP
Issue:
An existing application is using MODI and AxMiDocView to access Office files and
Outlook. These objects need to be replaced to work on Windows 7 and must work
with multiple versions of Office. The files will also need to be uploaded to a database.
I’ve found Infragistics examples on creating Word/Excel document(s) but haven’t found any examples for reading existing files from the file system or a database. Are we able to to use Infragistics to open existing files and Outlook emails within the application? If so, where are the examples/samples, please?
I don't have much experience with Infragistics so any help would be greatly appreciated. Thanks!
This article explains how to load an existing Excel file: http://help.infragistics.com/NetAdvantage/WinForms/2011.1/CLR2.0/?page=ExcelEngine_Read_an_Excel_File_Into_a_Workbook.html
However, the article targets version 11.1, where a namespace change had occurred, so you will see namespaces such as Infragistics.Documents.Excel, but this is Infragistics.Excel in version 9.2.
We currently do not offer any way to open Outlook files.
Let me know if I can offer any more help.
Thanks for the link which seems fairly simple.
The users want to be able to view the Excel file within the Winform applicaion. Is there an Infragistics control that I should use to display the opened Excel file to the user or am I only able to open the file non-visually? Some users will be able to modify the file and others will only be able to read the file.
Thanks for your help!
Currently, we do not have a control specifically for viewing/editing Excel files. They can only be opened non-visually. You can try to use the WinGrid to display/edit the contents of a worksheet. However, there may not be an equivalent to some things you would find in Excel. In addition, a worksheet is cell based whereas the WinGrid is column based, so it might only work if all cells in a certain column of the worksheet have the same data type.