Open an excel database and enter the contents to be printed, such as product name, price, serial number, etc. , and then input data by field name in turn, such as PT900 diamond ring, 5000.00, ASD 123, etc. , and then click Save. The file name is "Jewelry Label" (the file name must be in Chinese).

The storage location is "Desktop". At this time, you need to select the field column with decimal point, right-click to set the cell format and set it to numerical value.

Click File and select Save As to save the database in DBF4 format. Specific operation: Select Save As, click the save type to find DBF4 to save (note: do not change the original file name and save location).

Note: No matter what prompts appear when saving, you should confirm the software connection.

Open the Qlabel-III icon on the desktop, click New, click Database, select Open DBF file, select the DBF file just saved, and wait until "Connection Successful" appears.

Then click WinText, select database and nsterField for template arrangement.

Select the required file fields, click OK and then click Font to select the appropriate font and font size, and then put the contents to be printed on the template in turn.

After the print location is determined, click Save As File Name to save it.