Skip to content

spread sheetV11.1.2 upgrade #16

@luohong123

Description

@luohong123

spread sheet升级到V11.1.2版本

最新的SpreadJS V11.1.x可以直接npm 安装,并且在Angular中可以直接import
http://www.grapecity.com.cn/blogs/spread-sheets-v11sp1-support-npm,
spread-sheet售后支持电话:02988331988(葡萄城控件转620),
售后邮箱:support.xa@grapecity.com Clark.Pan@grapecity.com Dexter.Yao@grapecity.com

升级原因:

AOT打包对代码要求比较严格,Spread-sheetV11.0.0版本AOT打包不通过,升级到V11.1.xAOT打包通过后,项目性能会好很多,建议升级。

新版本使用方法步骤:

第一步:

删除assets/plugin/spread整个文件夹,在package的dependencies新增依赖:
"@grapecity/spread-excelio": "^11.1.2",
"@grapecity/spread-sheets": "^11.1.2",
"@grapecity/spread-sheets-angular": "^11.1.2",
"@grapecity/spread-sheets-charts": "^11.1.2",
"@grapecity/spread-sheets-pdf": "^11.1.2",
"@grapecity/spread-sheets-print": "^11.1.2",
"@grapecity/spread-sheets-resources-zh": "^11.1.2",
执行操作命令 npm i


第二步:

在index.module.ts导入spread-sheet模块
import { SpreadSheetsModule } from '@grapecity/spread-sheets-angular';
imports: [
SpreadSheetsModule
],


第三步:

在ts里面引入模块
import * as GC from "@grapecity/spread-sheets";
import * as Excel from "@grapecity/spread-excelio";
import "@grapecity/spread-sheets-charts";
如导入功能的写法:
HTML代码片段:`<gc-spread-sheets [hostStyle]="hostStyle" (workbookInitialized)="workbookInit($event)">

` > ts代码片段: `export class AppComponent { spreadBackColor = 'aliceblue'; hostStyle = { width: '95vw', height: '80vh' }; private spread: GC.Spread.Sheets.Workbook; private excelIO; constructor() { this.excelIO = new Excel.IO(); } workbookInit(args) { var self = this; self.spread = args.spread; self.spread.options.scrollbarMaxAlign = true; }

onFileChange(args) {
let self = this, file = args.srcElement && args.srcElement.files && args.srcElement.files[0];
if (self.spread && file) {
self.excelIO.open(file, (json) => {
self.spread.fromJSON(json);
setTimeout(() => {
alert("load successfully");
}, 0);
}, (error) => {
alert('load fail');
});
}
}
}`


*温馨提示:
1.做导出功能通过import引入file-saver,如import { saveAs } from 'file-saver';

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions