export to excel from html page using dynamic data

Lalit k

i had populated the html page using dynamic data

i want the functionality export tables from html page to excel file my tables not showing when i click view source for that page so how can i achieve this .

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Lalit k9y ago
That i did in my HTML page
0
John9y ago
As i can see the code where have u append the table body.. u have append only the table head
0
Lalit k9y ago
U had not read my question properly my page not showing the table data when we view source of the html page so for that what we can do
0
Midhun Tp9y ago
Hi,

Please check below blog -

http://www.c-sharpcorner.com/blogs/exporting-html-table-to-excel-using-jquery
0
Lalit k9y ago
Mycode

function buildTableDemo(d) {
var cols, iii, tx, attributes, GUID;
populateMeta(d, true, true);
// Populate table
for (ii = 0; ii < d.data[0].length; ii++) {
cols = '', attributes = '', iii = 0;
GUID = d.data[0][ii];
GUID2 = d.data[1][ii];
$.each(d.data, function (k, i) {
//alert(labels[k] + ' - ' + i[ii]);
});
}

}
function populateMeta(d, writeHead, popLists) {
$.each(d.columns, function (k, i) {
if (writeHead) $('thead>tr').append('' + i.label + '');
editable.push(i.editable);
labels.push(i.label.replace(/[\s\/]/g, '-'));
display.push(i.display);
entityType.push(i.entityType);
fieldname.push(i.field);
fieldType.push(i.fieldType);
fieldOptions.push(i.options);
// Populate drop-lists
if (popLists) {
var id = getFilterId(i.label);
if ($(id).length > 0) {
var list = $(id)[0];
var unq = Array.from(new Set(d.data[k])).sort();
$.each(unq, function (kk, t) {
if (!!t) list.options[list.options.length] = new Option(t, t);
});
$(id).multiselect({ includeSelectAllOption: true, nonSelectedText: i.label });
}
}
});
}
0
John9y ago
Can you share your code
0