Skip to content

spread sheetV11.1.2 upgrade

honghong edited this page Jun 15, 2018 · 1 revision

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';

Clone this wiki locally