| 用VB调用Excel实现SPD表自动编制 |
| |
| 引用本文： | 刘红坤,孟德东,王小丽. 用VB调用Excel实现SPD表自动编制[J]. 计算机时代, 2014, 0(1): 42-43,46 |
| |
| 作者姓名： | 刘红坤 孟德东 王小丽 |
| |
| 作者单位： | 河北省保定市气象局,河北保定071000 |
| |
| 摘 要： | 检测电涌保护器(Surge Protection Device,SPD)时,采集到的批量数据需要自动表格化,针对此问题,提出了在Visual Basic(简称VB)环境下调用Excel对象编程实现自动制SPD表的方法。分析了VB调用Excel的理论依据和步骤,阐述了自动绘制SPD表的主要设计思想,剖析了自动绘制SPD表的关键技术。实践证明,此方法可行且有效。
|
| 关 键 词： | SPD VB Excel 自动制表 |
Realization of automatically making SPD table by VB calling excel |
| |
| Liu Hongkun,Mcng Dedong,Wang Xiaoli. Realization of automatically making SPD table by VB calling excel[J]. Computer Era, 2014, 0(1): 42-43,46 |
| |
| Authors: | Liu Hongkun Mcng Dedong Wang Xiaoli |
| |
| Affiliation: | (Baoding Meteorological Office, Baoding, Hebei 071000, China) |
| |
| Abstract: | When SPD is detected, the mass data which has been collected need to be automatically made table. Aiming at the existing problems, a method of programming to realize automatically making SPD table in Visual Basic is laid out. The theoretical basis, procedure and method about VB calling Excel are analyzed. The main ideas of automatically making SPD table are stated. The key technology in automatically making SPD table is analyzed. Practice proves that the way is feasible and effective. |
| |
| Keywords: | SPD VB Excel automatically making table |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
