Microsoft Excel Barcode Integration Guide

IDAutomation provides a variety of solutions for integrating barcodes into Microsoft Excel environments with flexible license agreements such as Single User Licenses, Multi-User Licenses, and royalty-free Developer Licenses.

This native object is an all-in-one solution that embeds directly into the Microsoft Excel spreadsheets to provide the native ability to generate barcodes without fonts or other components.

Compatibility: Excel 2007 and greater in Windows; Excel 2016 and greater on Mac, local installations of Office 365 with VBA support. Compatible with both 32 and 64-bit systems.

Supported Barcodes: Linear: Code 128, GS1-128, Code 39, GS1 DataBar, Code 93, Codabar, UPC-A, EAN13, Interleaved 2 of 5, MSI, USPS Intelligent Mail, Postnet & Planet. 2D: PDF417, QR Code & Data Matrix.

Linear and 2D barcode font packages contain VBA Macros and functions that automatically convert data into a special text string that displays a barcode when the font is applied. These packages are flexible because they include encoders that also work with other environments.

Compatibility: Windows Excel 2003 and up, Mac Excel 2011 and up. VBA Modules are also compatible with legacy VB6.

Supported Barcodes: Linear: Code 39, Code 128, GS1-128, Interleaved 2 of 5, GS1 DataBar, Universal Fonts, USPS Intelligent Mail, UPC/EAN. 2D: Aztec, Data Matrix, PDF417, QR Code.

• Barcode Label Software can use Excel as the data source.
  • Tutorial: How to Use Microsoft Excel as a Data Source