First we open the barcode printing software and click "New" to create a label. After the label is created, we can click "Database Settings" in the upper right corner of the software and select "Add" "Excel Data Source" (JDBC)", click "Browse" to select your own Excel table file, click "Test Connection", so that we can see how much data there is in the Excel table, click "Add", so that we complete the data of the Excel table Batch Import. As shown in the picture below:
We want to batch generate QR codes from the data in the Excel table, so first we need to create a QR code, click on the left side of the barcode printing software Draw QR code on the side toolbar to create a new QR code. Here we first select this QR code, and then double-click to pop up the "Graphic Properties" window. Click the "Barcode" tab and we can see the default The type is QR Code. In fact, Zhonglang barcode printing software supports multiple QR code types. Here we just choose the default one, as shown in the figure below:
Related recommendations : "excel basic tutorial"
Then we open the "Data Source" tab in "Graphic Properties", click the "Modify" button, and in the pop-up "Data Object Management" window For the data type, we select "Database Import", so that we can see that the content in the "Connect" option below is the Excel table data source we just imported. Select the "field" content we need and click "Edit" , as shown below:
#If we want to display multiple field information for the same piece of data in the Excel table, click the " " sign in "Data Source" to add a new one Data object, the data object type is also "database import", select the "field" that needs to be displayed, and confirm, as shown in the figure below:
Here we use barcode printing The software imports data from existing Excel tables to generate QR codes in batches, and you're done. Next, we can click "Print Preview" so that we can see the variable QR codes we generated in batches, and the generated QR codes correspond to a piece of data in the Excel table. As shown below:
The above is the detailed content of Can Excel tables generate QR codes in batches based on order numbers?. For more information, please follow other related articles on the PHP Chinese website!