- 导入js包
路径:bootstrap-table/dist/extensions/export/bootstrap-table-export.min.js
依赖插件:tableExport.js
<script type="text/javascript" src="js/bootstrap-table-export.js"></script>
<script type="text/javascript" src="js/tableExport/tableExport.js"></script>
<script type="text/javascript" src="js/tableExport/libs/js-xlsx/xlsx.core.min.js"></script>
- 添加参数
function DoOnMsoNumberFormat(cell, row, col) {
var result = "";
if (row > 0 && col == 0)
result = "\\@";
return result;
}
showExport: true,
buttonsAlign:"right",
exportTypes:['excel','png','pdf'],
Icons:'glyphicon-export',
exportOptions:{
ignoreColumn: [0,"operate"],
fileName: '货物类别表',
worksheetName: 'sheet1',
tableName: '货物类别表',
excelstyles: ['background-color', 'color', 'font-size', 'font-weight'],
onMsoNumberFormat: DoOnMsoNumberFormat
}