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
EAN 128 Barcode FAQ in Excel
GS1-128/EAN-128 Barcode Add-In for Excel provides an easy access to EAN 128 barcode generation on Excel spreadsheet. Rich barcode setting options from various aspects on the barcode setting panel are provided to meet any requirement, such as barcode sizing configuration, barcode graphic configuration, etc.
As for EAN 128 creation, there are other barcode generators specifically designed for GS1 128, such as Java GS1 128 Barcode Generation Component, GS1 128 in Client RDLC, .NET EAN 128 Library in Report Applications, EAN 128 Fonts.
EAN 128 Data Encoding in Excel
As a 2D barcode, EAN 128 on Excel can encode the data conforming to its industry standards as below:
Valid Characters to be Encoded:
- Standard ASCII values: 0-128
- Extended ASCII Values: 128-255
EAN 128 Valid Data Length to be Encoded:
As for encoding EAN 128 data in the Excel Add-In, the following parameters will be used:
- 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.
Encode EAN 128 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 "EAN 128" in the "Barcode Type";
- Input the data to be encoded like "EAN 128" in the "Data" box;
- Customize the properties that are required and click "Generate" to output the created EAN 128 barcode;
- Then you may link the created barcode into a certain cell with data using "Link to Cell".
EAN 128 Image Customization in Excel
GS1 128 barcode image is not fixed for the bar placement as well as rotation angle. Users may set them to change the image displaying of EAN 128 on Excel:
- 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.
- Display checksum char --- Determine whether to display the last check sum character (s) in the barcode text.
- Font --- Adjust the font style of the barcode text under image; Default is "Arial", "Regular", "9".
Customize EAN 128 Image with Barcode Add-In for Excel
- Implement the add-in to generate an EAN 128 barcode;
- 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 "Display barcode data" if you want to customize "Font" into your needed style such as "Calibri", "Regular", "15";
- 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".
EAN 128 Size Adjustment in Excel
During the implementation of generating EAN 128 on Excel spreadsheet, you may take the size of EAN 128 a concern. Then you may set the following properties to change the size of EAN 128:
- Bar width (X) --- The width value of the barcode narrowest bar module (X); Default value is 1.
- 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 EAN 128 Size on Excel Spreadsheets
- Select the generated EAN 128 barcodes;
- Set the "Barcode width" into "2", "Barcode height" into "77", "Left margin" into "3", "Right margin" into "3", "Top margin" into "3", "Right margin" into "3";
- 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 GS1-128 Products & Information
The following GS1-128 products and GS1-128 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!
