Solved

Print EAN-13 barcodes in Excel

Posted on 2012-03-29
4
2,161 Views
Last Modified: 2012-06-21
Hello,

I've a friend that is trying to print EAN-13 barcodes using Excel. I used to do this with Code 39 barcodes where we had to put a * in the beginning and end of the string so that the printer could recognize it.
With EAN-13 I've never tryed. I've attached a sample file. We want to print the last column as a EAN-13 barcode.

Can someone please help?

Thanks,

jppinto
CODIPOR.xlsx
0
Comment
Question by:jppinto
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 8

Expert Comment

by:csoussan
ID: 37781573
You can format the numbers with the EAN-13 Barcode font.  I've looked around on the web and I've seen it available for sale in many places but they're all around $99-$150.  I pasted two links below from two of the more commercial looking web sites.  I can't say if they're any good or not as I've never used them.  Hope that helps!

http://barcodewiz.com/ms-office-upc-ean-fonts.aspx

http://www.barcodingfonts.com/barean.htm
0
 
LVL 26

Expert Comment

by:redmondb
ID: 37782383
Hi, jppinto.

Like you, I use "3 of 9". However, this page looks interesting for a free Excel-friendly EAN-13 solution.

Word of caution: I've no experience of either the blog or the bar-code sites it links to.

Regards,
Brian.
0
 
LVL 16

Accepted Solution

by:
DansDadUK earned 400 total points
ID: 37782687
>> ... with Code 39 barcodes where we had to put a * in the beginning and end of the string ...

But EAN-13 is a much more complex symbology, so you would do well to heed the advice given by  csoussan and redmondb to use a ready-made solution.



Just to give you an idea of the work involved in generating an EAN-13 barcode:

Each encoded barcode message consists of a left-hand guard character, a left-hand encoded value, a centre guard, a right-hand encoded value, and a right-hand guard character.

In more detail:

•      A country code; usually two digits.
The first digit is not explicitly barcoded, but is printed just as a human-readable character, to the left of a left-hand guard symbol.
This digit does, however, affect how the manufacturer code is encoded: hence, the value can subsequently be derived, by a bar-code reader, from the parity of the characters in the left-hand encoded value (i.e. the manufacturer code)
The second digit of the country code is encoded, using the left-hand odd parity (set A) characters, as the first character of a left-hand barcode value.

•      A manufacturer code; usually five digits.
Each of these digits is encoded using the appropriate character from either the left-hand odd parity (set A) characters, or the left-hand even parity (set B) characters.
The parity to be used for each digit, and hence which set is to be used, depends on the first digit of the country code, as shown in the following table:

Character
position -->             1      2      3      4      5
first digit                                    
0                  Odd      Odd      Odd      Odd      Odd
1                  Odd      Even      Odd      Even      Even
2                  Odd      Even      Even      Odd      Even
3                  Odd      Even      Even      Even      Odd
4                  Even      Odd      Odd      Even      Even
5                  Even      Even      Odd      Odd      Even
6                  Even      Even      Even      Odd      Odd
7                  Even      Odd      Even      Odd      Even
8                  Even      Odd      Even      Even      Odd
9                  Even      Even      Odd      Even      Odd

These digits are encoded, using the appropriate set A, or set B characters, as the remaining five characters of the six-character left-hand barcode value.
This is followed by a centre-guard character.

•      A product code; usually five digits.
These characters are encoded, using the right-hand side (set C) characters, as the first five characters of the right-hand barcode value.

•      A check digit character
See the Checksum Calculation section below for details.
This character is encoded, using the right-hand (set C) characters, as the sixth character of the right-hand barcode value.
This is followed by a right-hand guard character, and (optionally) a right-hand light-margin indicator character.



Checksum Calculation
The steps for calculating the check digit are as follows:

•      Consider the right-most digit of the message to be in an "even" position, and assign odd/even to each character moving from right to left.

•      Sum the digits in all odd positions.
•      Sum the digits in all even positions, and multiply the result by 3.
•      Sum the totals calculated in the previous two steps to produce a weighted total.
•      The check digit is the number which, when added to the weighted total, results in a number evenly divisible by 10.
If the weighted total is evenly divisible by 10, the check digit is "0" (not "10").


... and that assumes  that you have either a suitable font (to match the coded characters in the generated 'coded' value), or a means of converting those coded value to appropriate rectangular (bar and space) images.
0
 
LVL 7

Assisted Solution

by:leptonka
leptonka earned 100 total points
ID: 37784522
Hi!
To your friend - from my friend:
What you need is the EAN_13.xlsx file you find at the bottom of the page. It is a VBA-free solution:

https://sites.google.com/site/e90e50/user/barcode-codice-a-barre-excel-codice-39

Cheers,
Kris
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question