Excel Planet Generator Size Setting Tutorial

samples to generate linear Planet images and adjust barcode size in Excel



Excel Planet Add-In Introduction

Excel Planet Add-In

Planet, also known as USPS PLANET Barcode, USPS Confirm Service Barcode, is a linear barcode symbology adopted by United States Postal Service for tracking purpose when mail is processed on automated mail processing equipment.


More barcode generating in Excel:


It is a Planet generator for Microsoft Excel which can generate high quality Planet images in Microsoft Excel by adjusting the excel Planet size, such as Bar Width, Bar Height, Image Width and Image Height.

More information about Planet barcode settings in Excel Barcode Generator,please see:


Related Planet Generator

Excluding Excel Planet Add-In, Onbarcode provides other related Planet Generators to set the Planet size by setting Bar Width, Bar Height, Image Width and Image Height:

.NET Planet Generation SDK - Easy to generate Planet images for various .NET applications by setting the Planet Bar Width;

ASP.NET Planet Generator Web Control - Simply encode, create high-quality Planet for ASP.NET web projects with adjusting the Image Width;

Android Planet Generation Component - Easily encode, draw high-quality Planet for Android platforms with changing the Bar Width;

BIRT Planet Generation Component - Simple to generate, print high-quality Planet for BIRT Reports by adjusting the Bar Height;

Word Planet Generation Component - Simple to generate, print high-quality Planet for Microsoft Word 2003-2010 documents by adjusting the Bar Height;

Excel Planet Add-In Size Setting

Excel Planet Add-In Size Setting allows easy integration to set the size of Planet Bar Width, Image Width and Bar Height and Image Height. You may adjust these properties during your generating Planet procedure.

Excel Planet Bar Width Setting - Minimum X

Excel Planet Bar Width is the width of the generated Planet narrow bar when using Excel Planet Add-In. You may set the below properties to set minimum bar width(X):

1. Set the barcode type: PLANET

2. Set the data: 0123456789789

3. Set the Bar Width: 3

4. Customize the other properties.

The generated Planet image will be like this:



Excel Planet Image Width Setting - Fixed W

Excel Planet Image Width is the Width of the created Planet image when using Planet Excel Add-In. You may set the following properties to adjust a fixed image width(W):

1. Set the barcode type: PLANET

2. Set the data: 01234567890

3. Set the Image Width: 123

4. Customize the other properties.

The generated Planet image will be like this:



Excel Planet Bar Width & Image Width Setting

Planet Excel Add-In allows setting the bar width and image width at the same time.

1. Set the barcode type: PLANET

2. Set the data: 9876543210321

3. Set the Bar Width: 2

4. Set the Image Width: 200

5. Customize the other properties.

The generated Planet image will be like this:



Note that Onbarcode Excel Planet Generator will automatically generate a Planet image with a minimum Image Width when a fixed X is set. In this case, there are two situations:

1. If you set a image width value, which is less than the minimum image width, the generated image width will be the minimum Image Width. When it occurs, see Excel Planet Bar Width Setting - Minimum X and Excel Planet Image Width Setting - Fixed W.

2. If you set a image width value, which is more than the minimum image width, Excel Add-in will fill the difference with left and right margins generated automatically.

Excel Planet Bar Height Setting

The height of Planet barcode image is made up by the width of the following five parts:

Top Margin

Bar Height

Text Margin

Text Height

Bottom Margin

Short Bar to Tall Ratio

The height of barcode image is difficult to make sure, because the height of the text differs when font size and style changed. Even though, the image height should be 5 mm or 15% of the image width.

Our software can automatically make proper correction for your Planet to compatible with ISO / IEC 16388 (2nd edition 2007-05-15).

Property Name Property Description Property Range
Bar Height The height of the bars in Planet Float
Text Margin The width of the space between barcode and text Float
Text Height The height of text font below the bars and spaces -
Top Margin Width The height of the top margin Float
Bottom Margin Width The height of the bottom margin Float



Excel Barcode Generator Supporting Bar Code Types









OnBarcode is a market-leading provider of barcode 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 high quality tutorials and guides for various linear, 2d barcode information, such as C# Barcode, QR Code C#, QR Code VB.NET, QR Code ASP.NET, QR Code .NET, ASP.NET Barcode. 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.