Browse By Tags

  • Huge Data Excel Download

    Hello,

    I want to export huge data like >10lakh rows (>1crore values). I am not able to fetch this type of data through any API as there are memory constraints for any backend language that is around (10lakh values). How can I download excel values directly…

  • Want a clarification on the use case related to Excel Library

    Hi

    I want a small clarification on one of the use case related to Excel Library. (https://www.infragistics.com/products/ignite-ui-react/react/components/excel-library)

    We have added GroupDescription and SummaryDescription on the grid.  We want to know how…

  • Facing issue while align the cell value to center in Excel to export

    Hi

    I want a small clarification on one of the use case related to Excel Library. (https://www.infragistics.com/products/ignite-ui-react/react/components/excel-library-using-worksheets)

    I want to know how can I align the cell value to center

    Hoping…

  • Error Encountered While Exporting Large Data Set by using UltraGridExcelExporter. Export

    Hi All ,

    I am reaching out to address a critical issue that we are currently facing while utilizing the export method within your software library.

    Our team has been using the export functionality to export sizable data sets, and we recently encountered…

  • Facing issue in GroupedRows functionality while Exporting grid to excel

    Hi

    I want a small clarification on one of the use case related to Excel Library

    I want to know how we can Add the GroupedRows functionality for Row, Which we can expand by clicking on + icon.

    So, for this I need to know how can we achieve that.

    Hoping for…

  • How to import workbook with chart into your react component which can render data along with chart without writing any additional logic for rendering chart.


    I am trying to downloading sheet from here which contains chart and data. codesandbox.io/.../excel-with-chart-export-ksj68j


    But when upload it here.www.infragistics.com/.../spreadsheet-overview

    I can't see the chart. Only data is visible.

    Thanks…

  • Ignite UI Excel JavaScript heap out of memory exception with Angular 13

    Dear team, 

    We are trying to use igniteui-angular-excel library and installed it. We are using licenced version of Ignite UI.

    It's working fine locally but when trying to deploy it on to the servers we are getting the following exception during the build…

  • What is enhanced in Version 22.2 compared to Version 22.1 for Ignite UI for jQuery?

    Hi,

    What is enhanced in Version 22.2 compared to Version 22.1 for Ignite UI for jQuery?

    And what are the languages support for the grid content load.

    Clarify it.

  • IGX Spreadsheet Excel Utility

    Hi , am following this link  for implementing spreadsheet and trying to get the excel back from spradsheet

    https://www.infragistics.com/products/ignite-ui-angular/angular/components/excel-library  

    there is an excelutility which provides saving as excel…

  • igx angular spreadsheet not rendered fully

    I have created spreadsheet referring below link

    https://www.infragistics.com/products/ignite-ui-angular/angular/components/spreadsheet-overview

    I am able to generate spreadsheet, but it doesn't load properly.

    I have attached the screen shot below…

  • when i try to add long string for title for excel it will give a error (32 characters)

    Infragistics35.WebUI.Documents.Excel.v11.1

      workSheet = workbook.Worksheets.Add(sTitle);

    when I try to add a title for the Worksheet it will raise an error about the character limit. how can I add long titles for here 

  • Uncaught TypeError: Cannot read properties of null (reading 'contentType')

    Hello,

    I'm trying to load files into this library via ExcelUtility.load(file), where `file` is an xlsx file.

    The application crashes and the following error occurs:

    CachedLoadPackagePart.ts:39 Uncaught TypeError: Cannot read properties of null (reading…
  • Export to Excel using IgxExcelExporterService with custom datetime format

    Problem

    I'm using IgxExcelExporterService to export my columns and data to Excel. However, I'm facing issue whereby all my columns that contains the Datetime data type wasn't properly displayed in Excel unless I modified the column manually from Excel…

  • Save to an Excel format that supports dynamic arrays

    TestPlugin.zip

    In January 2020, Excel introduced a new feature called dynamic arrays and files saved in previous versions could have the implicit intersection operator (@) affixed to the beginning of their function calls.

    We have a plugin that creates…

  • Numeric format setting via Format cells dialog with comma as decimal separator

    Hi,

    We encountered a bit strange behaviour in Format cells dialog when setting the format for numeric fields, while having a comma set as decimal separator in the regional settings of Windows. It seems that  the dialog uses period as the separator, regardless…

  • Creating an XYScatterLine chart

    Howdy,

    For some reason, I can't figure out how to get an XYScatterLine chart to display data.

    I am doing this:

                        if (includeCharts)
                        {
                            WorksheetCell chartStartCell = worksheet.GetCell…

  • Read Excel file error - The left and top of the window bounds must be between -32768 and 32767

    Hi,

    I have an app that is processing excel files. To read the files I am using Infragistics4.WebUI.Documents.Excel.v12.2 library. Some times we are getting the error "The left and top of the window bounds must be between -32768 and 32767"

    By taking…

  • Do you have any suggestion to load xlsb or Excel4 file format into Infragistics Excel component ?

    Hi,

    I am getting an exception "The value of argument 'format' (-1) is invalid for Enum type 'WorkbookFormat'." from the below code

    Binary File : Workbook.Load("TestSheet.xlsb")

    Excel4 File : Workbook.Load("TestSheet…

  • Does Infragistics support loading Excel Binary files (.xlsb format)?

    I am getting an exception "The value of argument 'format' (-1) is invalid for Enum type 'WorkbookFormat'." from the following line of code.

    Workbook.Load("TestSheet.xlsb")

    DLL Name: Infragistics4.Documents.Excel.v19…

  • Formulas and inserting worksheets on UltraSpreadsheet

    Hi,

    We encountered an interesting behaviour regarding UltraSpreadsheet, formulas and inserting new worksheets. It seems that when a new worksheet is inserted in between existing ones, the formulas referring cells in the new worksheet are replaced to point…

  • WinForms Excel vertical text

    I know you can rotate text in an Excel cell, but how do you set vertical orientation?  See below.

    within MS Excel you do this using the Format Cells dialog:

  • fit to pages excel jQuery or javascript

    I want setting page setup in excel "Adjust to ... % normal size" and "fit to ... page(s) wide by ... tall"

  • Cells/Columns missing when xlsx opened

    Hello, again we have trouble with a generated xlsx file. I already contacted the manufacturer of the component used for generation. According to them the file is fine.
    When i open the attached file in excel the result is okay. But when i open it with igSpreadsheet…

  • Legend Name changes to Series whenever Series Collection is more than 3

    Why does Legend text changes to  "Series" rather than Series Name whenever I have more than 3 Legend Element

  • Syntax Structure for Adding Legend

    Is there no code/syntax example on how to Add Legend on My Excel Chart?