Guriddo » Topic: export to excel

export to excel

Guriddo
export to excel

This topic has 2 replies, 2 voices, and was last updated 5 years, 1 month ago by krisreddy.

Creator

Topic

August 30, 2019 at 11:24 pm #127218

krisreddy

Participant

using version 5.3

Loading dynamic grid with datatype: xml and using the following code to export to excel on click

mygrid.jqGrid('setGridParam',{loadonce:true}).trigger('reloadGrid');
setTimeout(function(){
mygrid.jqGrid('exportToExcel',{
fileName:"export.xlsx"
});
mygrid.jqGrid('setGridParam',{datatype:'xml',loadonce:false});
},500);

mygrid.jqGrid('setGridParam',{loadonce:true}).trigger('reloadGrid');

setTimeout(function(){

mygrid.jqGrid('exportToExcel',{

fileName:"export.xlsx"

});

mygrid.jqGrid('setGridParam',{datatype:'xml',loadonce:false});

},500);

Works great, but I have link in the xml data for example

<row><a href="somepage.html">View</a></row>

When exported to excel it shows as html encoded
<a href="somepage.html" >View</a>

Is there anyways to strip links/html when exporting to excel

Please advise

Kris
Guriddo Customer

This topic was modified 5 years, 1 month ago by krisreddy.
This topic was modified 5 years, 1 month ago by krisreddy.

Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies

September 1, 2019 at 10:04 pm #127221

guriddo.support

Participant

Hello,

One possible solution is to use custom formatter in case of export to excel for that field in colModel using the options isExported and exporttype like this:

colModel : [ 
...
{ name : 'field1',
    ..., 
    formatter : function( cellvalue, options, rawData) {
        if (options.isExported && options.exporttype === 'excel') {
             return stripped_cellvalue; // here strip the value 
        } else {
             return cellvalue;
        }
    },
    ...
}
...
]

colModel : [

...

{ name : 'field1',

...,

formatter : function( cellvalue, options, rawData) {

if (options.isExported && options.exporttype === 'excel') {

return stripped_cellvalue; // here strip the value

} else {

return cellvalue;

}

...

}

...

]

Kind Regards,
Will

Guriddo Support Team

September 2, 2019 at 6:44 pm #127222

krisreddy

Participant

Awesome! Thank you Will.

Another issue is when exported to excel if output in the cell is html encoded, – for example 6’s shows as 6"s –

This reply was modified 5 years, 1 month ago by krisreddy.

Author

Replies

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Registered Users: 12,249
Forums: 7
Topics: 10,947
Replies: 23,146
Topic Tags: 324
Empty Topic Tags: 9

6 Users Online

Users: 2 Guests, 4 Bots

Stay connected with us in your favorite flavor!

export to excel

Search Forum

Recent Replies

Forum Statistics

UserOnline