Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Jeremy
185
Workbook.Load not available
posted

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
.MaxExcelColorCount
etc...


Parents
No Data
Reply
  • 185
    posted

    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?

      

     

     

     

     

Children