Java org.apache.poi.ss.usermodel Name fields, constructors, methods, implement or subclass

Example usage for Java org.apache.poi.ss.usermodel Name fields, constructors, methods, implement or subclass

Introduction

In this page you can find the methods, fields and constructors for org.apache.poi.ss.usermodel Name.

The text is from its open source code.

Method

StringgetNameName()
Gets the name of the named range
StringgetRefersToFormula()
Returns the formula that the name is defined to refer to.
intgetSheetIndex()
Returns the sheet index this name applies to.
StringgetSheetName()
Get the sheets name which this named range is referenced to
booleanisDeleted()
Checks if this name points to a cell that no longer exists
booleanisFunctionName()
Checks if this name is a function name
voidsetNameName(String name)
Sets the name of the named range

The following is a list of syntax rules that you need to be aware of when you create and edit names.

  • Valid characters The first character of a name must be a letter, an underscore character (_), or a backslash (\).
voidsetRefersToFormula(String formulaText)
Sets the formula that the name is defined to refer to.
voidsetSheetIndex(int sheetId)
Tell Excel that this name applies to the worksheet with the specified index instead of the entire workbook.