Code 39 Barcode Add-In for Microsoft Excel

No barcode Code 39 font, Excel macro, formula, VBA to create and print 1D & 2D barcode images in Office Excel spreadsheet

Add Code 39 barcode images into your Excel spreadsheets using this barcode generator add-in



In this Excel user guide, you will learn how to generate, insert Code 39 barcode images in Microsoft Office Excel documents.

  • Code 39 standard mode, and full ASCII mode
  • Code 39 check digit
  • Code 39 barcode dimension size
  • Code 39 special characters encoding
  • Support latest version of Office Excel for Windows

How to create Code 39 barcodes in Office Excel?

  1. Download Code 39 Barcode Generator Excel Add-on
  2. Install barcode add-on to create Code 39 barcodes in Excel files
  3. Step by Step Tutorial








  • Completely compatible with Microsoft Office Excel 2019, 2016, 2013, 2010 and 2007
  • Easy to install barcode add-in, without any barcode font, macro vba required
  • Free barcode add-in software downloads. Complete demo source code included.
  • Easy to create batch Code-39 from a list of cells
  • Code 39 specifications are not required for inserting barcode images
  • Industry standards of Code 39 are well pre-configured
  • No programming knowledge and no barcode fonts are needed
  • Create Code 39 barcodes in Excel spreadsheets within a few seconds
  • Article lists or catalogues may be produced without any effort
  • Print high quality Code 39 images with both high and low resolution printers

A quick video tutorial for making, printing Code 39 in Excel

Top
Summy:
  • Quick to create a Code 39 barcode
  • How to generate a valid Code 39 barcode data
  • How to create Code 39 image by using selected cell data
  • How to create a high resolution Code 39 image for printing
  • How to generate list of Code 39 barcodes in Excel
  • Install & uninstall barcode Excel add-in


Introduction of Code 39 Barcode Generator Add-In Software for Excel

Top
Barcode Add in for Excel is an advanced and efficient barcode generator, which is used to insert Code 39 barcode images into spreadsheets in seconds. And this add-in can conveniently and quickly generate both a single image and barcode lists of Code 39.
OnBarcode.com provides not only Code 39 Barcode Add in for Excel, but also other linear and 2D barcode excel generator add-ins which support creating Code 128, EAN, UPC, GS1 128, Interleaved 2 of 5, Postal Codes, QR Code, Data Matrix and PDF-417.
  • Easy to embed Code 39 bar codes into Microsoft Office Excel spreadsheet with a few clicks.
  • Single Code 39 barcode as well as Code 39 barcode lists can be inserted easily and fast in Excel spreadsheets.
  • Each selected cell may be converted into Code 39 barcodes with a click and the barcode can be changed automatically with the content of the linked cells.
  • Parameters of Code 39, including barcode size, barcode types, check digits, rotation, colors etc, are all adjustable.
  • Thermal printers are supported for printing high quality barcode images on low resolution printers.
  • Checksum digit may be computed and added automatically by Excel Code 39 Barcode Add-In.
  • Code 39 Barcode add-in for Excel is available for Microsoft Excel 2016, 2013, 2010 and 2007 versions.

Code 39 barcode data characters encoding using C#

Top

Code 39 standard mode

Code 39 barcode standard mode supports 43 characters, including
  • Numeric digit: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
  • Uppercase letters (A - Z)
  • Special characters: - (Dash), $ (Dollar), % (Percentage), (Space), . (Point), / (Slash), + (Plus)
  • Start/Stop character
In Excel code 39 barcode generator, you need choose Barcode Type property value "CODE 39".



Code 39 Full ASCII mode

Code 39 supports encoding the full 128 character ASCII character set in accordance with ISO 646 IRV.
In code 39 barcode generator for Excel, you need choose Barcode Type property value "CODE 39 EX".



Code 39 barcode check digit

Code 39 barcode does not include a checksum or check digit by default.

For applications requiring enhanced data security, the modulo 43 (MOD43) check character may be used as a check digit.

You can view the barcode Code 39 check digit calculator in details
In excel barcode add-on property panel, go to tab "1D Barcode", and check property Add checksum char, and click button "Update". You will find that the barcode image has been updated with check sum digit ("Z") added.



