本帖最后由 thmnsc 于 2019-3-27 16:14 编辑
官网示例demo,添加了一下js引用:
- <script type="text/javascript" src="@Url.Content("~/Scripts/gc.spread.sheets.all.12.0.0.min.js")"></script>
- <script type="text/javascript" src="@Url.Content("~/Scripts/gc.spread.sheets.resources.zh.12.0.0.min.js")"></script>
- <script type="text/javascript" src="@Url.Content("~/Scripts/gc.spread.excelio.12.0.0.min.js")"></script>
- <script type="text/javascript" src="@Url.Content("~/Scripts/FileSaver.js")"></script>
- <script type="text/javascript" src="@Url.Content("~/Scripts/license.js")"></script>
- <script type="text/javascript" src="@Url.Content("~/Scripts/index.js")"></script>
复制代码
打开现有文件的JS函数如下:
- //打开已有的Excel
- function importFromExcel() {
- var excelIo = new GC.Spread.Excel.IO();
- var excelFilePath = '../upload/ufo2.xlsx';
- var xhr = new XMLHttpRequest();
- xhr.open('GET', excelFilePath, true);
- xhr.responseType = 'blob';
- xhr.onload = function (e) {
- if (this.status == 200) {
- // get binary data as a response
- var blob = this.response;
- // convert Excel to JSON
- excelIo.open(blob, function (json) {
- var workbookObj = json;
- spread.fromJSON(workbookObj);
- }, function (e) {
- //process error
- alert(e.errorMessage);
- }, {});
- }
- };
- xhr.send();
- }
复制代码
excel文件很简单,直接用office2010新建一个excel文件,简单编辑了2个单元格的文本。
点击按钮时提示:文件格式错误。
|
|