,
- <!DOCTYPE >
- <html>
- <head>
- <meta name="spreadjs culture" content="zh-cn" />
- <meta charset="utf-8" />
- <meta name="viewport" content="width=device-width, initial-scale=1.0" />
- <link rel="styleSheet" href="gc.spread.sheets.excel2013white.12.0.0.css" />
- <script src="TutorialSample/js/jquery-1.8.2.min.js"></script>
- <script src="gc.spread.sheets.all.12.0.0.min.js" type="text/javascript"></script>
- <script src="TutorialSample/js/FileSaver.js"></script>
- <script src="TutorialSample/js/spread/plugins/gc.spread.excelio.12.0.0.min.js"></script>
- <script src="gc.spread.sheets.resources.zh.12.0.0.min.js" type="text/javascript"></script>
- <style type="text/css">
- .sample-tutorial {
- position: relative;
- height: 100%;
- overflow: hidden;
- }
- .sample-spreadsheets {
- width: calc(100% - 280px);
- height: 100%;
- overflow: hidden;
- float: left;
- }
- .options-container {
- float: right;
- width: 280px;
- padding: 12px;
- height: 100%;
- box-sizing: border-box;
- background: #fbfbfb;
- overflow: auto;
- }
- .sample-options {
- z-index: 1000;
- }
- .inputContainer {
- width: 100%;
- height: auto;
- border: 1px solid #eee;
- padding: 6px 12px;
- margin-bottom: 10px;
- box-sizing: border-box;
- }
- .input {
- font-size: 14px;
- height: 20px;
- border: 0;
- outline: none;
- background: transparent;
- }
- .button {
- height: 30px;
- padding: 6px 12px;
- width: 80px;
- margin-top: 6px;
- }
- .group {
- padding: 12px;
- }
- .group input {
- padding: 4px 12px;
- }
- </style>
- </head>
- <body style='font-size:14px;'>
- <div class="sample-tutorial">
- <div id="ss" style="width:100%; height:360px;border: 1px solid gray;"></div>
- <div class="options-container">
- <div class="option-row">
- <div class="inputContainer">
- <input type="file" id="fileDemo" class="input">
- <input type="button" id="loadExcel" value="import" class="button">
- </div>
- <div class="inputContainer">
- <input id="exportFileName" value="export.xlsx" class="input">
- <input type="button" id="saveExcel" value="export" class="button">
- </div>
- </div>
- <div class="option-row">
- <div class="group">
- <label>Password:
- <input type="password" id="password">
- </label>
- </div>
- </div>
- </div>
- </div>
- <script type="text/javascript">
- window.onload = function() {
- var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), {
- sheetCount: 1
- });
- var excelIo = new GC.Spread.Excel.IO();
- window.onload = function() {
- var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));
- spread.fromJSON(jsonData);
- var excelIo = new GC.Spread.Excel.IO();
- var sheet = spread.getActiveSheet();
- 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;
- 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
- });
- };
- document.getElementById('saveExcel').onclick = function() {
- var fileName = document.getElementById('exportFileName').value;
- var password = document.getElementById('password').value;
- if (fileName.substr(-5, 5) !== '.xlsx') {
- fileName += '.xlsx';
- }
- var json = spread.toJSON();
- // here is excel IO API
- excelIo.save(json, function(blob) {
- saveAs(blob, fileName);
- }, function(e) {
- // process error
- console.log(e);
- }, {
- password: password
- });
- };
- };
- };
- </script>
- </body>
- </html>
复制代码
我的运行效果,
我用的Spreadjs 想实现导入excel解析功能,按照官网的教程,没有显示出来。js,css已经正确引入,导入一个excel文件,点击导入没有反应
|
|