Remove edit and delete column

Question

Hello Team, Please how do I prevent the edit and delete column from showing on the excel sheet.

Tuhin Paul · Accepted Answer

You can use the exportOptions property for each column. In your case, for the "Edit" and "Delete" columns, you can set the exportOptions property to { visible: false }.
$(document).ready(function () {
dataTable = $("#ItemInfo").DataTable({
"processing": false,
"serverSide": false,
"paging": true,
"destroy": true,
"order": [[0, 'desc']],
"pageLength": 25,
buttons: [
{
extend: 'excel',
className: 'btn btn-dark rounded-0 ',
text: ' Excel',
title: 'Smart App',
exportOptions: {
columns: [0, 1, 2, 3, 4, 5, 6] // Exclude "Edit" and "Delete" columns from export
}
},
],
dom: ' lTfgitp',
"columns": [
{ "data": "PCode" },
{ "data": "OrderDate" },
{ "data": "CategoryName" },
{ "data": "ProductName" },
{ "data": "UnitPrice" },
{ "data": "Quantity" },
{ "data": "TotalAmount" },
{
"data": null, "width": "50px", "render": function (data, type, full, meta) {
return " Edit ";
},
"exportOptions": {
visible: false // Exclude "Edit" column from export
}
},
{
"data": "StockInHistoryId", "width": "50px", "render": function (data) {
return " Delete ";
},
"exportOptions": {
visible: false // Exclude "Delete" column from export
}
},
],
"ajax": {
"url": "/Home/GetAllStockInHistory",
"type": "GET",
"dataSrc": "[]",
}
});
});
In the exportOptions property for the Excel button, I specified the columns to be exported (0 to 6) and set the visible: false property for the "Edit" and "Delete" columns to exclude them from the export.

Emmmanuel FIADUFE · Answer

I export data from my DataTable into excel, it include the edit and delete column
$(document).ready(function () {
dataTable = $("#ItemInfo").DataTable({
"processing": false,
"serverSide": false,
"paging": true,
"destroy": true,
"order":[[0,'desc']],
pageLength: 25,
buttons: [
{ extend: 'excel', className: 'btn btn-dark rounded-0 ', text: ' Excel', title: 'Smart App' },
],
dom: ' lTfgitp',
"columns": [
{ "data": "PCode" },
{ "data": "OrderDate" },
{ "data": "CategoryName" },
{ "data": "ProductName" },
{ "data": "UnitPrice" },
{ "data": "Quantity" },
{ "data": "TotalAmount" },
{
"data": null, "width": "50px", "render": function (data, type, full, meta) { return " Edit "; }
},
{
"data": "StockInHistoryId", "width": "50px", "render": function (data) { return " Delete "; }
},
],
"ajax": {
"url": "/Home/GetAllStockInHistory",
"type": "GET",
"dataSrc": "[]",
}
});
});

Emmmanuel FIADUFE · Answer

Thank you team,
it is working now, my appreciation goes to you all for your continuence support

Ali Benchaaban · Answer

Hello,
Could you give us more context about your query ?
Are you looking for a solution using Excel sheets ? Or it's used within a C#  code  ?
Regards,
BENCHAABAN Ali

Sachin Singh · Answer

use this it works fine
$(document).ready(function () {
dataTable = $("#ItemInfo").DataTable({
"processing": false,
"serverSide": false,
"paging": true,
"destroy": true,
"order": [[0, 'desc']],
pageLength: 25,
buttons: [
{
extend: 'excel',
className: 'btn btn-dark rounded-0',
text: ' Excel',
title: 'Smart App',
exportOptions: {
columns: [0, 1, 2, 3, 4, 5, 6] // Specify the columns to include in the export
}
}
],
dom: ' lTfgitp',
"columns": [
{ "data": "PCode" },
{ "data": "OrderDate" },
{ "data": "CategoryName" },
{ "data": "ProductName" },
{ "data": "UnitPrice" },
{ "data": "Quantity" },
{ "data": "TotalAmount" },
],
"ajax": {
"url": "/Home/GetAllStockInHistory",
"type": "GET",
"dataSrc": "[]",
}
});
});