{"id":165,"date":"2022-06-29T10:24:02","date_gmt":"2022-06-29T02:24:02","guid":{"rendered":"http:\/\/yanzhenhua.top\/?p=165"},"modified":"2022-06-29T10:24:02","modified_gmt":"2022-06-29T02:24:02","slug":"vue%e5%89%8d%e7%ab%afexcel%e5%af%bc%e5%87%ba%ef%bc%9axlsx","status":"publish","type":"post","link":"http:\/\/yanzhenhua.top\/?p=165","title":{"rendered":"vue\u524d\u7aefexcel\u5bfc\u51fa\uff1axlsx"},"content":{"rendered":"

xlsx-style \u884c\u9ad8\u8bbe\u7f6e<\/span><\/h1>\n

!rows\uff0cxlsx-style\u6ca1\u6709\u63d0\u4f9b\u8fd9\u4e2a\u529f\u80fd\uff0c\u4f46\u662fxlsx\u6709\u8fd9\u4e2a\u529f\u80fd\uff0c\u6240\u4ee5\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u65b9\u6cd5\u6709<\/span><\/p>\n

\u6b65\u9aa4\uff1a<\/span><\/h5>\n
    \n
  1. \n

    \u4f7f\u7528\u9759\u6001\u6587\u4ef6\u66ff\u4ee3import<\/span>\u00a0<\/span>\uff081\uff09\u5c06node_modules\u91cc\u7684xlsx-style\u7684\u6587\u4ef6\u5939\u4e0b\u7684<\/span>\u00a0<\/span>xlsx.core.min.js\u62ff\u51fa\u6765\u653e\u5728\u9759\u6001\u6587\u4ef6\u653e\u7f6e\u7684\u6587\u4ef6\u5939\u4e0b<\/span>\u00a0<\/span>\uff082\uff09index.html\u4e2d\u5f15\u5165<\/span><\/p>\n<\/li>\n<\/ol>\n

     \u00a0 \u00a0<<\/span>script<\/span> src<\/span>=\"<%= BASE_URL %>cdn\/xlsx-style\/xlsx.core.min.js\"<\/span> charset<\/span>=\"utf-8\"<\/span>><\/<\/span>script<\/span>><\/span><\/pre>\n
    \uff083\uff09\u5220\u9664import xlsxstyle\u4ee3\u7801<\/span><\/p>\n
    2.\u4fee\u6539xlsx.core.min.js<\/span><\/p>\n
    \u4f4d\u7f6e\uff1a<\/span>\u00a0<\/span>write_ws_xml_data<\/span><\/p>\n
    \u5b8c\u6574\u7248\u4ee3\u7801\u5982\u4e0b\uff1a<\/span><\/p>\n
    var<\/span> DEF_PPI<\/span> =<\/span> 96<\/span>, PPI<\/span> =<\/span> DEF_PPI<\/span>;\r\nfunction<\/span> px2pt<\/span>(px<\/span>) { return<\/span> px<\/span> *<\/span> 96<\/span> \/<\/span> PPI<\/span>; }\r\nfunction<\/span> pt2px<\/span>(pt<\/span>) { return<\/span> pt<\/span> *<\/span> PPI<\/span> \/<\/span> 96<\/span>; }\r\nfunction<\/span> write_ws_xml_data<\/span>(ws<\/span>, opts<\/span>, idx<\/span>, wb<\/span>) {\r\n \u00a0var<\/span> o<\/span> =<\/span> [], r<\/span> =<\/span> [], range<\/span> =<\/span> safe_decode_range<\/span>(ws<\/span>['!ref'<\/span>]), cell<\/span>=<\/span>\"\"<\/span>, ref<\/span>, rr<\/span> =<\/span> \"\"<\/span>, cols<\/span> =<\/span> [], R<\/span>=<\/span>0<\/span>, C<\/span>=<\/span>0<\/span>, rows<\/span> =<\/span> ws<\/span>['!rows'<\/span>];\r\n \u00a0var<\/span> dense<\/span> =<\/span> Array<\/span>.isArray<\/span>(ws<\/span>);\r\n \u00a0var<\/span> params<\/span> =<\/span> ({r<\/span>:rr<\/span>}), row<\/span>, height<\/span> =<\/span> -<\/span>1<\/span>;\r\n \u00a0for<\/span>(C<\/span> =<\/span> range<\/span>.s<\/span>.c<\/span>; C<\/span> <=<\/span> range<\/span>.e<\/span>.c<\/span>; ++<\/span>C<\/span>) cols<\/span>[C<\/span>] =<\/span> encode_col<\/span>(C<\/span>);\r\n \u00a0for<\/span>(R<\/span> =<\/span> range<\/span>.s<\/span>.r<\/span>; R<\/span> <=<\/span> range<\/span>.e<\/span>.r<\/span>; ++<\/span>R<\/span>) {\r\n \u00a0 \u00a0r<\/span> =<\/span> [];\r\n \u00a0 \u00a0rr<\/span> =<\/span> encode_row<\/span>(R<\/span>);\r\n \u00a0 \u00a0for<\/span>(C<\/span> =<\/span> range<\/span>.s<\/span>.c<\/span>; C<\/span> <=<\/span> range<\/span>.e<\/span>.c<\/span>; ++<\/span>C<\/span>) {\r\n \u00a0 \u00a0 \u00a0ref<\/span> =<\/span> cols<\/span>[C<\/span>] +<\/span> rr<\/span>;\r\n \u00a0 \u00a0 \u00a0var<\/span> _cell<\/span> =<\/span> dense<\/span> ?<\/span> (ws<\/span>[R<\/span>]||<\/span>[])[C<\/span>]: ws<\/span>[ref<\/span>];\r\n \u00a0 \u00a0 \u00a0if<\/span>(_cell<\/span> ===<\/span> undefined<\/span>) continue<\/span>;\r\n \u00a0 \u00a0 \u00a0if<\/span>((cell<\/span> =<\/span> write_ws_xml_cell<\/span>(_cell<\/span>, ref<\/span>, ws<\/span>, opts<\/span>, idx<\/span>, wb<\/span>)) !=<\/span> null<\/span>) r<\/span>.push<\/span>(cell<\/span>);\r\n \u00a0 }\r\n \u00a0 \u00a0if<\/span>(r<\/span>.length<\/span> ><\/span> 0<\/span> ||<\/span> (rows<\/span> &&<\/span> rows<\/span>[R<\/span>])) {\r\n \u00a0 \u00a0 \u00a0params<\/span> =<\/span> ({r<\/span>:rr<\/span>});\r\n \u00a0 \u00a0 \u00a0if<\/span>(rows<\/span> &&<\/span> rows<\/span>[R<\/span>]) {\r\n \u00a0 \u00a0 \u00a0 \u00a0row<\/span> =<\/span> rows<\/span>[R<\/span>];\r\n \u00a0 \u00a0 \u00a0 \u00a0if<\/span>(row<\/span>.hidden<\/span>) params<\/span>.hidden<\/span> =<\/span> 1<\/span>;\r\n \u00a0 \u00a0 \u00a0 \u00a0height<\/span> =<\/span> -<\/span>1<\/span>;\r\n \u00a0 \u00a0 \u00a0 \u00a0if<\/span> (row<\/span>.hpx<\/span>) height<\/span> =<\/span> px2pt<\/span>(row<\/span>.hpx<\/span>);\r\n \u00a0 \u00a0 \u00a0 \u00a0else<\/span> if<\/span> (row<\/span>.hpt<\/span>) height<\/span> =<\/span> row<\/span>.hpt<\/span>;\r\n \u00a0 \u00a0 \u00a0 \u00a0if<\/span> (height<\/span> ><\/span> -<\/span>1<\/span>) { params<\/span>.ht<\/span> =<\/span> height<\/span>; params<\/span>.customHeight<\/span> =<\/span> 1<\/span>; }\r\n \u00a0 \u00a0 \u00a0 \u00a0if<\/span> (row<\/span>.level<\/span>) { params<\/span>.outlineLevel<\/span> =<\/span> row<\/span>.level<\/span>; }\r\n \u00a0 \u00a0 }\r\n \u00a0 \u00a0 \u00a0o<\/span>[o<\/span>.length<\/span>] =<\/span> (writextag<\/span>('row'<\/span>, r<\/span>.join<\/span>(\"\"<\/span>), params<\/span>));\r\n \u00a0 }\r\n }\r\n \u00a0if<\/span>(rows<\/span>) for<\/span>(; R<\/span> <<\/span> rows<\/span>.length<\/span>; ++<\/span>R<\/span>) {\r\n \u00a0 \u00a0if<\/span>(rows<\/span> &&<\/span> rows<\/span>[R<\/span>]) {\r\n \u00a0 \u00a0 \u00a0params<\/span> =<\/span> ({r<\/span>:R<\/span>+<\/span>1<\/span>});\r\n \u00a0 \u00a0 \u00a0row<\/span> =<\/span> rows<\/span>[R<\/span>];\r\n \u00a0 \u00a0 \u00a0if<\/span>(row<\/span>.hidden<\/span>) params<\/span>.hidden<\/span> =<\/span> 1<\/span>;\r\n \u00a0 \u00a0 \u00a0height<\/span> =<\/span> -<\/span>1<\/span>;\r\n \u00a0 \u00a0 \u00a0if<\/span> (row<\/span>.hpx<\/span>) height<\/span> =<\/span> px2pt<\/span>(row<\/span>.hpx<\/span>);\r\n \u00a0 \u00a0 \u00a0else<\/span> if<\/span> (row<\/span>.hpt<\/span>) height<\/span> =<\/span> row<\/span>.hpt<\/span>;\r\n \u00a0 \u00a0 \u00a0if<\/span> (height<\/span> ><\/span> -<\/span>1<\/span>) { params<\/span>.ht<\/span> =<\/span> height<\/span>; params<\/span>.customHeight<\/span> =<\/span> 1<\/span>; }\r\n \u00a0 \u00a0 \u00a0if<\/span> (row<\/span>.level<\/span>) { params<\/span>.outlineLevel<\/span> =<\/span> row<\/span>.level<\/span>; }\r\n \u00a0 \u00a0 \u00a0o<\/span>[o<\/span>.length<\/span>] =<\/span> (writextag<\/span>('row'<\/span>, \"\"<\/span>, params<\/span>));\r\n \u00a0 }\r\n }\r\n \u00a0return<\/span> o<\/span>.join<\/span>(\"\"<\/span>);\r\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"
    xlsx-style \u884c\u9ad8\u8bbe\u7f6e !rows\uff0cxlsx-style\u6ca1\u6709\u63d0\u4f9b\u8fd9\u4e2a\u529f\u80fd\uff0c\u4f46\u662fxlsx\u6709\u8fd9\u4e2a… \u7ee7\u7eed\u9605\u8bfb vue\u524d\u7aefexcel\u5bfc\u51fa\uff1axlsx<\/span><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":{"0":"post-165","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-vue","7":"h-entry","9":"h-as-article"},"_links":{"self":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts\/165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=165"}],"version-history":[{"count":1,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts\/165\/revisions"}],"predecessor-version":[{"id":166,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=\/wp\/v2\/posts\/165\/revisions\/166"}],"wp:attachment":[{"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=165"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/yanzhenhua.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}