导出数据到excel在数据表中不起作用 [英] export data to excel not working in datatables

问题描述

 < script type =text，
导出数据和TableTools对我而言不起作用/ javascriptlanguage =javascriptsrc =../../ components / dataTables / media / js / jquery.dataTables.min.js>< / script> 
< script type =text / javascriptlanguage =javascriptsrc =../../ components / dataTables / media / js / ZeroClipboard.js>< / script> 
< script type =text / javascriptlanguage =javascriptsrc =../../ components / dataTables / media / js / TableTools.js>< / script> 
  

并在此更改表格id：

  $（'＃myTable'）。dataTable（{
sDom：'<clear> lfrtipT'
}）; 
  

我可以在桌子上看到tableTools按钮，但是没有工作

解决方案

首先使用jquery datable js 1.9（请检查下面的链接，你可以下载这个js）
，然后使用下面的代码查看datatable

  $（'＃example'）。dataTable（{
bJQueryUI：true，
sPaginationType：full_numbers，
oTableTools：{
aButtons：[
 {
'sExtends'：'csv'，
sFileName ：订阅者_+ GetTodayDate（）+。csv，
'mColumns'：[0,1] 
}，
 {
'sExtends'：'pdf' ，
sFileName：subscriber _+ GetTodayDate（）+。pdf，
'mColumns'：[0,1] 
}，
] 
 }，
sDom：'<HTlfr> tip<F>'，
aoColumns：
 [
 {bSearchable }，
 null，
 {bSortable：false，bSearchable：false}，
] 
}）; 
  

请记住导出到excel的主要代码如下：
代码

 oTableTools：{
aButtons：[
 {
'sExtends '：'csv'，
sFileName：subscribers.csv，
'mColumns'：[0,1] 
}，
 {
'sExtends '：'pdf'，
sFileName：subscribers.pdf，
'mColumns'：[0,1] 
}，
] 
} 
sDom：'<HTlfr>提示<F>'，
  

然后从该链接下载media文件夹并粘贴到datagrid显示的文件夹中

[注意：请提取并粘贴媒体文件夹在您的数据表显示在哪个页面上的准确路径中。]

export data and TableTools not working for me, after adding this line between head:

<script type="text/javascript" language="javascript" src="../../components/dataTables/media/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" language="javascript" src="../../components/dataTables/media/js/ZeroClipboard.js"></script>
<script type="text/javascript" language="javascript" src="../../components/dataTables/media/js/TableTools.js"></script>

and change table id prop in this:

$('#myTable').dataTable({
   "sDom": '<"clear">lfrtipT'
}); 

i can see tableTools buttons on the table but, thay are not working

解决方案

First use the jquery datable js 1.9 (please check the below link where you can download this js) and second use the code like below to view datatable

$('#example').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"oTableTools": {
"aButtons": [
{
'sExtends':'csv',
"sFileName": "subscribers_"+GetTodayDate()+".csv",
'mColumns':[0,1]
},
{
'sExtends':'pdf',
"sFileName": "subscribers_"+GetTodayDate()+".pdf",
'mColumns':[0,1] 
},
]
},
"sDom": '<"H"Tlfr>tip<"F">',
"aoColumns":
[
{ "bSearchable": false },
null,
{ "bSortable": false, "bSearchable": false },
]
});

please remember main code for export to excel is as below which is added in the above code

"oTableTools": {
"aButtons": [
{
'sExtends':'csv',
"sFileName": "subscribers.csv",
'mColumns':[0,1]
},
{
'sExtends':'pdf',
"sFileName": "subscribers.pdf",
'mColumns':[0,1] 
},
]
},
"sDom": '<"H"Tlfr>tip<"F">',

and then download the "media" folder from this link and paste into the folder where you datagrid show

[NOTE : please extract and paste the "media" folder in the accurate path on which page your datatable is display .]

这篇关于导出数据到excel在数据表中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！