处理71篇短文突破中考英语词汇

已于 2022-05-15 18:19:25 修改
阅读量1.1k 收藏
点赞数
文章标签： javascript 开发语言 ecmascript
于 2022-05-15 16:39:29 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/countsun/article/details/124783791
版权

71篇短文突破中考英语词汇 网上有很多版本

但是我不满意，不满意的几点，我的目的是给我4年级的儿子朗读

1、没有音标

2、没有单词解释

解决第1步：没有音标，参考前面文字英语加音标已经解决；

第2步没有单词解释，网上找了个单词英译汉的js库，发现库不全。

不全的是几点

1、单词变化形式，比如加了s，+er +est的，这个要自己处理。

2、动词变化形式 go went gone，找变化库，然后处理一下，加入这个库。

下面这个文章已经写好了，自己看看怎么处理，函数都在里边

小程序JS-处理英语单词，获取英语意思，注意事项_countsun的博客-CSDN博客

3、查找是否单词还是不全

这个是小程序写的js

getword71(){//测试71篇文章词汇，看看词汇是否都在词库
    let app=this
    let cutword='her+has+the+are+our+you+where+who+what+which+USA+gdp+there+but+his+she+him+hers+your+yours+for+they'//不想标注音标的
    let cutarr=cutword.toLowerCase().split("+")//分割一下，要不然hey这样的单词也可能不显示
  let copyStr=app.data.copyArr[0]//获取剪贴板数据
  let inarr=copyStr.split("\r\n")
  app.data.outArr=[];
  let outstr=''
  let word=''
  let nword=''
  let str=''
  let arrword=[]
  let isre=false
for(let m=0;m<inarr.length;m++)
{
  str=inarr[m];
  for(let i=0;i<str.length;i++)
  {
  if(app.isaz(str.charAt(i))){word=word+str.charAt(i)}
  else{
  if(word.trim()!==''){nword=word.toLowerCase();nword=app.findphs(nword).m;
  //console.log(nword)
  }
 if(word.length<3||cutarr.indexOf(word.toLowerCase())!==-1){ word='';nword='';isre=false;}
 else{
 if(nword==undefined||nword=='')  {
     console.log(word,'aa',nword)
  for(let wi=0;wi<arrword.length;wi++)
  {
    if(arrword[wi]==word.toLowerCase()){isre=true;break;}
  }
  if(!isre)
  {arrword.push(word.toLowerCase());
  outstr=outstr+word+'\r\n'; 
  }
  else
  { isre=false}
  }
 word='';nword='';
}
}
 if(i==str.length-1)
{
  if(word.trim()!==''){nword=word.toLowerCase();nword=app.findphs(nword).m;
    //console.log(nword)
    }
  if(word.length<3||cutarr.indexOf(word.toLowerCase())!==-1){ word='';nword='';isre=false;}
  else{
    if(nword==undefined||nword=='')  {
      console.log(word,'aa',nword)
      for(let wi=0;wi<arrword.length;wi++)
      {
        if(arrword[wi]==word.toLowerCase()){isre=true;break;}
      }
      if(!isre)
      {arrword.push(word.toLowerCase());
      outstr=outstr+word+'\r\n'; 
      }
      else
      { isre=false}
     }
    }
    word='';nword='';isre=false;

}
}
}
app.data.outStr=outstr;//把数据传递出去剪贴板数据
app.setData({
result:'ok' 
 });
 wx.setClipboardData({
  data:app.data.outStr,
  success: function(res) {

  },
  fail: function(res) {
  }
});  

},

 4、如果不在库里边

把单词，复制到百度翻译，获取一下，复制到excel处理一下，然后添加到库

