spreadjs 小记
首先声明一个容器
<div id="ss" class="sample-spreadsheets" style="margin:1px 1px 1px 1px;">
</div>
然后初始化表格
var spreadNS = GC.Spread.Sheets;
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), {
sheetCount: 1,
newTabVisible: false
});
导入数据
spread.fromJSON(stylejs);--参数模板数据。json字符串
是否隐藏行头列头,true/false
sheet.options.rowHeaderVisible = true;
sheet.options.colHeaderVisible = true;
spread.options.allowExtendPasteRange = true;
复制样式
spread.options.allowCopyPasteExcelStyle = true;
自动行高
spread.options.highlightInvalidData = true;
暂时挂起表格
spread.suspendPaint();
重新绘制
spread.resumePaint();
//隐藏标签
spread.options.tabStripVisible = false;
spread.options.newTabVisible = false;
PDF导出
function prot_PDF() {
var pdfp = document.createElement('div');
pdfp.className = 'expro';
var pdfc = document.createTextNode("导出PDF");
pdfp.appendChild(pdfc);
return pdfp;
}
//#region pdf字体注册
function addFontsToFontManager(fontsObj) {
var fonts = {
normal: fontsObj["simkai.ttf"]
};
GC.Spread.Sheets.PDF.PDFFontsManager.fallbackFont = function (font) {
var fontInfoArray = font.split(' ');
var fontName = fontInfoArray[fontInfoArray.length - 1];
if (fontName === '宋体') {
return fonts.normal;
}
}
}
//pdf字体设置
var fontsObj = fonts;
registerCustomFont(fontsObj);
addFontsToFontManager(fontsObj);
记得引用字体样式.css
映射键盘
spread.commandManager().register('myCmd',function ColorAction() {}
spread.commandManager().setShortcutKey('myCmd', GC.Spread.Commands.Key.del, false, false, false, false);