How to batch print labels in excel

The method of batch printing Excel table data as labels is as follows:

Print the data in the following two Excel tables as labels:

##1. First, design the asset tag template, as shown below:

2. Asset tags connect to the database. Click the database setting picture in the menu bar, as shown in the figure:

3. The following dialog box appears, select Next:

4. Check the corresponding database type. Here we take excel as an example. Click Next:

5. Click "Browse" to find the data source. That is, select the excel data you want to print, open it, and then click "Test Connection" to verify whether the connection is successful. Click Next:

6. Select the tables of Factory A and Factory B, add them to the right, and click Next:

7. At this point, click "Finish"

8. At this time, you can open the table directory on the left and click the "Browse" tab to browse the data content . Click OK to enter the label design interface:

9. Select "Barcode" and "Text" from the toolbar, place them in the corresponding positions of the label template, and edit them :

10. Double-click the "Barcode" box or the "Text" box, and the editing dialog box will appear, as shown in the figure below. Select "Database Field" and "Use Domain" from the "Source" drop-down box to indicate the area to be printed. Here, asset number is used as an example. The sample data can be filled with any asset number in the data source, or you can ignore it.

#11. Click OK. Now a barcode label connected to the excel data table has been created.

12. Regarding label printing settings:

In the print dialog box, the number of copies of the same label and the number of serial labels need to be set in the options. Settings, check "Set by data source".

13. If you only need to print a part of the data in the data table, you can manually select the data to be printed in Print---Select Record.

Recommended:

Excel Basic Tutorial

The above is the detailed content of How to batch print labels in excel. For more information, please follow other related articles on the PHP Chinese website!