Do not display Code 39 barcode check digit in HRI

You can also enable code 39 check digit, and hide it in the HRI (human readable interpretation).

In Excel Barcode Property Setting panel, go to tab "1D Barcode", and uncheck the option "Display checksum char".

Click button "Update" to refresh the generated Code 39 image with check sum enabled, but check sum digit hidden.



Code 39 barcode Start/stop characters

Code 39 barcode uses asterisk character (*) as Start and Stop characters, and it should not be part of the Code 39 barcode data.

In Excel Code 39 generator, you can display or hide start/stop characters (asterisk *) through check property Show start stop (*) under tab 1D Barcode.

Code 39 Barcode Dimension Size in Excel

Top
In Excel Code 39 barcode generator, you can use the following barcode dimension size settings:
  • Auto resize: Check this option to enable automatically use maximum bar width and height
  • Unit of Measure: You can choose PIXEL, CM or INCH.
  • Image width: Code 39 barcode image width
  • Image height: Code 39 barcode image height
  • Bar width (X): Width of narrow element. The mimumum bar width is defined by the application specification
  • Bar height (Y): Bar module height.
  • width to narrow bar ratio: Wide/narrow ratio. the valid value is from 2.0 to 3.0 inclusive.
  • I: Width of intercharacter gap
    • minimum gap is equal to X
    • maximum: for X < 0.287mm, is 5.3X; for X >= 0.287mm, is 1.52mm or 3X, whichever is greater.
  • Text margin: Space between bar and text below
  • Left margin, Right margin: Quiet zone. the minimum width of quiet zone is 10X.
  • Top margin, Bottom margin: Quiet zone.
You can view the Code 39 Barcode Size Calculator here.

Insert Code 39 Barcodes into Excel

Top

How to Generate a Code 39 Barcode for Excel

Firstly, activate "Barcode Settings" panel to choose "CODE 39" and type required data. Then click "Generate" to create the single Code 39 image into the Microsoft Excel workbook (To remove it, click "Delete").

How to Configure Code 39 within Setting Panel on Excel

Basing on the generation of Code 39 barcode image, switch to "Barcode Size" and "1D Barcode". The start and stop character can be shown or hidden. Besides, users also can check "Apply title (~)" to enable GS1 Application Identifiers and some special characters to be encoded. After that, click "Update".

How to Create Code 39 Barcode List in Excel

Apart from a single Code 39 image, the Excel Barcode Add-In allows barcode lists or tables to be created. Choose a column of cells with data, and select "CODE 39". And then click "Generate".

How to Link Code 39 to Cell for Excel

Generate a Code 39 barcode image, and click "Link To Cell". Then select a cell with data, and click "Update". The Code 39 barcode image has been linked to the required cell successfully. Meanwhile, linking multiple Code 39 images to cells is also able to be implemented by clicking "Update Link To Cell".
More detail will be represented by OnBarcode.com with Integration Tutorial for Office Excel Barcode Generator.

Barcode Types Supported by Excel Barcode Generator

Top
OnBarcode is a market-leading provider of barcode imaging generator, reader controls and components for ASP.NET, Windows Forms, WPF, as well Java, Android, iOS (iPhone, iPad) across all major enterprise development platforms. We provides comprehensive tutorials and how-tos for various linear, 2d barcode information, such as C# in ASP.NET, C# .NET, C# Barcode Encoding, C# Barcode Image, VB.NET in ASP.NET, VB.NET Winforms, VB.NET Barcode Encoding. OnBarcode barcode products are supported by RasterEdge ASP.NET Document Viewer, which supports ASP.NET PDF Viewer, ASP.NET MVC Document Viewer, ASP.NET PDF Editor, MVC PDF Viewer. And provide high quality C# Convert PDF to Tiff, C# Convert PDF to Word, C# Convert PDF to HTML, C# Convert PDF to Jpeg images, and their easy and simple documents, like C# PDF SDK, C# extract text from PDF, C# Compress PDF, Print PDF in C# and C# extract image from PDF.
Terms of Use | Privacy Policy
Copyright © OnBarcode.com . All rights reserved.