src/main/resources/static/assets/lib/kendo/js/kendo.ooxml.min.js

(完整代码) 27KB

/** 
 * Kendo UI v2017.2.621 (http://www.telerik.com/kendo-ui)                                                                                                                                               
 * Copyright 2017 Telerik AD. All rights reserved.                                                                                                                                                      
 *                                                                                                                                                                                                      
 * Kendo UI commercial licenses may be obtained at                                                                                                                                                      
 * http://www.telerik.com/purchase/license-agreement/kendo-ui-complete                                                                                                                                  
 * If you do not own a commercial license, this file shall be governed by the trial license terms.                                                                                                      
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       
                                                                                                                                                                                                       

*/
!function(e,define){define("kendo.ooxml.min",["kendo.core.min"],e)}(function(){return function(e,t){function o(e){var t=Math.floor(e/26)-1;return(t>=0?o(t):"")+String.fromCharCode(65+e%26)}function r(e,t){return o(t)+(e+1)}function i(e,t){return o(t)+"$"+(e+1)}function l(e){var t=e.frozenRows||(e.freezePane||{}).rowSplit||1;return t-1}function n(e){return(e/7*100+.5)/100}function s(e){return.75*e}function a(e){return(e+"").replace(/[\x00-\x08]/g,"").replace(/\n/g,"\r\n")}function d(e){return e.length<6&&(e=e.replace(/(\w)/g,function(e,t){return t+t})),e=e.substring(1).toUpperCase(),e.length<8&&(e="FF"+e),e}function m(e){var t="thin";return 2===e?t="medium":3===e&&(t="thick"),t}function f(e,t){var o="";return t&&(o+="<"+e+' style="'+m(t.size)+'">',t.color&&(o+='<color rgb="'+d(t.color)+'"/>'),o+="</"+e+">"),o}function c(e){return"<border>"+f("left",e.left)+f("right",e.right)+f("top",e.top)+f("bottom",e.bottom)+"</border>"}function p(e,t){var o,r,i,l=[],n=[];for(h(e,function(e,t){var o={_source:e,index:t,height:e.height,cells:[]};l.push(o),n[t]=o}),o=u(l).slice(0),r={rowData:l,rowsByIndex:n,mergedCells:t},i=0;i<o.length;i++)v(o[i],r),delete o[i]._source;return u(l)}function h(e,t){var o,r,i;for(o=0;o<e.length;o++)r=e[o],r&&(i=r.index,"number"!=typeof i&&(i=o),t(r,i))}function u(e){return e.sort(function(e,t){return e.index-t.index})}function g(e,t){e.indexOf(t)<0&&e.push(t)}function x(e,t){var o,r,i,l;for(t=t,o=0;o<e.length;++o)if(r=e[o],i=r.substr(0,2),i==t)return l=r.substr(3),i=y(i),l=y(l),{rowSpan:l.row-i.row+1,colSpan:l.col-i.col+1}}function y(e){function t(e){e=e.toUpperCase();for(var t=0,o=0;o<e.length;++o)t=26*t+e.charCodeAt(o)-64;return t-1}function o(e){return parseInt(e,10)-1}var r=/^([a-z]+)(\d+)$/i.exec(e);return{row:o(r[2]),col:t(r[1])}}function v(e,t){var o,i,l,n,s,a,d,m,f,c=e._source,p=e.index,h=c.cells,u=e.cells;if(h)for(o=0;o<h.length;o++)if(i=h[o]||V,l=i.rowSpan||1,n=i.colSpan||1,s=w(u,i),a=r(p,s),1==l&&1==n&&(d=x(t.mergedCells,a),d&&(n=d.colSpan,l=d.rowSpan)),T(i,u,s,n),(l>1||n>1)&&g(t.mergedCells,a+":"+r(p+l-1,s+n-1)),l>1)for(m=p+1;m<p+l;m++)f=t.rowsByIndex[m],f||(f=t.rowsByIndex[m]={index:m,cells:[]},t.rowData.push(f)),T(i,f.cells,s-1,n+1)}function w(e,t){var o;return"number"==typeof t.index?(o=t.index,b(e,t,t.index)):o=k(e,t),o}function b(e,t,o){e[o]=t}function k(e,t){var o,r=e.length;for(o=0;o<e.length+1;o++)if(!e[o]){e[o]=t,r=o;break}return r}function T(e,t,o,r){var i,l;for(i=1;i<r;i++)l={borderTop:e.borderTop,borderRight:e.borderRight,borderBottom:e.borderBottom,borderLeft:e.borderLeft},b(t,l,o+i)}function $(e){return W({ref:e.ref,columns:e.columns,generators:{custom:B,dynamic:U,top:H,value:X}})}var I='<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml"/><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties" Target="docProps/core.xml"/><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/></Relationships>',S=t.template('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n<cp:coreProperties xmlns:cp="http://schemas.openxmlformats.org/package/2006/metadata/core-properties" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dcmitype="http://purl.org/dc/dcmitype/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><dc:creator>${creator}</dc:creator><cp:lastModifiedBy>${lastModifiedBy}</cp:lastModifiedBy><dcterms:created xsi:type="dcterms:W3CDTF">${created}</dcterms:created><dcterms:modified xsi:type="dcterms:W3CDTF">${modified}</dcterms:modified></cp:coreProperties>'),C=t.template('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n<Properties xmlns="http://schemas.openxmlformats.org/officeDocument/2006/extended-properties" xmlns:vt="http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"><Application>Microsoft Excel</Application><DocSecurity>0</DocSecurity><ScaleCrop>false</ScaleCrop><HeadingPairs><vt:vector size="2" baseType="variant"><vt:variant><vt:lpstr>Worksheets</vt:lpstr></vt:variant><vt:variant><vt:i4>${sheets.length}</vt:i4></vt:variant></vt:vector></HeadingPairs><TitlesOfParts><vt:vector size="${sheets.length}" baseType="lpstr"># for (var idx = 0; idx < sheets.length; idx++) { ## if (sheets[idx].options.title) { #<vt:lpstr>${sheets[idx].options.title}</vt:lpstr># } else { #<vt:lpstr>Sheet${idx+1}</vt:lpstr># } ## } #</vt:vector></TitlesOfParts><LinksUpToDate>false</LinksUpToDate><SharedDoc>false</SharedDoc><HyperlinksChanged>false</HyperlinksChanged><AppVersion>14.0300</AppVersion></Properties>'),_=t.template('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types"><Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml" /><Default Extension="xml" ContentType="application/xml" /><Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" /><Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml"/><Override PartName="/xl/sharedStrings.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml"/># for (var idx = 1; idx <= count; idx++) { #<Override PartName="/xl/worksheets/sheet${idx}.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" /># } #<Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml" /><Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml" /></Types>'),F=t.template('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><fileVersion appName="xl" lastEdited="5" lowestEdited="5" rupBuild="9303" /><workbookPr defaultThemeVersion="124226" /><bookViews><workbookView xWindow="240" yWindow="45" windowWidth="18195" windowHeight="7995" /></bookViews><sheets># for (var idx = 0; idx < sheets.length; idx++) { ## var options = sheets[idx].options; ## var name = options.name || options.title ## if (name) { #<sheet name="${name}" sheetId="${idx+1}" r:id="rId${idx+1}" /># } else { #<sheet name="Sheet${idx+1}" sheetId="${idx+1}" r:id="rId${idx+1}" /># } ## } #</sheets># if (filterNames.length || userNames.length) { #<definedNames> # for (var di = 0; di < filterNames.length; di++) { #<definedName name="_xlnm._FilterDatabase" hidden="1" localSheetId="${filterNames[di].localSheetId}">${filterNames[di].name}!$${filterNames[di].from}:$${filterNames[di].to}</definedName> # } # # for (var i = 0; i < userNames.length; ++i) { #<definedName name="${userNames[i].name}" hidden="${userNames[i].hidden ? 1 : 0}" # if (userNames[i].localSheetId != null) { # localSheetId="${userNames[i].localSheetId}" # } #>${userNames[i].value}</definedName> # } #</definedNames># } #<calcPr fullCalcOnLoad="1" calcId="145621" /></workbook>'),D=t.template('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac"><dimension ref="A1" /><sheetViews><sheetView #if(index==0) {# tabSelected="1" #}# workbookViewId="0" #if (showGridLines === false) {# showGridLines="0" #}#># if (frozenRows || frozenColumns) { #<pane state="frozen"# if (frozenColumns) { # xSplit="${frozenColumns}"# } ## if (frozenRows) { # ySplit="${frozenRows}"# } # topLeftCell="${String.fromCharCode(65 + (frozenColumns || 0))}${(frozenRows || 0)+1}"/># } #</sheetView></sheetViews><sheetFormatPr x14ac:dyDescent="0.25" defaultRowHeight="#= defaults.rowHeight ? defaults.rowHeight * 0.75 : 15 #" # if (defaults.columnWidth) { # defaultColWidth="#= kendo.ooxml.toWidth(defaults.columnWidth) #" # } # /># if (defaultCellStyleId != null || (columns && columns.length > 0)) { #<cols># if (!columns || !columns.length) { #<col min="1" max="16384" style="${defaultCellStyleId}" # if (defaults.columnWidth) { # width="#= kendo.ooxml.toWidth(defaults.columnWidth) #" # } # /># } ## for (var ci = 0; ci < columns.length; ci++) { ## var column = columns[ci]; ## var columnIndex = typeof column.index === "number" ? column.index + 1 : (ci + 1); ## if (column.width === 0) { #<col #if(defaultCellStyleId!=null){# style="${defaultCellStyleId}" #}#min="${columnIndex}" max="${columnIndex}" hidden="1" customWidth="1" /># } else if (column.width) { #<col #if(defaultCellStyleId!=null){# style="${defaultCellStyleId}" #}#min="${columnIndex}" max="${columnIndex}" customWidth="1"# if (column.autoWidth) { # width="${((column.width*7+5)/7*256)/256}" bestFit="1"# } else { # width="#= kendo.ooxml.toWidth(column.width) #" # } #/># } ## } #</cols># } #<sheetData># for (var ri = 0; ri < data.length; ri++) { ## var row = data[ri]; ## var rowIndex = typeof row.index === "number" ? row.index + 1 : (ri + 1); #<row r="${rowIndex}" x14ac:dyDescent="0.25" # if (row.height === 0) { # hidden="1" # }   else if (row.height) { # ht="#= kendo.ooxml.toHeight(row.height) #" customHeight="1" # } # ># for (var ci = 0; ci < row.data.length; ci++) { ## var cell = row.data[ci];#<c r="#=cell.ref#"# if (cell.style) { # s="#=cell.style#" # } ## if (cell.type) { # t="#=cell.type#"# } #># if (cell.formula != null) { #<f>${cell.formula}</f># } ## if (cell.value != null) { #<v>${cell.value}</v># } #</c># } #</row># } #</sheetData># if (autoFilter) { #<autoFilter ref="${autoFilter.from}:${autoFilter.to}"/># } else if (filter) { ##= kendo.ooxml.spreadsheetFilters(filter) ## } ## if (mergeCells.length) { #<mergeCells count="${mergeCells.length}"># for (var ci = 0; ci < mergeCells.length; ci++) { #<mergeCell ref="${mergeCells[ci]}"/># } #</mergeCells># } ## if (validations.length) { #<dataValidations># for (var vi = 0; vi < validations.length; vi++) { ## var val = validations[vi]; #<dataValidation sqref="#= val.sqref.join(" ") #" showErrorMessage="#= val.showErrorMessage #" type="#= val.type #"# if (val.type != "list") {# operator="#= val.operator #" # } # allowBlank="#= val.allowBlank #" showDropDown="#= val.showDropDown #"# if (val.error) {# error="#= val.error #" # } ## if (val.errorTitle) {# errorTitle="#= val.errorTitle #" # } #># if (val.formula1) { #<formula1>#: val.formula1 #</formula1># } ## if (val.formula2) { #<formula2>#: val.formula2 #</formula2># } #</dataValidation># } #</dataValidations># } ## if (hyperlinks.length) { #<hyperlinks># for (var hi = 0; hi < hyperlinks.length; hi++) { #<hyperlink ref="${hyperlinks[hi].ref}" r:id="rId${hi}"/># } #</hyperlinks># } #<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3" /></worksheet>'),N=t.template('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"># for (var idx = 1; idx <= count; idx++) { #<Relationship Id="rId${idx}" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet${idx}.xml" /># } #<Relationship Id="rId${count+1}" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml" /><Relationship Id="rId${count+2}" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings" Target="sharedStrings.xml" /></Relationships>'),M=t.template('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"># for (var i = 0; i < hyperlinks.length; i++) { #<Relationship Id="rId${i}" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink" Target="${hyperlinks[i].target}" TargetMode="External" /># } #</Relationships>'),A=t.template('<?xml version="1.0" encoding="UTF-8" standalone="yes"?>\r\n<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="${count}" uniqueCount="${uniqueCount}"># for (var index in indexes) { #<si><t>${index.substring(1)}</t></si># } #</sst>'),P=t.template('<?xml version="1.0" encoding="UTF-8"?><styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><numFmts count="${formats.length}"># for (var fi = 0; fi < formats.length; fi++) { ## var format = formats[fi]; #<numFmt formatCode="${format.format}" numFmtId="${165+fi}" /># } #</numFmts><fonts count="${fonts.length+1}" x14ac:knownFonts="1"><font><sz val="11" /><color theme="1" /><name val="Calibri" /><family val="2" /><scheme val="minor" /></font># for (var fi = 0; fi < fonts.length; fi++) { ## var font = fonts[fi]; #<font># if (font.fontSize) { #<sz val="${font.fontSize}" /># } else { #<sz val="11" /># } ## if (font.bold) { #<b/># } ## if (font.italic) { #<i/># } ## if (font.underline) { #<u/># } ## if (font.color) { #<color rgb="${font.color}" /># } else { #<color theme="1" /># } ## if (font.fontFamily) { #<name val="${font.fontFamily}" /><family val="2" /># } else { #<name val="Calibri" /><family val="2" /><scheme val="minor" /># } #</font># } #</fonts><fills count="${fills.length+2}"><fill><patternFill patternType="none"/></fill><fill><patternFill patternType="gray125"/></fill># for (var fi = 0; fi < fills.length; fi++) { ## var fill = fills[fi]; ## if (fill.background) { #<fill><patternFill patternType="solid"><fgColor rgb="${fill.background}"/></patternFill></fill># } ## } #</fills><borders count="${borders.length+1}"><border><left/><right/><top/><bottom/><diagonal/></border># for (var bi = 0; bi < borders.length; bi++) { ##= kendo.ooxml.borderTemplate(borders[bi]) ## } #</borders><cellStyleXfs count="1"><xf borderId="0" fillId="0" fontId="0" /></cellStyleXfs><cellXfs count="${styles.length+1}"><xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0"/># for (var si = 0; si < styles.length; si++) { ## var style = styles[si]; #<xf xfId="0"# if (style.fontId) { # fontId="${style.fontId}" applyFont="1"# } ## if (style.fillId) { # fillId="${style.fillId}" applyFill="1"# } ## if (style.numFmtId) { # numFmtId="${style.numFmtId}" applyNumberFormat="1"# } ## if (style.textAlign || style.verticalAlign || style.wrap) { # applyAlignment="1"# } ## if (style.borderId) { # borderId="${style.borderId}" applyBorder="1"# } #># if (style.textAlign || style.verticalAlign || style.wrap) { #<alignment# if (style.textAlign) { # horizontal="${style.textAlign}"# } ## if (style.verticalAlign) { # vertical="${style.verticalAlign}"# } ## if (style.wrap) { # wrapText="1"# } #/># } #</xf># } #</cellXfs><cellStyles count="1"><cellStyle name="Normal" xfId="0" builtinId="0"/></cellStyles><dxfs count="0" /><tableStyles count="0" defaultTableStyle="TableStyleMedium2" defaultPivotStyle="PivotStyleMedium9" /></styleSheet>'),z=new Date(1900,0,0),R=t.Class.extend({init:function(e,t,o,r){this.options=e,this._strings=t,this._styles=o,this._borders=r,this._validations={}},relsToXML:function(){var e=this.options.hyperlinks||[];return e.length?M({hyperlinks:e}):""},toXML:function(e){var t,o,i,n,s,a,d=this.options.mergedCells||[],m=this.options.rows||[],f=p(m,d);this._readCells(f),t=this.options.filter,t&&"number"==typeof t.from&&"number"==typeof t.to?t={from:r(l(this.options),t.from),to:r(l(this.options),t.to)}:t&&t.ref&&t.columns&&(o=t,t=null),i=[];for(n in this._validations)Object.prototype.hasOwnProperty.call(this._validations,n)&&i.push(this._validations[n]);return s=null,this.options.defaultCellStyle&&(s=this._lookupStyle(this.options.defaultCellStyle)),a=this.options.freezePane||{},D({frozenColumns:this.options.frozenColumns||a.colSplit,frozenRows:this.options.frozenRows||a.rowSplit,columns:this.options.columns,defaults:this.options.defaults||{},data:f,index:e,mergeCells:d,autoFilter:t,filter:o,showGridLines:this.options.showGridLines,hyperlinks:this.options.hyperlinks||[],validations:i,defaultCellStyleId:s})},_lookupString:function(e){var t="$"+e,o=this._strings.indexes[t];return void 0!==o?e=o:(e=this._strings.indexes[t]=this._strings.uniqueCount,this._strings.uniqueCount++),this._strings.count++,e},_lookupStyle:function(o){var r,i=t.stringify(o);return"{}"==i?0:(r=e.inArray(i,this._styles),r<0&&(r=this._styles.push(i)-1),r+1)},_lookupBorder:function(o){var r,i=t.stringify(o);if("{}"!=i)return r=e.inArray(i,this._borders),r<0&&(r=this._borders.push(i)-1),r+1},_readCells:function(e){var t,o,r,i,l;for(t=0;t<e.length;t++)for(o=e[t],r=o.cells,o.data=[],i=0;i<r.length;i++)l=this._cell(r[i],o.index,i),l&&o.data.push(l)},_cell:function(e,o,i){var l,n,s,d,m,f,c,p,h,u;return e&&e!==V?(l=e.value,n={},e.borderLeft&&(n.left=e.borderLeft),e.borderRight&&(n.right=e.borderRight),e.borderTop&&(n.top=e.borderTop),e.borderBottom&&(n.bottom=e.borderBottom),n=this._lookupBorder(n),s=this.options.defaultCellStyle||{},d={borderId:n},function(e){e("color"),e("background"),e("bold"),e("italic"),e("underline"),e("fontFamily")||e("fontName","fontFamily"),e("fontSize"),e("format"),e("textAlign")||e("hAlign","textAlign"),e("verticalAlign")||e("vAlign","verticalAlign"),e("wrap")}(function(t,o){var r=e[t];if(void 0===r&&(r=s[t]),void 0!==r)return d[o||t]=r,!0}),m=this.options.columns||[],f=m[i],c=typeof l,f&&f.autoWidth&&(p=l,"number"===c&&(p=t.toString(l,e.format)),f.width=Math.max(f.width||0,(p+"").length)),"string"===c?(l=a(l),l=this._lookupString(l),c="s"):"number"===c?c="n":"boolean"===c?(c="b",l=+l):l&&l.getTime?(c=null,h=(l.getTimezoneOffset()-z.getTimezoneOffset())*t.date.MS_PER_MINUTE,l=(l-z-h)/t.date.MS_PER_DAY+1,d.format||(d.format="mm-dd-yy")):(c=null,l=null),d=this._lookupStyle(d),u=r(o,i),e.validation&&this._addValidation(e.validation,u),{value:l,formula:e.formula,type:c,style:d,ref:u}):null},_addValidation:function(e,t){var o={showErrorMessage:"reject"==e.type?1:0,formula1:e.from,formula2:e.to,type:q[e.dataType]||e.dataType,operator:E[e.comparerType]||e.comparerType,allowBlank:e.allowNulls?1:0,showDropDown:e.showButton?0:1,error:e.messageTemplate,errorTitle:e.titleTemplate},r=JSON.stringify(o);this._validations[r]||(this._validations[r]=o,o.sqref=[]),this._validations[r].sqref.push(t)}}),E={greaterThanOrEqualTo:"greaterThanOrEqual",lessThanOrEqualTo:"lessThanOrEqual"},q={number:"decimal"},O={General:0,0:1,"0.00":2,"#,##0":3,"#,##0.00":4,"0%":9,"0.00%":10,"0.00E+00":11,"# ?/?":12,"# ??/??":13,"mm-dd-yy":14,"d-mmm-yy":15,"d-mmm":16,"mmm-yy":17,"h:mm AM/PM":18,"h:mm:ss AM/PM":19,"h:mm":20,"h:mm:ss":21,"m/d/yy h:mm":22,"#,##0 ;(#,##0)":37,"#,##0 ;[Red](#,##0)":38,"#,##0.00;(#,##0.00)":39,"#,##0.00;[Red](#,##0.00)":40,"mm:ss":45,"[h]:mm:ss":46,"mmss.0":47,"##0.0E+0":48,"@":49,"[$-404]e/m/d":27,"m/d/yy":30,t0:59,"t0.00":60,"t#,##0":61,"t#,##0.00":62,"t0%":67,"t0.00%":68,"t# ?/?":69,"t# ??/??":70},L=t.Class.extend({init:function(t){this.options=t||{},this._strings={indexes:{},count:0,uniqueCount:0},this._styles=[],this._borders=[],this._sheets=e.map(this.options.sheets||[],e.proxy(function(e){return e.defaults=this.options,new R(e,this._strings,this._styles,this._borders)},this))},toDataURL:function(){var o,r,n,s,a,m,f,c,p,h,u,g,x,y,v,w,b,k,T;if("undefined"==typeof JSZip)throw Error("JSZip not found. Check http://docs.telerik.com/kendo-ui/framework/excel/introduction#requirements for more details.");for(o=new JSZip,r=o.folder("docProps"),r.file("core.xml",S({creator:this.options.creator||"Kendo UI",lastModifiedBy:this.options.creator||"Kendo UI",created:this.options.date||(new Date).toJSON(),modified:this.options.date||(new Date).toJSON()})),n=this._sheets.length,r.file("app.xml",C({sheets:this._sheets})),s=o.folder("_rels"),s.file(".rels",I),a=o.folder("xl"),m=a.folder("_rels"),m.file("workbook.xml.rels",N({count:n})),f={},a.file("workbook.xml",F({sheets:this._sheets,filterNames:e.map(this._sheets,function(e,t){var o,r=e.options,n=r.name||r.title||"Sheet"+(t+1);if(f[n.toLowerCase()]=t,o=r.filter,o&&void 0!==o.from&&void 0!==o.to)return{localSheetId:t,name:n,from:i(l(r),o.from),to:i(l(r),o.to)}}),userNames:e.map(this.options.names||[],function(e){return{name:e.localName,localSheetId:e.sheet?f[e.sheet.toLowerCase()]:null,value:e.value,hidden:e.hidden}})})),c=a.folder("worksheets"),p=c.folder("_rels"),h=0;h<n;h++)u=this._sheets[h],g=t.format("sheet{0}.xml",h+1),x=u.relsToXML(),x&&p.file(g+".rels",x),c.file(g,u.toXML(h));return y=e.map(this._borders,e.parseJSON),v=e.map(this._styles,e.parseJSON),w=function(e){return e.underline||e.bold||e.italic||e.color||e.fontFamily||e.fontSize},b=e.map(v,function(e){if(e.color&&(e.color=d(e.color)),w(e))return e}),k=e.map(v,function(e){if(e.format&&void 0===O[e.format])return e}),T=e.map(v,function(e){if(e.background)return e.background=d(e.background),e}),a.file("styles.xml",P({fonts:b,fills:T,formats:k,borders:y,styles:e.map(v,function(t){var o={};return w(t)&&(o.fontId=e.inArray(t,b)+1),t.background&&(o.fillId=e.inArray(t,T)+2),o.textAlign=t.textAlign,o.verticalAlign=t.verticalAlign,o.wrap=t.wrap,o.borderId=t.borderId,t.format&&(o.numFmtId=void 0!==O[t.format]?O[t.format]:165+e.inArray(t,k)),o})})),a.file("sharedStrings.xml",A(this._strings)),o.file("[Content_Types].xml",_({count:n})),"data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,"+o.generate({compression:"DEFLATE"})}}),V={},W=t.template('<autoFilter ref="${ref}"># for (var i = 0; i < columns.length; ++i) { ## var col = columns[i]; #<filterColumn colId="${col.index}">#= generators[col.filter](col) #</filterColumn># } #</autoFilter>'),B=t.template('<customFilters# if (logic == "and") {# and="1"# } #># for (var i = 0; i < criteria.length; ++i) { ## var f = criteria[i]; ## var op = kendo.ooxml.spreadsheetFilters.customOperator(f); ## var val = kendo.ooxml.spreadsheetFilters.customValue(f); #<customFilter# if (op) {# operator="${op}"#}# val="${val}"/># } #</customFilters>'),U=t.template('<dynamicFilter type="${kendo.ooxml.spreadsheetFilters.dynamicFilterType(type)}" />'),H=t.template('<top10 percent="#= /percent$/i.test(type) ? 1 : 0 #" top="#= /^top/i.test(type) ? 1 : 0 #"  val="#: value #" />'),X=t.template('<filters# if (blanks) {# blank="1"#}#># for (var i = 0; i < values.length; ++i) { #<filter val="${values[i]}" /># } #</filters>');$.customOperator=function(e){return{eq:"equal",gt:"greaterThan",gte:"greaterThanOrEqual",lt:"lessThan",lte:"lessThanOrEqual",ne:"notEqual",doesnotstartwith:"notEqual",doesnotendwith:"notEqual",doesnotcontain:"notEqual",doesnotmatch:"notEqual"}[e.operator.toLowerCase()]},$.customValue=function(e){function t(e){return e.replace(/([*?])/g,"~$1")}switch(e.operator.toLowerCase()){case"startswith":case"doesnotstartwith":return t(e.value)+"*";case"endswith":case"doesnotendwith":return"*"+t(e.value);case"contains":case"doesnotcontain":return"*"+t(e.value)+"*"}return e.value},$.dynamicFilterType=function(e){return{quarter1:"Q1",quarter2:"Q2",quarter3:"Q3",quarter4:"Q4",january:"M1",february:"M2",march:"M3",april:"M4",may:"M5",june:"M6",july:"M7",august:"M8",september:"M9",october:"M10",november:"M11",december:"M12"}[e.toLowerCase()]||e},t.ooxml={Workbook:L,Worksheet:R,toWidth:n,toHeight:s,borderTemplate:c,spreadsheetFilters:$}}(kendo.jQuery,kendo),kendo},"function"==typeof define&&define.amd?define:function(e,t,o){(o||t)()});
//# sourceMappingURL=kendo.ooxml.min.js.map

24 小时内免费解锁 3 个项目,之后 1 积分/个。 规则说明

AI 解读

登录后可用,每次 10 积分,解读结果公开显示在下面。

还没有人解读过这个文件。