客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
开源软件名称：hhurz/tableExport.jquery.plugin开源软件地址：https://github.com/hhurz/tableExport.jquery.plugin开源编程语言：HTML 88.6%开源软件介绍：tableExport.jquery.pluginExport HTML Table to
InstallationTo save the generated export files on client side, include in your html code: <script type="text/javascript" src="libs/FileSaver/FileSaver.min.js"></script>To export the table in XLSX (Excel 2007+ XML Format) format, you need to include additionally SheetJS/js-xlsx: <script type="text/javascript" src="libs/js-xlsx/xlsx.core.min.js"></script>In case you still want to support IE11, you need to include jsPDF's polyfills.umd.js. Please do this before you include jspdf.umd.min.js and html2canvas.min.js <script type="text/javascript" src="../libs/jsPDF/polyfills.umd.js"></script>To export an html table to a PDF file, you can use jsPDF as a PDF producer: <script type="text/javascript" src="libs/jsPDF/jspdf.umd.min.js"></script>Many HTML stylings can be converted to PDF with jsPDF, but support for non-western character sets is almost non-existent. Especially if you want to export Arabic or Chinese characters to your PDF file, you can use pdfmake as an alternative PDF producer. The disadvantage compared to jspdf is that using pdfmake has a reduced styling capability. To use pdfmake enable the pdfmake option and instead of the jsPDF files include <script type="text/javascript" src="libs/pdfmake/pdfmake.min.js"></script>
<script type="text/javascript" src="libs/pdfmake/vfs_fonts.js"></script>
<!-- To export arabic characters include mirza_fonts.js _instead_ of vfs_fonts.js
<script type="text/javascript" src="libs/pdfmake/mirza_fonts.js"></script>
-->
<!-- For a chinese font include either gbsn00lp_fonts.js or ZCOOLXiaoWei_fonts.js _instead_ of vfs_fonts.js
<script type="text/javascript" src="libs/pdfmake/gbsn00lp_fonts.js"></script>
-->To export the table in PNG format, you need to include: <script type="text/javascript" src="libs/html2canvas/html2canvas.min.js"></script>Regardless of the desired format, finally include: <script type="text/javascript" src="tableExport.min.js"></script>Please keep this include order. Dependencies
Examples// CSV format
$('#tableID').tableExport({type:'csv'});// Excel 2000 html format
$('#tableID').tableExport({type:'excel'});// XML Spreadsheet 2003 file format with multiple worksheet support
$('table').tableExport({type:'excel',
mso: {fileFormat:'xmlss',
worksheetName: ['Table 1','Table 2', 'Table 3']}});// PDF export using jsPDF only
$('#tableID').tableExport({type:'pdf',
jspdf: {orientation: 'p',
margins: {left:20, top:10},
autotable: false}
});// PDF format using jsPDF and jsPDF Autotable
$('#tableID').tableExport({type:'pdf',
jspdf: {orientation: 'l',
format: 'a3',
margins: {left:10, right:10, top:20, bottom:20},
autotable: {styles: {fillColor: 'inherit',
textColor: 'inherit'},
tableWidth: 'auto'}
}
});// PDF format with callback example
function DoCellData(cell, row, col, data) {}
function DoBeforeAutotable(table, headers, rows, AutotableSettings) {}
$('table').tableExport({fileName: sFileName,
type: 'pdf',
jspdf: {format: 'bestfit',
margins: {left:20, right:10, top:20, bottom:20},
autotable: {styles: {overflow: 'linebreak'},
tableWidth: 'wrap',
tableExport: {onBeforeAutotable: DoBeforeAutotable,
onCellData: DoCellData}}}
});// PDF export using pdfmake
$('#tableID').tableExport({type:'pdf',
pdfmake:{enabled:true,
docDefinition:{pageOrientation:'landscape'}}
});Options (Default settings)csvEnclosure: '"'
csvSeparator: ','
csvUseBOM: true
date: html: 'dd/mm/yyyy'
exportHiddenCells: false
fileName: 'tableExport'
htmlContent: false
htmlHyperlink: 'content'
ignoreColumn: []
ignoreRow: []
jsonScope: 'all'
jspdf: orientation: 'p'
unit:'pt'
format: 'a4'
margins: left: 20
right: 10
top: 10
bottom: 10
onDocCreated: null
autotable: styles: cellPadding: 2
rowHeight: 12
fontSize: 8
fillColor: 255
textColor: 50
fontStyle: 'normal'
overflow: 'ellipsize'
halign: 'inherit'
valign: 'middle'
headerStyles: fillColor: [52, 73, 94]
textColor: 255
fontStyle: 'bold'
halign: 'inherit'
valign: 'middle'
alternateRowStyles: fillColor: 245
tableExport: doc: null
onAfterAutotable: null
onBeforeAutotable: null
onAutotableText: null
onTable: null
outputImages: true
mso: fileFormat: 'xlshtml'
onMsoNumberFormat: null
pageFormat: 'a4'
pageOrientation: 'portrait'
rtl: false
styles: []
worksheetName: ''
xlsx: formatId: date: 14
numbers: 2
currency: 164
format: currency: '$#,##0.00;[Red]-$#,##0.00'
onHyperlink: null
numbers: html: decimalMark: '.'
thousandsSeparator: ','
output: decimalMark: '.'
thousandsSeparator: ','
onAfterSaveToFile: null
onBeforeSaveToFile: null
onCellData: null
onCellHtmlData: null
onCellHtmlHyperlink: null
onIgnoreRow: null
onTableExportBegin: null
onTableExportEnd: null
outputMode: 'file'
pdfmake: enabled: false
docDefinition: pageSize: 'A4'
pageOrientation: 'portrait'
styles: header: background: '#34495E'
color: '#FFFFFF'
bold: true
alignment: 'center'
fillColor: '#34495E'
alternateRow: fillColor: '#f5f5f5'
defaultStyle: color: '#000000'
fontSize: 8
font: 'Roboto'
fonts: {}
preserve: leadingWS: false
trailingWS: false
preventInjection: true
sql: tableEnclosure: '`'
columnEnclosure: '`'
tbodySelector: 'tr'
tfootSelector: 'tr'
theadSelector: 'tr'
tableName: 'myTableName'
type: 'csv'Notes on options that apply to all formatsThe option
To disable formatting of numbers in the exported output, which can be useful for csv and excel format, set the option There is an option There are a couple of format-independent and format-specific callback functions that can be used to control the output result during export. All callback functions have a name starting with Notes for Excel formatsSet the option Excel 2000 html format is the default excel file format which has better support of exporting table styles. The To export in XSLX format SheetJS/js-xlsx is used. Please note that with this format the amount of exportable styling information of the HTML table is limited compared to other formats. When exporting in Excel 2000 html format (xlshtml), the default extension of the output file is XLS, although the type of the file content is HTML. When you open a file in Microsoft Office Excel 2007 or later that contains content that does not match the extensionof the file, you receive the following warning message:
PDF format related optionsFor jsPDF options see the documentation of jsPDF. To generate tables with jsPDF this plugin uses a specific modified version (2.0.17) of jsPDF-AutoTable. Due to compatibility reasons the source code of this version has been integrated and was adapted. There is an extended setting for the jsPDF option Also there is an extended setting for the jsPDF-AutoTable options When exporting to pdf the option Optional html data attributes(can be applied while generating the table that you want to export) data-tableexport-cellformat<td data-tableexport-cellformat="">...</td> -> An empty data value preserves format of cell content. E.g. no number seperator conversion
More cell formats to be come...data-tableexport-colspan<td colspan="2" data-tableexport-colspan="3">...</td> -> Overwrites the colspan attribute of the table cell during export.
This attribute can be used if there follow hidden cells, that will be exported by using the "data-tableexport-display" attribute.data-tableexport-display<table style="display:none;" data-tableexport-display="always">...</table> -> A hidden table will be exported
<td style="display:none;" data-tableexport-display="always">...</td> -> A hidden cell will be exported
<td data-tableexport-display="none">...</td> -> This cell will not be exported
<tr data-tableexport-display="none">...</tr> -> All cells of this row will not be exporteddata-tableexport-msonumberformat<td data-tableexport-msonumberformat="\@">...</td> -> Data value will be used to style excel cells with mso-number-format (Excel 2000 html format only)
Format Description
===================================================================================
"\@" Excel treats cell content always as text, even numbers
"0" Excel will display no decimals for numbers
"0\.000" Excel displays numbers with 3 decimals
"0%" Excel will display a number as percent with no decimals
"Percent" Excel will display a number as percent with 2 decimals
"\#\,\#\#0\.000" Comma with 3 decimals
"mm\/dd\/yy" Date7
"mmmm\ d\,\ yyyy" Date9
"m\/d\/yy\ h\:mm\ AM\/PM" D -T AMPM
"Short Date" 01/03/1998
"Medium Date" 01-mar-98
"d\-mmm\-yyyy" 01-mar-1998
"Short Time" 5:16
"Medium Time" 5:16 am
"Long Time" 5:16:21:00
"0\.E+00" Scientific Notation
"\#\ ???\/???" Fractions - up to 3 digits
"\0022£\0022\#\,\#\#0\.00" £12.76
"\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ " 2 decimals, negative red numbersdata-tableexport-rowspan<td rowspan="2" data-tableexport-rowspan="3">...</td> -> Overwrites the rowspan attribute of the table cell during export.
This attribute can be used if there follow hidden rows, that will be exported by using the "data-tableexport-display" attribute.data-tableexport-value<th data-tableexport-value="export title">title</th> -> "export title" instead of "title" will be exported
<td data-tableexport-value="export content">content</td> -> "export content" instead of "content" will be exporteddata-tableexport-xlsxformatid<td data-tableexport-xlsxformatid="14">...</td> -> The data value represents a format id that will be used to format the content of a cell in Excel. This data attribute overwrites the default setting of defaults.mso.xslx.formatId.
This attribute is for Excel 2007 Office Open XML format only.
Format id Description
===============================================================
"1" 0
"2" 0.00
"3" #,##0
"4" #,##0.00
"9" 0%
"10" 0.00%
"11" 0.00E+00
"12" # ?/?
"13" # ??/??
"14" m/d/yy (will be localized by Excel)
"15" d-mmm-yy
"16" d-mmm
"17" mmm-yy
"18" h:mm AM/PM
"19" h:mm:ss AM/PM
"20" h:mm
"21" h:mm:ss
"22" m/d/yy h:mm
"37" #,##0 ;(#,##0)
"38" #,##0 ;[Red](#,##0)
"39" #,##0.00;(#,##0.00)
"40" #,##0.00;[Red](#,##0.00)
"45" mm:ss
"46" [h]:mm:ss
"47" mmss.0
"48" ##0.0E+0
"49" @
"56" 上午/下午 hh時mm分ss秒
{mso.xlsx.formatid.currency} {mso.xlsx.format.currency}SupportThe IDE used in the development of this project is supported by
2023-10-27 2022-08-15 2022-08-17 2022-09-23 2022-08-13 六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期 今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知 今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道 今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要 我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多 今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不 电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很 我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法 今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win 今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎 |
请发表评论