Label printing method and system based on XML and Excel

Abstract

The invention discloses a label printing method and system based on XML and Excel. The printing method comprises the steps: defining the type of a label according to the requirement of a pre-printed label; defining an XML configuration file according to the label type; analyzing the XML configuration file to obtain configuration file information, and loading an Excel template file; according to the configuration file information, obtaining original data from a data source and processing the original data to generate label data; combining the label data with the loaded Excel template file, andgenerating label Excel data in a system memory; and printing the label Excel data according to the configuration file information. The system comprises a label definition module, a configuration module, an analysis and loading module, a label data generation module, a label generation module and a printing processing module. According to the method and the system, a user can customize and dynamically generate the label only by using Excel, so that the WYSIWYG function is realized, and meanwhile, the implementation and maintenance cost can be greatly reduced.

Description

technical field [0001] The invention belongs to the technical field of sign printing, and in particular relates to a sign printing method and system based on XML and Excel, which are simple to use, customizable, and can greatly reduce implementation and maintenance costs. Background technique [0002] A sign is a sign used to identify important information such as varieties, specifications, and quantities of goods or services, and belongs to one of the labels. For example, steel signs are mainly used to display brand, steel type, weight and other information. In the prior art, the hard-coded label printing method in the software is generally used for the label printing of products such as steel products. Although it can meet some requirements, there are one or another deficiencies in terms of implementation cost, maintenance cost and flexibility, especially when When product signage requirements change, not only is it difficult for ordinary operators to customize in a timel...

AI Technical Summary

Problems solved by technology

In the prior art, the hard-coded label printing method in the software is generally used for the label printing of products such as steel products. Although it can meet some requirements, there are one or another deficiencies in terms of implementation cost, maintenance cost and flexibility, especially when When product signage requirements change, not only is it difficult for ordinary operators to customize in a timely manner, they often have to wait for developers to modify them, or even re-develop new programs before they can be realized. Moreover, it is difficult to achieve what you see is what you get in the modification process, requiring developers The modification can only be completed after repeated printing attempts, and the modification efficiency is also low, which often cannot meet the real-time requirements of frequent changes in steel and other multi-specification and multi-variety product labels

Images