the environmental background of the problems and what methods you have tried
var tableInit= {
tabelData:function () {
$("-sharptablesData").bootstrapTable({
url: "/manages/order/query_list", //URL*
method: "get", //*
showFooter: true, //
// classes: "table-no-bordered", //
striped: true, //
cache: false, //true*
pagination: true, //*
sortable: false, //
sortOrder: "asc", //
sortName:"id",
// queryParams: oTableInit.queryParams,//*
sidePagination: "client", //:clientserver*
pageNumber: 1, //
pageSize: 10, //*
pageList: [10, 25, 50, 100], //*
search: false, //
strictSearch: true,
showColumns: false, //
showRefresh: false, //
clickToSelect: true, //
//height: 800, //height
uniqueId: "ID", //
showToggle: true, //
showExport: true, //
toolbar: "-sharptoolbar", //
buttonsAlign:"right",
exportTypes:["excel","xlsx","JSON","CSV","SQL"],
exportDataType: "all",//basic", "all", "selected".
showRefresh:true,
showColumns:true,
//Icons:"glyphicon-export",
//icons:{refresh: "glyphicon-repeat", toggle: "glyphicon-list-alt", columns: "glyphicon-list"},
exportOptions:{
fileName: "", //
worksheetName: "Sheet1", //
tableName: ""
//excelstyles: ["background-color", "color", "font-size", "font-weight"]
},
columns: [{
checkbox: true,
}, {
field: "id",
title: "",
visible: true,
sortable: true,
align: "center",
valign: "middle",
//width:100
}, {
field: "type",
title: "",
align: "center",
valign: "middle",
formatter: handleType
}, {
field: "platformno",
title: "",
align: "center",
valign: "middle",
formatter: handlePlatformno
}, {
field: "realname",
title: "",
align: "center",
valign: "middle",
formatter: handleUserDatas,
// width:100
}, {
field: "createTime",
title: "",
align: "center",
valign: "middle",
formatter: handleCreateTime
}, {
field: "paycode",
title: "",
align: "center",
valign: "middle",
formatter: handlePaycode
}, {
field: "payment",
title: "",
align: "center",
valign: "middle"
}, {
field: "sendtime",
title: "",
align: "center",
valign: "middle",
formatter: handleSendtime
}, {
field: "status",
title: "",
align: "center",
valign: "middle",
formatter: handleStatus
},
// {
// field : "sendtime",
// title : "",
// align: "center",
// valign: "middle"
// },
{
field: "realname",
title: "",
align: "center",
valign: "middle",
formatter: handleRealname
},
{
field: "",
title: "",
align: "center",
valign: "middle",
events:operateEvents, //
formatter: AddFunctionAlty//
}
]
})
}}
want to be able to export data