This tutorial demonstrates how to embed dynamic redistributable barcode objects in Microsoft Excel Spreadsheets. This product uses VBA macros directly in the Excel file, so that even when it is distributed, the spreadsheet will still be able to generate barcodes.
Excel AddIn Integration adds barcode generation functionality for a particular user or computer. If the spreadsheet is distributed, Native Barcode Integration is recommended. The addin must be installed and then activated before it will function.
The formula used in step 7 of this tutorial
may be altered to generate different barcode types and change options, which are
listed below. Only DataToEncode is required; all
other properties are optional. For example, to create a Code 128 barcode from the data in cell
A3, the formula would be:
=IDAutomation_NXLS_C128(A3)
Alternatively, to change the options to generate barcode
stripe image, the formula would be:
=IDAutomation_NXLS_C128(A3,4)
To generate a QRCode Font Image (for use with the included barcode font)
with a QuietZone of 4, the formula would be:
=IDAutomation_NXLS_QRCode(A3,3,,,,,,,4)
To generate a
DataBar Expanded Stacked barcode, with a Segment of 4, the formula would be:
"=IDAutomation_NXLS_GS1DataBarExpanded($B$7,4)"
Linear Symbologies  
Symbology  Formula 
Code128 Auto  IDAutomation_NXLS_C128 (DataToEncode, ImageType, ApplyTilde, QuietZone) (ApplyTilde is automatically set to True in this function) 
IDAutomation_NXLS_C128HR (DataToEncode, ApplyTilde, QuietZone) (ApplyTilde is automatically set to True in this function)  
Code 128 A  IDAutomation_NXLS_C128A(DataToEncode, ImageType, QuietZone) 
IDAutomation_NXLS_C128AHR(DataToEncode, QuietZone)  
Code 128 B  IDAutomation_NXLS_C128B(DataToEncode, ImageType, QuietZone) 
IDAutomation_NXLS_C128BHR(DataToEncode, QuietZone)  
Code 128 C  IDAutomation_NXLS_C128C(DataToEncode, ImageType, QuietZone) 
IDAutomation_NXLS_C128CHR(DataToEncode, QuietZone)  
Code39  IDAutomation_NXLS_C39(DataToEncode, ImageType, N_Dimension, IncludeCheckDigit, QuietZone) 
IDAutomation_NXLS_C39HR(DataToEncode, N_Dimension, IncludeCheckDigit, CheckCharacterInText, QuietZone)  
Code 93  IDAutomation_NXLS_C93(DataToEncode, ImageType, QuietZone) 
IDAutomation_NXLS_C93HR(DataToEncode, CheckCharacterInText, QuietZone)  
Codabar  IDAutomation_NXLS_Codabar(DataToEncode, ImageType, QuietZone, StartChar, StopChar) 
IDAutomation_NXLS_CodabarHR(DataToEncode, StartChar, StopChar, QuietZone)  
EAN13  IDAutomation_NXLS_EAN13(DataToEncode, ImageType) (This function only returns image types 1 and 3 by design) 
Interleaved 2 of 5  IDAutomation_NXLS_I2of5(DataToEncode, ImageType, N_Dimension, IncludeCheckDigit, QuietZone) 
IDAutomation_NXLS_I2of5HR(DataToEncode, N_Dimension, IncludeCheckDigit, CheckCharacterInText, QuietZone)  
MSI  IDAutomation_NXLS_MSI(DataToEncode, ImageType, N_Dimension, IncludeCheckDigit, QuietZone) 
IDAutomation_NXLS_MSIHR(DataToEncode, N_Dimension, IncludeCheckDigit, CheckCharacterInText, QuietZone)  
Intelligent Mail  IDAutomation_NXLS_IMb(DataToEncode, ImageType, QuietZone) 
Postnet  IDAutomation_NXLS_Postnet(DataToEncode, ImageType, IncludeCheckDigit, QuietZone) 
Planet  IDAutomation_NXLS_Planet(DataToEncode, ImageType, IncludeCheckDigit, QuietZone) 
UPCA  IDAutomation_NXLS_UPCA(DataToEncode, ImageType) (This function only returns image types 1 and 3 by design) 
2D Symbologies  
Data Matrix  IDAutomation_NXLS_DataMatrix(DataToEncode, ImageType,
ApplyTilde, EncodingMode,
PreferredFormat, QuietZone) 
PDF417  IDAutomation_NXLS_PDF417(DataToEncode, ImageType,
EccLevel,
ColumnSpecify, RowSpecify,
Truncate,
ForceBinary, QuietZone) 
QRCode  IDAutomation_NXLS_QRCode(DataToEncode, ImageType,
ApplyTilde,
EncodingMode,
ErrorCorrectionLevel,
Version,
ProcessMask,
NewLineCharacter,
QuietZone) 
GS1 DataBar  
GS1DataBar  IDAutomation_NXLS_GS1DataBarOmni(DataToEncode, ImageType, Height, QuietZone) 
IDAutomation_NXLS_GS1DataBarStackedOmni(DataToEncode, ImageType, Height, QuietZone)  
IDAutomation_NXLS_GS1DataBarExpanded(DataToEncode, Segments, ImageType, Height, QuietZone) 
Additional problems and solutions are provided in public support forum threads. Priority phone, email and forum support are provided up to 30 days after purchase. Additional priority phone, email and forum support may be obtained if the Level 2 Support and Upgrade Subscription is active.
©Copyright 2019
IDAutomation.com, All Rights Reserved.
Legal
Notices. Barcode Fonts  Components  Scanners  Support  Contact Us 

Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses. 