com.spire.xls.core.spreadsheet
Class XlsName

java.lang.Object
  com.spire.xls.core.spreadsheet.XlsObject
      com.spire.xls.core.spreadsheet.XlsName

All Implemented Interfaces:

INamedRange, IXLSRange, java.lang.Iterable

public class XlsName
extends XlsObject
implements INamedRange, IXLSRange

Represents named range in the excel.

Constructor Summary

XlsName(java.lang.Object parent, java.lang.String name, java.lang.String rangeGloble, int islocalIndex)

XlsName(java.lang.Object parent, XlsWorksheet sheet)

Method Summary

java.util.Date	getDateTimeValue() Gets DateTime value of the range.
java.util.Date	getFormulaDateTime() Get formula DateTime value contained by this cell.
java.lang.String	getHtmlString() Gets the html string which contains data and some formattings in this cell.
void	setDateTimeValue(java.util.Date data) Sets DateTime value of the range.
void	setFormulaDateTime(java.util.Date date) Set formula DateTime value contained by this cell.
void	setHtmlString(java.lang.String value) Sets the html string which contains data and some formattings in this cell.

Methods inherited from class com.spire.xls.core.spreadsheet.XlsObject

dispose

Methods inherited from interface com.spire.xls.core.INamedRange

delete, getIndex, getName, getNameLocal, getRefersToRange, getScope, getValue, getValueR1C1, getVisible, getWorksheet, isLocal, setName, setNameLocal, setRefersToRange, setValue, setVisible

Methods inherited from interface com.spire.xls.core.IXLSRange

activate, addComment, autoFitColumns, autoFitRows, borderAround, borderAround, borderAround, borderAround, borderInside, borderInside, borderInside, borderInside, borderNone, clear, clearContents, collapseGroup, expandGroup, expandGroup, freezePanes, get, get, get, get, getBooleanValue, getBorders, getBuiltInStyle, getCellList, getCellStyleName, getColumn, getColumnGroupLevel, getColumns, getColumnWidth, getComment, getConditionalFormats, getCount, getDataValidation, getEndCell, getEntireColumn, getEntireRow, getEnvalutedValue, getErrorValue, getFormula, getFormulaArray, getFormulaArrayR1C1, getFormulaBoolValue, getFormulaErrorValue, getFormulaNumberValue, getFormulaR1C1, getFormulaStringValue, getHorizontalAlignment, getIgnoreErrorOptions, getIndentLevel, getInnerFormulaDateTime, getLastColumn, getLastRow, getMergeArea, getNumberFormat, getNumberText, getNumberValue, getRangeAddress, getRangeAddressLocal, getRangeGlobalAddress, getRangeR1C1Address, getRangeR1C1AddressLocal, getRichText, getRow, getRowGroupLevel, getRowHeight, getRows, getStyle, getText, getTimeSpanValue, getValue, getValue2, getVerticalAlignment, getWorksheet, hasBoolean, hasDataValidation, hasDateTime, hasError, hasExternalFormula, hasFormula, hasFormulaArray, hasFormulaBoolValue, hasFormulaDateTime, hasFormulaErrorValue, hasFormulaNumberValue, hasFormulaStringValue, hasMerged, hasNumber, hasRichText, hasString, hasStyle, intersect, isBlank, isFormulaHidden, isGroupedByColumn, isGroupedByRow, isInitialized, isStringsPreserved, isStringsPreserved, isWrapText, isWrapText, merge, merge, merge, set, setBooleanValue, setBuiltInStyle, setFormulaNumberValue, setFormulaStringValue, setIgnoreErrorOptions, setObjectValue, setValue, setVerticalAlignment, unMerge

Constructor Detail

XlsName

public XlsName(java.lang.Object parent,
               XlsWorksheet sheet)

XlsName

public XlsName(java.lang.Object parent,
               java.lang.String name,
               java.lang.String rangeGloble,
               int islocalIndex)

Method Detail

getDateTimeValue

public java.util.Date getDateTimeValue()

Gets DateTime value of the range.

Specified by:

getDateTimeValue in interface IXLSRange

setDateTimeValue

public void setDateTimeValue(java.util.Date data)

Sets DateTime value of the range.

getFormulaDateTime

public java.util.Date getFormulaDateTime()

Get formula DateTime value contained by this cell. Date.MinValue if not all cells of the range have same Date value.

setFormulaDateTime

public void setFormulaDateTime(java.util.Date date)

Set formula DateTime value contained by this cell. Date.MinValue if not all cells of the range have same Date value.

getHtmlString

public java.lang.String getHtmlString()

Gets the html string which contains data and some formattings in this cell.

Specified by:

getHtmlString in interface IXLSRange

Returns:

setHtmlString

public void setHtmlString(java.lang.String value)

Sets the html string which contains data and some formattings in this cell.

Specified by:

setHtmlString in interface IXLSRange

Parameters:

value -