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 · 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.

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": "[]", } }); });

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