Spire.XLS API

Spire.XLS namespace

Spire.Xls

AlertStyleType Enumeration

AutoFormatOptions Enumeration

AutoFormatType Enumeration

AverageType Enumeration

AxisLineIdentifierType Enumeration

AxisTextDirectionType Enumeration

AxisType Enumeration

AxisTypes Enumeration

BaseFormatType Enumeration

BookmarkHyperlink Class

BordersLineType Enumeration

BubbleSizeType Enumeration

BuiltInPropertyType Enumeration

BuiltInStyles Enumeration

CategoryType Enumeration

CellBorder Class

CellDataType Enumeration

CellFormatType Enumeration

CellRange Class

CellStyle Class

CellStyleFlag Class

CellStyleObject Class

Chart Class

ChartBackgroundMode Enumeration

ChartBaseUnitType Enumeration

ChartDisplayUnitType Enumeration

ChartExPositionAlignment Enumeration

ChartExSidePosition Enumeration

ChartLinePatternType Enumeration

ChartLineWeightType Enumeration

ChartMarkerType Enumeration

ChartParagraphType Enumeration

ChartPieType Enumeration

ChartPlotEmptyType Enumeration

ChartShadow Class

ChartSheet Class

ChartStyleElements Enumeration

CheckState Enumeration

ColorModel Enumeration

ColorScale Class

ColorType Enumeration

CommentHAlignType Enumeration

CommentVAlignType Enumeration

ComparisonOperatorType Enumeration

CompoundLineType Enumeration

ConditionalFormat Class

ConditionalFormats Class

ConditionalFormatScope Enumeration

ConditionalFormatType Enumeration

ConditionalFormatWrapper Class

ConditionalTopNType Enumeration

ConditionValue Class

ConditionValuePosition Enumeration

ConditionValueType Enumeration

ConnectionDataSourceType Enumeration

ConverterSetting Class

CopyRangeOptions Enumeration

CustomFontData Class

DataBar Class

DataLabelPositionType Enumeration

DataSourceType Enumeration

DBConnection Class

DeleteOption Enumeration

DocumentProperty Class

DropLineStyleType Enumeration

EndLineCap Enumeration

ErrorBarIncludeType Enumeration

ErrorBarType Enumeration

Excel2007DataLabelPos Enumeration

Excel2016Charttype Enumeration

ExcelAddInFunction Class

ExcelCalculationMode Enumeration

ExcelChartType Enumeration

ExcelClearOptions Enumeration

ExcelColors Enumeration

ExcelComboType Enumeration

ExcelComment Class

ExcelCommentObject Class

ExcelFindOptions Enumeration

ExcelFont Class

ExcelGradient Class

ExcelHorizontalAlignment Enumeration

ExcelInterior Class

ExcelPatternType Enumeration

ExcelPicture Class

ExcelQuartileCalculation Enumeration

ExcelSaveType Enumeration

ExcelShapeType Enumeration

ExcelSheetType Enumeration

ExcelTotalsCalculation Enumeration

ExcelTreeMapLabelOption Enumeration

ExcelVersion Enumeration

ExcelVerticalAlignment Enumeration

ExpandCollapseFlags Enumeration

ExportTableOptions Class

ExternalConnection Class

ExternalLink Class

FileFormat Enumeration

FilterConditionType Enumeration

FilterDataType Enumeration

FindType Enumeration

FontCollectionIndex Enumeration

FontUnderlineType Enumeration

FontVertialAlignmentType Enumeration

Format3D Class

GoalSeek Class

GoalSeekResult Class

GradientColorType Enumeration

GradientPatternType Enumeration

GradientPresetType Enumeration

GradientStyleType Enumeration

GradientTextureType Enumeration

GradientVariantsType Enumeration

GroupByType Enumeration

HorizontalAlignType Enumeration

HPageBreak Class

HttpContentType Enumeration

HyperLink Class

HyperLinkType Enumeration

IConditionValue Interface

IconSet Class

IconSetType Enumeration

IgnoreErrorType Enumeration

ImageFormatType Enumeration

ImageType Enumeration

ImportObjectOptions Class

InsertMoveOption Enumeration

InsertOptionsType Enumeration

IPropertyData Interface

LegendPositionType Enumeration

LegendSpacingType Enumeration

LineShapeType Enumeration

LineStyleType Enumeration

MarkerDesigner Class

MeasureUnits Enumeration

MsoPathType Enumeration

OColor Class

OdsPageBackground Class

OdsPageBackgroundImagePositionType Enumeration

OdsPageBackgroundImageType Enumeration

OdsPageBackgroundType Enumeration

OLEDBCommandType Enumeration

OleLinkType Enumeration

OleObjectType Enumeration

OrderBy Enumeration

OrderType Enumeration

PageBreakExtentType Enumeration

PageBreakType Enumeration

PageColRow Structure

PageImagePaintedEventArgs Class

PageImagePaintedHandler Delegate

PageOrientationType Enumeration

PageSetup Class

PagesOrderType Enumeration

PaperSizeType Enumeration

PathFillMode Enumeration

PivotAutoFomatTypes Enumeration

PivotBuiltInStyles Enumeration

PivotCache Class

PivotDataType Enumeration

PivotField Class

PivotFieldFormatType Enumeration

PivotFieldSortType Enumeration

PivotGroupByTypes Enumeration

PivotItemType Enumeration

PivotLabelFilterType Enumeration

PivotPageAreaFieldsOrderType Enumeration

PivotTable Class

PivotTableElement Enumeration

PivotTableFields Class

PivotTableLayoutType Enumeration

PivotValueFilterType Enumeration

PresetTextEffect Enumeration

PrintCommentType Enumeration

PrintErrorsType Enumeration

PrintingPageType Enumeration

PropertyType Enumeration

PrstGeomShapeType Enumeration

QueryTableXls Class

ReadingOrderType Enumeration

RectangleShapeType Enumeration

RectangleStyleType Enumeration

ReferRangeArea Class

RenameStrategy Enumeration

ResizeBehaveType Enumeration

RichText Class

RichTextObject Class

SaveShapeTypeOption Class

SelectionType Enumeration

ShapeArrowLengthType Enumeration

ShapeArrowStyleType Enumeration

ShapeArrowWidthType Enumeration

ShapeDashLineStyleType Enumeration

ShapeFillType Enumeration

ShapeGlow Class

ShapeLayerChangeType Enumeration

ShapeLineStyleType Enumeration

ShapeReflection Class

SheetProtectionType Enumeration

SlicerCacheCrossFilterType Enumeration

SortComparsionType Enumeration

SortedWayType Enumeration

SortOrientationType Enumeration

Sparkline Class

SparklineCollection Class

SparklineEmptyCells Enumeration

SparklineGroup Class

SparklineGroupCollection Class

SparklineType Enumeration

SpartlineVerticalAxisType Enumeration

SplitType Enumeration

StyleEntryModifierEnum Enumeration

SubtotalTypes Enumeration

TableBuiltInStyles Enumeration

TextDirection Enumeration

TextRotationType Enumeration

TextSaveOptions Class

TextVerticalValue Enumeration

ThemeColorType Enumeration

TickLabelPositionType Enumeration

TickMarkType Enumeration

TopBottomType Enumeration

TopFormatType Enumeration

TrendLineType Enumeration

UnknownVariableAction Enumeration

Validation Class

ValidationComparisonOperator Enumeration

VariableTypeAction Enumeration

VerticalAlignType Enumeration

ViewMode Enumeration

VPageBreak Class

WebQueryConnection Class

Workbook Class

Worksheet Class

WorksheetCopyType Enumeration

WorksheetVisibility Enumeration

XlsConditionValue Class

XlsDocumentProperty Class

XlsSlicer Class

XlsSlicerCache Class

XlsSlicerCacheItem Class

XlsSlicerCacheItemCollection Class

XlsSlicerCollection Class

XLSXBorderJoinType Enumeration

XLSXChartBevelType Enumeration

XLSXChartLightingType Enumeration

XLSXChartMaterialType Enumeration

XLSXChartPrespectiveType Enumeration

XLSXChartShadowInnerType Enumeration

XLSXChartShadowOuterType Enumeration

XLSXPivotItemType Enumeration

XmlOpenType Enumeration

WorksheetCopyType Enumeration

Enumeration to specify options when copying worksheets.

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

[FlagsAttribute]
public enum WorksheetCopyType

<FlagsAttribute>
Public Enumeration WorksheetCopyType

[FlagsAttribute]
public enum class WorksheetCopyType

[<FlagsAttribute>]
type WorksheetCopyType

Members

Member name	Value	Description
None	0	No flags.
ClearBefore	1	Represents the ClearBefore copy flags.
CopyNames	2	Represents the CopyNames copy flags.
CopyCells	4	Represents the CopyCells copy flags.
CopyRowHeight	8	Represents the CopyRowHeight copy flags.
CopyColumnHeight	16	Represents the CopyColumnHeight copy flags.
CopyOptions	32	Represents the CopyOptions copy flags.
CopyMerges	64	Represents the CopyMerges copy flags.
CopyShapes	128	Represents the CopyShapes copy flags.
CopyConditionlFormats	256	Represents the CopyConditionlFormats copy flags.
CopyAutoFilters	512	Represents the CopyAutoFilters copy flags.
CopyDataValidations	1024	Represents the CopyDataValidations copy flags.
CopyPageSetup	2048	Copy page setup (page breaks, paper orientation, header, footer and other properties).
CopyTables	2560	Represents the CopyAll copy flags.
CopyPivotTables	4096	Copy pivot table objects.
CopyPalette	8192	Copies palette.
CopyAll	16383	Represents the CopyAll copy flags.
CopyWithoutNames	8189	Represents the CopyWithoutNames copy flags.

Reference

Spire.Xls Namespace