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
Code 39 Barcode FAQ in Excel
Excel Code 39 Add-In provides easy Code 39 creation on Microsoft Excel spreadsheet. Developed according to the latest barcode specification and industry standards, special parameters for Code 39 are considered in this add-in. Users may feel easy during the procedure of Code 39 generation with Code 39 Add-In for Excel.
If you want to generate Code 39 barcodes for other applications or in other developmental environments you may use .NET Code 39 Barcode Generator, Code 39 for Crystal Report, Code 39 Barcode Fonts, and Java Code 39 Class Library.
Code 39 Data Encoding in Excel
Conforming to its industry standards the following data set and characters can be encoded in Excel Code 39 Add-In:
Valid Characters to be Encoded:
- Numeric characters: 0 - 9
- Special characters: - (Dash), $ (Dollar), % (Percentage), (Space), . (Point), / (Slash), + (Plus)
- Uppercase letters: A - Z
Code 39 Extension Valid Data:
- Standard ASCII values 0-127
Code 39 Valid Data Length to be Encoded:
On the Excel Code 39 setting panel, the following parameters should be set to encode data:
- Barcode Type --- Barcode types could be changed by setting this property, default value is Code 128. Code 39 and Code 39 Extension are valid here.
- Data --- The data to be encoded. This property lets you encode desired data; Default value is 12345.
- Apply tilde --- Use the tilde character "~" to specify the special characters in the input data.
Encode Code 39 Data Using Excel Barcode Add-In
- Barcode Add-In for Excel needs to be downloaded and installed at first;
- Install this barcode generator into your Excel;
- Activate the add-in and choose "CODE 39" or "CODE 39 EX" in the "Barcode Type";
- Click "Generate" for a barcode;
- Input the data to be encoded like "1234567" in the "Data" box;
- Enable "Apply tilde" if needed;
- Customize the properties that are required and click "Update" to output the created Code 39 barcode;
- Then you may link the created barcode into a certain cell with data using "Link to Cell".
Code 39 Image Customization in Excel
Code 39 barcode image created by Excel Code 39 Add-In allows any changes to its placement and rotation angle. In addition, human readable interpretation is adjustable.
- 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.
- Display checksum char --- Determine whether to display the last check sum character (s) in the barcode text.
- Font --- Adjust the font style of the barcode text under image; Default is "Arial", "Regular", "9".
- Show star stop (*) --- Enable it to show the start and stop characters on the both sided of Code 39 encoded data.
- Add checksum char --- Determine whether to calculate and add the check character to the data of Code 39.
Customize Code 39 Image with Barcode Add-In for Excel
- Implement the add-in to generate an Code 39 barcode;
- 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";
- Enable "Show start stop (*)", "Add checksum char", "Display barcode data";
- Enable "Display barcode data" if you want to customize "Font" into your needed style such as "Calibri", "Regular", "15";
- 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".
Code 39 Size Adjustment in Excel
During the implementation of generating Code 39 on Excel spreadsheet, you may take the size of Code 39 a concern. Then you may set the following properties to change the size of Code 39:
- 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.
- 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.
- Wide to narrow bar ratio (N) --- The proportion of the wide bar to the narrowest one, ranging from 2.0 to 3.0.
- I --- The space between characters of Cod 39, the value of which is the multiple of the bar module (X) and arranging 1.0X to 56.3X.
Adjust Code 39 Size on Excel Spreadsheets
- Select the generated Code 39 barcodes;
- Set the "Barcode width" into "100", "Barcode height" into "77", "Left margin" into "3", "Right margin" into "3", "Top margin" into "3", "Right margin" into "3";
- Adjust "N" into "2.5" and "I" into "6" if required;
- 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 Code 39 Products & Information
The following Code 39 products and Code 39 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!
