Browse By Tags

Hi there,

I'm wondering if there is a way to auto-size all grid columns when we export to Excel using the $.ig.GridExcelExporter() javascript libraries.

I can see a "defaultColumnWidth" setting, but nothing to indicate we can auto-size the column…

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…

Dear Infragistics Team,

I am currently working with the igx-grid component and am exploring options for customizing the appearance of the grid's column headers.

I have a specific requirement to align the column headers vertically. Could you please…

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…

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…

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…

Hi

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

I'm trying to Export the IgrDataGrid and using the following code for that. I'm able to Export the grid but facing issue on styling.

I have put download which can download the sheet data with chart here https://codesandbox.io/s/excel-with-chart-export-ksj68j?file=/src/index.tsx

If I download the sheet and want my chart back while uploading here https://www.infragistics.com/products/ignite…

Can not access a closed Stream.
System.ObjectDisposedException: Can not access a closed Stream.
   at System.IO.Compression.DeflateStream.EnsureNotDisposed()
   at MS.Internal.IO.Packaging.CompressStream.Flush()
   at MS.Internal.IO.Zip.ZipIOLocalFileBlock…

Hi,

Am following this link for spreadsheet

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

when we click  on particular row and apply filter it gives excel style filtering. now clicking on that filter…

Hi ,

Am following this link to create excel style filtering https://www.infragistics.com/products/ignite-ui-angular/angular/components/grid/excel-style-filtering

currently the individual rows are shown as drop  down with multi select option , can we…

HI Team,

I am new to the Excel igx-spreadsheet Library and I added the following dependencies: "file-saver", "igniteui-angular-core" and "igniteui-angular-excel" as well as the Excel utility class. As I followed this documentation…

Hi everyone,

I am using an igxGrid in my Application. I use the IgxExcelExporterService to export the data of my grid to an Excel file (.xlsx). The export works without problems and generates an Excel file on my machine.

However, if I open the file with…

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…

I'm on AG 12.3 and IG 12.3 with Excel and Charts.

Users would like to be able to download the charts in addition to the Spreadsheet report being generated in the same page of our app. If at all possible, they would like both charts (Design & Process…

Hi,

Our customer raised a problem on xamSpreadsheet control extremely slow response time on click of column filter to access filter values. I was able to create simple Excel sheet which also reproduces same problem. Obviously the problem already in Microsoft…

Hello Everyone I am a newcomer to this group. Basically, I want my site best ERP partner in Kolkata to migrate to any CMS Platform or on ASP.NET. So can anyone tell me what is the exact process to do this migration? Basically, due to Google Optimization…

I have a dotnet framework windows gui app using InfragisticsWPF4.v20.2 upgraded from V14.1, where the following code was working for V14.1, but not working any more even in compiling:

excelWorkSheetRow.Cells[i + level].CellFormat.FillPatternForegroundColor…

Hello, I am trying to use React Excel Library, and downloaded the code , so when the excel sheet is downloading , can we make only the header file a readonly (Non editable)? Name,Age,company ,Title,country Fields, can we make it as readonly text?

Hi,

I have date column on igx grid with date filter with column data as (6/30/2021, 3/16/2020....).

While exporting to excel this date column is exporting as text in excel (shows text filter in excel column).

Please advise.

We are using the Igx Spreadsheet in an angular component. If a user enters data that triggers a validation error (i.e. not a valid formula like =()), then the alert box shown below appears.  The problem that we are having is that we have code wired up…

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…