Author Topic: local export excel  (Read 3025 times)

ONEITSS

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 27
    • View Profile
local export excel
« 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>

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: local export excel
« Reply #1 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

ONEITSS

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 27
    • View Profile
Re: local export excel
« Reply #2 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

ONEITSS

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 27
    • View Profile
Re: local export excel
« Reply #3 on: October 13, 2016, 02:13:45 pm »
just want to update, it worked given answer for Data render function.

thank you

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: local export excel
« Reply #4 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