1500字范文,内容丰富有趣,写作好帮手!
1500字范文 > 「Vue To Words」 - 教你在Vue项目中导出Word文档(包含表格合并 图片修改大小)

「Vue To Words」 - 教你在Vue项目中导出Word文档(包含表格合并 图片修改大小)

时间:2019-04-11 14:51:07

相关推荐

「Vue To Words」 - 教你在Vue项目中导出Word文档(包含表格合并 图片修改大小)

前言:最近在项目中遇到了,vue页面需要导出word文档,今日就进行记录一下,如有不对的地方,还请见谅 ^^

简单说一下需求:需要导出的页面是表格页面,因为包含表格的嵌套和合并,其实最主要的就是导出页面需要进行表格合并。

项目需求:

起初使用的常规的方法:docxtemplater配合file-saver和jszip,并且使用wps进行定义word模板,同时在word模板使用{data}占位符进行渲染(具体不细说),这种方式打出的word不符合要求,具体是的可以参考官网的示例,Demo of Docxtemplater with all modules active | docxtemplater

docxtemplater方式导出:

导出的word不符合要求,数据是一对多,又没有添加边框,所以就造成了这种又大量的留白区域,即便添加了表格,只有一条数据的时候也会出现大量的留白区域,不符合需求;

官网其实也有是实现表格的方式‘docxtemplater-table-module’比较头疼的就是需要付费使用,所以就换了另一种方式进行导出word;

官网案例:

具体方法:那就是利用html片段进行导出word

使用html片段导出的word,可以有表格合并,而且可以将页面的图片也进行导出,具体我们看一下效果:

不知道为啥图片违规了,之前的图片也找不到,没办法贴图片了,可以多试试看

这种导出的方式:是没有样式的的,如何需要样式,可以自己进行定义,同时使用这种方式有甚多的限制,许多的css样式不能够进行生效,比如一些:定位,弹性盒,浮动,等等,基本只能使用一下文本样式,

使用方法:

使用的时候需要引入jqurey,和file-saver(千万不要忘记npm下载)

import $ from 'jquery'import {saveAs} from "file-saver";

一般使用的方式就是在新建一个js文件,讲一下代码复制到页面,并将js文件引入到需要导出word的页面;

