Avapose.Barcode for Excel
- Mature barcode generation add-in for MS-Excel 2007/2010
- Support 20+ common linear and 2D barcodes creation
- Provide freely adjustable barcode options
Data Matrix Barcode FAQ in Excel
Data Matrix Barcode Add-In for Excel provides a quick and direct access to generating Data Matrix 2D barcodes on Excel cells. Dynamic barcode creation support permits a created Data Matrix to be linked to a cell with data, and the barcode can update automatically with the data of the linked cell.
Some other Data Matrix generators for different developmental environment and applications may be needed like .NET Data Matrix for SSRS, .NET Data Matrix in Client RDLC, .NET Data Matrix Library in Report Applications, ASP.NET Data Matrix Component for Web Applications.
Data Matrix Data Encoding in Excel
As a 2D barcode, Data Matrix on Excel can encode the data conforming to its industry standards as below:
Data Matrix Valid Encoding Characters:
- Standard ASCII values: 0-128
- Extended ASCII Values: 128-255
Data Matrix Maximum Size per Symbology:
- Alphanumeric data: up to 2335 characters
- 8-bit byte data: 1555 characters
- Numeric data: 3116 digits
Data Matrix Available Data Mode:
- Auto --- The default encoding format
- ASCII --- For encoding data that mainly contains ASCII characters from 0 to 127
- C40 --- For mainly encoding numeric and uppercase characters
- TEXT --- For encoding data that mainly contains numeric data and lowercase letters
- X12 --- Used to encode the standard ANSI X12 electronic data interchange characters
- EDIFACT --- Used to encode 63 ASCII from 32 to 94 with an Unlatch character (binary 011111)
- BASE256 --- For encoding 8 bit values
Data Matrix encoding data can be influenced by those following factors:
- Barcode Type --- Barcode types could be changed by setting this property, default value is Code 128.
- Data --- The data to be encoded. This property lets you encode desired data; Default value is 12345.
- Apply tilde --- Tilde character (~).When enabled, the tilde character (~) is used to specify the special character in the input data.
- Data Mode --- Used to encode different kinds of characters; Default value is AUTO.
- GS1 Compatible Barcode --- Used to use GS1 specification for GS1 compatible barcode image creation.
Encode Data Matrix Data using Excel Barcode Add-In
- Barcode Add-In for Excel needs to be downloaded and installed at first;
- Install this barcode generator on your Excel;
- Activate the add-in and choose "Data Matrix" in the "Barcode Type";
- Select a proper "Data mode" according to the data to be encoded like "X12";
- Enable "Apply tilde" if you want to specify the special characters in the input data;
- Input the data to be encoded like "Data Matrix" in the "Data" box;
- Enable "GS1 Compatible Barcode" if you need GS1 compatible barcode image;
Data Matrix Image Customization in Excel
Excel Data Matrix Add-In lets Data Matrix image customization an easy task once users follow the below steps:
- Rotate --- Barcode orientation can be changed into 0, 90, 180 or 270 degrees; Default is 0.
- Bar Alignment --- Bar placement can be customized into right, center and left inside the image; Default is Center.
Customize Data Matrix Image with Barcode Add-In for Excel
- Select the generated Data Matrix barcodes;
- Set the rotation angle of the barcode image into any valid angle such as "90";
- Select the proper position to put the bar module by setting "Bar alignment" such as "LEFT";
- Click "Update" where "Generate" is located for a updated barcode;
- Then you may link the created barcode into a certain cell with data using "Link to Cell".
Data Matrix Size Adjustment in Excel
During the implementation of generating Data Matrix on Excel spreadsheet, you may take the size of Data Matrix a concern. Thus, you may set the following properties to change the size of Data Matrix:
- Bar width (X) --- The width value of the barcode narrowest bar module (X); Default value is 1.
- Image width --- The width value of whole barcode image; Default value is 99.
- Image height --- The height value of the whole barcode image; Default value is 60.
- Format mode --- Ranges from 10X10 to 144X144 and from 8X18 to 16X48; Default value is 10X10.
- Left margin --- The value of the left margin; Default value is 0.
- Right margin --- The value of the right margin; Default value is 0.
- Bottom margin --- The value of the bottom margin; Default value is 0.
- Top margin --- The value of the top margin; Default value is 0.
Adjust Data Matrix Size on Excel Spreadsheets
- Select the generated Data Matrix barcodes;
- Set the "Barcode width" into "2", "Barcode height" into "90", "Left margin" into "2", "Right margin" into "2", "Top margin" into "2", "Right margin" into "2";
- Customize the "Format mode" for your needed one like "16X36";
- Click "Update" where "Generate" is located for a customized barcode;
- Then you may link the created barcode into a certain cell with data using "Link to Cell".
Related Data Matrix Products & Information
The following Data Matrix products and Data Matrix barcode creating information links relate to this product that may be of interest to you:
We bought your product Barcode Add-In for Excel a few weeks ago, and it works pretty well!
