vue里面excel导入报错，选择文件，导入报错

收藏

本帖最后由 shawnfeng 于 2018-6-24 13:50 编辑

{errorCode: 1, errorMessage: "Incorrect file format."}

代码如下：
ImportFileStart() {
      let _this = this;
      var excelFile = this.$refs.fileDemo.files[0];
      console.log(excelFile);
      console.log("this.excelIO: ",this.excelIO);
      this.excelIO.open(excelFile, function (json) {
      var workbookObj = json;
      this.spread.fromJSON(workbookObj); // 须将 this 变成_this ====》_this.spread.fromJSON(...)
      }, function(e){
      console.log(e);
      });
   },

shawnfeng · shawnfeng

解决了，里面的一句话写错了

this.spread.fromJSON(workbookObj); == 》 _this.spread.fromJSON(workbookObj); 就好了

shawnfeng · shawnfeng

vue里面这样引入
import GC from '@grapecity/spread-sheets'
import Excel from '@grapecity/spread-excelio'
然后在 data中定义：
spread: {},
excelIO: {}
在mounted方法中，这样写：
this.spread = new GC.Spread.Sheets.Workbook(this.$refs.ss); //注意$refs
this.initSpread(this.spread); // （var sheet = spread.getActiveSheet();）
this.excelIO = new Excel.IO();