帮助文档:http://wijmo.com/docs/wijmo/#SpreadJS.html
如果要打开本地的Excel文件,需要先转成CSV,再用Uploader上传,然后序列化读取到csvString,然后才能读入SpreadJS。
下面代码是导入CSV的示例。
-     var sheet1 = spread.getSheet(0);
-     sheet1.setRowCount(3);
-     sheet1.setColumnCount(5);
-     sheet1.setColumnHeaderAutoText($.wijmo.wijspread.HeaderAutoText.blank);
-     sheet1.setRowHeaderAutoText($.wijmo.wijspread.HeaderAutoText.blank);
-     sheet1.setText(0, 0, "Row1", $.wijmo.wijspread.SheetArea.rowHeader);
-     sheet1.setText(1, 0, "Row2", $.wijmo.wijspread.SheetArea.rowHeader);
-     sheet1.setText(2, 0, "Row3", $.wijmo.wijspread.SheetArea.rowHeader);
-     sheet1.setText(0, 0, "Column1", $.wijmo.wijspread.SheetArea.colHeader);
-     sheet1.setText(0, 1, "Column2", $.wijmo.wijspread.SheetArea.colHeader);
-     sheet1.setText(0, 2, "Column3", $.wijmo.wijspread.SheetArea.colHeader);
-     sheet1.setText(0, 3, "Column4", $.wijmo.wijspread.SheetArea.colHeader);
-     sheet1.setText(0, 4, "Column5", $.wijmo.wijspread.SheetArea.colHeader);
-     sheet1.setText(0, 0, "SPREAD-1");
-     sheet1.setText(1, 0, "SPREAD-2");
-     sheet1.setText(2, 0, "SPREAD-3");
-     sheet1.setValue(0, 1, new Date().setFullYear(2006, 8, 1));
-     sheet1.setValue(1, 1, new Date().setFullYear(2006, 8, 2));
-     sheet1.setValue(2, 1, new Date().setFullYear(2006, 8, 3));
-     sheet1.setColumnWidth(1, 90);
-     sheet1.setValue(0, 2, 123.45);
-     sheet1.setValue(1, 2, 99.9999);
-     sheet1.setValue(2, 2, 100);
-     sheet1.setValue(0, 3, true);
-     sheet1.setValue(1, 3, false);
-     sheet1.setValue(2, 3, true);
-     sheet1.setValue(0, 4, "aaa");
-     sheet1.setValue(1, 4, "bbb");
-     sheet1.setValue(2, 4, "ccc");
-
- $("#button1").click(function(){
-     //Save all data on the first sheet in a csv format.
-     window.CSVString = spread.getSheet(0).getCsv(0, 0, spread.getSheet(0).getRowCount(), spread.getSheet(0).getColumnCount(), "\r", ",");
- });
-
- $("#button2").click(function(){
-     //Load the saved csv file on the second sheet.
-     spread.getSheet(1).setCsv(0, 0, window.CSVString, "\r", ",", $.wijmo.wijspread.TextFileOpenFlags.None);
-  });
-
- //Add button controls to page
- <input type="button" id="button1" value="button1"/>
- <input type="button" id="button2" value="button2"/>
复制代码 |