VB结合Excel进行数据处理和绘图的工程应用

论述了VB程序设计语言与Excel软件相结合,成功地解决VB在数据处理及自动绘图方面编程难度大、开发效率低的难题.并以水库溃坝计算程序的编制过程为例,不仅实现了在VB内部调用Excel进行数据处理及自动绘图功能,而且还调出Excel自动生成的图表并显示在VB的表单中.应用VB与Excel相结合处理大批量图表数据,其优点更为显著,可大大的提高工作效率.

Application of VB associated with Excel to the data-dealing and plotting

In this paper,the method that using the VB language associated with Excel is given in the paper which is proved to solve the difficulty successfully of programming hard and developing inefficient with VB language in data-dealing and plotting automatically. A programming to calculate the process of dam-routing of reservoir is taken for example to prove such application above with further function of showing the diagrams generated by Excel automatically in the form-list of VB. It shows that it has great advantages and can help work more efficiently with the application to the dealing of great deal of data and diagrams.