The Generation of Data Report of Roller Automatic Production Line Detection Unit

摘要

The detecting unit of the roller automatic production line detects the key parameters of each roller and archive them, to analyze whether the roller product performance standards according to the detecting information. The detecting data was stored into SQL database using the VBS of the WinCC software in the host computer. The data in the database were read out to report forms using the VBA in EXCEL for producer to analysis. To solve practical problems and good results have been achieved.