-
com.grapecity.documents.excel
- Classes
- Enum Classes
- Exceptions
-
Interfaces
- EventHandler
- IAboveAverage
- IAIModelRequestHandler
- IAreas
- IAuthor
- IAutoFilter
- IAutoMergeRangeInfo
- IBarcode
- IBorder
- IBorders
- IBuiltInDocumentPropertyCollection
- ICalcContext
- ICalculatedFields
- ICalculatedItems
- ICascadeSparkLine
- ICellColorSortField
- ICellControl
- ICellDecoration
- ICellDecorationIcon
- ICellPadding
- ICodabar
- ICode128
- ICode39
- ICode49
- ICode93
- IColorScale
- IColorScaleCriteria
- IColorScaleCriterion
- IColorStop
- IColorStops
- IComment
- IComments
- ICommentsThreaded
- ICommentThreaded
- IConditionValue
- ICornerFold
- ICsvParser
- ICustomDocumentPropertyCollection
- ICustomView
- ICustomViews
- ICustomXmlPart
- ICustomXmlPartCollection
- IDataBar
- IDataBarBorder
- IDataMatrix
- IDataOptions
- IDisplayFormat
- IDocumentProperty
- IDocumentPropertyCollection
- IEAN13
- IEAN8
- IExcelOptions
- IFilter
- IFilters
- IFont
- IFontColorSortField
- IFontOption
- IFontProvider
- IFormatColor
- IFormatCondition
- IFormatConditions
- IFormulaOptions
- IFormulaResolver
- IGraphic
- IGraphicsInfo
- IGroupInfo
- IGS1128
- IHeaderFooter
- IHPageBreak
- IHPageBreaks
- IHyperlink
- IHyperlinks
- IIcon
- IIconCriteria
- IIconCriterion
- IIconSet
- IIconSetCondition
- IIconSets
- IIconSortField
- IInterior
- IJsonSerializer
- ILabelOption
- ILabelOptions
- ILinearGradient
- IName
- INames
- INegativeBarFormat
- IOutline
- IOutlineColumn
- IPage
- IPageSetup
- IPane
- IPanes
- IPDF417
- IPDFRenderEngine
- IPivotAxis
- IPivotCache
- IPivotCaches
- IPivotCell
- IPivotField
- IPivotFields
- IPivotFilter
- IPivotFilters
- IPivotFormula
- IPivotFormulas
- IPivotItem
- IPivotItemList
- IPivotItems
- IPivotLine
- IPivotLineCells
- IPivotLines
- IPivotTable
- IPivotTables
- IPivotValueCell
- IProtectionSettings
- IQRCode
- IRange
- IRangeProvider
- IReadOnlySignatureDetails
- IRectangularGradient
- IRichText
- IScenario
- IScenarios
- ISheetTab
- ISheetTabs
- IShrinkToFitSettings
- ISignature
- ISignatureSet
- ISignatureSetup
- ISlicer
- ISlicerCache
- ISlicerCaches
- ISlicerItem
- ISlicerItems
- ISlicerPivotTables
- ISlicers
- ISort
- ISortField
- ISortFields
- ISparkAxes
- ISparkColor
- ISparkHorizontalAxis
- ISparkline
- ISparklineGroup
- ISparklineGroups
- ISparkLineObject
- ISparkPoints
- ISparkVerticalAxis
- IStyle
- IStyleCollection
- ITable
- ITableColumn
- ITableColumns
- ITableDataSource
- ITableRow
- ITableRows
- ITables
- ITableStyle
- ITableStyleCollection
- ITableStyleElement
- ITableStyleElements
- ITextRun
- ITheme
- IThemeColor
- IThemeColorScheme
- IThemeFont
- IThemeFonts
- IThemeFontScheme
- ITop10
- IUniqueValues
- IValidation
- IValueSortField
- IVPageBreak
- IVPageBreaks
- IWebRequestHandler
- IWorkbook
- IWorkbookView
- IWorksheet
- IWorksheets
- IWorksheetView
- com.grapecity.documents.excel.drawing
- com.grapecity.documents.excel.expressions
- com.grapecity.documents.excel.forms
- com.grapecity.documents.excel.template
- com.grapecity.documents.excel.template.DataSource
IEAN13
Interface IEAN13
- All Superinterfaces:
IBarcode,IFontOption,ILabelOption
Represents an EAN-13 barcode.
An EAN-13 barcode consists of 12 numeric digits and 1 check digit. This interface provides access to barcode-specific options such as the add-on text and its label position, together with the common barcode, font, and label settings defined by IBarcode, IFontOption, and ILabelOption.
In the example below, cell A1 stores the 12-digit EAN-13 primary code, and "12" passed to the formula is the separate add-on text.
worksheet.getRange("A1").setValue("123456789012");
worksheet.getRange("B1").setFormula("=BC_EAN13(A1,\"rgb(0, 0, 0)\",\"rgb(255, 255, 255)\",1,\"bottom\",\"12\",\"bottom\",,\"normal\",\"normal\",\"none\",\"center\",12,11,7,0,0)");
IEAN13 barcode = (IEAN13) worksheet.getRange("B1").getValue();
String primaryCode = barcode.getValue();
String addOn = barcode.getAddOn();
String addOnLabelPosition = barcode.getAddOnLabelPosition();
-
Method Summary
Modifier and TypeMethodDescriptiongetAddOn()Gets the add-on text of the EAN-13 barcode.Gets the position of the add-on text on the EAN-13 barcode.Methods inherited from interface com.grapecity.documents.excel.IBarcode
getBackgroundColor, getCodeType, getColor, getQuietZoneBottom, getQuietZoneLeft, getQuietZoneRight, getQuietZoneTop, getValueMethods inherited from interface com.grapecity.documents.excel.IFontOption
getFontFamily, getFontSize, getFontStyle, getFontTextAlign, getFontTextDecoration, getFontWeightMethods inherited from interface com.grapecity.documents.excel.ILabelOption
getLabelPosition, getShowLabel
-
Method Details
-
getAddOn
String getAddOn()Gets the add-on text of the EAN-13 barcode.The add-on text is an optional supplemental code associated with the barcode. When present, its length is 2 or 5 characters.
In the example below, cell A1 provides the 12-digit primary code and
"12"passed to the formula is the separate add-on text.worksheet.getRange("A1").setValue("123456789012"); worksheet.getRange("B1").setFormula("=BC_EAN13(A1,\"rgb(0, 0, 0)\",\"rgb(255, 255, 255)\",1,\"bottom\",\"12\",\"bottom\",,\"normal\",\"normal\",\"none\",\"center\",12,11,7,0,0)"); IEAN13 barcode = (IEAN13) worksheet.getRange("B1").getValue(); String primaryCode = barcode.getValue(); String addOn = barcode.getAddOn();- Returns:
- The add-on text of the EAN-13 barcode.
-
getAddOnLabelPosition
String getAddOnLabelPosition()Gets the position of the add-on text on the EAN-13 barcode.In the example below, cell A1 provides the 12-digit primary code and
"12"passed to the formula is the separate add-on text.worksheet.getRange("A1").setValue("123456789012"); worksheet.getRange("B1").setFormula("=BC_EAN13(A1,\"rgb(0, 0, 0)\",\"rgb(255, 255, 255)\",1,\"bottom\",\"12\",\"bottom\",,\"normal\",\"normal\",\"none\",\"center\",12,11,7,0,0)"); IEAN13 barcode = (IEAN13) worksheet.getRange("B1").getValue(); String primaryCode = barcode.getValue(); String addOnLabelPosition = barcode.getAddOnLabelPosition();- Returns:
- The position of the add-on text on the EAN-13 barcode.
-