[]
产品首页 在线Demo 产品文档 API参考 技术社区
立即试用
(Showing Draft Content)

EAN-8

EAN-8 barcode is used on small packages where an EAN-13 barcode would be too large. Similar to EAN-13, EAN-8 uses only numeric characters and a check digit. This barcode accepts only seven numbers as a string to calculate a check digit (CheckSum) and add it to the eighth position. The check digit is an additional digit that can be used to verify that the barcode has been scanned accurately. When the CheckSum property is set to True, the check digit is automatically added.

The below image displays EAN-8 barcode in a PDF document.

EAN-8 barcode

Formula definition

You can set EAN-8 barcode in a worksheet using the following formula:

=BC_EAN8(value, color, backgroundColor, showLabel, labelPosition, fontFamily, fontStyle, fontWeight, fontTextDecoration, fontTextAlign, fontSize, quietZoneLeft, quietZoneRight, quietZoneTop, quietZoneBottom)

Parameter

Name

Description

value

Specifies that the value length must be 7 or 8.

color

A color that represents the barcode color. The default value is 'rgb(0,0,0)'.

backgroundColor

A color that represents the barcode backgroundcolor. The default value is 'rgb(255, 255, 255)'

showLabel

Specifies whether to show label text when the barcode has label.

labelPosition

​A value that represents the label position when the label is shown.

fontFamily

A string that represents the label text fontFamily. The default value is 'sans-serif'.

fontStyle

A string that represents the label text fontStyle. The default value is 'normal'.

fontWeight

A string that represents the label text fontWeight. The default value is 'normal'.

fontTextDecoration

A string that represents the label text fontTextDecoration. The default value is 'none'.

fontTextAlign

A string that represents the label text fontTextAlign. The default value is 'center'.

fontSize

A string that represents the label text fontSize. The default value is '12px'.

quietZoneLeft

A value that represents the size of left quiet zone.

quietZoneRight

A value that represents the size of right quiet zone.

quietZoneTop

A value that represents the size of top quiet zone.

quietZoneBottom

A value that represents the size of bottom quiet zone.

Using Code

This example code sets EAN-8 in the worksheet.

// Create a new workbook
var workbook = new GrapeCity.Documents.Excel.Workbook();

// Set worksheet layout and data
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.Range["B:G"].ColumnWidth = 17;
worksheet.Range["4:7"].RowHeight = 60;
worksheet.Range["A:A"].ColumnWidth = 5;
worksheet.Range["B2"].Value = "EAN-8";
worksheet.Range["B2:F2"].Merge(true);
worksheet.Range["B3:G3"].Value = new object[,]{
    {"Name", "Number", "Defult", "Change showLable", "Change labelPosition", "Explain"}
};
worksheet.Range["B4:C7"].HorizontalAlignment = HorizontalAlignment.Center;
worksheet.Range["B4:C7"].VerticalAlignment = VerticalAlignment.Center;
worksheet.Range["B2:F3"].HorizontalAlignment = HorizontalAlignment.Center;
worksheet.Range["B2:F3"].VerticalAlignment = VerticalAlignment.Center;
worksheet.Range["B4:C6"].Value = new object[,]
  {
    {"Value length is 7", "4137962"},
    {"Value length is 8", "81424863"},
    {"value length is 8", "81424865"}
  };
worksheet.Range["G6"].Value = "No EAN-8 generated, because the last digit is check-sum digit and it is invalid";
worksheet.Range["G6"].Font.Color = Color.Red;
worksheet.Range["B4:C6"].WrapText = true;
worksheet.Range["G6"].WrapText = true;
worksheet.PageSetup.Orientation = PageOrientation.Landscape;
worksheet.PageSetup.PrintGridlines = true;

// Set formula
for (var i = 4; i < 7; i++)
{
   worksheet.Range["D" + i].Formula = "=BC_EAN8" + "(C" + i + ")";
   worksheet.Range["E" + i].Formula = "=BC_EAN8" + "(C" + i + ",,,0)";
   worksheet.Range["F" + i].Formula = "=BC_EAN8" + "(C" + i + ",,,,\"top\")";
}

// Save to a pdf file
workbook.Save("ean8.pdf");