Our Customers
|
Code 128 Barcode Generator Add-In for Excel
How to Generate & Print Code 128 Barcode in Excel Spreadsheets
- Mature Code 128 generating add-in, suitable for users of Excel 2007 & 2010
- Capable of generating Code 128 barcode in Excel with 4 directions
- Flexible to adjust properties of Code 128 in Excel, like image width & height
- Able to link cells with linear Code 128 barcodes in Excel spreadsheet
- Compute and add checksum character to Code 128 automatically in Excel
- Created Code 128 barcodes meet industry standards and support all printers
Guidance to Install Code 128 Generator Add-In to Excel
Integration with Office Excel
- Close all Excel spreadsheets.
- Run the "BarcodeLib.Barcode.Excel.{NNNN}.Addin.Setup.exe" to install. Note: {NNNN} is your Microsoft Office Excel verison, such as 2019, 2016, 2013.
How to Insert a Code-128 barcode with Specified Image Width and Height
If you need generate Code-128 barcodes with required image width and height, and also need Code-128 bar module (X, Y) as max as possible.
- Check property "Auto resize"
- Set property "Image Width", "Image Height"
Code 128 Barcode Property Settings
- Set the Barcode Type property to CODE 128, CODE 128 A, or CODE 128 B, or CODE 128 C.
- CODE 128 - default (auto):Barcode Library will automatically switch between code sets to encode the ASCII values.
- CODE 128 A: Barcode Library will encode the Char Set A which only supports ASCII values from 0 to 95.
- CODE 128 B: Barcode Library will encode the Char Set B which only supports ASCII values from 32 to 127.
- CODE 128 C: Barcode Library will encode the Char Set C which only supports pairs of digits.
- Set the Data property with the value to encode.
Type is string.
- Valid Data Scope for Code 128 Auto:
- All 128 characters of ASCII (ASCII values from 0 to 127)
- Valid Data Scope for Code 128 Set A :
- Supports ASCII values from 0 to 95
- Valid Data Scope for Code 128 Set B :
- Supports ASCII values from 32 to 127
- Valid Data Scope for Code 128 Set C:
- Sample: "BLSample"
- Check the Apply Tilde (~) property,, if you want use the tilde character "~" to specify special characters in the input data.
- ~1: is used to represent the FNC1 code.
- ~2: is used to represent the Structured Append and must be followed by a 3-digit number between 1 and 255.
- ~3: is used only at the very beginning of the symbol for the reader programming purpose.
- ~5: is used only at the very beginning of the symbol, the header [)> + ASCII 30 + ASCII 05 + ASCII 29 will be transmitted by the barcode reader before the data in the message and the trailer ASCII 30 + ASCII 4 will be transmitted afterwards.
- ~6: is used only at the very beginning of the symbol, the header [)> + ASCII 30 + ASCII 06 + ASCII 29 will be transmitted by the barcode reader before the data in the message and the trailer ASCII 30 + ASCII 4 will be transmitted afterwards.
- ~7NNNNNN: is used to specify the Extended Channel and NNNNNN is a value between 000000 and 999999.
- ~dNNN: is used to represent the ASCII character with the value of NNN.
- Add checksum char property is not applied here. Barcode Library will always add a check character between encoded data and stop character (modulo 103).
- Barcode Size Settings.
- Set property Unit of Measure (Unit of Measure) for properties Bar Width, Bar Height, Margins.
Valid values are Pixel, CM, Inch.
- Set the Image Width and Image Height properties.
Both types are float.
- Set the Bar width (X) (for bar cell width) and Bar height (Y) (for bar cell height) properties.
Both types are float.
- Set the Left Margin, Right Margin, Top Margin and Bottom Margin properties.
Types are all float.
- If the Auto Resize property is chacked, the generated barcode image width and height will be the same as property "Image width", and "Image hight", and it will generate the maximum Bar Width and Bar Hight.
- Set the DPI property (Value is expressed in DPI - Dots per inch).
Type is int.
- Setting up Barcode data text style in barcode image (Tab: 1D Barcode).
- Set the Display barcode data properties. If Display barcode data is checked, barcode data will be displayed with the barcode.
- Set the Font property. The font used to display text in barcode image.
- Set Rotate property.
If you want to rotate barcode image, valid values are : 0, 90, 180, 270
All Supported Linear & 2D Barcode Types in Excel 2019/2016/2013/2010/2007
You can also generate other linear barcodes in Excel spreadsheet as well.
- It is also available for 2d barcode types as follows:
|