Problem exporting date column value with igGridExcelExporter

State Not Answered
Replies 3 replies
Subscribers 13 subscribers
Views 876657 views
Users 0 members are here

igGridExcelExporter

Hubert Schmid posted over 4 years ago

Version: IgniteUi (R) 2015 Volume1 (JavaScript)

Problem description:

We try to export an igGrid with a date column to excel. Export is successful for all columns except the date column.
The column value for the date column contains the values from all rows instead of only the current row.

Also during the 'cellExporting' event of 'ig.GridExcelExporter.export...' we can see that the 'args.cellValue' contains the values of all rows

Screenshot:

igGrid:

Excel:

Any ideas what could be wrong here?

1080

Offline Martin Asenov posted over 4 years ago in reply to Hubert Schmid

Hi Hubert,

I have modified the sample for the igLoader to use local resources and test it with the version you mentioned. Still, the exported cell value for the date column contains only the row's date value.

Attached you will find my sample. Please test it on your side and let me know how it behaves. If this is not an accurate demonstration of what you are trying to achieve please feel free to modify it and send it back to me along with steps to reproduce.

70678.Sample.zip
Cancel
Reply

Cancel

Offline Hubert Schmid posted over 4 years ago in reply to Martin Asenov

Hi Martin,

thanks for your reply and sample.
The version that you are using in your sample is newer than the version we have.

Because you also don't need to use the following 'quick-fix' that is an known reported bug in this version:
www.infragistics.com/.../gridexcelexporter-uncaught-error-empty-color-cannot-be-used-to-create-a-workbookcolorinfo-instance

We already tried to replace all 'latest' tags in your sample with a specific version string without success ;-)

Your sample is using:

/*!@license Infragistics.Web.Loader 15.1.20151.2410 
* 
* Copyright (c) 2011-2016 Infragistics Inc. 
* 
* http://es.infragistics.com/ 
* 
*/

We are using:

/*!@license Infragistics.Web.Loader 15.1.20151.1005 
* 
* Copyright (c) 2011-2015 Infragistics Inc. 
* 
* http://es.infragistics.com/ 
* 
*/

This part is also not working in our version:

$.ig.loader({ 
scriptPath: "https://cdn-na.infragistics.com/igniteui/2015.1/latest/js/", 
cssPath: "https://cdn-na.infragistics.com/igniteui/2015.1/latest/css/", 
resources: "igGrid, igGridExcelExporter" 
});

We have to use the following code, because 'igGridExcelExporter' is not known:

$.ig.loader({
			scriptPath: "https://cdn-na.infragistics.com/igniteui/2015.1/latest/js/",
			cssPath: "https://cdn-na.infragistics.com/igniteui/2015.1/latest/css/",
			resources: "igGrid.*, igCombo, igEditors, modules/infragistics.util.js, modules/infragistics.documents.core.js, modules/infragistics.excel.js, modules/infragistics.gridexcelexporter.js"
		});

Can you create a sample with the exact same version that we have?

1080

Offline Martin Asenov posted over 4 years ago

Hello,

Thank you for posting in our community.

I have created and attached a sample trying to reproduce the behavior that you described using the latest 2015.1 service release. The cell value for the date column contains only the row's date value.

If this is not an accurate demonstration of what you are trying to achieve please feel free to modify it and send it back to me.

0574.Sample.zip
Cancel
Reply

Cancel