xlsx 简单快速地将客户名字和客户金额转到收据的小软件
资源内容介绍
xlsx 简单快速地将客户名字和客户金额转到收据的小软件更新版本20240925 <link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/base.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89796912/raw.css" rel="stylesheet"/><div id="sidebar" style="display: none"><div id="outline"></div></div><div class="pf w0 h0" data-page-no="1" id="pf1"><div class="pc pc1 w0 h0"><img alt="" class="bi x0 y0 w1 h1" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89796912/bg1.jpg"/><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">【确保<span class="_ _0"> </span><span class="ff2">shouju<span class="_ _0"> </span></span>文件夹为空<span class="_ _1"></span>,确保<span class="_ _1"></span>模板日期<span class="_ _1"></span>正确再<span class="_ _1"></span>运行程<span class="_ _1"></span>序,否<span class="_ _1"></span>则程序会<span class="_ _1"></span>崩溃、<span class="_ _1"></span>或者不<span class="_ _1"></span>符合</div><div class="t m0 x1 h2 y2 ff1 fs0 fc0 sc0 ls0 ws0">要求。<span class="_ _2"></span>】</div><div class="t m0 x1 h2 y3 ff1 fs0 fc0 sc0 ls0 ws0">第一步,将文件夹<span class="_ _3"> </span><span class="ff2">1 <span class="_ _0"> </span></span>复制到<span class="_ _3"> </span><span class="ff2">D<span class="_"> </span></span>盘,确保是直接在<span class="_ _3"> </span><span class="ff2">D<span class="_ _3"> </span></span>盘下,而不是在<span class="_ _3"> </span><span class="ff2">D<span class="_ _3"> </span></span>盘的其他文件夹下。</div><div class="t m0 x1 h2 y4 ff1 fs0 fc0 sc0 ls0 ws0">第二步<span class="_ _1"></span>,<span class="ff2"> <span class="_ _0"> </span></span>将所<span class="_ _1"></span>需数据复<span class="_ _1"></span>制到<span class="_ _3"> </span><span class="ff2">1.xlsx<span class="_ _0"> </span></span>文件中<span class="_ _1"></span>,确保只<span class="_ _1"></span>复制有<span class="_ _1"></span>关信息,<span class="_ _1"></span>没有标<span class="_ _1"></span>题和合计<span class="_ _1"></span>部分,</div><div class="t m0 x1 h2 y5 ff1 fs0 fc0 sc0 ls0 ws0">否则程序会报错崩溃。</div><div class="t m0 x1 h2 y6 ff1 fs0 fc0 sc0 ls0 ws0">重复单据要需要手动删除,累加。</div><div class="t m0 x1 h2 y7 ff1 fs0 fc0 sc0 ls0 ws0">确保<span class="ff2"> <span class="_ _4"> </span>C<span class="_ _3"> </span></span>列为客户名<span class="ff2"> <span class="_ _5"> </span>L<span class="_ _3"> </span></span>列为对应金额</div><div class="t m0 x1 h3 y8 ff3 fs1 fc0 sc1 ls0 ws0">第三步,双击<span class="_ _1"></span>运行程序</div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div><div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89796912/bg2.jpg"><div class="t m0 x1 h2 y9 ff1 fs0 fc0 sc0 ls0 ws0">第四步,运行程序完毕后,到<span class="_ _3"> </span><span class="ff2">D<span class="_ _3"> </span></span>盘<span class="_ _3"> </span><span class="ff2">1<span class="_ _3"> </span></span>文件夹内的<span class="_ _3"> </span><span class="ff2">shouju<span class="_ _3"> </span></span>文件夹里获得。</div><div class="t m0 x1 h2 ya ff1 fs0 fc0 sc0 ls0 ws0">第五步<span class="ff2"> <span class="_ _5"> </span></span>批量打印。</div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div><div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89796912/bg3.jpg"><div class="t m0 x1 h2 yb ff1 fs0 fc0 sc0 ls0 ws0">如图,文档中已包含已要求的<span class="_ _3"> </span><span class="ff2">1<span class="_ _3"> </span></span>客户姓名、<span class="ff2">2<span class="_ _3"> </span></span>金额、<span class="ff2"> <span class="_ _0"> </span>3<span class="_"> </span></span>大写金额</div><div class="t m0 x1 h2 y7 ff1 fs0 fc0 sc0 ls0 ws0">以及对应位置的¥符号、和<span class="_ _3"> </span><span class="ff2">4<span class="_ _3"> </span></span>相应的收据打印格式,并且在文件夹中<span class="_ _3"> </span><span class="ff2">5<span class="_ _3"> </span></span>按顺序排放。</div><div class="t m0 x1 h2 yc ff1 fs0 fc0 sc0 ls0 ws0">批量打印用到<span class="_ _3"> </span><span class="ff2">wps<span class="_ _3"> </span></span>文件内的<span class="_ _3"> </span><span class="ff2">xlsx<span class="_ _3"> </span></span>的批量打印如图</div></div><div class="pi" data-data='{"ctm":[1.611830,0.000000,0.000000,1.611830,0.000000,0.000000]}'></div></div>