Browse By Tags

I am using Infragistics WebExcelExporter.Export(webdatagrid, worksheet) to export large datatable having 70000+ rows and 25 columns. The export fails due to timeouts. Is there any other way to export with Infragistics WebExcelExporter.

Works without any…

I am exporting the filtered data of webdatagrid. It is working fine for string columns but for datetime columns suppose if filtering on this month the ui is showing correct filtered data but while exporting to excel it is showing current month data suppose…

Is there a way to get the webdatagrid to export to excel using the Text propery of the webdatagrid and not the Value property?  When you export to excel, if you did any translation in the InitializeRow event, this translation is lost in the export to Excel…

Hi All!

Well, i have a problem, with the export with the Hierarchical DataGrid, well, the export is OK,  but i have hidden  columns,  in my Asp PAge, don't display (this is good), but when i export the Grid, the exported file show me the columns that i…

I use the infragistics WebDataGrid to show a number of elements in an ASP.NET application. Now I use the WebExcelExporter class to create a excel file for the all paged rows. In the WebExcelExporter I can use the DataExportMode Property to set the number…

Hi together,

once I export my data from the web data grid I get the following error:

System.NotSupportedException: 'Newtonsoft.Json.Linq.JValue is not a supported cell value type.'

I bind my data to the grid in the following way:

wgWorf…

An exception of type 'System.InvalidOperationException' occurred in Infragistics4.WebUI.Documents.Excel.v11.1.dll but was not handled in user code

Additional information: Merged cell regions can't overlap.

here is my code:

sheet.MergedCellsRegions…

When I export a WebDataGrid that contains only a couple of thousand records, the export works fine.  The export works for most lists.  However, this particular set of data that I am trying to export has 6000 records, and results in an error traced to somewhere…

hi,

I recently donwloaded version 15.1 and replacing all obsolete controls.I have WebExplorerBar and inside I haVE USER CONTROL.

how can I access this user id and any other asp controls:

<ig:WebExplorerBar ID="WebExplorerBar1" runat="server" CssClass…

Hi

        I am exporting the WebDataGrid to the excel using WebExcelExporter. It is exporting nicely.

In the Excel sheet surpose in one column value has 1 and 0 but I want to replace 1 as "Yes" and 0 as "No" while opening the excel sheet.…

Using the Page_Load event page to load data in the grid
in the local machine when I apply the sort in any of the column of the grid the data changes and can export exactly looks in the grid
but when I public this project in our server and I apply the s…

Hi Infragistics Team,

see the below code ( This metadata code) this code how to implemented ?

//

// Summary:

// Exports a single flat grid to the specified worksheet. Exporting starts

// from the defined row and column offsets.

public vi…

I am exporting a grid using the WebExcelExporter and the GroupFields do not seem to be exporting correctly.

See image below.

Hi Infragistics Team,

Now currently using infragistics 2015 v1,  we are using the name space " infragistics.web.ui.Gridcontrol",  now using webexcelexporter contrl . it's throw the Error .

see the below error .

The base class includes…

Private Sub grdExporter_Exported(sender As Object, e As ExcelExportedEventArgs) Handles grdExporter.Exported

e.Worksheet.Columns(0).SetWidth(140, Infragistics.Documents.Excel.WorksheetColumnWidthUnit.Pixel)

e.Worksheet.Columns(1).SetWidth…

Hi,

On WebExporerBar clicked action, i am exporting the grid data into the Excel,

but On exporting the data i am getting the ThreadAbortException,

while my data is exported into the file.

after this if i clicked on any other ExplorerBar action it…

Hi,

Would like to ask for an alternative way on how to handle auto-resize of row height when Webdatagrid is exported into excel file using webexcelexporter.

Webdatagrid is populated via code behind and several columns were hidden and are set with different…

Hi,

I would like to export grid which is having more than 2 lakhs records data into Excel. 

when i tried to export the grid data, after some time i am getting the below exception as response.

An exception of type 'System.OutOfMemoryException' occurred…

We are using WebExcelExporter for exporting WHDG grid data. But the exported data in excel is not well formatted. The columns are overlapping each other when parent nodes are expanded. What is solution for this?

Is there any way to have flat export of…

When exporting using an existing Excel file all formatting is preserved (column width, row heights, cell formatting, etc…) The only thing that isn’t being preserved is the conditional formatting.

 When EnableStylesExport is turned on (True…

We export data from WebDataGrid using WebExcelExporter. In the grid, we right align all the columns which have numeric data (by updating the grid CSS). However, when we export this data to excel, the horizontal alignment setting is not exported.

Please…

hi ,

This is srinivas. I have used infragistics excel in my application.But i am getting an exception of  "Out of Memory Exception" while exporting data into excel about 58000 records.I tried alot but i couldn't find any solution.

Can you…

I am using WebExcelExporter to export the grid data to Excel.

The grid has format set for each column.

When i try to export the grid data to excel, the numeric columns are exported and shown as text in  Excel sheet. Also there is one note in the cell…

Hi all!

I am using 12,1 and have a strange behaviour behaviour:

In the grid i set the font-Color (green or red - depending on the datavalues) with CSS, working fine.

BUT:

In the Excelfile I see only 1 Color.

Even if I try to set only 1 Color the…

I there,

Is it possible to only export the parent columns so i dont get the expand (+) in the Excel file?