ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: ONEITSS on October 11, 2016, 04:05:04 pm

Title: local export excel
Post by: ONEITSS on October 11, 2016, 04:05:04 pm

Hi,
I am using 3.3 and local export to excel feature, Excel is getting all html used in headers and some of the columns div style, image url which we used.

is there any way we can hide html content like <BR>, <img>, <div>

Title: Re: local export excel
Post by: paramvir on October 12, 2016, 04:43:37 pm

column.title can be a callback. Hide html when ui.Export is true inside callback.

Reference:

http://paramquery.com/pro/api#option-column-title

Title: Re: local export excel
Post by: ONEITSS on October 13, 2016, 07:54:21 am

Thank you for response, given solution works for header details, how to handle data/cells.

some of cesll has images, which are rendering <img> tags in excel

Thank you

Title: Re: local export excel
Post by: ONEITSS on October 13, 2016, 02:13:45 pm

just want to update, it worked given answer for Data render function.

thank you

Title: Re: local export excel
Post by: paramvir on October 13, 2016, 04:55:25 pm

As mentioned in the docs, export of rendered cells can be controlled with column.render callback, exportRender option and exportData().

http://paramquery.com/pro/api#option-column-render

http://paramquery.com/pro/api#option-column-exportRender

http://paramquery.com/pro/api#method-exportData