下面是一个excel的模板，改成了xml格式，把这段复制到txt然后重命名为abc.xml ，然后用excel打开就可以了。

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Author>User</Author><LastAuthor>User</LastAuthor><Created>2022-05-09T15:22:00Z</Created><LastSaved>2022-05-15T08:27:40Z</LastSaved></DocumentProperties><CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><KSOProductBuildVer dt:dt="string">2052-11.1.0.10132</KSOProductBuildVer></CustomDocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowWidth>18600</WindowWidth><WindowHeight>6980</WindowHeight><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Style ss:ID="s44" ss:Name="40% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#B4C6E7" ss:Pattern="Solid"/></Style><Style ss:ID="s43" ss:Name="强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#4472C4" ss:Pattern="Solid"/></Style><Style ss:ID="s29" ss:Name="链接单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#FF8001"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FA7D00"/></Style><Style ss:ID="s27" ss:Name="20% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#E2EFDA" ss:Pattern="Solid"/></Style><Style ss:ID="s16" ss:Name="警告文本"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FF0000"/></Style><Style ss:ID="s1" ss:Name="货币[0]"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0_ ;_ &quot;￥&quot;* \-#,##0_ ;_ &quot;￥&quot;* &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s8" ss:Name="千位分隔"><NumberFormat ss:Format="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s34" ss:Name="强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#5B9BD5" ss:Pattern="Solid"/></Style><Style ss:ID="s33" ss:Name="20% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#D9E1F2" ss:Pattern="Solid"/></Style><Style ss:ID="s19" ss:Name="标题 1"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#5B9BD5"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="15" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s9" ss:Name="60% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#C9C9C9" ss:Pattern="Solid"/></Style><Style ss:ID="s7" ss:Name="差"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#9C0006"/><Interior ss:Color="#FFC7CE" ss:Pattern="Solid"/></Style><Style ss:ID="s46" ss:Name="强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#70AD47" ss:Pattern="Solid"/></Style><Style ss:ID="s42" ss:Name="40% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFE699" ss:Pattern="Solid"/></Style><Style ss:ID="s22" ss:Name="标题 3"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#ACCCEA"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s3" ss:Name="输入"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#3F3F76"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s6" ss:Name="40% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/></Style><Style ss:ID="s37" ss:Name="20% - 强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FCE4D6" ss:Pattern="Solid"/></Style><Style ss:ID="s15" ss:Name="标题 4"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s13" ss:Name="注释"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/></Borders><Interior ss:Color="#FFFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="Default" ss:Name="Normal"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s2" ss:Name="20% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#EDEDED" ss:Pattern="Solid"/></Style><Style ss:ID="s5" ss:Name="千位分隔[0]"><NumberFormat ss:Format="_ * #,##0_ ;_ * \-#,##0_ ;_ * &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s48" ss:Name="60% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#A9D08E" ss:Pattern="Solid"/></Style><Style ss:ID="s45" ss:Name="60% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#8EA9DB" ss:Pattern="Solid"/></Style><Style ss:ID="s41" ss:Name="20% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFF2CC" ss:Pattern="Solid"/></Style><Style ss:ID="s32" ss:Name="适中"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#9C6500"/><Interior ss:Color="#FFEB9C" ss:Pattern="Solid"/></Style><Style ss:ID="s25" ss:Name="计算"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FA7D00" ss:Bold="1"/><Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/></Style><Style ss:ID="s17" ss:Name="标题"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="18" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s10" ss:Name="超链接"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#0000FF" ss:Underline="Single"/></Style><Style ss:ID="s4" ss:Name="货币"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0.00_ ;_ &quot;￥&quot;* \-#,##0.00_ ;_ &quot;￥&quot;* &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s39" ss:Name="强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/></Style><Style ss:ID="s35" ss:Name="20% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#DDEBF7" ss:Pattern="Solid"/></Style><Style ss:ID="s31" ss:Name="好"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#006100"/><Interior ss:Color="#C6EFCE" ss:Pattern="Solid"/></Style><Style ss:ID="s12" ss:Name="已访问的超链接"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#800080" ss:Underline="Single"/></Style><Style ss:ID="s11" ss:Name="百分比"><NumberFormat ss:Format="0%"/></Style><Style ss:ID="s38" ss:Name="40% - 强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#F8CBAD" ss:Pattern="Solid"/></Style><Style ss:ID="s36" ss:Name="40% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#BDD7EE" ss:Pattern="Solid"/></Style><Style ss:ID="s30" ss:Name="汇总"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#5B9BD5"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#5B9BD5"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" ss:Bold="1"/></Style><Style ss:ID="s18" ss:Name="解释性文本"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#7F7F7F" ss:Italic="1"/></Style><Style ss:ID="s14" ss:Name="60% - 强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#F4B084" ss:Pattern="Solid"/></Style><Style ss:ID="s47" ss:Name="40% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#C6E0B4" ss:Pattern="Solid"/></Style><Style ss:ID="s28" ss:Name="强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#ED7D31" ss:Pattern="Solid"/></Style><Style ss:ID="s26" ss:Name="检查单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/><Border ss:Position="Left" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/><Border ss:Position="Right" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/><Border ss:Position="Top" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/><Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/></Style><Style ss:ID="s24" ss:Name="输出"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#3F3F3F" ss:Bold="1"/><Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/></Style><Style ss:ID="s20" ss:Name="标题 2"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#5B9BD5"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="13" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s21" ss:Name="60% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#9BC2E6" ss:Pattern="Solid"/></Style><Style ss:ID="s23" ss:Name="60% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFD966" ss:Pattern="Solid"/></Style><Style ss:ID="s40" ss:Name="强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFC000" ss:Pattern="Solid"/></Style><Style ss:ID="s49"/><Style ss:ID="s50"><Alignment ss:Horizontal="Justify" ss:Vertical="Center"/><Font ss:FontName="Calibri" x:CharSet="134" ss:Size="10.5" ss:Color="#000000"/></Style></Styles><Worksheet ss:Name="Sheet1"><Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="159" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="48" ss:DefaultRowHeight="14"><Column ss:Index="1" ss:StyleID="Default" ss:AutoFitWidth="0" ss:Width="107"/><Column ss:Index="6" ss:StyleID="Default" ss:AutoFitWidth="0" ss:Width="116"/><Row><Cell><Data ss:Type="String">someone</Data></Cell><Cell><Data ss:Type="String">某人</Data></Cell><Cell ss:Index="4" ss:Formula="=RC[-1]&amp;RC[-2]"><Data ss:Type="String">某人</Data></Cell><Cell ss:Formula="=&quot;&quot;&quot;&quot;&amp;LOWER(RC[-4])&amp;&quot;&quot;&quot;:&quot;&quot;&quot;&amp;&quot;&quot;&amp;RC[-1]&amp;&quot;&quot;&quot;&quot;&amp;&quot;,&quot;"><Data ss:Type="String">&quot;someone&quot;:&quot;某人&quot;,</Data></Cell><Cell ss:Index="7" ss:Formula="=RC[-2]"><Data ss:Type="String">&quot;someone&quot;:&quot;某人&quot;,</Data></Cell></Row><Row><Cell><Data ss:Type="String">pence</Data></Cell><Cell><Data ss:Type="String">便士</Data></Cell><Cell ss:Index="4" ss:Formula="=RC[-1]&amp;RC[-2]"><Data ss:Type="String">便士</Data></Cell><Cell ss:Formula="=&quot;&quot;&quot;&quot;&amp;LOWER(RC[-4])&amp;&quot;&quot;&quot;:&quot;&quot;&quot;&amp;&quot;&quot;&amp;RC[-1]&amp;&quot;&quot;&quot;&quot;&amp;&quot;,&quot;"><Data ss:Type="String">&quot;pence&quot;:&quot;便士&quot;,</Data></Cell><Cell ss:Index="7" ss:Formula="=R[-1]C&amp;RC[-2]"><Data ss:Type="String">&quot;someone&quot;:&quot;某人&quot;,&quot;pence&quot;:&quot;便士&quot;,</Data></Cell></Row><Row><Cell><Data ss:Type="String">Mrs</Data></Cell><Cell><Data ss:Type="String">夫人</Data></Cell><Cell ss:Index="4" ss:Formula="=RC[-1]&amp;RC[-2]"><Data ss:Type="String">夫人</Data></Cell><Cell ss:Formula="=&quot;&quot;&quot;&quot;&amp;LOWER(RC[-4])&amp;&quot;&quot;&quot;:&quot;&quot;&quot;&amp;&quot;&quot;&amp;RC[-1]&amp;&quot;&quot;&quot;&quot;&amp;&quot;,&quot;"><Data ss:Type="String">&quot;mrs&quot;:&quot;夫人&quot;,</Data></Cell><Cell ss:Index="7" ss:Formula="=R[-1]C&amp;RC[-2]"><Data ss:Type="String">&quot;someone&quot;:&quot;某人&quot;,&quot;pence&quot;:&quot;便士&quot;,&quot;mrs&quot;:&quot;夫人&quot;,</Data></Cell></Row><Row><Cell><Data ss:Type="String">Bur</Data></Cell><Cell><Data ss:Type="String">伯尔</Data></Cell><Cell ss:Index="4" ss:Formula="=RC[-1]&amp;RC[-2]"><Data ss:Type="String">伯尔</Data></Cell><Cell ss:Formula="=&quot;&quot;&quot;&quot;&amp;LOWER(RC[-4])&amp;&quot;&quot;&quot;:&quot;&quot;&quot;&amp;&quot;&quot;&amp;RC[-1]&amp;&quot;&quot;&quot;&quot;&amp;&quot;,&quot;"><Data ss:Type="String">&quot;bur&quot;:&quot;伯尔&quot;,</Data></Cell><Cell ss:Index="7" ss:Formula="=R[-1]C&amp;RC[-2]"><Data ss:Type="String">&quot;someone&quot;:&quot;某人&quot;,&quot;pence&quot;:&quot;便士&quot;,&quot;mrs&quot;:&quot;夫人&quot;,&quot;bur&quot;:&quot;伯尔&quot;,</Data></Cell></Row><Row ss:Index="159"><Cell ss:StyleID="s50"/></Row></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/></PageSetup><Selected/><TopRowVisible>0</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><PageBreakZoom>100</PageBreakZoom><Panes><Pane><Number>3</Number><ActiveRow>3</ActiveRow><ActiveCol>1</ActiveCol><RangeSelection>R4C2</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet></Workbook>

