Aspose.Cells for .NET - API Reference

Aspose.Cells for .NET - Namespaces

Aspose.Cells

AboveAverage Class

AbstractCalculationEngine Class

AbstractCalculationMonitor Class

AbstractTextLoadOptions Class

AutoFilter Class

AutoFitMergedCellsType Enumeration

AutoFitterOptions Class

AutoFitWrappedTextType Enumeration

BackgroundType Enumeration

Border Class

BorderCollection Class

BorderType Enumeration

BuiltinStyleType Enumeration

CalcModeType Enumeration

CalculationCell Class

CalculationData Class

CalculationOptions Class

CalculationPrecisionStrategy Enumeration

Cell Class

CellArea Structure

CellBorderType Enumeration

CellValueFormatStrategy Enumeration

CellValueType Enumeration

CellWatch Class

CellWatchCollection Class

ColorFilter Class

ColorScale Class

ColorType Enumeration

Column Class

ColumnCollection Class

Comment Class

CommentCollection Class

ConditionalFormattingCollection Class

ConditionalFormattingIcon Class

ConditionalFormattingIconCollection Class

ConditionalFormattingResult Class

ConditionalFormattingValue Class

ConditionalFormattingValueCollection Class

ConsolidationFunction Enumeration

ContentDisposition Enumeration

CopyFormatType Enumeration

CopyOptions Class

CountryCode Enumeration

CustomFilter Class

CustomFilterCollection Class

CustomImplementationFactory Class

DataBar Class

DataBarAxisPosition Enumeration

DataBarBorder Class

DataBarBorderType Enumeration

DataBarFillType Enumeration

DataBarNegativeColorType Enumeration

DataSorter Class

DataSorterKey Class

DataSorterKeyCollection Class

DateTimeGroupingType Enumeration

DateTimeGroupItem Class

DeleteOptions Class

DifSaveOptions Class

DirectoryType Enumeration

DisplayDrawingObjects Enumeration

DxfCollection Class

DynamicFilter Class

DynamicFilterType Enumeration

EmfRenderSetting Enumeration

EncryptionType Enumeration

ErrorCheckOption Class

ErrorCheckOptionCollection Class

ErrorCheckType Enumeration

ExceptionType Enumeration

ExportObjectEvent Class

ExportTableOptions Class

ExternalLink Class

ExternalLinkCollection Class

ExternalLinkType Enumeration

FileFontSource Class

FileFormatInfo Class

FileFormatType Enumeration

FileFormatUtil Class

FilterColumn Class

FilterColumnCollection Class

FilterOperatorType Enumeration

FilterType Enumeration

FindOptions Class

FolderFontSource Class

Font Class

FontConfigs Class

FontSchemeType Enumeration

FontSetting Class

FontSourceBase Class

FontSourceType Enumeration

FontUnderlineType Enumeration

FormatCondition Class

FormatConditionCollection Class

FormatConditionType Enumeration

FormatConditionValueType Enumeration

FormulaParseOptions Class

GlobalizationSettings Class

GridlineType Enumeration

HeaderFooterCommand Class

HeaderFooterCommandType Enumeration

HorizontalPageBreak Class

HorizontalPageBreakCollection Class

HtmlCrossType Enumeration

HtmlExportDataOptions Enumeration

HtmlHiddenColDisplayType Enumeration

HtmlHiddenRowDisplayType Enumeration

HtmlLinkTargetType Enumeration

HtmlLoadOptions Class

HtmlSaveOptions Class

Hyperlink Class

HyperlinkCollection Class

ICellsDataTable Interface

IconFilter Class

IconSet Class

IconSetType Enumeration

ICustomFunction Interface

ICustomParser Interface

IExportObjectListener Interface

IFilePathProvider Interface

ImageSaveOptions Class

ImportTableOptions Class

IndividualFontConfigs Class

InsertOptions Class

InterruptMonitor Class

ISmartMarkerCallBack Interface

IStreamProvider Interface

IWarningCallback Interface

License Class

LightCellsDataHandler Interface

LightCellsDataProvider Interface

LoadDataFilterOptions Enumeration

LoadFilter Class

LoadFormat Enumeration

LoadOptions Class

LookAtType Enumeration

LookInType Enumeration

MarkdownSaveOptions Class

MemoryFontSource Class

MemorySetting Enumeration

Metered Class

MultipleFilterCollection Class

Name Class

NameCollection Class

NegativeBarFormat Class

NumberCategoryType Enumeration

OdsLoadOptions Class

OdsSaveOptions Class

OoxmlCompliance Enumeration

OoxmlCompressionType Enumeration

