Encoding Barcode 128 into Excel Sheet as a Font

topics related to linear barcode formats such as Code 39, Code128, Interleaved 2 of 5 (ITF25), UCC/EAN-128, UPC-A, UPC-E, EAN-13, EAN-8, GS1 Databar etc.

Encoding Barcode 128 into Excel Sheet as a Font

Postby hans302 on Tue May 16, 2017 3:02 am

Hi I am a bit of a novice to barcodes, but have an excel program that can encode a data string from an excel cell into a scanable font barcode.

However I believe that I may need a Start and Stop character for the string.....

An example is A010200023J that I need to be encoded. The barcode that is produced directly from this string will not scan.

I have tried Code128 and 3 of 9 but no luck

Can anyone assist?

Mant thanks

First Timer !!
Posts: 1
Joined: Tue May 16, 2017 2:55 am

Re: Encoding Barcode 128 into Excel Sheet as a Font

Postby glitch on Tue May 16, 2017 8:49 am

You cannot format the data string directly using a barcode font. You need to call an encoder function to convert the data string into barcode string and format the barcode string with the font.

I suggest that you take a look at http://www.morovia.com/excel-barcode-font/. If you are using Code128 font, change the function to Code128Ex.
The information above is provided "AS IS", with no warranties, and confers no rights.
User avatar
Support Engineer
Posts: 174
Joined: Wed May 14, 2008 2:42 pm

Return to Linear symbologies

Who is online

Users browsing this forum: No registered users and 1 guest