-
com.grapecity.documents.excel
-
- EventHandler
- IAboveAverage
- IAreas
- IAuthor
- IAutoCorrect
- IAutoFilter
- IAutoMergeRangeInfo
- IBarcode
- IBorder
- IBorders
- IBuiltInDocumentPropertyCollection
- ICalcContext
- ICalculatedFields
- ICalculatedItems
- ICascadeSparkLine
- ICellCollection
- ICellColorSortField
- ICellDecoration
- ICellDecorationIcon
- ICellPadding
- ICodabar
- ICode128
- ICode39
- ICode49
- ICode93
- IColorScale
- IColorScaleCriteria
- IColorScaleCriterion
- IColorStop
- IColorStops
- IComment
- IComments
- ICommentsThreaded
- ICommentThreaded
- IConditionValue
- ICornerFold
- ICsvParser
- ICustomDocumentPropertyCollection
- ICustomView
- ICustomViews
- 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
- ITableStyleInfo
- ITextRun
- ITheme
- IThemeColor
- IThemeColorScheme
- IThemeFont
- IThemeFonts
- IThemeFontScheme
- ITop10
- IUniqueValues
- IValidation
- IValueSortField
- IVPageBreak
- IVPageBreaks
- IWebRequestHandler
- IWorkbook
- IWorkbookView
- IWorksheet
- IWorksheets
- IWorksheetView
- RangeFindReplace.FindReplaceImpl.FindMatch
- RangePartialClasses.FindReplaceImpl.FindMatch
-
- 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
(Showing Draft Content)
IStyle
Interface IStyle
public interface IStyle
Represents a style description for a range.
-
Method Summary
Modifier and TypeMethodDescriptionbooleandelete()Deletes the object.voidGenerates the named style from the json string.booleanGets whether text is automatically indented when the text alignment in a cell is set to equal distribution either horizontally or vertically.Returns theIBorderscollection that represents the borders of astyle.booleanGets whether the style is a built-in style.getFont()Returns theIFontobject that represents the font of the specifiedobject.booleanSets whether the formula is hidden when the worksheet is protected.Gets the horizontal alignment for the specified object.booleanGets whether style includes the AddIndent, HorizontalAlignment, VerticalAlignment, WrapText, and Orientation properties.booleanGets whether the style includes the Color, ColorIndex, LineStyle, and Weight border properties.booleanGets whether the style includes the Bold, Color, ColorIndex, FontStyle, Italic, Name, OutlineFont, Shadow, Size, Strikethrough, Subscript, Superscript, and Underline font properties.booleanGets whether the style includes the NumberFormat property.booleanGets whether the style includes the Color, InvertIfNegative, Pattern, PatternColor, and PatternColorIndex interior properties.booleanGets whether the style includes the FormulaHidden and Locked properties.intGets the indent level for the style.Returns anIInteriorobject that represents the interior of thespecified object.booleanGets whether the object is locked; False if the object can be modified when the sheet is protected.getName()Returns the name of the object.Gets the format code for the object as a string in the language of the user.intGets the text orientation.booleanGets whether the text automatically shrinks to fit in the available column width.Gets the vertical alignment of the specified object.booleanGets whether to wrap the text.voidsetAddIndent(boolean value) Sets whether text is automatically indented when the text alignment in a cell is set to equal distribution either horizontally or vertically.voidsetFormulaHidden(boolean value) Gets whether the formula is hidden when the worksheet is protected.voidSets the horizontal alignment for the specified object.voidsetIncludeAlignment(boolean value) Sets whether style includes the AddIndent, HorizontalAlignment, VerticalAlignment, WrapText, and Orientation properties.voidsetIncludeBorder(boolean value) Sets whether the style includes the Color, ColorIndex, LineStyle, and Weight border properties.voidsetIncludeFont(boolean value) Sets whether the style includes the Bold, Color,ColorIndex, FontStyle,Italic, Name,OutlineFont, Shadow,Size, Strikethrough,Subscript, Superscript, and Underline font properties.voidsetIncludeNumber(boolean value) Sets whether the style includes the NumberFormat property.voidsetIncludePatterns(boolean value) Sets whether the style includes the Color, InvertIfNegative, Pattern, PatternColor, and PatternColorIndex interior properties.voidsetIncludeProtection(boolean value) Sets whether the style includes the FormulaHidden and Locked properties.voidsetIndentLevel(int value) Sets the indent level for the style.voidsetLocked(boolean value) Sets whether the object is locked; False if the object can be modified when the sheet is protected.voidsetNumberFormat(String value) Sets the format code for the object as a string in the language of the user.voidsetOrientation(int value) Sets the text orientation.voidsetShrinkToFit(boolean value) Sets whether the text automatically shrinks to fit in the available column width.voidSets the vertical alignment of the specified object.voidsetWrapText(boolean value) Sets whether to wrap the text.toJson()Generates a json string from the named style.
-
Method Details
-
getAddIndent
boolean getAddIndent()Gets whether text is automatically indented when the text alignment in a cell is set to equal distribution either horizontally or vertically. -
setAddIndent
void setAddIndent(boolean value) Sets whether text is automatically indented when the text alignment in a cell is set to equal distribution either horizontally or vertically. -
getBorders
IBorders getBorders()Returns theIBorderscollection that represents the borders of astyle. -
getBuiltIn
boolean getBuiltIn()Gets whether the style is a built-in style. -
getFont
IFont getFont()Returns theIFontobject that represents the font of the specifiedobject. -
getFormulaHidden
boolean getFormulaHidden()Sets whether the formula is hidden when the worksheet is protected. -
setFormulaHidden
void setFormulaHidden(boolean value) Gets whether the formula is hidden when the worksheet is protected. -
getHorizontalAlignment
HorizontalAlignment getHorizontalAlignment()Gets the horizontal alignment for the specified object. -
setHorizontalAlignment
Sets the horizontal alignment for the specified object. -
getIncludeAlignment
boolean getIncludeAlignment()Gets whether style includes the AddIndent, HorizontalAlignment, VerticalAlignment, WrapText, and Orientation properties. -
setIncludeAlignment
void setIncludeAlignment(boolean value) Sets whether style includes the AddIndent, HorizontalAlignment, VerticalAlignment, WrapText, and Orientation properties. -
getIncludeBorder
boolean getIncludeBorder()Gets whether the style includes the Color, ColorIndex, LineStyle, and Weight border properties. -
setIncludeBorder
void setIncludeBorder(boolean value) Sets whether the style includes the Color, ColorIndex, LineStyle, and Weight border properties. -
getIncludeFont
boolean getIncludeFont()Gets whether the style includes the Bold, Color, ColorIndex, FontStyle, Italic, Name, OutlineFont, Shadow, Size, Strikethrough, Subscript, Superscript, and Underline font properties. -
setIncludeFont
void setIncludeFont(boolean value) Sets whether the style includes the Bold, Color,ColorIndex, FontStyle,Italic, Name,OutlineFont, Shadow,Size, Strikethrough,Subscript, Superscript, and Underline font properties. -
getIncludeNumber
boolean getIncludeNumber()Gets whether the style includes the NumberFormat property. -
setIncludeNumber
void setIncludeNumber(boolean value) Sets whether the style includes the NumberFormat property. -
getIncludePatterns
boolean getIncludePatterns()Gets whether the style includes the Color, InvertIfNegative, Pattern, PatternColor, and PatternColorIndex interior properties. -
setIncludePatterns
void setIncludePatterns(boolean value) Sets whether the style includes the Color, InvertIfNegative, Pattern, PatternColor, and PatternColorIndex interior properties. -
getIncludeProtection
boolean getIncludeProtection()Gets whether the style includes the FormulaHidden and Locked properties. -
setIncludeProtection
void setIncludeProtection(boolean value) Sets whether the style includes the FormulaHidden and Locked properties. -
getIndentLevel
int getIndentLevel()Gets the indent level for the style. -
setIndentLevel
void setIndentLevel(int value) Sets the indent level for the style. -
getInterior
IInterior getInterior()Returns anIInteriorobject that represents the interior of thespecified object. -
getLocked
boolean getLocked()Gets whether the object is locked; False if the object can be modified when the sheet is protected. -
setLocked
void setLocked(boolean value) Sets whether the object is locked; False if the object can be modified when the sheet is protected. -
getName
String getName()Returns the name of the object. -
getNumberFormat
String getNumberFormat()Gets the format code for the object as a string in the language of the user. -
setNumberFormat
Sets the format code for the object as a string in the language of the user. -
getOrientation
int getOrientation()Gets the text orientation. Can be an integer value from –90 to 90 degrees. -
setOrientation
void setOrientation(int value) Sets the text orientation. Can be an integer value from –90 to 90 degrees. -
getShrinkToFit
boolean getShrinkToFit()Gets whether the text automatically shrinks to fit in the available column width. -
setShrinkToFit
void setShrinkToFit(boolean value) Sets whether the text automatically shrinks to fit in the available column width. -
getVerticalAlignment
VerticalAlignment getVerticalAlignment()Gets the vertical alignment of the specified object. -
setVerticalAlignment
Sets the vertical alignment of the specified object. -
getWrapText
boolean getWrapText()Gets whether to wrap the text. -
setWrapText
void setWrapText(boolean value) Sets whether to wrap the text. -
delete
boolean delete()Deletes the object.- Returns:
- whether successfully deleted.
-
fromJson
Generates the named style from the json string.- Parameters:
json- the json string
-
toJson
String toJson()Generates a json string from the named style.- Returns:
- the json string contains a named style
-