Automatic UPC-A Barcode Generation Used on Excel

• Fully functional UPC-A barcode generator add-in used in Excel 2007 and 2010
• All generating operations are done using an intuitive user interface within Excel
• Generate all printers-compatible UPC-A barcode in Excel without any barcode fonts
• Link cells of data with UPC-A barcodes in Excel quickly and conveniently
• Offer customizable options for image size, orientations and text style
• Generate most 1d & 2d barcode types in Microsoft Excel spreadsheets

1. Set the Barcode Type property to UPC-A or UPC-A +2 or UPC-A +5.
2. Set the Data property with the value to encode. Type is string.
   User should only provide 11 digits, and DO NOT include last digit checksum character.
1. Valid Data Scope:
• 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
2. Valid Data Format:
   11 digits. There are totally 12 digits in UPC-A barcode, first 11 digits are barcode value, and last digit is the checksum digit, which is generated by barcode library automatically.
3. Sample: Data = "01234567891"
3. Set the Supplement data property with the supplement value to encode. Type is string.
   Provide 2 digits for barcode type UPC-A +2, and provide 5 digits for type UPC-A +5.



4. Add checksum char property is not applied here. Barcode Library will always add a check character in the last digit (modulo 10).



5. 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.
6. 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.
7. Set Rotate property.
   If you want to rotate barcode image, valid values are : 0, 90, 180, 270