效果如下图 

someone某人某人"someone":"某人","someone":"某人",
pence便士便士"pence":"便士","someone":"某人","pence":"便士",
Mrs夫人夫人"mrs":"夫人","someone":"某人","pence":"便士","mrs":"夫人",
Bur伯尔伯尔"bur":"伯尔","someone":"某人","pence":"便士","mrs":"夫人","bur":"伯尔",

上面几步都处理完毕了，说明单词都在库里了

下面用小程序处理一下单词（音标上面处理完毕了）

操作步骤是复制，粘贴

  getword0509(){
      let app=this
      let cutword='now++all+not+has+her+the+are+our+you+where+who+what+which+USA+gdp+there+but+his+she+him+hers+your+yours+for+they'//不想标注音标的
      let cutarr=cutword.toLowerCase().split("+")//分割一下，要不然hey这样的单词也可能不显示
    let copyStr=app.data.copyArr[0]//获取剪贴板数据
    let inarr=copyStr.split("\r\n")
    app.data.outArr=[];
    let outstr=''
    let kg='                               ';
    let word=''
    let nword=''
    let oldw=''
    let neww=''
    let bk2='    '//空4个
    let lold=''
    let lnew=''
    let str=''
    let arrword=[]
    let isre=false
    let iscut=false
    let istwo=1
    let wordshow=''
  for(let m=0;m<inarr.length;m++)
  {
    str=inarr[m];
    for(let i=0;i<str.length;i++)
    {
   if(i==0){lold=bk2;lnew=bk2}
    if(app.isaz(str.charAt(i))){word=word+str.charAt(i)}
    else{
    {
    if(word.trim()!==''){
    nword=word.toLowerCase();
    if(app.findphs(nword)!==undefined&&app.findphs(nword).w!==undefined&&app.findphs(nword).w!==''&&word.toLowerCase()!==app.findphs(nword).w){wordshow=word+'['+app.findphs(nword).w+']'}
    else{wordshow=word}
    nword=''+app.findphs(nword).m+'';
     }
   if(word.length<3||cutarr.indexOf(word.toLowerCase())!==-1){ word='';nword='';isre=false;}
   else{
    for(let wi=0;wi<arrword.length;wi++)
    {
      if(arrword[wi]==word.toLowerCase()){isre=true;break}
    }
    if(!isre)
    {arrword.push(word.toLowerCase());
    if(istwo==1){
      outstr=outstr+wordshow+' '+nword+'\t';   istwo=2
    }else{ outstr=outstr+wordshow+' '+nword+'\r\n'; istwo=1  }
    wordshow='';  word='';nword='';
    }
   else { wordshow='';word='';nword='';   isre=false}
  }
   if(i==str.length-1)
  {
    if(word.length<3||cutarr.indexOf(word.toLowerCase())!==-1){ word='';nword='';isre=false;}
    else{
      if(word.trim()!==''){
        nword=word.toLowerCase();
        if(app.findphs(nword)!==undefined&&app.findphs(nword).w!==undefined&&app.findphs(nword).w!==''&&word.toLowerCase()!==app.findphs(nword).w){wordshow=word+'['+app.findphs(nword).w+']'}
        else{wordshow=word}
        nword=''+app.findphs(nword).m+'';
         }
    for(let wi=0;wi<arrword.length;wi++)
    {
      if(arrword[i]==word.toLowerCase()){isre=true}
    }
    if(!isre)
    {arrword.push(word.toLowerCase());
    if(istwo==1){
      outstr=outstr+wordshow+' '+nword+'\t';   istwo=2
    }else{ outstr=outstr+wordshow+' '+nword+'\r\n'; istwo=1  }
    wordshow=''; word='';nword='';
    }
    else
    { wordshow='';word='';nword='';   isre=false}
  }
  }
 }
}
}
}

app.data.outStr=outstr;//把数据传递出去剪贴板数据
app.setData({
  result:'ok' 
   });
   wx.setClipboardData({
    data:app.data.outStr,
    success: function(res) {

    },
    fail: function(res) {
    }
  });  

  },

然后复制到excel中

模板同样给个xml格式

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Author>User</Author><LastAuthor>User</LastAuthor><Created>2022-05-10T13:41:00Z</Created><LastSaved>2022-05-15T08:36:07Z</LastSaved></DocumentProperties><CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><KSOProductBuildVer dt:dt="string">2052-11.1.0.10132</KSOProductBuildVer></CustomDocumentProperties><ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"><WindowWidth>18600</WindowWidth><WindowHeight>6980</WindowHeight><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Style ss:ID="s19" ss:Name="标题 1"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#5B9BD5"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="15" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="Default" ss:Name="Normal"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s8" ss:Name="千位分隔"><NumberFormat ss:Format="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s5" ss:Name="千位分隔[0]"><NumberFormat ss:Format="_ * #,##0_ ;_ * \-#,##0_ ;_ * &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s16" ss:Name="警告文本"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FF0000"/></Style><Style ss:ID="s15" ss:Name="标题 4"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s4" ss:Name="货币"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0.00_ ;_ &quot;￥&quot;* \-#,##0.00_ ;_ &quot;￥&quot;* &quot;-&quot;??_ ;_ @_ "/></Style><Style ss:ID="s10" ss:Name="超链接"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#0000FF" ss:Underline="Single"/></Style><Style ss:ID="s1" ss:Name="货币[0]"><NumberFormat ss:Format="_ &quot;￥&quot;* #,##0_ ;_ &quot;￥&quot;* \-#,##0_ ;_ &quot;￥&quot;* &quot;-&quot;_ ;_ @_ "/></Style><Style ss:ID="s3" ss:Name="输入"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#3F3F76"/><Interior ss:Color="#FFCC99" ss:Pattern="Solid"/></Style><Style ss:ID="s42" ss:Name="40% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFE699" ss:Pattern="Solid"/></Style><Style ss:ID="s40" ss:Name="强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFC000" ss:Pattern="Solid"/></Style><Style ss:ID="s7" ss:Name="差"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#9C0006"/><Interior ss:Color="#FFC7CE" ss:Pattern="Solid"/></Style><Style ss:ID="s37" ss:Name="20% - 强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FCE4D6" ss:Pattern="Solid"/></Style><Style ss:ID="s27" ss:Name="20% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#E2EFDA" ss:Pattern="Solid"/></Style><Style ss:ID="s6" ss:Name="40% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#DBDBDB" ss:Pattern="Solid"/></Style><Style ss:ID="s34" ss:Name="强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#5B9BD5" ss:Pattern="Solid"/></Style><Style ss:ID="s33" ss:Name="20% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#D9E1F2" ss:Pattern="Solid"/></Style><Style ss:ID="s2" ss:Name="20% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#EDEDED" ss:Pattern="Solid"/></Style><Style ss:ID="s41" ss:Name="20% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#FFF2CC" ss:Pattern="Solid"/></Style><Style ss:ID="s14" ss:Name="60% - 强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#F4B084" ss:Pattern="Solid"/></Style><Style ss:ID="s9" ss:Name="60% - 强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#C9C9C9" ss:Pattern="Solid"/></Style><Style ss:ID="s25" ss:Name="计算"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#7F7F7F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FA7D00" ss:Bold="1"/><Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/></Style><Style ss:ID="s18" ss:Name="解释性文本"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#7F7F7F" ss:Italic="1"/></Style><Style ss:ID="s11" ss:Name="百分比"><NumberFormat ss:Format="0%"/></Style><Style ss:ID="s26" ss:Name="检查单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/><Border ss:Position="Left" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/><Border ss:Position="Right" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/><Border ss:Position="Top" ss:LineStyle="Double" ss:Weight="3" ss:Color="#3F3F3F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/><Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/></Style><Style ss:ID="s13" ss:Name="注释"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#B2B2B2"/></Borders><Interior ss:Color="#FFFFCC" ss:Pattern="Solid"/></Style><Style ss:ID="s12" ss:Name="已访问的超链接"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#800080" ss:Underline="Single"/></Style><Style ss:ID="s29" ss:Name="链接单元格"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#FF8001"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FA7D00"/></Style><Style ss:ID="s22" ss:Name="标题 3"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#ACCCEA"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s17" ss:Name="标题"><Font ss:FontName="宋体" x:CharSet="134" ss:Size="18" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s30" ss:Name="汇总"><Borders><Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3" ss:Color="#5B9BD5"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#5B9BD5"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000" ss:Bold="1"/></Style><Style ss:ID="s24" ss:Name="输出"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/><Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/><Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/><Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#3F3F3F"/></Borders><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#3F3F3F" ss:Bold="1"/><Interior ss:Color="#F2F2F2" ss:Pattern="Solid"/></Style><Style ss:ID="s20" ss:Name="标题 2"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2" ss:Color="#5B9BD5"/></Borders><Font ss:FontName="宋体" x:CharSet="134" ss:Size="13" ss:Color="#44546A" ss:Bold="1"/></Style><Style ss:ID="s46" ss:Name="强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#70AD47" ss:Pattern="Solid"/></Style><Style ss:ID="s28" ss:Name="强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#ED7D31" ss:Pattern="Solid"/></Style><Style ss:ID="s21" ss:Name="60% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#9BC2E6" ss:Pattern="Solid"/></Style><Style ss:ID="s45" ss:Name="60% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#8EA9DB" ss:Pattern="Solid"/></Style><Style ss:ID="s35" ss:Name="20% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#DDEBF7" ss:Pattern="Solid"/></Style><Style ss:ID="s23" ss:Name="60% - 强调文字颜色 4"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#FFD966" ss:Pattern="Solid"/></Style><Style ss:ID="s31" ss:Name="好"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#006100"/><Interior ss:Color="#C6EFCE" ss:Pattern="Solid"/></Style><Style ss:ID="s43" ss:Name="强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#4472C4" ss:Pattern="Solid"/></Style><Style ss:ID="s38" ss:Name="40% - 强调文字颜色 2"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#F8CBAD" ss:Pattern="Solid"/></Style><Style ss:ID="s32" ss:Name="适中"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#9C6500"/><Interior ss:Color="#FFEB9C" ss:Pattern="Solid"/></Style><Style ss:ID="s44" ss:Name="40% - 强调文字颜色 5"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#B4C6E7" ss:Pattern="Solid"/></Style><Style ss:ID="s39" ss:Name="强调文字颜色 3"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#A5A5A5" ss:Pattern="Solid"/></Style><Style ss:ID="s36" ss:Name="40% - 强调文字颜色 1"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#BDD7EE" ss:Pattern="Solid"/></Style><Style ss:ID="s47" ss:Name="40% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#000000"/><Interior ss:Color="#C6E0B4" ss:Pattern="Solid"/></Style><Style ss:ID="s48" ss:Name="60% - 强调文字颜色 6"><Font ss:FontName="宋体" x:CharSet="0" ss:Size="11" ss:Color="#FFFFFF"/><Interior ss:Color="#A9D08E" ss:Pattern="Solid"/></Style><Style ss:ID="s49"><Alignment ss:Vertical="Center"/><Borders/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Style ss:ID="s50"><Alignment ss:Vertical="Center" ss:WrapText="1"/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Color="#000000"/></Style><Style ss:ID="s51"><Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Color="#000000"/></Style><Style ss:ID="s52"><Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/><Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Color="#000000"/></Style></Styles><Worksheet ss:Name="1"><Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="101" x:FullColumns="1" x:FullRows="1" ss:StyleID="s50" ss:DefaultColumnWidth="48" ss:DefaultRowHeight="15"><Column ss:Index="1" ss:StyleID="s50" ss:AutoFitWidth="0" ss:Width="241" ss:Span="1"/><Row ss:Height="21"><Cell ss:StyleID="s52" ss:MergeAcross="1"><Data ss:Type="String">l. A Young Officer and an Old Soldier </Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">Young adj.年轻的n.青年人</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">Officer n.军官，警官，官员</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">and conj.和，与，而</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">Old adj.老的，...岁的</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">Soldier n.士兵，兵</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">very adv.很，非常</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="36.5"><Cell ss:StyleID="s50"><Data ss:Type="String">new adj.新的，重新的</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">was (be/biː/ was/were been)&#10;v.是，存在</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">railway n.铁路，铁路公司</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">station n.站，台v.驻扎</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">going[go] v.去，进行，打算</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">visit v.n.访问，参观</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">mother n.母亲adj.出生地的</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">wanted[want] v.想要，通辑n.缺乏</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">telephone n.电话v.打电话</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">tell v.告诉，讲，说出</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">time n.时间，时候，次数</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">train n.列车，一列v.训练</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">looked[look] v.看，看上去n.外表</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">pockets[pocket] n.衣袋adj.袖珍的</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">found v.创办，使有根据</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">that adj.那adv.那么</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="36.5"><Cell ss:StyleID="s50"><Data ss:Type="String">did (do/duː/ did done)&#10;v.做，干，足够，制作</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">have v.有，不得不，拿</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="36.5"><Cell ss:StyleID="s50"><Data ss:Type="String">coins[coin] n.硬币，创造新词</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">went (go/gəʊ/ went gone)&#10;v.去，进行，打算</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">outside n.外部adv.在外面</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">around adv.在周围，大约</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">someone 某人</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">help v.n.帮助，有助于</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">want v.想要，通辑n.缺乏</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">pocket n.衣袋adj.袖珍的</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">find v.寻找，找到，发现</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">coin n.硬币，创造新词</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">look v.看，看上去n.外表</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">last adj.最后的adv.上次</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="36.5"><Cell ss:StyleID="s50"><Data ss:Type="String">came (come/kʌm/ came come)&#10;v.来到，出现，发生</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">stopped[stop] v.停止，终止n.停止</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="36.5"><Cell ss:StyleID="s50"><Data ss:Type="String">said adj.上述的，该</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">got (get/gɛt/ got gotten)&#10;v.获得，记住，到达</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">change n.变化，零钱v.改变</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">ten num.十</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">pence 便士</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">Wait v.等候，伺候</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">moment n.时刻，瞬间</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">answered[answer] n.答案v.答复</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">beginning n.开端，起点</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">put v.放置，估价，表达</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">hand n.手，人手，指针</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">see v.看见，明白，查看</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">whether conj.是否，还是...</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">can v.aux.能，会，可以</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">Don 大学教师</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">know n.知道，认识，懂</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">how adv.如何，多么，怎样</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">speak v.说话，发言，讲</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">man n.人，男人，人类</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">angrily[angry] adj.生气的，愤怒的</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">let v.让，使</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">start v.开始，着手，发动</Data></Cell></Row><Row ss:StyleID="s50" ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">again adv.再，又</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">sir n.先生</Data></Cell></Row><Row ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">quickly adv.快，迅速地</Data></Cell><Cell ss:StyleID="s50"><Data ss:Type="String">answer n.答案v.答复</Data></Cell></Row><Row ss:Height="21"><Cell ss:StyleID="s50"><Data ss:Type="String">begin v.开始，着手进行</Data></Cell></Row><Row ss:Height="21" ss:Span="66"/></Table><WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Header/><Footer/><PageMargins x:Left="0.751388888888889" x:Right="0.751388888888889" x:Top="0.786805555555556" x:Bottom="0.393055555555556"/></PageSetup><FitToPage/><Print><ValidPrinterInfo/><Scale>99</Scale><PaperSizeIndex>9</PaperSizeIndex><HorizontalResolution>600</HorizontalResolution></Print><Selected/><TopRowVisible>0</TopRowVisible><LeftColumnVisible>0</LeftColumnVisible><PageBreakZoom>100</PageBreakZoom><Panes><Pane><Number>3</Number><ActiveRow>4</ActiveRow><ActiveCol>0</ActiveCol><RangeSelection>R5C1</RangeSelection></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet></Workbook>

