当前位置:网站首页>How to generate PDF417 code from excel sheet data by barcode printing software

How to generate PDF417 code from excel sheet data by barcode printing software

2020-11-10 16:03:05 Yu Xiaotao

PDF417 It's a stacked QR code , Can represent a number , Alphabetic or binary data ,PDF417 The QR code can hold 1850 Characters or 1108 Bytes of binary data , If only the number can hold 2710 A digital . Today, I'd like to introduce how to use Zhonglang barcode printing software to save in Excel The data in the table is generated in batch PDF417 code .

Create a blank label in Zhonglang barcode printing software , Click the database button above the software to open “ Database settings ” Add one “Excel data source ”, Keep in Excel The QR code data in the table is imported into the software through the database .

 Batch build PDF417 code 1.png 

 Batch build PDF417 code 2.png 

add to Excel The data source will pop up “Excel Data source management ” window , Click on “ Browse ” Find and add Excel Table file , Click on “ Test connection ” and “ add to ” Button , Then close the database settings window .

 Batch build PDF417 code 3.png 

Use the QR code icon in the left toolbar of barcode printing software , Draw a QR code on a white canvas ( The default type of QR code drawn is QR code ), Double click the QR code to open “ Graphic properties - bar code ” One column , Change the QR code type to “PDF417”, After saving, you can see that the QR code has become PDF417 code ,PDF417 Code can be changed by dragging the QR code .

 Batch build PDF417 code 4.png 

And then in “ data source ” Modify the QR code data , Change the data object type to “ Database import ”, Import Excel Batch generation of table data PDF417 code . Print Preview allows you to view batch generation PDF417 QR code effect .

 Batch build PDF417 code 5.png 

 Batch build PDF417 code 6.png 

The above is the use of Lang barcode printing software Excel Batch generation of table data PDF417 Code operation method , Zhonglang software supports a variety of database types , except Excel Tables can also be connected to TXT、Access、CSV、MySQL、SQLServer And other database types to generate barcode QR code in batch , If you need it, you can experience it !

版权声明
本文为[Yu Xiaotao]所创,转载请带上原文链接,感谢