Hi,
When I do the following, it always crashed with a NotSupportedException: packageFactory cannot be null. When loading from Excel2007 workbook format and using the Infragistics2.Excel assembly, you must provide an IPackageFactory to handle the packaging of data. If you are using the DotNet Framework 3.0 or higher, use the Infragistics3.Excel assembly instead, and the packaging will be handled by the WindowsBase class.
Dim Path As String = "C:\Development\2005\WebSite1\test.xlsx"
Dim wkb As Infragistics.Excel.Workbook = Infragistics.Excel.Workbook.Load(Path)
According to the help file, it should be possible to load an excel2007 workbook this way. Using the .Net Framework 3.0 is not an option. Where can I find some info on how to implement that IPackageFactory interface?
I answered this same question here: How to use v2008.3 Excel functionality in .NET 2.0 - Infragistics Community