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
I am glad to hear that! :)
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!
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.
You could try excluding the problematic column -
columnsToSkip: "ColumnName"
and maybe have a hidden version of the same column, without the formatting, that would export to Excel.
Yes it is better to keep the code as simple as possible.