轉(zhuǎn)帖|使用教程|編輯:龔雪|2016-03-08 16:34:27.000|閱讀 901 次
概述:本文主要介紹SpreadJS 9 新功能:預(yù)覽和打印數(shù)據(jù)視圖。通過簡單的幾步代碼示例,然后得出運行效果以及打印效果展示。
# 界面/圖表報表/文檔/IDE等千款熱門軟控件火熱銷售中 >>
相關(guān)鏈接:
SpreadJS在頁面上添加打印按鈕,可以直接打開標準的瀏覽器打印窗口。SpreadJS滿足您的各種打印細節(jié)設(shè)置需求:自適應(yīng)文本高寬打印、網(wǎng)格線、邊框、頁眉、頁腳、邊距、頁面自適應(yīng)、頁面尺寸、插入分頁符等等。導(dǎo)入或?qū)С鯡xcel文件之后,打印設(shè)置依然可以保留。
<link href="gcspread.sheets.9.40.20153.0.css" rel="stylesheet" type="text/css" />
<script src="jquery-1.8.2.min.js" type="text/javascript"></script>
<script type="text/javascript" src="gcspread.sheets.all.9.40.20153.0.min.js"></script>
<script type="text/javascript" src="gcspread.sheets.print.9.40.20153.0.min.js"></script>
sheet.setFormula(17, 9, "=SUM(J12:J17)");
for (var i = 0; i < 14; i++)
{
sheet.setFormula(4 + i, 10, "=SUM(E" + (5 + i).toString() + ":J" + (5 + i).toString() + ")");
}
sheet.setFormula(18, 4, "=E11+E18");
sheet.setFormula(18, 5, "=F11+F18");
sheet.setFormula(18, 6, "=G11+G18");
sheet.setFormula(18, 7, "=H11+H18");
sheet.setFormula(18, 8, "=I11+I18");
sheet.setFormula(18, 9, "=J11+J18");
sheet.setFormula(18, 10, "=K11+K18");
sheet.getCells(1, 1, 3, 10).backColor("#D9D9FF");
sheet.getCells(4, 1, 18, 3).backColor("#D9FFD9");
sheet.getCells(1, 1, 3, 10).hAlign(GcSpread.Sheets.HorizontalAlign.center);
sheet.setBorder(new GcSpread.Sheets.Range(1, 1, 18, 10), new GcSpread.Sheets.LineBorder("Black", GcSpread.Sheets.LineStyle.thin), { all: true });
sheet.setBorder(new GcSpread.Sheets.Range(4, 4, 3, 6), new GcSpread.Sheets.LineBorder("Black", GcSpread.Sheets.LineStyle.dotted), { inside: true });
sheet.setBorder(new GcSpread.Sheets.Range(7, 4, 3, 6), new GcSpread.Sheets.LineBorder("Black", GcSpread.Sheets.LineStyle.dotted), { inside: true });
sheet.setBorder(new GcSpread.Sheets.Range(11, 4, 3, 6), new GcSpread.Sheets.LineBorder("Black", GcSpread.Sheets.LineStyle.dotted), { inside: true });
sheet.setBorder(new GcSpread.Sheets.Range(14, 4, 3, 6), new GcSpread.Sheets.LineBorder("Black", GcSpread.Sheets.LineStyle.dotted), { inside: true });
fillSampleData(sheet, new GcSpread.Sheets.Range(4, 4, 6, 6));
fillSampleData(sheet, new GcSpread.Sheets.Range(11, 4, 6, 6));
sheet.setColumnWidth(0, 40);
sheet.setColumnWidth(1, 40);
sheet.setColumnWidth(3, 40);
sheet.setColumnWidth(4, 40);
sheet.setColumnWidth(11, 40);
addFigures(sheet);
sheet.isPaintSuspended(false);
}
$(document).ready(function ()
{
var spread = new GcSpread.Sheets.Spread(document.getElementById("ss"));
initSpread(spread);
$("#btnPrint").click(function ()
{
// used to adjust print range, should set with printInfo (refer custom print for detail)
spread.sheets[0].setText(31, 11, " ");
spread.print();
});
});
<body>
<div id="ss" style="width: 800px; height: 600px; border: 1px solid gray">
</div>
<input type="button" value="Print" id="btnPrint">
</body>


本站文章除注明轉(zhuǎn)載外,均為本站原創(chuàng)或翻譯。歡迎任何形式的轉(zhuǎn)載,但請務(wù)必注明出處、不得修改原文相關(guān)鏈接,如果存在內(nèi)容上的異議請郵件反饋至chenjj@ke049m.cn