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

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.是,存在
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
好的,我们可以使用C语言实现统计一篇英语短文中单词个数的功能。具体实现如下: ```c #include <stdio.h> #include <stdlib.h> #include <string.h> #define MAX_LEN 10000 int main() { char text[MAX_LEN]; char *word; char *delim = " \n\t.,;?!-\""; int word_count = 0; // 读取英语短文 printf("请输入英文短文:\n"); fgets(text, MAX_LEN, stdin); // 统计单词个数 word = strtok(text, delim); while (word != NULL) { word_count++; word = strtok(NULL, delim); } // 输出结果 printf("该短文中单词的个数为:%d\n", word_count); return 0; } ``` 在上述代码中,我们使用了字符串库函数 `strtok` 来分割英文短文中的单词,具体流程如下: 1. 定义一个字符串 `delim`,用于指定分隔符,包括空格、换行、制表符、逗号、句号、分号、问号、感叹号和破折号等常见标点符号。 2. 使用 `fgets` 函数读取控制台输入的英文短文,并将其存储到字符数组 `text` 中。 3. 使用 `strtok` 函数将 `text` 字符串按照 `delim` 分隔符分割成单词,每次调用 `strtok` 函数返回一个单词,并将指针指向下一个单词。 4. 使用一个计数器 `word_count` 统计单词个数,每次调用 `strtok` 函数成功返回一个单词,就将 `word_count` 加1。 5. 统计完所有单词后,输出结果。 注意:在使用 `strtok` 函数时需要注意线程安全问题,如果需要在多线程环境下使用,可以使用 `strtok_r` 函数代替。 希望这个例子能够帮助你理解如何使用C语言统计英语短文中单词的个数。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值