您好,由于条件格式中存在一些无效的公式,您可以参考下面的代码来解决此问题。关于此问题的demo已上传至附件,您可以下载查看。
- document.getElementById('loadExcel').onclick = function () {
- var excelFile = document.getElementById("fileDemo").files[0];
- var password = document.getElementById('password').value;
- // here is excel IO API
- excelIo.open(excelFile, function (json) {
- var workbookObj = json;
- delete workbookObj.sheets.sheet1.conditionalFormats;
- delete workbookObj.sheets.sheet6.conditionalFormats;
- spread.fromJSON(workbookObj);
- }, function (e) {
- // process error
- alert(e.errorMessage);
- if (e.errorCode === 2/*noPassword*/ || e.errorCode === 3 /*invalidPassword*/)
- { document.getElementById('password').onselect = null; }}, {password: password});
- };
复制代码
|
|