导出 - 简书

<!DOCTYPE html>

<head>

<title>SpreadJS Demo : 导入导出Excel、导出PDF、打印</title>

<!-- Local Reference

-->

<style>

body {

background: rgb(250, 250, 250);

color: #333;

font-family: mtcorsva !important;

}

#ss {

border: 1px #ccc solid;

}

.container {

width: 95%;

background: rgb(250, 250, 250);

margin: 0 auto;

height: 600px;

}

.full-height {

height: 100%;

}

.left{

height: 100%;

overflow: auto;

}

</style>

</head>

<body>

<h3>SpreadJS Demo : 导入导出Excel、导出PDF、打印</h3>

</div>

<h5>

<li class="inline-block mr1"><a class="btn" href="https://www.grapecity.com.cn/developer/spreadjs "

target="_blank ">产品官网</a></li>

<li class="inline-block mr1"><a class="" href="https://gcdn.grapecity.com.cn/showforum-185-1.html "

target="_blank ">论坛求助</a></li>

<li class="inline-block mr1"><a class="" href="https://demo.grapecity.com.cn/SpreadJS/TutorialSample/#/samples "

target="_blank ">更多示例</a></li>

</ul>

</h5>

</div>

</div>

</div>

<label>密码:

</label>

<div>

</div>

<div>

</div>

</div>

</body>

var spreadNS = GC.Spread.Sheets;

$(document).ready(function () {

var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));

var sheet = spread.getActiveSheet();

// spread.fromJSON(model1);

var excelIo = new GC.Spread.Excel.IO();

/*-----------------导入Excel--------------------------*/

document.getElementById('loadExcel').onclick = function(){

var excelFile = document.getElementById('fileDemo').files[0];

var password = document.getElementById('password').value;

excelIo.open(excelFile,function(json){

var obj = json;

spread.fromJSON(obj);

},{password: password});

};

/*-------------------------导出Excel---------------------------------*/

document.getElementById('saveExcel').onclick = function() {

var fileName = document.getElementById('exportFileName').value;

var password = document.getElementById('password').value;

if (fileName.substr(-5, 5) !== '.xlsx') {

fileName += '.xlsx';

}

var json = spread.toJSON();

excelIo.save(json, function (blob) {

saveAs(blob, fileName);

}, function (e) {

console.log(e);

}, {password: password});

}

/*----------------------------- 导出PDF-------------------------------------*/

var fontsObj = fonts;

// 注册一个自定义字体

registerCustomFont(fontsObj);

setPrintInfo(spread);

var style = new GC.Spread.Sheets.Style();

style.font = "8pt simkai";

for (var i = 0; i < spread.getSheetCount(); i++) {

spread.sheets[i].setDefaultStyle(style,GC.Spread.Sheets.SheetArea.viewport);

}

function registerCustomFont(fontsObj) {

var fonts = {

normal: fontsObj["simkai.ttf"]

};

GC.Spread.Sheets.PDF.PDFFontsManager.registerFont('simkai', fonts);

}

document.getElementById('pdf').onclick = function(){

spread.savePDF(function(blob){

saveAs(blob,'download.pdf');

function (error) {

console.log(error);

{

title:'Test Title', // 导出PDF文件的参数

author:'Test Author',

subject:'TestSubject',

keywords:'Text Keywords',

creator:'test Creator'

});

}

function setPrintInfo(spread) {

var sheet = spread.getActiveSheet();

var printInfo = sheet.printInfo();

printInfo.showBorder(false);

printInfo.showGridLine(false);

printInfo.showColumnHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);

printInfo.showRowHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);

sheet.printInfo(printInfo);

}

/*--------------------------打印-------------------------*/

document.getElementById('print').onclick = function(sheetsindex) {

// spread.print(3);

printSetting(spread);

}

//打印设置

function printSetting( ) {

var sheet = spread.getActiveSheet();

var printInfo = sheet.printInfo();

//打印设置

printInfo.paperSize(new GC.Spread.Sheets.Print.PaperSize(GC.Spread.Sheets.Print.PaperKind.a4));

printInfo.margin({ top: 0, bottom: 0, left: 0, right: 0, header: 0, footer: 0 });

//是否打印控件的外边框

printInfo.showBorder(false);

//是否打印网格线（默认打印）

printInfo.showGridLine(false);

printInfo.zoomFactor(0.8);//缩放

printInfo.qualityFactor(1);//打印的质量因子

printInfo.orientation(GC.Spread.Sheets.Print.PrintPageOrientation.portrait);//打印的页面方向。portrait landscape

printInfo.centering(GC.Spread.Sheets.Print.PrintCentering.horizontal);//打印页面的居中方式。

printInfo.showColumnHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);//获取或设置是否打印列标题。

printInfo.showRowHeader(GC.Spread.Sheets.Print.PrintVisibilityType.hide);

//设置是否以黑白打印

printInfo.blackAndWhite(true);

for (var i = 0; i < spread.getSheetCount(); i++) {

spread.sheets[i].printInfo(printInfo);

}

spread.print(2);

}

});

</script>

</html>

导出

推荐阅读更多精彩内容