import $ from 'jquery'import {saveAs} from "file-saver";let rules=`.wl_table .all {background: #fff !important;}`if (typeof $ !== 'undefined' && typeof saveAs !== 'undefined') {;(function($) {$.fn.wordExport = function(fileName) {fileName = typeof fileName !== 'undefined' ? fileName : 'jQuery-Word-Export'var statics = {mhtml: { top: "Mime-Version: 1.0\nContent-Base: " + location.href + "\nContent-Type: Multipart/related; boundary=\"NEXT.ITEM-BOUNDARY\";type=\"text/html\"\n\n--NEXT.ITEM-BOUNDARY\nContent-Type: text/html; charset=\"utf-8\"\nContent-Location: " + location.href + "\n\n<!DOCTYPE html>\n" + "<html xmlns:v=\"urn:schemas-microsoft-com:vml\" xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:w=\"urn:schemas-microsoft-com:office:word\" xmlns:m=\"/office//12/omml\" xmlns=\"/TR/REC-html40\">\n_html_</html>", head: "<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\n<style>\n_styles_\n</style>\n<!--[if gte mso 9]><xml><w:WordDocument><w:View>Print</w:View><w:TrackMoves>false</w:TrackMoves><w:TrackFormatting/><w:ValidateAgainstSchemas/><w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid><w:IgnoreMixedContent>false</w:IgnoreMixedContent><w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText><w:DoNotPromoteQF/><w:LidThemeOther>EN-US</w:LidThemeOther><w:LidThemeAsian>ZH-CN</w:LidThemeAsian><w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript><w:Compatibility><w:BreakWrappedTables/><w:SnapToGridInCell/><w:WrapTextWithPunct/><w:UseAsianBreakRules/><w:DontGrowAutofit/><w:SplitPgBreakAndParaMark/><w:DontVertAlignCellWithSp/><w:DontBreakConstrainedForcedTables/><w:DontVertAlignInTxbx/><w:Word11KerningPairs/><w:CachedColBalance/><w:UseFELayout/></w:Compatibility><w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel><m:mathPr><m:mathFont m:val=\"Cambria Math\"/><m:brkBin m:val=\"before\"/><m:brkBinSub m:val=\"--\"/><m:smallFrac m:val=\"off\"/><m:dispDef/><m:lMargin m:val=\"0\"/> <m:rMargin m:val=\"0\"/><m:defJc m:val=\"centerGroup\"/><m:wrapIndent m:val=\"1440\"/><m:intLim m:val=\"subSup\"/><m:naryLim m:val=\"undOvr\"/></m:mathPr></w:WordDocument></xml><![endif]--></head>\n", body: "<body>_body_</body>" }}var options = {maxWidth: 80}// Clone selected element before manipulating itvar markup = $(this).clone()// Remove hidden elements from the outputmarkup.each(function() {var self = $(this)if (self.is(':hidden')) self.remove()})// Embed all images using Data URLsvar images = Array()var img = markup.find('img')for (var i = 0; i < img.length; i++) {// Calculate dimensions of output image// console.log(img[i])var w = Math.min(img[i].width, options.maxWidth)// console.log(w)var h = img[i].height * (w / img[i].width)// console.log(h)// Create canvas for converting image to data URLvar canvas = document.createElement('CANVAS')canvas.width = wcanvas.height = h// Draw image to canvasvar context = canvas.getContext('2d')context.drawImage(img[i], 0, 0, w, h)// Get data URL encoding of imagevar uri = canvas.toDataURL('image/png/jpg')$(img[i]).attr('src', img[i].src)img[i].width = wimg[i].height = h// Save encoded image to arrayimages[i] = {type: uri.substring(uri.indexOf(':') + 1, uri.indexOf(';')),encoding: uri.substring(uri.indexOf(';') + 1, uri.indexOf(',')),location: $(img[i]).attr('src'),data: uri.substring(uri.indexOf(',') + 1)}}// Prepare bottom of mhtml file with image datavar mhtmlBottom = '\n'for (var j = 0; j < images.length; j++) {mhtmlBottom += '--NEXT.ITEM-BOUNDARY\n'mhtmlBottom += 'Content-Location: ' + images[j].location + '\n'mhtmlBottom += 'Content-Type: ' + images[j].type + '\n'mhtmlBottom += 'Content-Transfer-Encoding: ' + images[j].encoding + '\n\n'mhtmlBottom += images[j].data + '\n\n'}mhtmlBottom += '--NEXT.ITEM-BOUNDARY--'//TODO: load css from included stylesheet// var styles =// ' /* Font Definitions */@font-face{font-family:宋体;panose-1:2 1 6 0 3 1 1 1 1 1;mso-font-alt:SimSun;mso-font-charset:134;mso-generic-font-family:auto;mso-font-pitch:variable;mso-font-signature:3 680460288 22 0 262145 0;} @font-face{font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;mso-font-charset:1;mso-generic-font-family:roman;mso-font-format:other;mso-font-pitch:variable;mso-font-signature:0 0 0 0 0 0;} @font-face{font-family:"@宋体";panose-1:2 1 6 0 3 1 1 1 1 1;mso-font-charset:134;mso-generic-font-family:auto;mso-font-pitch:variable;mso-font-signature:3 680460288 22 0 262145 0;}/* Style Definitions */p.MsoNormal, li.MsoNormal, div.MsoNormal{mso-style-unhide:no;mso-style-qformat:yes;mso-style-parent:"";margin:0cm;margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:14.0pt;font-family:宋体;mso-bidi-font-family:宋体;}p.MsoHeader, li.MsoHeader, div.MsoHeader{mso-style-noshow:yes;mso-style-priority:99;mso-style-link:"页眉 Char";margin:0cm;margin-bottom:.0001pt;text-align:center;mso-pagination:widow-orphan;layout-grid-mode:char;font-size:9.0pt;font-family:宋体;mso-bidi-font-family:宋体;}p.MsoFooter, li.MsoFooter, div.MsoFooter{mso-style-noshow:yes;mso-style-priority:99;mso-style-link:"页脚 Char";margin:0cm;margin-bottom:.0001pt;mso-pagination:widow-orphan;layout-grid-mode:char;font-size:9.0pt;font-family:宋体;mso-bidi-font-family:宋体;}p.MsoAcetate, li.MsoAcetate, div.MsoAcetate{mso-style-noshow:yes;mso-style-priority:99;mso-style-link:"批注框文本 Char";margin:0cm;margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:9.0pt;font-family:宋体;mso-bidi-font-family:宋体;}span.Char{mso-style-name:"页眉 Char";mso-style-noshow:yes;mso-style-priority:99;mso-style-unhide:no;mso-style-locked:yes;mso-style-link:页眉;font-family:宋体;mso-ascii-font-family:宋体;mso-fareast-font-family:宋体;mso-hansi-font-family:宋体;}span.Char0{mso-style-name:"页脚 Char";mso-style-noshow:yes;mso-style-priority:99;mso-style-unhide:no;mso-style-locked:yes;mso-style-link:页脚;font-family:宋体;mso-ascii-font-family:宋体;mso-fareast-font-family:宋体;mso-hansi-font-family:宋体;}span.Char1{mso-style-name:"批注框文本 Char";mso-style-noshow:yes;mso-style-priority:99;mso-style-unhide:no;mso-style-locked:yes;mso-style-link:批注框文本;font-family:宋体;mso-ascii-font-family:宋体;mso-fareast-font-family:宋体;mso-hansi-font-family:宋体;}p.msochpdefault, li.msochpdefault, div.msochpdefault{mso-style-name:msochpdefault;mso-style-unhide:no;mso-margin-top-alt:auto;margin-right:0cm;mso-margin-bottom-alt:auto;margin-left:0cm;mso-pagination:widow-orphan;font-size:10.0pt;font-family:宋体;mso-bidi-font-family:宋体;}span.msonormal0{mso-style-name:msonormal;mso-style-unhide:no;}.MsoChpDefault{mso-style-type:export-only;mso-default-props:yes;font-size:10.0pt;mso-ansi-font-size:10.0pt;mso-bidi-font-size:10.0pt;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman";mso-font-kerning:0pt;}/* Page Definitions */ @page WordSection1{size:595.3pt 841.9pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;mso-header-margin:42.55pt;mso-footer-margin:49.6pt;mso-paper-source:0;}div.WordSection1{page:WordSection1;}'var styles =rules// Aggregate parts of the file togethervar fileContent =statics.mhtml.top.replace('_html_',statics.mhtml.head.replace('_styles_', styles) + statics.mhtml.body.replace('_body_', markup.html())) + mhtmlBottom// Create a Blob with the file contentsvar blob = new Blob([fileContent], {// type: 'application/vnd.openxmlformats-officedocument.wordprocessingml.document;charset=UTF-8'type: 'application/msword;charset=UTF-8'})saveAs(blob, fileName + '.doc')}})($)} else {if (typeof $ === 'undefined') {console.error('jQuery Word Export: missing dependency (jQuery)')}if (typeof saveAs === 'undefined') {console.error('jQuery Word Export: missing dependency (FileSaver.js)')}}

需要定义样式写在styles里面:

通过options可以进行改变图片的大小:

在需要使用的vue页面中中引入js文件和jqurey

import $ from 'jquery'import '@/utils/jqureyWordExport'

利用jqurey获取到需要导出的html页面的类名,可以使用id,class,docx传入的是导出文件的名字,具体可以根据自己的需要进行更改;

ExportWord_1(){let date=new Date().toLocaleDateString()let docx='导出测试'+date$(".print").wordExport(docx);}

需要注意的:

如何到大家遇到这种右上角或者左上角放置了一个定位的图片,可以在外层套一个标签,放在标题的上面,因为是定位不会影响布局的,然后使用text-align进行图片位置的调整,如果不调整图片可能会进行错位

不知道为啥图片违规了,之前的图片也找不到,没办法贴图片了,可以多试试看

例子:页面样式

最终导出的样式:和页面的样式不可能百分百相同,但是也大差不差了

word导出:

最终导出的样式基本就是这样的,之前的图片违规找不到了,就手绘了一下;

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。