I have a project that requires creating a form using your Excel object, but I'm running into several problems!
First, where can I find some VB.Net examples that describe how to display the workbook?
Second, will the Excel object work with your WinGrid? If so, how do you display the data?
Any help would be greatly appreciated.
Thanks,
PR
Hi PR,
proyAshley said:First, where can I find some VB.Net examples that describe how to display the workbook?
A workbook has no display features.
proyAshley said:Second, will the Excel object work with your WinGrid? If so, how do you display the data?
No, the UltraWinGrid will not display Excel data. You can export a grid to a workbook, but not the other way around.
If you want to display an actual Excel sheet inside your application, you would need to use the Microsoft Office interop classes for that. The Infragistics Excel assembly can write or read Excel files, but there's no user interface.
Do you have any good examples using your Excel object with the MS Office Interop classes?
If so, where do I find them?
No, I don't know of any examples of this. As far as I know, there is no interaction between the two. Except that you could save an excel WorkBook to a file using the Infragistics assemblies and load the same file into the Interop classes. Other that that, they are completely unrelated.