js 导出Excel
最近从Silverlight这边转到javascript过来，现在要导出一个导出excel的功能。上级领导指示当页显示多少数据，就导出多少数据，没有必要从后台在去数据。以前也没有接触过这方面的，在网上一整狂查资料，最终决定采用excel2003xml+flash插件实现改功能。
获取excel2003xml格式
在桌面新建一个excel文件，另存为2003xml格式，用Vs2012打开该文件，就能清晰的明白数据保存方式。
javascript构造xml数据
了解数据结构后，我们已经知道了excel中的数据存储在节点Worksheet下的Table中，ExpandedColumnCount属性说明该Execl文件中有多少列，ExpandedRowCount说明有多少行数据。Row节点下ss:Index说明改行数据是从第几行开始。Cell节点属性ss:Index说明数据是在第几列，ss:MergeDown是从本单元格像下合并多少单元格，ss:MergeAcross从本单元格开始向左合并多少个单元格，数据格式如下：
表格中的数据个列都会有列头信息，我采用列头和数据分离，都采用一个二维数组， dataOpts.HeadInfo格式：
[[
{ field: \'F_UserID\', title: \'公告ID\', width: 100, hidden: true, rowspan: 3 },
{ field: \'F_RealName\', title: \'姓名\', width: 100, rowspan: 3 },
{ field: \'F_LoginName\', title: \'登录名\', width: 100, rowspan: 3 },
{ field: \'F_Password\', title: \'密码\', width: 100, rowspan: 3 },
{ title: \'多表头\', colspan: 5 }
], [
{ field: \'F_UserNick\', title: \'昵称\', width: 100,rowspan:2},
{ field: \'F_IdNumber\', title: \'身份证号\', width: 100,rowspan:2 },
{ title: \'多表3\', colspan: 3}
], [
{ field: \'F_Tel\', title: \'电话\', width: 100},
{ field: \'F_BirthDate\', title: \'生日\', width: 100 },
{ field: \'F_EMail\', title: \'邮箱\', width: 100 },
]
filed用于判断是否是合并列，其中rowspan对应MergeDown，clospan对应MergeAcross,构建表头代码如下：
for (var i = 0; i < dataOpts.HeadInfo.length; i++) {
var rowindex = dataOpts.RowStart + i;
headerXml += \'<Row ss:Index="\' + rowindex + \'" ss:AutoFitHeight="0">\';
for (var cell = 0; cell < dataOpts.HeadInfo[i].length; cell++) {
var curcell = dataOpts.HeadInfo[i][cell];
if (curcell.hidden)
continue;
var cellindex = dataOpts.ColumStart + cloumIndex;
var MergeDown = curcell.rowspan ? curcell.rowspan - 1 : 0;
var MergeAcross = curcell.colspan ? curcell.colspan - 1 : 0;
if (curcell.field) {
cloumIndex = cloumIndex + 1;
ExpandedColumnCount = ExpandedColumnCount + 1;
}
headerXml += \'<Cell ss:StyleID="TableHeadStyle" ss:Index="\' + cellindex +
(MergeDown === 0 ? \'\' : \'" ss:MergeDown="\' + MergeDown) +
(MergeAcross === 0 ? \'\' : \'" ss:MergeAcross="\' + MergeAcross) +
\'"><Data ss:Type="String">\' + curcell.title + \'</Data></Cell>\';
}
headerXml += \'</Row>\';
ExpandedRowCount = ExpandedRowCount + 1;
}
同理，构建数据就显得简单些了，不会存在合并问题,数据行是从表头后开始绘制的，在Row节点中可不用设置ss:index的值，主要代码如下：
//创建数据
for (var i = 0; i < dataOpts.RowInfo.length; i++) {
rowxml += \'<Row ss:AutoFitHeight="0">\';
for (var j = 0; j < dataOpts.RowInfo[i].length; j++) {
var value = dataOpts.RowInfo[i][j];
rowxml += \'<Cell ss:StyleID="TableHeadStyle" \' +
(j === 0 ? \'ss:Index="\' + dataOpts.ColumStart + \'"\' : \' \') +
\' ><Data ss:Type="String">\' + value + \'</Data></Cell>\'
}
rowxml += \'</Row> \';
ExpandedRowCount = ExpandedRowCount + 1;
}
改功能主要是针对easyui中datagrid开发，单生成在处理行数据时需要特别处理转换成二维数组，调用方式
onLoadSuccess: function (data) {
setTimeout(function () {
ZeroClipboard_TableTools.setMoviePath(\'@Url.Content("~/Scripts/media/copy_csv_xls_pdf.swf")\');
var flash = new ZeroClipboard_TableTools.Client("exportExcel");
flash.setHandCursor(true);
data = [];
var dataarray = grid.datagrid("getRows");
for (var i = 0; i < dataarray.length; i++) {
data[i] = [];
cols = grid.datagrid("getColumnFields");
var mins = 0;
for (var j = 0; j < cols.length; j++) {
var colname = cols[j];
var filed = grid.datagrid("getColumnOption", colname);
if (filed.hidden) {
mins += 1;
continue
}
data[i][j - mins] = dataarray[i][colname];
}
}
flash.setText(JSXmlExcel.BulidXml({ HeadInfo: grid.datagrid("options").columns, RowInfo: data, RowStart: 2, ColumStart: 2, SheetName: \'Test\' }));
flash.setAction(\'save\');
flash.setCharSet(\'UTF8\');
flash.setFileName("excel.xls");
}, 100);
}
});
ZeroClipboard.js
1 // Simple Set Clipboard System 2 // Author: Joseph Huckaby 3 4 var ZeroClipboard_TableTools = { 5 6 version: "1.0.4-TableTools2", 7 clients: {}, // registered upload clients on page, indexed by id 8 moviePath: \'\', // URL to movie 9 nextId: 1, // ID of next movie 10 11 $: function (thingy) { 12 // simple DOM lookup utility function 13 if (typeof (thingy) == \'string\') thingy = document.getElementById(thingy); 14 if (!thingy.addClass) { 15 // extend element with a few useful methods 16 thingy.hide = function () { this.style.display = \'none\'; }; 17 thingy.show = function () { this.style.display = \'\'; }; 18 thingy.addClass = function (name) { this.removeClass(name); this.className += \' \' + name; }; 19 thingy.removeClass = function (name) { 20 this.className = this.className.replace(new RegExp("\\s*" + name + "\\s*"), " ").replace(/^\s+/, \'\').replace(/\s+$/, \'\'); 21 }; 22 thingy.hasClass = function (name) { 23 return !!this.className.match(new RegExp("\\s*" + name + "\\s*")); 24 } 25 } 26 return thingy; 27 }, 28 29 setMoviePath: function (path) { 30 // set path to ZeroClipboard.swf 31 this.moviePath = path; 32 }, 33 34 dispatch: function (id, eventName, args) { 35 // receive event from flash movie, send to client 36 var client = this.clients[id]; 37 if (client) { 38 client.receiveEvent(eventName, args); 39 } 40 }, 41 42 register: function (id, client) { 43 // register new client to receive events 44 this.clients[id] = client; 45 }, 46 47 getDOMObjectPosition: function (obj) { 48 // get absolute coordinates for dom element 49 debugger; 50 var info = { 51 left: 0, 52 top: 0, 53 width: obj.width ? obj.width : obj.offsetWidth, 54 height: obj.height ? obj.height : obj.offsetHeight 55 }; 56 57 if (obj.style.width != "") 58 info.width = obj.style.width.replace("px", ""); 59 60 if (obj.style.height != "") 61 info.height = obj.style.height.replace("px", ""); 62 63 while (obj) { 64 info.left += obj.offsetLeft; 65 info.top += obj.offsetTop; 66 obj = obj.offsetParent; 67 } 68 69 return info; 70 }, 71 72 Client: function (elem) { 73 // constructor for new simple upload client 74 this.handlers = {}; 75 76 // unique ID 77 this.id = ZeroClipboard_TableTools.nextId++; 78 this.movieId = \'ZeroClipboard_TableToolsMovie_\' + this.id; 79 80 // register client with singleton to receive flash events 81 ZeroClipboard_TableTools.register(this.id, this); 82 83 // create movie 84 if (elem) this.glue(elem); 85 } 86 }; 87 88 ZeroClipboard_TableTools.Client.prototype = { 89 90 id: 0, // unique ID for us 91 ready: false, // whether movie is ready to receive events or not 92 movie: null, // reference to movie object 93 clipText: \'\', // text to copy to clipboard 94 fileName: \'\', // default file save name 95 action: \'copy\', // action to perform 96 handCursorEnabled: true, // whether to show hand cursor, or default pointer cursor 97 cssEffects: true, // enable CSS mouse effects on dom container 98 handlers: null, // user event handlers 99 sized: false, 100 101 glue: function (elem, title) { 102 // glue to DOM element 103 // elem can be ID or actual DOM element object 104 this.domElement = ZeroClipboard_TableTools.$(elem); 105 106 // float just above object, or zIndex 99 if dom element isn\'t set 107 var zIndex = 99; 108 if (this.domElement.style.zIndex) { 109 zIndex = parseInt(this.domElement.style.zIndex) + 1; 110 } 111 debugger; 112 // find X/Y position of domElement 113 var box = ZeroClipboard_TableTools.getDOMObjectPosition(this.domElement); 114 115 // create floating DIV above element 116 this.div = document.createElement(\'div\'); 117 var style = this.div.style; 118 style.position = \'absolute\'; 119 style.left =\'0px\'; 120 style.top = \'0px\'; 121 style.width = (box.width) + \'px\'; 122 style.height = (box.height) + \'px\'; 123 style.zIndex = zIndex; 124 125 if (typeof title != "undefined" && title != "") { 126 this.div.title = title; 127 } 128 if (box.width != 0 && box.height != 0) { 129 this.sized = true; 130 } 131 132 style.backgroundColor = \'#f00\'; // debug 133 if (this.domElement) { 134 this.domElement.appendChild(this.div); 135 this.div.innerHTML = this.getHTML(box.width, box.height); 136 } 137 }, 138 139 positionElement: function () { 140 var box = ZeroClipboard_TableTools.getDOMObjectPosition(this.domElement); 141 var style = this.div.style; 142 143 style.position = \'absolute\'; 144 //style.left = (this.domElement.offsetLeft)+\'px\'; 145 //style.top = this.domElement.offsetTop+\'px\'; 146 style.width = box.width + \'px\'; 147 style.height = box.height + \'px\'; 148 149 if (box.width != 0 && box.height != 0) { 150 this.sized = true; 151 } else { 152 return; 153 } 154 155 var flash = this.div.childNodes[0]; 156 flash.width = box.width; 157 flash.height = box.height; 158 }, 159 160 getHTML: function (width, height) { 161 // return HTML for movie 162 var html = \'\'; 163 var flashvars = \'id=\' + this.id + 164 \'&width=\' + width + 165 \'&height=\' + height; 166 167 if (navigator.userAgent.match(/MSIE/)) { 168 // IE gets an OBJECT tag 169 var protocol = location.href.match(/^https/i) ? \'https://\' : \'http://\'; 170 html += \'<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="\' + protocol + \'download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=10,0,0,0" width="\' + width + \'" height="\' + height + \'" id="\' + this.movieId + \'" align="middle"><param name="allowScriptAccess" value="always" /><param name="allowFullScreen" value="false" /><param name="movie" value="\' + ZeroClipboard_TableTools.moviePath + \'" /><param name="loop" value="false" /><param name="menu" value="false" /><param name="quality" value="best" /><param name="bgcolor" value="#ffffff" /><param name="flashvars" value="\' + flashvars + \'"/><param name="wmode" value="transparent"/></object>\'; 171 } 172 else { 173 // all other browsers get an EMBED tag 174 html += \'<embed id="\' + this.movieId + \'" src="\' + ZeroClipboard_TableTools.moviePath + \'" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="\' + width + \'" height="\' + height + \'" name="\' + this.movieId + \'" align="middle" allowScriptAccess="always" allowFullScreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="\' + flashvars + \'" wmode="transparent" />\'; 175 } 176 return html; 177 }, 178 179 hide: function () { 180 // temporarily hide floater offscreen 181 if (this.div) { 182 this.div.style.left = \'-2000px\'; 183 } 184 }, 185 186 show: function () { 187 // show ourselves after a call to hide() 188 this.reposition(); 189 }, 190 191 destroy: function () { 192 // destroy control and floater 193 if (this.domElement && this.div) { 194 this.hide(); 195 this.div.innerHTML = \'\'; 196 197 var body = document.getElementsByTagName(\'body\')[0]; 198 try { body.removeChild(this.div); } catch (e) {; } 199 200 this.domElement = null; 201 this.div = null; 202 } 203 }, 204 205 reposition: function (elem) { 206 // reposition our floating div, optionally to new container 207 // warning: container CANNOT change size, only position 208 if (elem) { 209 this.domElement = ZeroClipboard_TableTools.$(elem); 210 if (!this.domElement) this.hide(); 211 } 212 213 if (this.domElement && this.div) { 214 var box = ZeroClipboard_TableTools.getDOMObjectPosition(this.domElement); 215 var style = this.div.style; 216 style.left = \'\' + box.left + \'px\'; 217 style.top = \'\' + box.top + \'px\'; 218 } 219 }, 220 221 clearText: function () { 222 // clear the text to be copy / saved 223 this.clipText = \'\'; 224 if (this.ready) this.movie.clearText(); 225 }, 226 227 appendText: function (newText) { 228 // append text to that which is to be copied / saved 229 this.clipText += newText; 230 if (this.ready) { this.movie.appendText(newText); } 231 }, 232 233 setText: function (newText) { 234 // set text to be copied to be copied / saved 235 this.clipText = newText; 236 if (this.ready) { this.movie.setText(newText); } 237 }, 238 239 setCharSet: function (charSet) { 240 // set the character set (UTF16LE or UTF8) 241 this.charSet = charSet; 242 if (this.ready) { this.movie.setCharSet(charSet); } 243 }, 244 245 setBomInc: function (bomInc) { 246 // set if the BOM should be included or not 247 this.incBom = bomInc; 248 if (this.ready) { this.movie.setBomInc(bomInc); } 249 }, 250 251 setFileName: function (newText) { 252 // set the file name 253 this.fileName = newText; 254 if (this.ready) this.movie.setFileName(newText); 255 }, 256 257 setAction: function (newText) { 258 // set action (save or copy) 259 this.action = newText; 260 if (this.ready) this.movie.setAction(newText); 261 }, 262 263 addEventListener: function (eventName, func) { 264 // add user event listener for event 265 // event types: load, queueStart, fileStart, fileComplete, queueComplete, progress, error, cancel 266 eventName = eventName.toString().toLowerCase().replace(/^on/, \'\'); 267 if (!this.handlers[eventName]) this.handlers[eventName] = []; 268 this.handlers[eventName].push(func); 269 }, 270 271 setHandCursor: function (enabled) { 272 // enable hand cursor (true), or default arrow cursor (false) 273 this.handCursorEnabled = enabled; 274 if (this.ready) this.movie.setHandCursor(enabled); 275 }, 276 277 setCSSEffects: function (enabled) { 278 // enable or disable CSS effects on DOM container 279 this.cssEffects = !!enabled; 280 }, 281 282 receiveEvent: function (eventName, args) { 283 // receive event from flash 284 eventName = eventName.toString().toLowerCase().replace(/^on/, \'\'); 285 286 // special behavior for certain events 287 switch (eventName) { 288 case \'load\': 289 // movie claims it is ready, but in IE this isn\'t always the case... 290 // bug fix: Cannot extend EMBED DOM elements in Firefox, must use traditional function 291 this.movie = document.getElementById(this.movieId); 292 if (!this.movie) { 293 var self = this; 294 setTimeout(function () { self.receiveEvent(\'load\', null); }, 1); 295 return; 296 } 297 298 // firefox on pc needs a "kick" in order to set these in certain cases 299 if (!this.ready && navigator.userAgent.match(/Firefox/) && navigator.userAgent.match(/Windows/)) { 300 var self = this; 301 setTimeout(function () { self.receiveEvent(\'load\', null); }, 100); 302 this.ready = true; 303 return; 304 } 305 306 this.ready = true; 307 this.movie.clearText(); 308 this.movie.appendText(this.clipText); 309 this.movie.setFileName(this.fileName); 310 this.movie.setAction(this.action); 311 this.movie.setCharSet(this.charSet); 312 this.movie.setBomInc(this.incBom); 313 this.movie.setHandCursor(this.handCursorEnabled); 314 break; 315 316 case \'mouseover\': 317 if (this.domElement && this.cssEffects) { 318 //this.domElement.addClass(\'hover\'); 319 if (this.recoverActive) this.domElement.addClass(\'active\'); 320 } 321 break; 322 323 case \'mouseout\': 324 if (this.domElement && this.cssEffects) { 325 this.recoverActive = false; 326 if (this.domElement.hasClass(\'active\')) { 327 this.domElement.removeClass(\'active\'); 328 this.recoverActive = true; 329 } 330 //this.domElement.removeClass(\'hover\'); 331 } 332 break; 333 334 case \'mousedown\': 335 if (this.domElement && this.cssEffects) { 336 this.domElement.addClass(\'active\'); 337 } 338 break; 339 340 case \'mouseup\': 341 if (this.domElement && this.cssEffects) { 342 this.domElement.removeClass(\'active\'); 343 this.recoverActive = false; 344 } 345 break; 346 } // switch eventName 347 348 if (this.handlers[eventName]) { 349 for (var idx = 0, len = this.handlers[eventName].length; idx < len; idx++) { 350 var func = this.handlers[eventName][idx]; 351 352 if (typeof (func) == \'function\') { 353 // actual function reference 354 func(this, args); 355 } 356 else if ((typeof (func) == \'object\') && (func.length == 2)) { 357 // PHP style object + method, i.e. [myObject, \'myMethod\'] 358 func[0][func[1]](this, args); 359 } 360 else if (typeof (func) == \'string\') { 361 // name of function 362 window[func](this, args); 363 } 364 } // foreach event handler defined 365 } // user defined handler for event 366 } 367 368 };
ZeroClipboard
JSXmlExcel.js
1 /***根据传入数据生成 2 [ 3 { field: \'F_UserID\', title: \'公告ID\', width: 100, sortable: true, hidden: true, rowspan: 3 }, 4 { field: \'F_RealName\', title: \'姓名\', width: 100, sortable: true, rowspan: 3 }, 5 { field: \'F_LoginName\', title: \'登录名\', width: 100, sortable: true, rowspan: 3 }, 6 { field: \'F_Password\', title: \'密码\', width: 100, sortable: true, rowspan: 3 }, 7 { title: \'多表头\', colspan: 5 } 8 ], [ 9 { field: \'F_UserNick\', title: \'昵称\', width: 100, sortable: true ,rowspan:2}, 10 { field: \'F_IdNumber\', title: \'身份证号\', width: 100, sortable: true,rowspan:2 }, 11 { title: \'多表3\', colspan: 3} 12 ], [ 13 { field: \'F_Tel\', title: \'电话\', width: 100, sortable: true }, 14 { field: \'F_BirthDate\', title: \'生日\', width: 100, sortable: true }, 15 { field: \'F_EMail\', title: \'邮箱\', width: 100, sortable: true }, 16 ] 17 @param {Array} dataOpts.HeadInfo 18 @param {Array} dataOpts.RowInfo 19 @param {object} dataOpts.EwbInfo 20 @param {int} dataOpts.RowStart 21 @param {int} dataOpts.ColumStart 22 @param {String} dataOpts.SheetName 23 ***/ 24 var JSXmlExcel = { 25 BulidXml: function (dataOpts) { 26 if (!dataOpts.SheetName) 27 dataOpts.SheetName = \'Sheet1\'; 28 var headerXml = ""; 29 var columnInfo = ""; 30 var cloumIndex = 0; 31 var rowxml = ""; 32 var ExpandedColumnCount = dataOpts.ColumStart ? dataOpts.ColumStart - 1 : 1; 33 var ExpandedRowCount = dataOpts.RowStart ? dataOpts.RowStart - 1 : 1; 34 for (var i = 0; i < dataOpts.HeadInfo.length; i++) { 35 var rowindex = dataOpts.RowStart + i; 36 headerXml += \'<Row ss:Index="\' + rowindex + \'" ss:AutoFitHeight="0">\'; 37 for (var cell = 0; cell < dataOpts.HeadInfo[i].length; cell++) { 38 var curcell = dataOpts.HeadInfo[i][cell]; 39 if (curcell.hidden) 40 continue; 41 var cellindex = dataOpts.ColumStart + cloumIndex; 42 var MergeDown = curcell.rowspan ? curcell.rowspan - 1 : 0; 43 var MergeAcross = curcell.colspan ? curcell.colspan - 1 : 0; 44 if (curcell.field) { 45 cloumIndex = cloumIndex + 1; 46 ExpandedColumnCount = ExpandedColumnCount + 1; 47 } 48 headerXml += \'<Cell ss:StyleID="TableHeadStyle" ss:Index="\' + cellindex + 49 (MergeDown === 0 ? \'\' : \'" ss:MergeDown="\' + MergeDown) + 50 (MergeAcross === 0 ? \'\' : \'" ss:MergeAcross="\' + MergeAcross) + 51 \'"><Data ss:Type="String">\' + curcell.title + \'</Data></Cell>\'; 52 } 53 headerXml += \'</Row>\'; 54 ExpandedRowCount = ExpandedRowCount + 1; 55 } 56 headerXml = columnInfo + headerXml; 57 //创建数据 58 for (var i = 0; i < dataOpts.RowInfo.length; i++) { 59 rowxml += \'<Row ss:AutoFitHeight="0">\'; 60 for (var j = 0; j < dataOpts.RowInfo[i].length; j++) { 61 var value = dataOpts.RowInfo[i][j]; 62 rowxml += \'<Cell ss:StyleID="TableHeadStyle" \' + 63 (j === 0 ? \'ss:Index="\' + dataOpts.ColumStart + \'"\' : \' \') + 64 \' ><Data ss:Type="String">\' + value + \'</Data></Cell>\' 65 } 66 rowxml += \'</Row> \'; 67 ExpandedRowCount = ExpandedRowCount + 1; 68 } 69 //创建XMl尾部信息 70 var TableHeadStyle = \'<Style ss:ID="TableHeadStyle"> \' + 71 \'<Alignment ss:Horizontal="Center" ss:Vertical="Center"/> \' + 72 \'<Borders> \' + 73 \'<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> \' + 74 \'<Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> \' + 75 \'<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> \' + 76 \'<Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> \' + 77 \'</Borders> \' + 78 \'</Style> \'; 79 var Styles = TableHeadStyle; 80 var WorkSheet = \'<Worksheet ss:Name="\' + dataOpts.SheetName + \'">\' + 81 \'<Table ss:ExpandedColumnCount="\' + ExpandedColumnCount + 82 \'" ss:ExpandedRowCount="\' + ExpandedRowCount + 83 \'" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="100" ss:DefaultRowHeight="16">\' + headerXml + rowxml + 84 \'</Table>\'; 85 var xmlInfo = \'<?xml version="1.0" encoding="utf-8"?> \' + 86 \'<?mso-application progid="Excel.Sheet"?> \' + 87 \'<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" \' + 88 \'xmlns:o="urn:schemas-microsoft-com:office:office" \' + 89 \'xmlns:x="urn:schemas-microsoft-com:office:excel" \' + 90 \'xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" \' + 91 \'xmlns:html="http://www.w3.org/TR/REC-html40"> \' + 92 \'<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> \' + 93 \'</DocumentProperties> \' + 94 \'<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> \' + 95 \'<RemovePersonalInformation/> \' + 96 \'</OfficeDocumentSettings> \' + 97 \'<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> \' + 98 \'</ExcelWorkbook><Styles> \' + Styles + \'</Styles> \' + 99 WorkSheet + \' </Worksheet></Workbook>\'; 100 return xmlInfo; 101 } 102 };
JSXmlExcel.js
有喜欢聊技术朋友也欢迎入群，若二维码失效可加我微信回复**前端**
版权声明：本文为yfrs原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。