I have a reference set to Infragistics2.Excel.v6.3
using System;using System.Collections.Generic;using System.Text;using Infragistics.Excel;namespace myNamespace{ class ExcelAdapter { Infragistics.Excel.Workbook workbook = null; public ExcelAdapter() { workbook = Infragistics.Excel.Workbook.Load("C:\\ExistingWorkbook.xls"); // this line fails to compile }
...
I don't have a static Load method avaialable from the Workbook object. Any ideas as to why this might be? The VS.NET 2005 intellissnse for Infragisitcs.Excel.Workbook object is as follows:
.Equals.MaxExcelCellFormatCount.MaxExcelColorCountetc...
I believe I have answered this question several times. There is no way to use the Infragistics assemblies to load a workbook in that version. You have to upgrade to the latest version or use the Microsoft Interop assemblies for Excel.
In my current version of Infragistics 7.1 how can i open any existing Excel workbook. There is any other way to open it without using Workbook.Load() ?
Okay, so... what is your question? You can open up an existing Excel file using NetAdvantage, but you will need to update to the latest version to do so, as this functionality was not added until v8.3.
Hi Mike,
I want to export win grid into Excel by using Infragistic Export to excel. Here I want to open an existing Excel Workbook from the system and then i want to create worksheet in it by using Infragistic Excel and then export the ultra grid into that worksheet. (Here i don't want to create a new Workbook at runtime.)
Hi,
As I stated above, this feature was added to NetAdvantage 2008 Vol. 3. It does not exist in the version you are using, so if you need to load Excel workbooks into your code, you will need to upgrade. Or, you could use the Excel Interop assemblies from Microsoft.