Avapose.Barcode for Excel
- Mature barcode generation add-in for MS-Excel 2007/2010
- Support 20+ common linear and 2D barcodes creation
- Provide freely adjustable barcode options
PDF 417 Barcode FAQ in Excel
Excel PDF 417 is a PDF 417 generation function developed for Excel to generate PDF 417 barcodes on cells of Excel. Full barcode setting properties are customizable including some special features of PDF 417 conforming to its specification, like error correction level, data mode, row count, column count, truncated PDF 417, etc.
You may need these tools for other developmental environments or applications such as .NET PDF 417 Generator for SSRS, Word PDF 417 Barcode Add-In, Barcode Fonts for PDF 417, ASP .NET PDF 417 Component for Web Applications.
PDF 417 Data Encoding in Excel
This part focuses on PDF 417 valid encoding data set as well as encodable data length. Detailed data encoding steps are provided for your easier implementation:
PDF 417 Valid Encoding Characters:
- Standard ASCII values: 0-128
- Extended ASCII Values: 128-255
PDF 417 Maximum Number of Data Character:
- Text Compaction mode: 1 850 characters
- Byte Compaction mode: 1 108 characters
- Numeric Compaction mode: 2 710 characters
Properties that may be needed for PDF 417 data encoding for excel:
- Barcode Type --- Barcode types could be changed by setting this property, default value is Code 128.
- Data --- The data to be encoded. This property lets you encode desired data; Default value is 12345.
- Apply tilde --- Tilde character (~).When enabled, the tilde character (~) is used to specify the special character in the input data.
- Data Mode --- Used to encode different kinds of characters; Default value is AUTO.
- GS1 Compatible Barcode --- Used to use GS1 specification for GS1 compatible barcode image creation.
Encode PDF 417 Data using Excel Barcode Add-In
- Barcode Add-In for Excel needs to be downloaded and installed at first;
- Install this barcode generator on your Excel;
- Activate the add-in and choose "PDF 417" in the "Barcode Type";
- Select a proper "Data mode" according to the data to be encoded like "Text";
- Enable "Apply tilde" if you want to specify the special characters in the input data;
- Input the data to be encoded like "excel-add-in" in the "Data" box;
- Enable "GS1 Compatible Barcode" if you need GS1 compatible barcode image;
- Customize the properties that are required and click "Generate" to output the created PDF 417 barcode;
- Then you may link the created barcode into a certain cell with data using "Link to Cell".
PDF 417 Image Customization in Excel
The following parameters may be required to change the image of PDF 417 barcode on Excel spreadsheet:
- Rotate --- Barcode orientation can be changed into 0, 90, 180 or 270 degrees; Default is 0.
- Bar Alignment --- Bar placement can be customized into right, center and left inside the image; Default is Center.
- Truncated PDF 417 --- Enable it to create truncated PDF 417 barcode.
Customize PDF 417 Image with Barcode Add-In for Excel
- Select the generated PDF 417 barcodes;
- Set the rotation angle of the barcode image into any valid angle such as "90";
- Select the proper position to put the bar module by setting "Bar alignment" such as "LEFT";
- Enable "Truncated PDF 417" if required;
- Click "Update" where "Generate" is located for a updated barcode;
- Then you may link the created barcode into a certain cell with data using "Link to Cell".
PDF 417 Size Adjustment in Excel
During the implementation of generating PDF 417 on Excel spreadsheet, you may take the size of PDF 417 a concern. Then you may set the following properties to change the size of PDF 417:
- Bar width (X) --- The width value of the barcode narrowest bar module (X); Default value is 1.
- Row count --- To adjust the number of the rows for PDF 417 barcode ranging from 3 to 90.
- Column count --- To adjust the number of the columns for PDF 417 barcode ranging from 1 to 30.
- Image width --- The width value of whole barcode image; Default value is 99.
- Image height --- The height value of the whole barcode image; Default value is 60.
- Left margin --- The value of the left margin; Default value is 0.
- Right margin --- The value of the right margin; Default value is 0.
- Bottom margin --- The value of the bottom margin; Default value is 0.
- Top margin --- The value of the top margin; Default value is 0.
Adjust PDF 417 Size on Excel Spreadsheets
- Select the generated PDF 417 barcodes;
- Set the "Barcode width" into "2", "Barcode height" into "90", "Left margin" into "2", "Right margin" into "2", "Top margin" into "2", "Right margin" into "2";
- Customize the "Row count" to "8" and "Column count" to "8";
- Click "Update" where "Generate" is located for a customized barcode;
- Then you may link the created barcode into a certain cell with data using "Link to Cell".
Related PDF417 Products & Information
The following PDF417 products and PDF417 barcode creating information links relate to this product that may be of interest to you:
We bought your product Barcode Add-In for Excel a few weeks ago, and it works pretty well!