另外这个excel里边加个宏，自动换行替换一下，然后自动调整高度

Sub abc()

For Each c In Range("A1:B100")
If InStr(c.Value, "()") > 0 Then c.Value = Replace(c.Value, "()", Chr(10))
Next

 
Rem 第1行到第100行进行一次循环（可根据需要自己改行数）
For i = 1 To 100
 
Rem 隐藏行不执行（可根据需要自己修改，进行了更新，如果需要执行隐藏行请参考下面图片里的代码）
If Not Rows(i).Hidden Then
 
Rem 第i行调整为最适合行高（如果不需要此步骤删除下面的代码）
Rows(i).AutoFit
 
Rem 第i行高度+6（可根据需要自己改高度）
Rows(i).RowHeight = Rows(i).RowHeight + 6
 
End If
 
Next

End Sub

下面是效果图

l. A Young Officer and an Old Soldier 
Young adj.年轻的n.青年人Officer n.军官，警官，官员
and conj.和，与，而Old adj.老的，...岁的
Soldier n.士兵，兵very adv.很，非常
new adj.新的，重新的was (be/biː/ was/were been)
v.是，存在
countsun
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
40篇英语短文搞定高考3500个单词
闲时不练功，忙时一场空
04-10 10万+
40篇英语短文搞定高考3500个单词 1. Fall in Love with English爱上英语 Hiding behind the loose dusty curtain, a teenager packed up his overcoat into the suitcase. He planned to leave home at dusk though there was thun...
一个简明的英语单词中文解释库，71篇短文搞定中考词汇（全部在了，包括姓名等）
05-15
js小程序格式："pleasure":"n.快乐，乐事，乐趣"," 有动词不规则形式；库比较小，简明解释 "awoke":"(awake/əˈweɪk/ awoke awoken)()v.醒来，醒悟adj.醒的","awoken":"(awake/əˈweɪk/ awoke awoken)()v.醒来，醒悟；没有音标。 20220528更新：把多余的去掉，比如bit，既是一个bite bit biten；又是a bit of 一片的意思； 把这两个拼接在一起，（）表示可以替换成回车，显示的时候好看一点； "bit":"(bite/baɪt/ bit bitten)()bite n.v.咬，叮n.一口()(bit n.小片，一点)"
python 统计单词个数和频次 和 70篇短文突破中考英语词汇 实用
松果储存小窝
01-07 2505
开始学习python，习题需要统计单词个数和频次。百度找到的代码好像都有问题。字节写了一个，调试通过。 环境：python: 3.9.1 64bit ； pycharm: 2020.2 电脑 win10 64 思路如下： 1. 打开文件，将所有字符读入list：s 2. 使用正则表达式，以非英文字符为间隔符，切片，生成一个以单词为基本元素的list 3.由于原先非字母可能连续，故生成的list可能存在空单词，所以需要去除空串 4.全部转成小写，并排序。 5. 将单词顺次存入dict，如果...
c语言中考成绩分析报告,初中英语成绩分析报告
weixin_29997657的博客
05-22 308
(一)一试卷基本情况：这套试卷是一套综合型试卷，考核了学生考前所应达到的英语运用综合能力，考核的听力难度系数比较大，词汇方面考核了学生生容易掌握的词汇。总的来说，试卷涉及的知识面广，挖掘的考点比较深。卷面结构为：听力20分，阅读理解20分，口头表达15分，书面表达25分，词汇和句子20分。三、试卷分析1、从听力来看，若想把听力成为学生的“优势”得分题型，还需加强教与学。学生“短暂记忆”能力还不过硬...
70篇短文突破中考英语词汇(全).doc
09-18
70篇短文突破中考英语词汇(全).doc
70篇短文突破初三中考英语词汇(全) .doc
12-04
70篇短文突破初三中考英语词汇(全) .doc
70篇短文突破初三中考英语词汇(一) .doc
11-30
70篇短文突破初三中考英语词汇(一) .doc
2020年中考英语热点专题突破训练十二短文填空202004082177
09-08
这篇内容主要涉及的是中考英语的短文填空专题训练，是2020年的热点话题，尤其强调了励志类的故事。这个训练旨在提高考生的阅读理解能力和对英语词汇、语法、习惯用法及固定搭配的综合运用能力。 1. **语法知识**：...
Vue 3 和 SpringBoot 实现文件分片上传示例
exlink2012的专栏
07-22 468
实现分片上传，并使用Spring Boot在后端保存文件。前端将文件分片并逐个上传到后端，后端接收到所有分片后再进行合并，最终保存为一个完整文件。
JavaScript青少年简明教程：函数及其相关知识（下）
最新发布
cnds123的专栏
07-26 428
JavaScript青少年简明教程：函数及其相关知识（下）
HarmonyOS应用开发者高级认证，Next版本发布后最新题库 - 多选题序号4
Gusha_的博客
07-23 1183
HarmonyOS应用开发者高级认证最新题库，编写于2024年7月19日，Next版本发布之后
【React 】开发环境搭建详细指南
lph159的博客
07-24 1030
无论你是刚刚开始学习 React，还是希望在现有项目中采用 React 技术，搭建一个高效的开发环境都是至关重要的。本文将详细介绍如何从零开始搭建 React 开发环境，涵盖所需的工具和最佳实践，帮助你快速启动并顺利进行开发。Visual Studio Code（VS Code）是目前最流行的代码编辑器之一，提供了丰富的扩展和强大的功能。如果你希望对项目的配置有更多的控制，可以选择手动配置 React 项目。下载并安装最新版本的 Node.js，安装 Node.js 后，npm 会自动安装。
VUE中的重点*
qq_61132537的博客
07-22 983
实际上就是一个闭包，因为vue是单页面应用，是由很多组件构成，每一个组件中都有一个data， 所以通过闭包给每一个组件创建了一个私有的作用域，这样就不会相互影响。
vue el-select的下拉树形结构 带检索功能
Jokerxiuka的博客
07-26 88
【代码】vue el-select的下拉树形结构。
已解决：vue-office/excel 多个sheet点击切换，滚动条高度不重置，表格视图位置不正确
weixin_42289080的博客
07-26 83
解决 @vue-office/excel 多个sheet切换，内容以及滚动条展示不正确的问题
el-menu根据多层树形结构递归遍历展示菜单栏
m0_62317155的博客
07-23 869
el-menu根据多层树形结构递归遍历展示菜单栏
爬虫基本原理入门
RHeng的博客
07-25 700
爬虫（Web Crawler），又称为网络爬虫或网页蜘蛛，是一种按照一定的规则，自动地抓取万维网信息的程序或者脚本。它们可以模拟浏览器行为，遍历网页并抓取网页中的信息，如文本、图片、链接等。接下来，我们会尝试使用Python等编程语言，结合相关库和工具，动手编写自己的爬虫程序，探索更多关于爬虫技术的奥秘。
计算机专业英语词汇大全：考研复试必备
"这是一份计算机专业英语词汇的整理文档，专为计算机学科考研复试准备，包含专业词汇和短文翻译，便于考生学习和复习。" 计算机专业英语词汇是计算机科学学习和研究的重要组成部分，特别是在研究生阶段的考试和研究...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值