export to excel from html page using dynamic data

Question

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 .

Lalit k · Answer

That i did in my HTML page

Dipika · Answer

As i can see the code where have u append the table body.. u have append only the table head

Lalit k · Answer

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

Midhun T P · Answer

Hi, Please check below blog - http://www.c-sharpcorner.com/blogs/exporting-html-table-to-excel-using-jquery

Lalit k · Answer

Mycode function buildTableDemo(d) { var cols, iii, tx, attributes, GUID; populateMeta(d, true, true); // Populate table for (ii = 0; 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 }); } } }); }

Dipika · Answer

Can you share your code

export to excel from html page using dynamic data

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)