<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ilwtfqqc的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ilwtfqqc</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ilwtfqqc]]></copyright><item><title><![CDATA[WPS文字的“邮件合并”功能-----批量生成word文档]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/147977521</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/147977521</guid><author>ilwtfqqc</author><pubDate>Thu, 15 May 2025 10:51:06 +0800</pubDate><description><![CDATA[日常工作中的word很多，不同场景使用不同的文本，但同类型文件使用的框架基本一致，这时批量处理、批量生成尤为重要！！！下面我根据自己的工作经验，来分享WPS文字的“邮件合并”功能。可以通过“引用”里面找到“邮件合并”功能，或者直接搜索“邮件合并”功能，点击进入“邮件合并”功能关键需要4步，第1步制作文书模板，第2步制作要素表，第3步插入合并域，第4步批量生成导出。首先来讲第1步，制作文书模板，例如我们需要做个成绩单成绩单做好后，我们进行第2步，制作要素表，并录入相应的数值。划重点！！！填充好数值后，表格一定]]></description><category></category></item><item><title><![CDATA[excel技巧]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/135076662</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/135076662</guid><author>ilwtfqqc</author><pubDate>Tue, 19 Dec 2023 09:21:11 +0800</pubDate><description><![CDATA["2"})=UPPER(MID(C1,18,1)),"正确","错误")第二种：直接告诉结果。]]></description><category></category></item><item><title><![CDATA[qeephp笔记]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/131466185</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/131466185</guid><author>ilwtfqqc</author><pubDate>Thu, 29 Jun 2023 23:00:17 +0800</pubDate><description><![CDATA[qeephp笔记]]></description><category></category></item><item><title><![CDATA[部署新网站]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/131455460</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/131455460</guid><author>ilwtfqqc</author><pubDate>Thu, 29 Jun 2023 14:20:40 +0800</pubDate><description><![CDATA[部署新网站]]></description><category></category></item><item><title><![CDATA[wps中去除带@的超链接，防止取消超链接后自动又生成超链接]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/127381887</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/127381887</guid><author>ilwtfqqc</author><pubDate>Tue, 18 Oct 2022 09:40:03 +0800</pubDate><description><![CDATA[文件->工具 -> 选项 -> 编辑->  取消勾选键入时将Internet及网络路径转换成超链接。]]></description><category></category></item><item><title><![CDATA[eccel身份证截取指定格式日期&插入10000条序号]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/117552782</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/117552782</guid><author>ilwtfqqc</author><pubDate>Fri, 04 Jun 2021 10:56:33 +0800</pubDate><description><![CDATA[=MID(D2,7,4)&amp;"-"&amp;MID(D2,11,2)&amp;"-"&amp;MID(D2,13,2)&amp;"" 
]]></description><category></category></item><item><title><![CDATA[php时间处理]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/115398420</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/115398420</guid><author>ilwtfqqc</author><pubDate>Fri, 02 Apr 2021 14:46:01 +0800</pubDate><description><![CDATA[date_default_timezone_set('PRC'); //默认时区

//当前的时间增加5天

$date1 = "2018-12-21";

echo date('Y-m-d',strtotime("$date1 +5 day")); //输出结果：2018-12-26

//相应地,要增加月,年,将day改成month或year即可

//+++ 今天、昨天、明天 、上一周、下一周 +++++++++

echo "今天:",date("Y-m-d",time()),"&lt;hr&gt;]]></description><category></category></item><item><title><![CDATA[新电脑或新安装php套件时出现这个错误说明是程序在调用‘ZipArchive‘ 这个类的时候没有成功]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/114527726</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/114527726</guid><author>ilwtfqqc</author><pubDate>Mon, 08 Mar 2021 13:02:23 +0800</pubDate><description><![CDATA[Fatal error: Class 'ZipArchive' not found in

 在新电脑或新安装php套件时出现这个错误说明是程序在调用'ZipArchive' 这个类的时候没有成功，原因是由于在安装php的时候没有增加php zip的支持（非zlib）。

在Windows下的解决办法是：

1、在php.ini文件中，将extension=php_zip.dll前面的分号“;”去除；

(如果没有，请添加extension=php_zip.dll此行并确保php_zip.dll文...]]></description><category></category></item><item><title><![CDATA[22]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/107593051</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/107593051</guid><author>ilwtfqqc</author><pubDate>Sun, 26 Jul 2020 14:13:12 +0800</pubDate><description><![CDATA[function actionShenlun()
 {
    // 为 $this-&gt;_view 指定的值将会传递数据到视图中
   $title_type = $this-&gt;_context-&gt;title_type;
  $page = intval($this-&gt;_context-&gt;page);
  
  if ($page &lt; 1 or $page&gt;140) $page = 1;
  
...]]></description><category></category></item><item><title><![CDATA[2]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/107593040</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/107593040</guid><author>ilwtfqqc</author><pubDate>Sun, 26 Jul 2020 14:12:28 +0800</pubDate><description><![CDATA[&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&lt;link rel="stylesheet" href="http://code.jquery.com/mobile/1.3.2/jquery.mobile-1.3.2.min.css"&gt;
&lt;script src="http://code.jquery.com/jquery-1.8.3.min.js"&gt;&lt;/script&gt;
&lt;script src="http://code.]]></description><category></category></item><item><title><![CDATA[php删除指定大小的jpg文件]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/97889075</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/97889075</guid><author>ilwtfqqc</author><pubDate>Wed, 31 Jul 2019 09:49:06 +0800</pubDate><description><![CDATA[function actionZmdel()
 {
  //set_time_limit(0);
  $dir = dirname(dirname(dirname(dirname(__FILE__)))).'/2012jxgwyimg';
  $dirarr = scandir($dir);
  echo '正在删除...';
  ...]]></description><category></category></item><item><title><![CDATA[联想M7216NWA墨粉清零：]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/97888607</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/97888607</guid><author>ilwtfqqc</author><pubDate>Wed, 31 Jul 2019 09:46:18 +0800</pubDate><description><![CDATA[联想M7216NWA墨粉清零：
在设备就绪状态下，按“功能”键，进入设置菜单，按上下键进行选择，屏幕出现“设备信息”项时按"确认"键，再按上下键选择，当屏幕出现“重置硒鼓”后长按“确认”键不松手，指导屏幕出现提示“重置”和“退出”，千万注意了，这时候不要选择重置也不要选择退出，而是直接按最右边的“开始“键，这时候屏幕文字全部消失，这时速度再按“向上键”这时候屏幕显示00，这时候再速度按“确认（ok...]]></description><category></category></item><item><title><![CDATA[用excel 和dos批量修改文件名]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/84935919</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/84935919</guid><author>ilwtfqqc</author><pubDate>Mon, 10 Dec 2018 10:28:49 +0800</pubDate><description><![CDATA[1、将目录下的所有文件名导入到test.xls里，用excel批量命名。

dir /b&amp;gt;test.xls

2、选中并输入公式：=&quot;ren &quot;&amp;amp;A1&amp;amp;&quot; &quot;&amp;amp;B1，可以拼接任意的文件名。

3、复制所有ren A B 到一个bat文件中，执行就ok，执行不成功看一下是否是编码问题。



其他：

ren *.jpge *.jpg //将所有jpge文件改为j...]]></description><category></category></item><item><title><![CDATA[excel判断语句]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/84935589</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/84935589</guid><author>ilwtfqqc</author><pubDate>Mon, 10 Dec 2018 10:08:21 +0800</pubDate><description><![CDATA[=IF(C6&amp;lt;80,&quot;长期在外&quot;,IF(C6&amp;lt;=85,&quot;三星&quot;,IF(C6&amp;lt;=94,&quot;四星&quot;,&quot;五星&quot;)))]]></description><category></category></item><item><title><![CDATA[将doxc的文件批处理添加前缀]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/84861281</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/84861281</guid><author>ilwtfqqc</author><pubDate>Thu, 06 Dec 2018 17:07:23 +0800</pubDate><description><![CDATA[@echo off
for /f &quot;delims=&quot; %%a in ('dir /a /b *.docx') do (
ren &quot;%%~a&quot; &quot;王村%%a&quot;)]]></description><category></category></item><item><title><![CDATA[根据一个人的姓氏随机生成几个人的名字]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/82788063</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/82788063</guid><author>ilwtfqqc</author><pubDate>Thu, 20 Sep 2018 15:25:15 +0800</pubDate><description><![CDATA[        $name5= mb_substr('袁斯强', 0,1,'utf-8');
        $ab=array(&quot;忠&quot;,&quot;少&quot;,&quot;小&quot;,&quot;斯&quot;,&quot;钦&quot;,&quot;义&quot;,&quot;仁&quot;,&quot;泉&quot;,&quot;仕&quot;,&quot;国&quot;,&quot;广&quot;,&quot;良&quot;,&quot;早&quot;,&quot;春&q]]></description><category></category></item><item><title><![CDATA[批量替换word模板，并解决中文乱码问题]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/82769429</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/82769429</guid><author>ilwtfqqc</author><pubDate>Wed, 19 Sep 2018 11:17:54 +0800</pubDate><description><![CDATA[require_once './lib/word/PhpWord.php';
require_once './lib/word/PHPWord/IOFactory.php';
$PHPWord = new  PHPWord();
$selsct = Weifanggaizao::find(&quot;id &amp;gt;= 1&quot;)-&amp;gt;order(&quot;id ASC&quot;)-&amp;gt;getAll();

foreac...]]></description><category></category></item><item><title><![CDATA[压缩图片，并解决中文名字乱码问题]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/81334615</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/81334615</guid><author>ilwtfqqc</author><pubDate>Wed, 01 Aug 2018 17:21:52 +0800</pubDate><description><![CDATA[&amp;lt;?php

    function thumbImage($im,$maxwidth,$maxheight,$name,$filetype)
    {
        $im =  iconv(&quot;utf-8&quot;,&quot;gbk&quot;,$im);
        $name =  iconv(&quot;utf-8&quot;,&quot;gbk&quot;,$name);
        switch ($filetype) {    ...]]></description><category></category></item><item><title><![CDATA[从phpMyAdmin批量导入Excel内容到MySQL]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/80462056</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/80462056</guid><author>ilwtfqqc</author><pubDate>Sat, 26 May 2018 15:19:48 +0800</pubDate><description><![CDATA[1、excel中的字段与数据库字段对应。2、清空id，然后excel文件&quot;--&quot;另存为&quot;，类型选择为&quot;CSV(逗号分隔)(*.csv)&quot;，将excel表另存为csv文档。3、notepad++打开csv文件，utf-8编码，保存。4、phpmyadmin导入&quot;导入文件的格式&quot;选择第二个&quot;CSV 使用 LOAD DATA&quot;，&quot;字段分隔符&quot;更改为&quot;,&quot;，OK了。...]]></description><category></category></item><item><title><![CDATA[zend studio创建一个已经有的项目]]></title><link>https://blog.youkuaiyun.com/ilwtfqqc/article/details/80104964</link><guid>https://blog.youkuaiyun.com/ilwtfqqc/article/details/80104964</guid><author>ilwtfqqc</author><pubDate>Fri, 27 Apr 2018 11:00:12 +0800</pubDate><description><![CDATA[首先在zend studio里面创建一个文项目，注意：不是文件夹，然后再将你的项目导入进去，（方法：点击创建的项目-右键-import-General-File System-browse-选择你要导入的项目-勾选Finish-Yes To All)就可以了...]]></description><category></category></item></channel></rss>