首先这是个鸡肋的方法 合理的做法是 后端直接生成 前端给个链接就行了
（先说原因与过程最后上代码）
1. 先说说为什么会出现这个需求吧。
： 在写运维网站时 自己粗略的看了一下bootstarp-table 就是 基于bootstarp的一个table框架 发现其扩展插件有个导出的功能 Excel 于是乎，就和老板夸下海口 说什么分页的 导出的就在前端做吧 于是。。。呵呵，起初在测试服时由于数据量小 导出就没有多大问题，但是当数据量大（大于300条）的情况下 发现 网页直接就卡死了现象 ，一下就蒙圈了 ，然后自己就看源码
2,在说说我的分析过程
加快速度：
整理插件 第一发现 在导出Excel 的时候 每个table 的cell 的进行的遍历 过滤操作， 发现延时比较长 同时他也将 每个tr 的样式 弄了下拉导致数据过大于是 直接获取 修改，成 innerHtml 速度直线上升 （将非必要数据删除）， 拼接的html 全部转换未 StringBuffer 解决 var 对象不够长度的问题导出长度问题 ： 首先我们必须了解 JavaScript Blob 对象
一个
Blob对象就是一个包含有只读原始数据的类文件对象。Blob对象中的数据并不一定得是JavaScript中的原生形式。File接口基于Blob，继承了Blob的功能,并且扩展支持了用户计算机上的本地文件。具体信息去百度一下 了解 用JavaScript读取和保存文件
3代码
/*
tableExport.jquery.plugin
Copyright (c) 2015 hhurz, https://github.com/hhurz/tableExport.jquery.plugin
Original work Copyright (c) 2014 Giri Raj, https://github.com/kayalshri/
Licensed under the MIT License, http://opensource.org/licenses/mit-license
*/
(function ($) {
$.fn.extend({
tableExport: function (options) {
var defaults = {
consoleLog: false,
csvEnclosure: '"',
csvSeparator: ',',
csvUseBOM: true,
displayTableName: false,
escape: false,
excelstyles: ['border-bottom', 'border-top', 'border-left', 'border-right'],
fileName: 'tableExport',
htmlContent: false,
ignoreColumn: [],
ignoreRow:[],
jspdf: {orientation: 'p',
unit: 'pt',
format: 'a4', // jspdf page format or 'bestfit' for autmatic paper format selection
margins: {left: 20, right: 10, top: 10, bottom: 10},
autotable: {styles: {cellPadding: 2,
rowHeight: 12,
fontSize: 8,
fillColor: 255, // color value or 'inherit' to use css background-color from html table
textColor: 50, // color value or 'inherit' to use css color from html table
fontStyle: 'normal', // normal, bold, italic, bolditalic or 'inherit' to use css font-weight and fonst-style from html table
overflow: 'ellipsize', // visible, hidden, ellipsize or linebreak
halign: 'left', // left, center, right
valign: 'middle' // top, middle, bottom
},
headerStyles: {fillColor: [52, 73, 94],
textColor: 255,
fontStyle: 'bold',
halign: 'center'
},
alternateRowStyles: {fillColor: 245
},
tableExport: {onAfterAutotable: null,
onBeforeAutotable: null,
onTable: null
}
}
},
numbers: {html: {decimalMark: '.',
thousandsSeparator: ','
},
output: {decimalMark: '.',
thousandsSeparator: ','
}
},
onCellData: null,
onCellHtmlData: null,
outputMode: 'file', // 'file', 'string' or 'base64'
tbodySelector: 'tr',
theadSelector: 'tr',
tableName: 'myTableName',
type: 'csv', // 'csv', 'txt', 'sql', 'json', 'xml', 'excel', 'doc', 'png' or 'pdf'
worksheetName: 'xlsWorksheetName'
};
var FONT_ROW_RATIO = 1.15;
var el = this;
var DownloadEvt = null;
var $hrows = [];
var $rows = [];
var rowIndex = 0;
var rowspans = [];
var trData = '';
function StringBuffer() {
this.content = new Array;
}
StringBuffer.prototype.append = function(str) {
this.content.push(str);
}
StringBuffer.prototype.prepend = function(str) {
this.content.unshift(str);
}
StringBuffer.prototype.toString = function() {
return this.content.join("");
}
$.extend(true, defaults, options);
if (defaults.type == 'csv' || defaults.type == 'txt') {
var csvData = new StringBuffer();
var rowlength = 0;
rowIndex = 0;
function CollectCsvData (tgroup, tselector, rowselector, length) {
$rows = $(el).find(tgroup).first().find(tselector);
$rows.each(function () {
csvData.append(this.innerHTML);
rowIndex++;
});
return $rows.length;
}
rowlength += CollectCsvData ('thead', defaults.theadSelector, 'th,td', rowlength);
rowlength += CollectCsvData ('tbody', defaults.tbodySelector, 'td', rowlength);
CollectCsvData ('tfoot', defaults.tbodySelector, 'td', rowlength);
csvData.append("\n");
//output
if (defaults.consoleLog === true)
console.log(csvData);
if (defaults.outputMode === 'string')
return csvData;
if (defaults.outputMode === 'base64')
return base64encode(csvData);
try {
var blob = new Blob(csvData.content.slice(0,1200), {type: "text/" + (defaults.type == 'csv' ? 'csv' : 'plain') + ";charset=utf-8"});
saveAs(blob, defaults.fileName + '.' + defaults.type, (defaults.type != 'csv' || defaults.csvUseBOM === false));
}
catch (e) {
downloadFile(defaults.fileName + '.' + defaults.type,
'data:text/' + (defaults.type == 'csv' ? 'csv' : 'plain') + ';charset=utf-8,' + ((defaults.type == 'csv' && defaults.csvUseBOM)? '\ufeff' : ''),
csvData.toString());
}
} else if (defaults.type == 'sql') {
// Header
rowIndex = 0;
var tdData = "INSERT INTO `" + defaults.tableName + "` (";
$hrows = $(el).find('thead').first().find(defaults.theadSelector);
$hrows.each(function () {
ForEachVisibleCell(this, 'th,td', rowIndex, $hrows.length,
function (cell, row, col) {
tdData += "'" + parseString(cell, row, col) + "',";
});
rowIndex++;
tdData = $.trim(tdData);
tdData = $.trim(tdData).substring(0, tdData.length - 1);
});
tdData += ") VALUES ";
// Row vs Column
$rows = $(el).find('tbody').first().find(defaults.tbodySelector);
$rows.each(function () {
trData = "";
ForEachVisibleCell(this, 'td', rowIndex, $hrows.length + $rows.length,
function (cell, row, col) {
trData += "'" + parseString(cell, row, col) + "',";
});
if (trData.length > 3) {
tdData += "(" + trData;
tdData = $.trim(tdData).substring(0, tdData.length - 1);
tdData += "),";
}
rowIndex++;
});
tdData = $.trim(tdData).substring(0, tdData.length - 1);
tdData += ";";
//output
if (defaults.consoleLog === true)
console.log(tdData);
if (defaults.outputMode === 'string')
return tdData;
if (defaults.outputMode === 'base64')
return base64encode(tdData);
try {
var blob = new Blob([tdData], {type: "text/plain;charset=utf-8"});
saveAs(blob, defaults.fileName + '.sql');
}
catch (e) {
downloadFile(defaults.fileName + '.sql',
'data:application/sql;charset=utf-8,',
tdData);
}
} else if (defaults.type == 'json') {
var jsonHeaderArray = [];
$hrows = $(el).find('thead').first().find(defaults.theadSelector);
$hrows.each(function () {
var jsonArrayTd = [];
ForEachVisibleCell(this, 'th,td', rowIndex, $hrows.length,
function (cell, row, col) {
jsonArrayTd.push(parseString(cell, row, col));
});
jsonHeaderArray.push(jsonArrayTd);
});
var jsonArray = [];
$rows = $(el).find('tbody').first().find(defaults.tbodySelector);
$rows.each(function () {
var jsonArrayTd = [];
ForEachVisibleCell(this, 'td', rowIndex, $hrows.length + $rows.length,
function (cell, row, col) {
jsonArrayTd.push(parseString(cell, row, col));
});
if (jsonArrayTd.length > 0 && (jsonArrayTd.length != 1 || jsonArrayTd[0] != ""))
jsonArray.push(jsonArrayTd);
rowIndex++;
});
var jsonExportArray = [];
jsonExportArray.push({header: jsonHeaderArray, data: jsonArray});
var sdata = JSON.stringify(jsonExportArray);
if (defaults.consoleLog === true)
console.log(sdata);
if (defaults.outputMode === 'string')
return sdata;
if (defaults.outputMode === 'base64')
return base64encode(sdata);
try {
var blob = new Blob([sdata], {type: "application/json;charset=utf-8"});
saveAs(blob, defaults.fileName + '.json');
}
catch (e) {
downloadFile(defaults.fileName + '.json',
'data:application/json;charset=utf-8;base64,',
sdata);
}
} else if (defaults.type === 'xml') {
rowIndex = 0;
var xml = '<?xml version="1.0" encoding="utf-8"?>';
xml += '<tabledata><fields>';
// Header
$hrows = $(el).find('thead').first().find(defaults.theadSelector);
$hrows.each(function () {
ForEachVisibleCell(this, 'th,td', rowIndex, $rows.length,
function (cell, row, col) {
xml += "<field>" + parseString(cell, row, col) + "</field>";
});
rowIndex++;
});
xml += '</fields><data>';
// Row Vs Column
var rowCount = 1;
$rows = $(el).find('tbody').first().find(defaults.tbodySelector);
$rows.each(function () {
var colCount = 1;
trData = "";
ForEachVisibleCell(this, 'td', rowIndex, $hrows.length + $rows.length,
function (cell, row, col) {
trData += "<column-" + colCount + ">" + parseString(cell, row, col) + "</column-" + colCount + ">";
colCount++;
});
if (trData.length > 0 && trData != "<column-1></column-1>") {
xml += '<row id="' + rowCount + '">' + trData + '</row>';
rowCount++;
}
rowIndex++;
});
xml += '</data></tabledata>';
//output
if (defaults.consoleLog === true)
console.log(xml);
if (defaults.outputMode === 'string')
return xml;
if (defaults.outputMode === 'base64')
return base64encode(xml);
try {
var blob = new Blob([xml], {type: "application/xml;charset=utf-8"});
saveAs(blob, defaults.fileName + '.xml');
}
catch (e) {
downloadFile(defaults.fileName + '.xml',
'data:application/xml;charset=utf-8;base64,',
xml);
}
} else if (defaults.type == 'excel' || defaults.type == 'xls' || defaults.type == 'word' || defaults.type == 'doc') {
var MSDocType = (defaults.type == 'excel' || defaults.type == 'xls') ? 'excel' : 'word';
var MSDocExt = (MSDocType == 'excel') ? 'xls' : 'doc';
var MSDocSchema = (MSDocExt == 'xls') ? 'xmlns:x="urn:schemas-microsoft-com:office:excel"' : 'xmlns:w="urn:schemas-microsoft-com:office:word"';
rowIndex = 0;
var docData = new StringBuffer();
docData.append('<table><thead>');
// Header
$hrows = $(el).find('thead').first().find(defaults.theadSelector);
var statrD = (new Date()).getTime();
console.log(statrD);
$hrows.each(function () {
docData.append('<tr>' + this.innerHTML + '</tr>');
});
docData.append('</thead><tbody>');
// Row Vs Column
$rows = $(el).find('tbody').first().find(defaults.tbodySelector);
$rows.each(function () {
docData.append('<tr>' + this.innerHTML + '</tr>');
});
console.log("====第二循环：===="+((new Date()).getTime()-statrD));
if (defaults.displayTableName)
docData.append( '<tr><td></td></tr><tr><td></td></tr><tr><td>' + parseString($('<p>' + defaults.tableName + '</p>')) + '</td></tr>');
docData.append('</tbody></table>');
var docFile = new StringBuffer();
docFile.append('<html xmlns:o="urn:schemas-microsoft-com:office:office" ' + MSDocSchema + ' xmlns="http://www.w3.org/TR/REC-html40">');
docFile.append('<meta http-equiv="content-type" content="application/vnd.ms-' + MSDocType + '; charset=UTF-8">');
docFile.append("<head>");
if (MSDocType === 'excel') {
docFile.append("<!--[if gte mso 9]>" );
docFile.append("<xml>" );
docFile.append("<x:ExcelWorkbook>" );
docFile.append("<x:ExcelWorksheets>" );
docFile.append("<x:ExcelWorksheet>" );
docFile.append("<x:Name>" );
docFile.append(defaults.worksheetName);
docFile.append("</x:Name>" );
docFile.append("<x:WorksheetOptions>" );
docFile.append("<x:DisplayGridlines/>" );
docFile.append("</x:WorksheetOptions>" );
docFile.append("</x:ExcelWorksheet>" );
docFile.append("</x:ExcelWorksheets>" );
docFile.append("</x:ExcelWorkbook>" );
docFile.append("</xml>" );
docFile.append("<![endif]-->" );
}
docFile.append( "</head>");
docFile.append( "<body>");
for(var i =0; i<docData.content.length ; i++){
docFile.append(docData.content[i].toString());
}
//docFile.append( docData.toString());
docFile.append( "</body>");
docFile.append( "</html>");
if (defaults.consoleLog === true)
/*console.log(docFile.toString());*/
if (defaults.outputMode === 'string')
return docFile.toString();
if (defaults.outputMode === 'base64')
return base64encode(docFile.toString());
try {
var blob = new Blob(docFile.content,{type: 'application/vnd.ms-' + defaults.type});
console.log("blob.size==="+blob.size);
saveAs(blob, defaults.fileName + '.' + MSDocExt+"x");
}
catch (e) {
downloadFile(defaults.fileName + '.xlsx' ,
'data:application/vnd.ms-' + MSDocType + ';base64,',
docFile.toString());
}
} else if (defaults.type == 'png') {
html2canvas($(el)[0], {
allowTaint: true,
background: '#fff',
onrendered: function (canvas) {
var image = canvas.toDataURL();
image = image.substring(22); // remove data stuff
var byteString = atob(image);
var buffer = new ArrayBuffer(byteString.length);
var intArray = new Uint8Array(buffer);
for (var i = 0; i < byteString.length; i++)
intArray[i] = byteString.charCodeAt(i);
if (defaults.consoleLog === true)
console.log(byteString);
if (defaults.outputMode === 'string')
return byteString;
if (defaults.outputMode === 'base64')
return base64encode(image);
try {
var blob = new Blob([buffer], {type: "image/png"});
saveAs(blob, defaults.fileName + '.png');
}
catch (e) {
downloadFile(defaults.fileName + '.png',
'data:image/png;base64,',
image);
}
}
});
} else if (defaults.type == 'pdf') {
if (defaults.jspdf.autotable === false) {
var addHtmlOptions = {
dim: {
w: getPropertyUnitValue($(el).first().get(0), 'width', 'mm'),
h: getPropertyUnitValue($(el).first().get(0), 'height', 'mm')
},
pagesplit: false
};
var doc = new jsPDF(defaults.jspdf.orientation, defaults.jspdf.unit, defaults.jspdf.format);
doc.addHTML($(el).first(),
defaults.jspdf.margins.left,
defaults.jspdf.margins.top,
addHtmlOptions,
function () {
jsPdfOutput(doc);
});
//delete doc;
}
else {
// pdf output using jsPDF AutoTable plugin
// https://github.com/simonbengtsson/jsPDF-AutoTable
var teOptions = defaults.jspdf.autotable.tableExport;
// When setting jspdf.format to 'bestfit' tableExport tries to choose
// the minimum required paper format and orientation in which the table
// (or tables in multitable mode) completely fits without column adjustment
if (typeof defaults.jspdf.format === 'string' && defaults.jspdf.format.toLowerCase() === 'bestfit') {
var pageFormats = {
'a0': [2383.94, 3370.39], 'a1': [1683.78, 2383.94],
'a2': [1190.55, 1683.78], 'a3': [841.89, 1190.55],
'a4': [595.28, 841.89]
};
var rk = '', ro = '';
var mw = 0;
$(el).filter(':visible').each(function () {
if ($(this).css('display') != 'none') {
var w = getPropertyUnitValue($(this).get(0), 'width', 'pt');
if (w > mw) {
if (w > pageFormats['a0'][0]) {
rk = 'a0';
ro = 'l';
}
for (var key in pageFormats) {
if (pageFormats.hasOwnProperty(key)) {
if (pageFormats[key][1] > w) {
rk = key;
ro = 'l';
if (pageFormats[key][0] > w)
ro = 'p';
}
}
}
mw = w;
}
}
});
defaults.jspdf.format = (rk == '' ? 'a4' : rk);
defaults.jspdf.orientation = (ro == '' ? 'w' : ro);
}
// The jsPDF doc object is stored in defaults.jspdf.autotable.tableExport,
// thus it can be accessed from any callback function
teOptions.doc = new jsPDF(defaults.jspdf.orientation,
defaults.jspdf.unit,
defaults.jspdf.format);
$(el).filter(function() {
return $(this).data("tableexport-display") != 'none' &&
($(this).is(':visible') ||
$(this).data("tableexport-display") == 'always');
}).each(function () {
var colKey;
var rowIndex = 0;
teOptions.columns = [];
teOptions.rows = [];
teOptions.rowoptions = {};
// onTable: optional callback function for every matching table that can be used
// to modify the tableExport options or to skip the output of a particular table
// if the table selector targets multiple tables
if (typeof teOptions.onTable === 'function')
if (teOptions.onTable($(this), defaults) === false)
return true; // continue to next iteration step (table)
// each table works with an own copy of AutoTable options
defaults.jspdf.autotable.tableExport = null; // avoid deep recursion error
var atOptions = $.extend(true, {}, defaults.jspdf.autotable);
defaults.jspdf.autotable.tableExport = teOptions;
atOptions.margin = {};
$.extend(true, atOptions.margin, defaults.jspdf.margins);
atOptions.tableExport = teOptions;
// Fix jsPDF Autotable's row height calculation
if (typeof atOptions.beforePageContent !== 'function') {
atOptions.beforePageContent = function (data) {
if (data.pageCount == 1) {
var all = data.table.rows.concat(data.table.headerRow);
all.forEach(function (row) {
if ( row.height > 0 ) {
row.height += (2 - FONT_ROW_RATIO) / 2 * row.styles.fontSize;
data.table.height += (2 - FONT_ROW_RATIO) / 2 * row.styles.fontSize;
}
});
}
}
}
if (typeof atOptions.createdHeaderCell !== 'function') {
// apply some original css styles to pdf header cells
atOptions.createdHeaderCell = function (cell, data) {
if (typeof teOptions.columns [data.column.dataKey] != 'undefined') {
var col = teOptions.columns [data.column.dataKey];
cell.styles.halign = col.style.align;
if (atOptions.styles.fillColor === 'inherit')
cell.styles.fillColor = col.style.bcolor;
if (atOptions.styles.textColor === 'inherit')
cell.styles.textColor = col.style.color;
if (atOptions.styles.fontStyle === 'inherit')
cell.styles.fontStyle = col.style.fstyle;
}
}
}
if (typeof atOptions.createdCell !== 'function') {
// apply some original css styles to pdf table cells
atOptions.createdCell = function (cell, data) {
var rowopt = teOptions.rowoptions [data.row.index + ":" + data.column.dataKey];
if ( typeof rowopt != 'undefined' && typeof rowopt.style != 'undefined' ) {
cell.styles.halign = rowopt.style.align;
if (atOptions.styles.fillColor === 'inherit')
cell.styles.fillColor = rowopt.style.bcolor;
if (atOptions.styles.textColor === 'inherit')
cell.styles.textColor = rowopt.style.color;
if (atOptions.styles.fontStyle === 'inherit')
cell.styles.fontStyle = rowopt.style.fstyle;
}
}
}
if (typeof atOptions.drawHeaderCell !== 'function') {
atOptions.drawHeaderCell = function (cell, data) {
var colopt = teOptions.columns [data.column.dataKey];
if (colopt.style.hasOwnProperty("hidden") != true || colopt.style.hidden !== true)
return prepareAutoTableText (cell, data, colopt);
else
return false; // cell is hidden
}
}
if (typeof atOptions.drawCell !== 'function') {
atOptions.drawCell = function (cell, data) {
var rowopt = teOptions.rowoptions [data.row.index + ":" + data.column.dataKey];
return prepareAutoTableText (cell, data, rowopt);
}
}
// collect header and data rows
$hrows = $(this).find('thead').find(defaults.theadSelector);
$hrows.each(function () {
colKey = 0;
ForEachVisibleCell(this, 'th,td', rowIndex, $hrows.length,
function (cell, row, col) {
var obj = getCellStyles (cell);
obj.title = parseString(cell, row, col);
obj.key = colKey++;
teOptions.columns.push(obj);
});
rowIndex++;
});
var rowCount = 0;
$rows = $(this).find('tbody').find(defaults.tbodySelector);
$rows.each(function () {
var rowData = [];
colKey = 0;
ForEachVisibleCell(this, 'td', rowIndex, $hrows.length + $rows.length,
function (cell, row, col) {
if (typeof teOptions.columns[colKey] === 'undefined') {
// jsPDF-Autotable needs columns. Thus define hidden ones for tables without thead
var obj = {
title: '',
key: colKey,
style: {
hidden: true
}
};
teOptions.columns.push(obj);
}
if (cell !== null) {
teOptions.rowoptions [rowCount + ":" + colKey++] = getCellStyles (cell);
}
else {
var obj = $.extend(true, {}, teOptions.rowoptions [rowCount + ":" + (colKey-1)]);
obj.colspan = -1;
teOptions.rowoptions [rowCount + ":" + colKey++] = obj;
}
rowData.push(parseString(cell, row, col));
});
if (rowData.length) {
teOptions.rows.push(rowData);
rowCount++
}
rowIndex++;
});
// onBeforeAutotable: optional callback function before calling
// jsPDF AutoTable that can be used to modify the AutoTable options
if (typeof teOptions.onBeforeAutotable === 'function')
teOptions.onBeforeAutotable($(this), teOptions.columns, teOptions.rows, atOptions);
teOptions.doc.autoTable(teOptions.columns, teOptions.rows, atOptions);
// onAfterAutotable: optional callback function after returning
// from jsPDF AutoTable that can be used to modify the AutoTable options
if (typeof teOptions.onAfterAutotable === 'function')
teOptions.onAfterAutotable($(this), atOptions);
// set the start position for the next table (in case there is one)
defaults.jspdf.autotable.startY = teOptions.doc.autoTableEndPosY() + atOptions.margin.top;
});
jsPdfOutput(teOptions.doc);
teOptions.columns.length = 0;
teOptions.rows.length = 0;
delete teOptions.doc;
teOptions.doc = null;
}
}
function ForEachVisibleCell(tableRow, selector, rowIndex, rowCount, cellcallback) {
/*console.log(JSON.stringify(tableRow.innerHTML));*/
if ($.inArray(rowIndex, defaults.ignoreRow) == -1 &&
$.inArray(rowIndex-rowCount, defaults.ignoreRow) == -1) {
var $row = $(tableRow).filter(function() {
return $(this).data("tableexport-display") != 'none' &&
($(this).is(':visible') ||
$(this).data("tableexport-display") == 'always' ||
$(this).closest('table').data("tableexport-display") == 'always');
}).find(selector);
var rowColspan = 0;
$row.each(function (colIndex) {
if ($(this).data("tableexport-display") == 'always' ||
($(this).css('display') != 'none' &&
$(this).css('visibility') != 'hidden' &&
$(this).data("tableexport-display") != 'none')) {
if ($.inArray(colIndex, defaults.ignoreColumn) == -1 &&
$.inArray(colIndex-$row.length, defaults.ignoreColumn) == -1) {
if (typeof (cellcallback) === "function") {
var c, Colspan = 0;
var r, Rowspan = 0;
// handle rowspans from previous rows
if (typeof rowspans[rowIndex] != 'undefined' && rowspans[rowIndex].length > 0) {
for (c = 0; c <= colIndex; c++) {
if (typeof rowspans[rowIndex][c] != 'undefined') {
cellcallback(null, rowIndex, c);
delete rowspans[rowIndex][c];
colIndex++;
}
}
}
if ($(this).is("[colspan]")) {
Colspan = parseInt($(this).attr('colspan'));
rowColspan += Colspan > 0 ? Colspan - 1 : 0;
}
if ($(this).is("[rowspan]"))
Rowspan = parseInt($(this).attr('rowspan'));
// output content of current cell
cellcallback(this, rowIndex, colIndex);
// handle colspan of current cell
for (c = 0; c < Colspan - 1; c++)
cellcallback(null, rowIndex, colIndex + c);
// store rowspan for following rows
if (Rowspan) {
for (r = 1; r < Rowspan; r++) {
if (typeof rowspans[rowIndex + r] == 'undefined')
rowspans[rowIndex + r] = [];
rowspans[rowIndex + r][colIndex + rowColspan] = "";
for (c = 1; c < Colspan; c++)
rowspans[rowIndex + r][colIndex + rowColspan - c] = "";
}
}
}
}
}
});
}
}
function jsPdfOutput(doc) {
if (defaults.consoleLog === true)
console.log(doc.output());
if (defaults.outputMode === 'string')
return doc.output();
if (defaults.outputMode === 'base64')
return base64encode(doc.output());
try {
var blob = doc.output('blob');
saveAs(blob, defaults.fileName + '.pdf');
}
catch (e) {
downloadFile(defaults.fileName + '.pdf',
'data:application/pdf;base64,',
doc.output());
}
}
function prepareAutoTableText (cell, data, cellopt) {
var cs = 0;
if ( typeof cellopt != 'undefined' )
cs = cellopt.colspan;
if ( cs >= 0 ) {
// colspan handling
var cellWidth = cell.width;
var textPosX = cell.textPos.x;
var i = data.table.columns.indexOf(data.column);
for (var c = 1; c < cs; c++) {
var column = data.table.columns[i+c];
cellWidth += column.width;
}
if ( cs > 1 ) {
if ( cell.styles.halign === 'right' )
textPosX = cell.textPos.x + cellWidth - cell.width;
else if ( cell.styles.halign === 'center' )
textPosX = cell.textPos.x + (cellWidth - cell.width) / 2;
}
cell.width = cellWidth;
cell.textPos.x = textPosX;
if ( typeof cellopt != 'undefined' && cellopt.rowspan > 1 )
{
if ( cell.styles.valign === 'middle' )
cell.textPos.y = cell.textPos.y + (cell.height * (cellopt.rowspan - 1)) / 2;
else if ( cell.styles.valign === 'bottom' )
cell.textPos.y += (cellopt.rowspan - 1) * cell.height;
cell.height = cell.height * cellopt.rowspan;
}
// fix jsPDF's calculation of text position
if ( cell.styles.valign === 'middle' || cell.styles.valign === 'bottom' ) {
var splittedText = typeof cell.text === 'string' ? cell.text.split(/\r\n|\r|\n/g) : cell.text;
var lineCount = splittedText.length || 1;
if (lineCount > 2)
cell.textPos.y -= ((2 - FONT_ROW_RATIO) / 2 * data.row.styles.fontSize) * (lineCount-2) / 3 ;
}
return true;
}
else
return false; // cell is hidden (colspan = -1), don't draw it
}
function escapeRegExp(string) {
return string.replace(/([.*+?^=!:${}()|\[\]\/\\])/g, "\\$1");
}
function replaceAll(string, find, replace) {
return string.replace(new RegExp(escapeRegExp(find), 'g'), replace);
}
// Takes a string and encapsulates it (by default in double-quotes) if it
// contains the csv field separator, spaces, or linebreaks.
function csvString(cell, rowIndex, colIndex) {
var result = '';
if (cell != null) {
var dataString = parseString(cell, rowIndex, colIndex);
var csvValue = (dataString === null || dataString == '') ? '' : dataString.toString();
if (dataString instanceof Date)
result = defaults.csvEnclosure + dataString.toLocaleString() + defaults.csvEnclosure;
else {
result = replaceAll(csvValue, defaults.csvEnclosure, defaults.csvEnclosure + defaults.csvEnclosure);
if (result.indexOf(defaults.csvSeparator) >= 0 || /[\r\n ]/g.test(result))
result = defaults.csvEnclosure + result + defaults.csvEnclosure;
}
}
return result;
}
function parseNumber(value) {
value = value || "0";
value = replaceAll(value, defaults.numbers.html.decimalMark, '.');
value = replaceAll(value, defaults.numbers.html.thousandsSeparator, '');
return typeof value === "number" || jQuery.isNumeric(value) !== false ? value : false;
}
function parseString(cell, rowIndex, colIndex) {
var result = '';
if (cell != null) {
var $cell = $(cell);
var htmlData = $cell.html();
if (typeof defaults.onCellHtmlData === 'function')
htmlData = defaults.onCellHtmlData($cell, rowIndex, colIndex, htmlData);
if (defaults.htmlContent === true) {
result = $.trim(htmlData);
}
else {
var text = htmlData.replace(/\n/g,'\u2028').replace(/<br\s*[\/]?>/gi, '\u2060');
var obj = $('<div/>').html(text).contents();
text = '';
$.each(obj.text().split("\u2028"), function(i, v) {
if (i > 0)
text += " ";
text += $.trim(v);
});
$.each(text.split("\u2060"), function(i, v) {
if (i > 0)
result += "\n";
result += $.trim(v).replace(/\u00AD/g, ""); // remove soft hyphens
});
if (defaults.numbers.html.decimalMark != defaults.numbers.output.decimalMark ||
defaults.numbers.html.thousandsSeparator != defaults.numbers.output.thousandsSeparator) {
var number = parseNumber (result);
if ( number !== false ) {
var frac = ("" + number).split('.');
if ( frac.length == 1 )
frac[1] = "";
var mod = frac[0].length > 3 ? frac[0].length % 3 : 0;
result = (number < 0 ? "-" : "") +
(defaults.numbers.output.thousandsSeparator ? ((mod ? frac[0].substr(0, mod) + defaults.numbers.output.thousandsSeparator : "") + frac[0].substr(mod).replace(/(\d{3})(?=\d)/g, "$1" + defaults.numbers.output.thousandsSeparator)) : frac[0]) +
(frac[1].length ? defaults.numbers.output.decimalMark + frac[1] : "");
}
}
}
if (defaults.escape === true) {
result = escape(result);
}
if (typeof defaults.onCellData === 'function') {
result = defaults.onCellData($cell, rowIndex, colIndex, result);
}
}
return result;
}
function hyphenate(a, b, c) {
return b + "-" + c.toLowerCase();
}
function rgb2array(rgb_string, default_result) {
var re = /^rgb\((\d{1,3}),\s*(\d{1,3}),\s*(\d{1,3})\)$/;
var bits = re.exec(rgb_string);
var result = default_result;
if (bits)
result = [ parseInt(bits[1]), parseInt(bits[2]), parseInt(bits[3]) ];
return result;
}
function getCellStyles (cell) {
var a = getStyle(cell, 'text-align');
var fw = getStyle(cell, 'font-weight');
var fs = getStyle(cell, 'font-style');
var f = '';
if (a == 'start')
a = getStyle(cell, 'direction') == 'rtl' ? 'right' : 'left';
if (fw >= 700)
f = 'bold';
if (fs == 'italic')
f += fs;
if (f == '')
f = 'normal';
return {
style: {
align: a,
bcolor: rgb2array(getStyle(cell, 'background-color'), [255, 255, 255]),
color: rgb2array(getStyle(cell, 'color'), [0, 0, 0]),
fstyle: f
},
colspan: (parseInt($(cell).attr('colspan')) || 0),
rowspan: (parseInt($(cell).attr('rowspan')) || 0)
};
}
// get computed style property
function getStyle(target, prop) {
try {
if (window.getComputedStyle) { // gecko and webkit
prop = prop.replace(/([a-z])([A-Z])/, hyphenate); // requires hyphenated, not camel
return window.getComputedStyle(target, null).getPropertyValue(prop);
}
if (target.currentStyle) { // ie
return target.currentStyle[prop];
}
return target.style[prop];
}
catch (e) {
}
return "";
}
function getPropertyUnitValue(target, prop, unit) {
var baseline = 100; // any number serves
var value = getStyle(target, prop); // get the computed style value
var numeric = value.match(/\d+/); // get the numeric component
if (numeric !== null) {
numeric = numeric[0]; // get the string
var temp = document.createElement("div"); // create temporary element
temp.style.overflow = "hidden"; // in case baseline is set too low
temp.style.visibility = "hidden"; // no need to show it
target.parentElement.appendChild(temp); // insert it into the parent for em, ex and %
temp.style.width = baseline + unit;
var factor = baseline / temp.offsetWidth;
target.parentElement.removeChild(temp); // clean up
return (numeric * factor);
}
return 0;
}
function downloadFile(filename, header, data) {
var ua = window.navigator.userAgent;
if (ua.indexOf("MSIE ") > 0 || !!ua.match(/Trident.*rv\:11\./)) {
// Internet Explorer (<= 9) workaround by Darryl (https://github.com/dawiong/tableExport.jquery.plugin)
// based on sampopes answer on http://*.com/questions/22317951
// ! Not working for json and pdf format !
var frame = document.createElement("iframe");
if (frame) {
document.body.appendChild(frame);
frame.setAttribute("style", "display:none");
frame.contentDocument.open("txt/html", "replace");
frame.contentDocument.write(data);
frame.contentDocument.close();
frame.focus();
frame.contentDocument.execCommand("SaveAs", true, filename);
document.body.removeChild(frame);
}
}
else {
var DownloadLink = document.createElement('a');
if (DownloadLink) {
DownloadLink.style.display = 'none';
DownloadLink.download = filename;
console.log((header + base64encode(data)).length);
if (header.toLowerCase().indexOf("base64,") >= 0)
DownloadLink.href = header + base64encode(data);
else
DownloadLink.href = encodeURIComponent(header + data);
document.body.appendChild(DownloadLink);
if (document.createEvent) {
if (DownloadEvt == null)
DownloadEvt = document.createEvent('MouseEvents');
DownloadEvt.initEvent('click', true, false);
DownloadLink.dispatchEvent(DownloadEvt);
}
else if (document.createEventObject)
DownloadLink.fireEvent('onclick');
else if (typeof DownloadLink.onclick == 'function')
DownloadLink.onclick();
/*document.body.removeChild(DownloadLink);*/
}
}
}
function utf8Encode(string) {
string = string.replace(/\x0d\x0a/g, "\x0a");
var utftext = "";
for (var n = 0; n < string.length; n++) {
var c = string.charCodeAt(n);
if (c < 128) {
utftext += String.fromCharCode(c);
}
else if ((c > 127) && (c < 2048)) {
utftext += String.fromCharCode((c >> 6) | 192);
utftext += String.fromCharCode((c & 63) | 128);
}
else {
utftext += String.fromCharCode((c >> 12) | 224);
utftext += String.fromCharCode(((c >> 6) & 63) | 128);
utftext += String.fromCharCode((c & 63) | 128);
}
}
return utftext;
}
function saveAs(blob, filename) {
var type = blob.type;
var force_saveable_type = 'application/octet-stream';
if (type && type != force_saveable_type) { // 强制下载，而非在浏览器中打开
var slice = blob.slice || blob.webkitSlice || blob.mozSlice;
blob = slice.call(blob, 0, blob.size, force_saveable_type);
}
var url = URL.createObjectURL(blob);
var save_link = document.createElementNS('http://www.w3.org/1999/xhtml', 'a');
save_link.href = url;
save_link.download = filename;
var event = document.createEvent('MouseEvents');
event.initMouseEvent('click', true, false, window, 0, 0, 0, 0, 0, false, false, false, false, 0, null);
save_link.dispatchEvent(event);
URL.revokeObjectURL(url);
}
function base64encode(input) {
var keyStr = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=";
var output = "";
var chr1, chr2, chr3, enc1, enc2, enc3, enc4;
var i = 0;
input = utf8Encode(input);
while (i < input.length) {
chr1 = input.charCodeAt(i++);
chr2 = input.charCodeAt(i++);
chr3 = input.charCodeAt(i++);
enc1 = chr1 >> 2;
enc2 = ((chr1 & 3) << 4) | (chr2 >> 4);
enc3 = ((chr2 & 15) << 2) | (chr3 >> 6);
enc4 = chr3 & 63;
if (isNaN(chr2)) {
enc3 = enc4 = 64;
} else if (isNaN(chr3)) {
enc4 = 64;
}
output = output +
keyStr.charAt(enc1) + keyStr.charAt(enc2) +
keyStr.charAt(enc3) + keyStr.charAt(enc4);
}
return output;
}
return this;
}
});
})(jQuery);