Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

 

Barcode Generator

 

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Barcode Creator-Barcode Generator-Create Barcodes-Generate Barcodes

Barcode Sites: IDAutomation

Barcode generator and creator. Generate Barcodes, all types of Barcodes in seconds. EAN 8,13, UPC A,E, Code39, Code 2/5 interlaced, Code 2/5i (German), Code 128 A,B,C

Barcode Generator for free by buying Label Master

Barcode Generator Options

Barcode Generator
- EAN 8,13
- UPC A,E
- Code39
- Code 2/5 interlaced
- Code 2/5i (german)
- Code 128 A,B,C

Parameters : width, scale, rotation, text, font, add-on Barcode Generator Screen Shot
- Printer
- Clipboard
- Export to BMP

All modifications are seen immediately in a preview area before being applied.

Types

EAN-8 : European Article Numbering. Allows 7 digits plus 1 EAN control digit.
EAN-13 : European Article Number. 13-digit code, similar to UPC-A with respect to height, width and number of bars. Allows, however, a 13th EAN control digit.

UPC-A : Universal Product Code. Commonly used in shops since 1973. Identifies a product and its maker. 11-digit code, plus one control digit.
UPC-E : 6-digit variant of UPC-A, used on many drinking cans, when space is not available for a full UPC-A (a number of zeroes are ignored).

Code 39 : The oldest type of bar-code. It uses all the printable ASCII characters. Its length is variable and can reach 50 characters. The code Start s and ends with a * symbol. Each character is associated with 5 bars and 4 spaces.
Interlaced 2/5 code : High density, variable-length code using the digits between 0 and 9. The number of digits must be even. If the number of input digits is odd, a control digit is automatically added.
2/5i code : German version of the 2/5 code. The control digit is calculated in a different way.

128 code : variable length code that accepts all ASCII characters. Introduced in 1981 as a very high density code.

Text

Contains the string of characters that will be coded in the bar-code. EAN, UPC and the 2/5 code do only accept the digits between 0 and 9. The 39 code accepts additionally the characters of the alphabet (from A to Z). EAN and UPC have a fixed length. The 39 code and the 2/5 code have variable lengths.
Input controls are as follows:
- non numerical characters are converted to digits when necessary (EAN, UPC and 2/5 code)
- if the string is too long, the extra characters are truncated.
- if the string is too short, padding zeroes are added at the end.
- lower-case characters are converted to upper-case in the 39 code.
- if an odd number of characters is input in the 2/5 code, a control number is added.

The number of allowed characters (excluding the control digit) is :
- EAN-8 : 7 digits
- EAN-13 : 12 digits
- UPC-A : 11 digits
- UPC-E : 6 digits
- 39 code : less or equal to 50 (letters in upper-case and digits)
- 2/5 code : any even number of digits
- 128 code : any number of upper-case or lower-case letters, as well as digits and special characters.

Add-on

The EAN-13 and UPC-A codes can take a supplementary 2-digit code (for magazines) or a supplementary 5-digit code (book price, following the main part which codes the ISBN number). The 2-digit add-ons range from 00 to 99. The 5-digit add-ons range from 00000 to 99999. Any string featuring more than two characters will be interpreted as a 5-digit add-on.

Width

Bar-codes consist of elementary modules. Each module is a bar or a space of a given width. The minimum width (for both bars and spaces) is called the module width. All other widths are multiple values of this width.

The module widths of EAN and UPC are :

SC0: 0,270 mm
SC1: 0,297 mm
SC2: 0,330 mm
SC3: 0,363 mm
SC4: 0,396 mm
SC5: 0,445 mm
SC6: 0,495 mm
SC7: 0,544 mm
SC8: 0,610 mm
SC9: 0,660 mm

A technical problem due to the resolution of the output peripheral can result in the printed bar-codes having a different size from the bar-codes displayed on screen : the smallest size difference for bar-codes is 0.033 mm (between SC1 and SC2, for example). The resolution of most printers is larger than this value (300 dpi correspond to 25,4/300 = 0,0847 mm). It follows that the module width is rounded. If you use SC2 (module width of 0.33 mm), a 300 dpi printer will use 4 pixels for one module, that is 25,4*4/300=0,339 mm. The smallest bar-code would use 3 printer pixels for a module, that is 25,4*3/300=0,254 mm, which is just below the correct size for SC0. The biggest bar-code would use 5 printer pixels, that is 25,4*5/300=0,423 mm, which corresponds roughly to SC5. For that reason, not all printers will allow to print bar-codes at their correct size, as they do not manage all the sizes (SC0 to SC9). The higher the resolution of the printer, the bigger the range of widths that can be printed. Screen resolutions are also an awkward problem: Windows uses a 96 dpi resolution (about 0,265 mm). A bar with a width of 0,265 mm has a width of 1 pixel. If you take 2 pixels as a module width (0,530 mm), only two sizes will be represented on screen.

Height scale

A value of 100 corresponds to the real size. You can print a bar-code that is less high, by specifying a smaller number. The range varies between 20 and 200.

Rotation

Shows the orientation of the bar-code.

Font

This is the font used for the bar-code text. Arial is the default, as it is delivered with Windows. You can use any True Type font installed on your computer. With the UPC and EAN codes, it is recommended to use the OCR-B font.

Font scale

Sets the font size for the bar-code text. A value of 100 is recommended for most cases. The range varies from 20 to 200.

Fine lines

Check this option if you do not have a laser printer (note : to print bar-codes, you should, in principle, ALWAYS use a laser printer). With ink-jet printers, the bars are often too wide and leak into the spaces, which makes it difficult to read by a scanner. Checking this option, will result in the bars being narrower by a printer pixel in comparison with spaces of the same width. This will ensure flawless bar-codes in most cases. However, a perfect quality cannot be guaranteed with ink-jet printers. The same can be said for dot matrix printers, for the following reason :  the needles of a matrix printer have a diameter of about 0.160 mm. Yet, some claim to print with a resolution of 360 dpi, which correspond to points with a diameter of 0.07 mm. If you want to print a 0.07 mm thick line, the printer will produce a 0.160 mm thick line... The difference is enough to render a bar-code unreadable. In principle, this defect has been corrected in the drivers for matrix printers written for Windows 95. In summary, if you use a matrix printer, perform tests, with or without the option checked, in order to determine what works best in your particular case.

Show text

Depending on whether this option is checked or not, the bar-code text is displayed (and hence printed) or not.

Barcode Generator Screen Shot

Barcode Generator and Creator  $10.00 Secure Payment Options

Get Barcode Generator for free by buying Label Master

Special ! Free Choice of Complete Excel Training Course or Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Send payment proof to [email protected] 31 days after purchase date.  All purchases can be made via Id-Automations site

See Also: Barcodes - Fonts, ActiveX, labels and DLL's Index. Barcode MICR CMC-7 || Codabar Barcode Font || Code 11 Barcode Font || Code 128 Barcode Font || Code 25 Barcode Font || Code 39 Barcode Font || Code 93 Barcode Font || Code39 Full ASCII Barcode Font || Data Matrix Encoder || Interleaved 25 Barcode Font || MICR E13B Font || MSI Barcode Font || OCR Font || PDF417 Encoder || Telepen Barcode Font || UPC EAN Barcode Font



Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS