com.spire.xls-ag凯发旗舰厅



package com.spire.xls

interface summary
iconditionvalue represents single condition value for iconset, databar, colorscale conditions.
 
class summary
cellborder  
cellrange represents the cell range.
cellstyle  
cellstyleobject  
chart  
chartshadow  
chartsheet  
colorscale the color scale condition in the conditional format
conditionalformat contains a condition and the formatting for cells.
conditionalformats contains a condition and the formatting for cells.
conditionalformatwrapper summary description for conditional format wrapper.
convertersetting convert setting
databar represents a data bar conditional formating rule.
documentproperty  
excelcomment  
excelcommentobject  
excelfont represents the excel font.
excelgradient  
excelinterior used to get or set interior settings.
excelpicture excel picture
format3d  
hpagebreak  
hyperlink  
iconset conditional formatting icon set condition.
markerdesigner workbook designerused for template markers to the workbook and worksheet.
ocolor this object used to store, convert colors.
pagecolrow page col row types in excel.
pagesetup represents the page setup description.
pivotcache  
pivotfield  
pivottable  
pivottablefields  
richtext  
richtextobject  
sparkline a sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data.
sparklinecollection represents the sparkline collection.
sparklinegroup represents a sparkline group.the sparkline group object is a member of the sparkline groups collection.the sparkline groups collection contains all the sparkline group objects in a workheet.
sparklinegroupcollection the sparkline group collection represents the collection of sparkline group objects.
validation  
vpagebreak represents a vertical page break.
workbook represents the workbook object of excel.
worksheet represents the worksheet.
 
enum summary
alertstyletype possible error style values:
autoformatoptions represents auto format options.
autoformattype represents auto format values.
averagetype average type.
axislineidentifiertype axis line indentifier type.
axistextdirectiontype represents axis text direction.
axistype primary axis types for charts.
axistypes axis types.
baseformattype base format options.
borderslinetype specifies border and diagonal line types in excel.
bubblesizetype bubble size.
builtinpropertytype summary information property type.
builtinstyles specifies existing built-in styles for excel 2007.
categorytype represents category type.
celldatatype cell data types.
cellformattype cell format types.
chartbackgroundmode chart background mode.
chartbaseunittype represents chart base unit.
chartdisplayunittype represents excel chart uint to display.
chartlinepatterntype chart line patterns.
chartlineweighttype chart line weight values type.
chartmarkertype chart marker types.
chartparagraphtype ms chart font type
chartplotemptytype chart plot empty type.
checkstate specifies check state of the check box.
colortype color types.
commenthaligntype comment horizontally align.
commentvaligntype comment vertically align
comparisonoperatortype the comparison operator for conditional formatting in excel.
conditionalformattype conditional formatting type.
conditionvalueposition specifies condition value position.
conditionvaluetype specifies the types of condition values that can be used.
copyrangeoptions enumeration to specify the options to update formulas and merged ranges during copy range operation.
datalabelpositiontype represents data label placement.
datasourcetype data source type.
deleteoption delete option
excelcalculationmode enum that defines different types of the formula calculations.
excelcharttype chart types.
excelclearoptions enumeration of possible directions to clear the cell formats, content, comments or clear all of them.
excelcolors predefined colors in excel.
excelcombotype represents possible combo box type values.
excelfindoptions possible type of finding options
excelpatterntype patterns style.
excelshapetype excel shapes.
excelsheettype sheet types.
exceltotalscalculation specifies the type of calculation in the totals row of a list column.
excelversion represents possible excel versions.
expandcollapseflags flags for expand/collapse settings.
fileformat represents possible excel versions.
filterconditiontype filter conditions.
filterdatatype data type for filters.
findtype possible types of param, specified as string, number in find first, find all methods.
fontunderlinetype font underline types.
fontvertialalignmenttype defines the possible settings for vertical alignment of a run of text.
gradientcolortype represents gradient color type.
gradientpatterntype represents excel gradient pattern.
gradientpresettype represents preset gradient type.
gradientstyletype represents excel shape shading style.
gradienttexturetype represents gradient texture.
gradientvariantstype represents shape shading variants.
groupbytype enumeration of group types in excel.
horizontalaligntype horizontal alignment type.
hyperlinktype hyper link type.
iconsettype icon set type for conditional formatting.
ignoreerrortype represents flags of excel ignore error indicator.
imageformattype image formats.
insertmoveoption insert move option
insertoptionstype enumeration of the insert options in excel.
legendpositiontype legend placement for charts.
lineshapetype  
linestyletype border line styles.
olelinktype defines types of the ole object field.
oleobjecttype defines the types of ole object
orderby represents the sort order.
ordertype page order for sheet in excel.
pagebreakextenttype page break extent types in excel.
pagebreaktype page break types in excel.
pageorientationtype page orientation types in excel.
pagesordertype page order type
papersizetype paper size type.
pivotbuiltinstyles excel 2007 pivot table built in styles.
pivotfieldformattype  
pivotfieldsorttype sort orders that can be applied to fields in a pivottable.
pivottableelement  
printcommenttype  
printerrorstype print error values.
prstgeomshapetype  
readingordertype reading order types.
resizebehavetype represents the resize behave mode.
shapearrowlengthtype represents arrow head length.
shapearrowstyletype represents shape arrow style type.
shapearrowwidthtype represents arrow head width.
shapedashlinestyletype represents shape dash line style.
shapefilltype represents shape xls fill type.
shapelinestyletype represents shape line style.
sheetprotectiontype represents sheet protection flags enums.
sortcomparsiontype represents the sort by in the range.
sortedwaytype represents the algorithm to sort.
sparklinetype defined types of sparkline chart types.
splittype split type.
subtotaltypes represents the subtotal types.
tablebuiltinstyles excel 2007 table built in styles.
textrotationtype text rotation types.
ticklabelpositiontype represents enum of chart tick label position values.
tickmarktype represents enum of chart tick mark values.
topbottomtype topbottom
topformattype top format type.
trendlinetype represents trend line values.
unknownvariableaction defines action that must be taken when meeting unknown variable during template markers processing.
validationcomparisonoperator the comparison operator for conditional formatting.
variabletypeaction defines value type and numberformat in the template marker variable.
verticalaligntype vertical alignment type.
viewmode defines the view setting of the sheet.
worksheetcopytype enumeration to specify options when copying worksheets.
worksheetvisibility visibility of worksheet type.
xlsxborderjointype shape border join type
xlsxchartmaterialtype indicates the material property values fro the chart
xlsxchartprespectivetype indicates the perspective shadow values
xlsxchartshadowinnertype indicates the inner shadow values
xlsxchartshadowoutertype indicates the outer shadow values
 


网站地图