<script src="https://cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js"></script>
<table id="table2" border="1">
<thead>
<th>Sr</th>
<th>Name</th>
<th>Location</th>
<th>Job Profile</th>
</thead>
<tbody>
<tr>
<td>1</td>
<td><p>Amit Sarna</p></td>
<td>Florida</td>
<td>Data Scientist</td>
</tr>
</tbody>
</table>
<button onclick="ExportToExcel()">Export table to excel</button>
</html>
<script>
function ExportToExcel() {
$("#table2").table2excel({
filename: "file.xls",
exclude_inputs:true,
ignoreColumn: ['A1']
});
}
</script>
I want to set readonly column values in excel file.but i cannot set read only properties. please help me to solve this