I have a web application with an HTML table that displays data to users.
I wanted to export the table to Excel and found a jQuery code for it.
However, the exported data includes information that is hidden in the table.
Is there a way to export the table without including the
<td style="display:none;"> @Html.DisplayFor(modelItem => item.Id) </td>Below is the table structure:
<table id="tblParts" class="table table-striped">
<thead>
<tr>
<th> Part Number </th>
<th> Description </th>
<th> Model </th>
<th> Order Qty </th>
<th></th>
</tr>
</thead>
<tbody> @foreach (var item in Model.OrderBy(i => i.PartNumber)) { <tr>
<td style="display:none;"> @Html.DisplayFor(modelItem => item.Id) </td>
<td> @Html.DisplayFor(modelItem => item.PartNumber) </td>
<td> @Html.DisplayFor(modelItem => item.Description) </td>
<td> @Html.DisplayFor(modelItem => item.Model) </td>
<td> @Html.DisplayFor(modelItem => item.OrderQty) </td>
</tr> } </tbody>
</table>
Here is the Jquery function:
function ExportToExcel(type, fn, dl) {
var elt = document.getElementById('tblParts');
var wb = XLSX.utils.table_to_book(elt, {
sheet: "sheet1"
});
return dl ?
XLSX.write(wb, {
bookType: type,
bookSST: true,
type: 'base64'
}) :
XLSX.writeFile(wb, fn || ('Order.' + (type || 'xlsx')));
}