export to excel button on a UI page, how do I export a html table from a UI page via export to excel button?

[manisha_maurya]

How do I export a html table from a UI page via export to excel button? I'm trying to have a function called in html of UI page, this function is being called from client script of the same UI page. Where in client script is calling the script include which is having OOTB code for "export to excel context menu". find teh script include below:

script include:

var printing = Class.create();

printing.prototype = Object.extendsObject(AbstractAjaxProcessor, {

runContextAction :   function() {

///log("query"); -------------------------------> when i check the log it is calling the script include.

@

var sysparm_rows = g_list.grandTotalRows;

var num_rows = parseInt(sysparm_rows);

var sysparm_query = g_list.getQuery({orderby: true, fixed: true});

gs.log("query=="+sysparm_query);----------------------------------> i dont find any log for this, i believe it is not able to pick up the row count from the UI Page.

var sysparm_view = g_list.view;

      if (num_rows < g_export_warn_threshold) {

              var dialog = new GwtPollDialog(g_list.tableName, sysparm_query, sysparm_rows, sysparm_view, 'unload_excel_xlsx');

              dialog.execute();

              return;

      }

      var dialog = new GwtExportScheduleDialog(g_list.tableName, sysparm_query, sysparm_rows, sysparm_view, 'unload_excel_xlsx');

      dialog.execute();  

  return dialog;

},

      type: 'printing'

});

Client script:

function xyz(){

var ga = new GlideAjax('labelprinting');

ga.addParam('sysparm_name','runContextAction');

//ga.addParam('sysparm_user_name',"Bob");

ga.getXML(runContext);

}

function runContext(response) {

    var answer = response.responseXML.documentElement.getAttribute("answer");

    alert(answer);

}

[manisha_maurya]

in client script, for the first two lines, it is printing

Client script:

function xyz(){

var ga = new GlideAjax('printing');

[Shishir Srivast]

Can you try with below code.

var list = GlideList2.(String listID or DOMElement element);

var sysparm_rows = list.grandTotalRows;

var num_rows = parseInt(sysparm_rows);

var sysparm_query = g_list.getQuery({orderby: true, fixed: true});

[Nana5]

Hi Manisha,

  Try the code which i post and create one html export button and call this function it will export the table to excel.

Thanks

[Nana5 · Accepted solution]

Hi Manisha,

  You can try below code.it should work.

//excel export

function fnExcelReport() {

var tab_text = "<table border='2px'><tr bgcolor='#87AFC6'>";

var textRange;

var j = 0;

tab = document.getElementById('tableid'); // id of table

for (j = 0; j < tab.rows.length; j++) {

tab_text = tab_text + tab.rows[j].innerHTML + "</tr>";

//tab_text=tab_text+"</tr>";

tab_text = tab_text.replace(/Remove/i, "");

}

tab_text = tab_text + "</table>";

tab_text = tab_text.replace(/<A[^>]*>|<\/A>/g, ""); //remove if u want links in your table

tab_text = tab_text.replace(/<img[^>]*>/gi, ""); // remove if u want images in your table

tab_text = tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params

//tab_text = tab_text.replace(/Remove/i, ""); // reomves theremove button label.

var ua = window.navigator.userAgent;

var msie = ua.indexOf("MSIE ");

if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer

{

txtArea1.document.open("txt/html", "replace");

txtArea1.document.write(tab_text);

txtArea1.document.close();

txtArea1.focus();

sa = txtArea1.document.execCommand("SaveAs", true, "test.xls");

} else //other browser not tested on IE 11

sa = window.open('data:application/vnd.ms-excel,' + encodeURIComponent(tab_text));

return (sa);

}

Regards,

Prakash Ranjan