xujinhua 发表于 2020-5-13 19:38:07

将表内容填入指定excel的指定工作表内

(("空" "空" "空" "十三" "个人" "有" "有" "1998" "商店" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "211.46" "72.83" "138.63" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "空" "4.71" "44.64" "4.71" "44.64" "4.71" "44.64" "4.71" "44.64" "空" "32.90" "5" "4" "A" "A" "空" "0.00" "211.46" "32.90" "32.90" "44.89" "36.12" "33.61" "123.45" "67432" "建设用地规划许可证" "32131231" "集体土地建设用地使用证" "21321312" "不动产权证书" "花都区" "xujin" "001"))

想把上述表写入指定excel的工作表上,并以表内其中一项作为文件名另存呢?

比如我的excel文件在c:\模版表格\表格.xlsx      

表格.xlsx内在5个工作表,分别是1、2、3   我想把上述表内容写到2工作表的第二行开始填起。并以表最后一个001作为文件名另存excel文件


谢谢!!!

yhly555 发表于 2021-2-24 09:17:37

参考一下这个
http://bbs.mjtd.com/forum.php?mod=viewthread&tid=110435&highlight=excel

xujinhua 发表于 2021-3-5 22:36:57

yhly555 发表于 2021-2-24 09:17
参考一下这个
http://bbs.mjtd.com/forum.php?mod=viewthread&tid=110435&highlight=excel

谢谢!我看下
页: [1]
查看完整版本: 将表内容填入指定excel的指定工作表内