igGrid Export to Excel Error | Infragistics Forums

igGrid Export to Excel Error

Erik Freund posted over 5 years ago

Hello,

I'm trying to export an igGrid to Excel. I'm getting an error of "[object Object] is not a supported cell value type". I've tried to use some of the callbacks from the igGrid to debug the issue but it seems that this error is ocurring after all the rows have been processed.

I read one post on here that the GridExcelExporter.exportGrid function uses the templated igGrid cell to export - I think that may be my problem. I'm using a template that takes the data value and wraps it in a div then sets the background color depending on the value. Is there a way to turn this feature off and have the exporter only take the raw data values from the igGrid instead of the templated value?

Thanks,

Erik

Top Replies

70

Offline John Brady posted over 5 years ago in reply to Rumesh Rathod +1
You could try excluding the problematic column - columnsToSkip: "ColumnName" and maybe have a hidden version of the same column, without the formatting...view reply »
20255

Offline Zdravko Kolev posted over 5 years ago in reply to Erik Freund +1
Hello Erik, I am unable to reproduce the issue , could you please share a small sample that is reproducing it, or update this one . Also, you may...view reply »
70

Offline Erik Freund posted over 5 years ago in reply to Zdravko Kolev +1 verified
Thanks Zdravko, with your code I was able to figure it out. I was giving the exporter an extra empty object as an input, since I saw a lot of other examples...view reply »

Parents

25665

Offline Michael Peterson posted over 5 years ago

Hello Erik,

Thank you for contacting Infragistics!

How are you currently trying to export the igGrid?
Do you have an isolated sample you can attach to demonstrate the issue?
Cancel
Reply

Cancel
70

Offline Erik Freund posted over 5 years ago in reply to Michael Peterson

I'm just using it as simply as I can,

$('#exportToExcelButton').click(() => {

        $.ig.GridExcelExporter.exportGrid($("#igGrid"),

            {

                fileName: 'export',

                gridFeatureOptions: {

                    filtering: 'applied',

                    hiding: 'applied',

                    sorting: 'applied'

                }

            },

{ });

    });

The grid isn't complex either, but like I said I'm using fairly complex templates that output html elements like:
<div class="rounded px-1" style="background-color:@status?.Color;">
${Status}
</div>
Cancel
Reply

Cancel
20255

Offline Zdravko Kolev posted over 5 years ago in reply to Erik Freund

Hello Erik,

I am unable to reproduce the issue, could you please share a small sample that is reproducing it, or update this one.

Also, you may consider the suggestion from John, and use columnsToSkip option.
Cancel
Reply

Cancel

Reply

70

Verified Answer
Offline Erik Freund posted over 5 years ago in reply to Zdravko Kolev

Thanks Zdravko, with your code I was able to figure it out. I was giving the exporter an extra empty object as an input, since I saw a lot of other examples with that. I removed that, updated my page to have the filesaver and blob scripts and it worked! Thanks!
Cancel
Reply

Reject Answer

Cancel

Children

20255

Offline Zdravko Kolev posted over 5 years ago in reply to Erik Freund

I am glad to hear that! :)
Cancel
Reply

Cancel