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...
Now that I'm able to use the Load method to import my Excel document I found another limitation. You can extract Formula values from cells, but there is no way resolve a formula (e.g. if I have: SUM(A1:A10) in cell A11 and I work my way through the Infragistics.Excel.Worksheet object structure to extract a WorksheetCell object representing A11, the Value property is always going to display string "SUM(A1:A10)" and there is no aparent built in functionality to resolve/parse the formula to a numeric value.
So I'm a bit confused about the purpose behind the Infragistics.Excel namespace. What exactly is its usefulness and why is it advertised as in the following manner
Look Ma, No Excel Dependency
Infragistics.Excel runs completely independently of Excel, and does not require Excel to be installed alongside your application. Say "Good Bye" to the costly overhead of deploying Excel alongside your application as you might incur with a Visual Studio Tools for Office (VSTO) or Excel Automation solution.
From skimming the documentation and API reference it appears Infragistics.Excel acts as an alternative to using Microsoft Office interropt, this would be extreemly valuable to developers and would complement the WinGrid and WinChart objects very well.... However sadly, I could see some issues (from office politics standpoint) that may prevent this feature from coming to frutation
Can someone from Infragistics provide an update on this? Is it possible to resolve expressions in the current verstion of NetAdvantage for WinForms?
Hi,
The idea is that you can save create, save, and load Excel files into memory without deploying the Microsoft Excel dlls to your users. The version you are using currently does not support calculating formulas, though.
The good news is that this feature is coming soon - in the next version of NetAdvantage (2008 vol. 3), in fact. :)
That sounds great, I was planning to upgrade anyway...
It's already September, any idea when vol. 3 will be released? Would it be at all possible to obtain a beta build of vol. 3 so that I can build my application with it?
Oh, here's a blog post with some info about release dates.
http://blogs.infragistics.com/blogs/devin_rader/archive/2008/02/05/about-the-infragistics-product-release-cycles.aspx
I'm afraid I'm in the dark about release dates and beta tests. You can try contacting Developer Support and perhaps they can give you more details.