avatar
Articles
9
Tags
0
Categories
0

隔夜的剑客

VBS操作Excel

Created2023-01-15|Updated2023-03-09
|Post View:
Author: zhangjian
Link: http://industrialcontrolbamboo.github.io/2023/01/15/VBS%E6%93%8D%E4%BD%9CExcel/
Copyright Notice: All articles in this blog are licensed under CC BY-NC-SA 4.0 unless stating additionally.
cover of previous post
Previous Post
VBS与Access交互
cover of next post
Next Post
单轴运动控制绝对运动程序
avatar
zhangjian
Articles
9
Tags
0
Categories
0
Follow Me
Announcement
This is my Blog
Catalog
  1. 1. 1.创建Excel应用程序对象
  2. 2. 2.指定路径
  3. 3. 3.检查路径中文件是否存在,如果存在打开工作簿,工作表
  4. 4. 4.向工作表中的单元格插入相关值
  5. 5. 4.1 读取Excel表中的值
  6. 6. 5.保存并关闭工作簿
  7. 7. 6.关闭Excel程序,释放Excel对象
Recent Post
Hello World
Hello World2024-12-06
VBS操作Mysql
VBS操作Mysql2023-03-13
VBS与SqlServer交互
VBS与SqlServer交互2023-03-13
VBS与Access交互
VBS与Access交互2023-01-29
VBS操作Excel
VBS操作Excel2023-01-15
©2020 - 2024 By zhangjian
Framework Hexo|Theme Butterfly