ExcelVBA在SPI二次开发中的应用

针对SPI所生成报告形式相对固定、客户化难度大的问题，提出利用ExcelVBA编程自动生成仪表专业报告的解决方法，详细介绍了该方法实现的关键步骤及要点。该方法成功地提取了SPI数据库中的仪表设计数据，并将这些数据按照设计单位的相关模版自动输出为最终仪表设计文件。经过项目的实际应用和不断完善，该软件已经能自动输出仪表索引...

Application of Excel VBA in Secondary Development of SPI

According to the problem of relative fixed and difficult customized report form generated from SPI, one solution is proposed to utilize Excel VBA programming to automatically generate instrument professional reports, key steps and main content of the method are described in details. The method extracts instrument design data from SPI database successfully, and then automatically export into final instrument design documents based on related template of the design unit. After application in actual projects and continuous improvements, this software already can export many instrument design documents, such as instrument index, monitoring data sheet, material sheet and instrument and cable sheet, etc. The practice proves that the method provides advantage of stunning flexibility and strong reusability, and can improve instrument designer＇s working efficiency significantly.