校园迎新信息管理系统-毕业设计.zip

tableExport.jquery.plugin ========================= <h3>Export HTML Table to</h3> <ul> <li> CSV <li> DOC <li> JSON <li> PDF <li> PNG <li> SQL <li> TSV <li> TXT <li> XLS (Excel 2000 HTML format) <li> XLSX (Excel 2007 Office Open XML format) <li> XML (Excel 2003 XML Spreadsheet format) <li> XML (Raw xml) </ul> Installation ============ To save the generated export files on client side, include in your html code: ```html <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: ```html <script type="text/javascript" src="libs/js-xlsx/xlsx.core.min.js"></script> ``` To export the table as a PDF file the following includes are required if using jsPDF and jsPDF-AutoTable as pdf producer: ```html <script type="text/javascript" src="libs/jsPDF/jspdf.min.js"></script> <script type="text/javascript" src="libs/jsPDF-AutoTable/jspdf.plugin.autotable.js"></script> ``` As an alternative pdf producer you can use pdfmake. Instead of jsPDF include then ```html <script type="text/javascript" src="libs/pdfmake/pdfmake.min.js"></script> <script type="text/javascript" src="libs/pdfmake/vfs_fonts.js"></script> <!-- For output of arabic characters include mirza_fonts.js instead of vfs_fonts.js --> <!-- For output of chinese characters include either gbsn00lp_fonts.js or ZCOOLXiaoWei_fonts.js instead of vfs_fonts.js --> ``` To export the table in PNG format, you need to include: ```html <!-- For IE support include es6-promise before html2canvas --> <script type="text/javascript" src="libs/es6-promise/es6-promise.auto.min.js"></script> <script type="text/javascript" src="libs/html2canvas/html2canvas.min.js"></script> ``` Regardless of the desired format, finally include: ```html <script type="text/javascript" src="tableExport.min.js"></script> ``` Please keep this include order. Dependencies ============ Library | Version --------|-------- [jQuery](https://github.com/jquery/jquery) | \>= 1.9.1 [es6-promise](https://github.com/stefanpenner/es6-promise) | \>= 4.2.4 [FileSaver](https://github.com/hhurz/tableExport.jquery.plugin/blob/master/libs/FileSaver/FileSaver.min.js) | \>= 1.2.0 [html2canvas](https://github.com/niklasvh/html2canvas) | \>= 0.5.0-beta4 [jsPDF](https://github.com/MrRio/jsPDF) | \>=1.3.4 [jsPDF-AutoTable](https://github.com/simonbengtsson/jsPDF-AutoTable) | 2.0.14 or 2.0.17 [pdfmake](https://github.com/bpampuch/pdfmake) | 0.1.65 [SheetJS](https://github.com/SheetJS/js-xlsx) | \>= 0.12.5 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' displayTableName: false (Deprecated) escape: false (Deprecated) 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: '' xslx: formatId: date: 14 numbers: 2 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: pageOrientation: 'portrait' defaultStyle: font: 'Roboto' fonts: {} preserve: leadingWS: false trailingWS: false preventInjection: true sql: tableEnclosure: '`' columnEnclosure: '`' tbodySelector: 'tr' tfootSelector: 'tr' theadSelector: 'tr' tableName: 'myTableName' type: 'csv' ``` ```ignoreColumn``` can be either an array of indexes (i.e. [0, 2]) or field names (i.e. ["id", "name"]). * Indexes correspond to the position of the header elements `th` in the DOM starting at 0. (If the `th` elements are removed or added to the DOM, the indexes will be shifted so use the functionality wisely!) * Field names should correspond to the values set on the "data-field" attribute of the header elements `th` in the DOM. * "Nameless" columns without data-field attribute will be named by their index number (converted to a string) To disable formatting of numbers in the exported output, which can be useful for csv and excel format, set the option ``` numbers: output ``` to ``` false ```. Set the option ``` mso.fileFormat ``` to ``` 'x