OoxmlSaveOptions Class

OperatorType Enumeration

Outline Class

PageLayoutAlignmentType Enumeration

PageOrientationType Enumeration

PageSetup Class

PaneCollection Class

PaperSizeType Enumeration

ParameterType Enumeration

PasteOptions Class

PasteType Enumeration

PdfSaveOptions Class

PrintCommentsType Enumeration

PrintErrorsType Enumeration

PrintingPageType Enumeration

PrintOrderType Enumeration

PrintSizeType Enumeration

ProtectedRange Class

ProtectedRangeCollection Class

Protection Class

ProtectionType Enumeration

QueryTable Class

QueryTableCollection Class

Range Class

RangeCollection Class

ReferredArea Class

ReferredAreaCollection Class

RegexType Enumeration

RenameStrategy Enumeration

ReplaceOptions Class

ResourceLoadingType Enumeration

Row Class

RowCollection Class

SaveFormat Enumeration

SaveOptions Class

SaveType Enumeration

Scenario Class

ScenarioCollection Class

ScenarioInputCell Class

ScenarioInputCellCollection Class

SheetType Enumeration

ShiftType Enumeration

SortOnType Enumeration

SortOrder Enumeration

SpreadsheetML2003SaveOptions Class

StreamProviderOptions Class

Style Class

StyleCollection Class

StyleFlag Class

StyleModifyFlag Enumeration

SubtotalSetting Class

SvgSaveOptions Class

TargetModeType Enumeration

TextAlignmentType Enumeration

TextCapsType Enumeration

TextCrossType Enumeration

TextDirectionType Enumeration

TextOrientationType Enumeration

TextStrikeType Enumeration

ThemeColor Class

ThemeColorType Enumeration

ThreadedComment Class

ThreadedCommentAuthor Class

ThreadedCommentAuthorCollection Class

ThreadedCommentCollection Class

TimePeriodType Enumeration

Top10 Class

Top10Filter Class

TxtLoadOptions Class

TxtLoadStyleStrategy Enumeration

TxtSaveOptions Class

TxtValueQuoteType Enumeration

UpdateLinksType Enumeration

Validation Class

ValidationAlertType Enumeration

ValidationCollection Class

ValidationType Enumeration

VerticalPageBreak Class

VerticalPageBreakCollection Class

ViewType Enumeration

VisibilityType Enumeration

WarningInfo Class

WarningType Enumeration

Workbook Class

WorkbookDesigner Class

WorkbookSettings Class

Worksheet Class

WorksheetCollection Class

WriteProtection Class

XlsbSaveOptions Class

XlsSaveOptions Class

XmlColumnProperty Class

XmlDataBinding Class

XmlMap Class

XmlMapCollection Class

XpsSaveOptions Class

LoadDataFilterOptions Enumeration

Represents the options to filter data when loading workbook from template.

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 20.3.0.0 (20.3)

Syntax

C++

public enum LoadDataFilterOptions

Public Enumeration LoadDataFilterOptions

public enum class LoadDataFilterOptions

type LoadDataFilterOptions

Members

Member name	Value	Description
None	0	Obsolete. Load nothing for sheet data
All	2147483647	Load all
CellBlank	1	Load cells whose value is blank
CellString	2	Load cells whose value is string
CellNumeric	4	Load cells whose value is numeric(including datetime)
CellError	8	Load cells whose value is error
CellBool	16	Load cells whose value is bool
CellValue	31	Load cells value(all value types) only
Formula	32	Load cell formulas.
CellData	67108927	Load cells data including values, formulas and formattings
Chart	256	Load charts
Shape	402653696	Obsolete. Load shapes
Drawing	402653952	Drawing objects(including Chart, Picture, OleObject and all other drawing objects)
MergedArea	1024	Load merged cells
ConditionalFormatting	2048	Load conditional formattings
DataValidation	4096	Load data validations
PivotTable	8192	Load pivot tables
Table	16384	Load tables
Hyperlinks	32768	Load hyperlinks
SheetSettings	65536	Load settings for worksheet
SheetData	403701759	Load all data of worksheet, such as cells dadta, settings, objects, ...etc.
BookSettings	1048576	Load settings for workbook
Settings	1114112	Load settings for workbook and worksheet
XmlMap	2097152	Load XmlMap
Structure	4194304	Load structure of the workbook
DocumentProperties	8388608	Load document properties
DefinedNames	16777216	Load defined Name objects
VBA	33554432	Load VBA projects
Style	67108864	Load styles for cell formatting
Picture	134217728	Load pictures
OleObject	268435456	Load OleObjects

Reference

Aspose.Cells Namespace