Browse By Tags

  • Cannot load a particular worksheet / 指定したシートのみをロードできません。

    Hello everyone,

    I have a big excel files (with somes worksheets)

    I only want to load a particular worksheet. 

    Do you have any idea?

    Thank you.

    -------------------------------------------------------------------

    複数シートを含む巨大Excelファイルをロードする時は、

    どうやって指定したシートのみをロードする方法がありませんか…

  • Error Importing file with User Defined functions.

    I just upgraded to NetAdvantage 11.2. In my application, I am trying to import a workbook with user defined functions. When I call the function WorkBook.Load(fileName), It crashes with an ArgumentNullException. The formula string cannot be null. Parameter…

  • Workbook.Load takes around 5 min for reading a 2007 Excel file with 500 rows

    Hi,

    1 of our user file  had bunch of pivot tables (in multiple worksheets) in this workbook and some standard dataset in worksheets and formula referring to other worksheets. I tried to import this excel file using

    Workbook wbExceldata = Workbook.Load…

  • Workbook.Load and scalability

    Hi all, I'm fairly new to Infragistics.Excel, so maybe I'm missing something.

    I am wanting to load in the first 25 rows of an Excel spreadsheet in order to gain a hueristic understanding of the rest of the data, and display something meaningful…

  • object reference exception on loading a workbook with a Picture in of the sheet

    Hi,

     When we have picture in some worksheet and am trying to load the workbook using Workbook.Load(fileName) and it fails with obj reference exception and i figure out that it doesn't like pictures in a worksheet. am assuming this is a bug.. I really appreciate…

  • Workbook.Load loose CellFormat

    Hello dear Infragistics-Team,

     

    I have a Problem by loading an MS-Excel-Workbook from a Stream. My Stream is a dump-file of an Excel-document which I want to fill with my data:

     Workbook retval = Workbook.Load(p_Source);

    The dump-file have some CellFormats…

  • An item with the same key has already been added

    I'm using Infragistics.Excel.v8.2 (8.2.20082.1000).  I am attempting to open an excel file using the " Workbook.Load" method.  However, as soon as I open the file, I receive an exception

    "An item with the same key has already been added"…

  • How to load excel with dynamic column collection

    Hi,

    I am looking to read an excel file into the workbook.

    the issue is that the columns in my excel sheet are not certain or pre-defined.

    They may vary and I don't want to put any column schema restriction as such.

    In the samples you have a…

  • WorkBook Load Issue - Need help

    Hi,

    I worked in the "Importing from Excel" functionality, it is working fine with following code provided we need to set the Properties of the excel file to "Build Actions = Embedded Resource".

     string   resourceName = "ExcelWebGrid…