products
.NET APIs
Spire.Office for .NET
Spire.OfficeViewer for .NET
Spire.Doc for .NET
Spire.DocViewer for .NET
Spire.XLS for .NET
Spire.Spreadsheet for .NET
Spire.Presentation for .NET
Spire.PDF for .NET
Spire.PDFViewer for .NET
Spire.PDFViewer for ASP.NET
Spire.DataExport for .NET
Spire.Barcode for .NET
Spire.Email for .NET
Spire.OCR for .NET
Free Products
Free Spire.Office for .NET
Free Spire.Doc for .NET
Free Spire.DocViewer for .NET
Free Spire.XLS for .NET
Free Spire.Presentation for .NET
Free Spire.PDF for .NET
Free Spire.PDFViewer for .NET
Free Spire.PDFConverter for .NET
Free Spire.DataExport for .NET
Free Spire.Barcode for .NET
WPF APIs
Spire.Office for WPF
Spire.Doc for WPF
Spire.DocViewer for WPF
Spire.XLS for WPF
Spire.PDF for WPF
Spire.PDFViewer for WPF
Purchase
Order Online
Download Centre
Temporary License
Purchase Policies
Renewal Policies
Find A Reseller
Purchase FAQS
Support FAQs
How to Apply License
License Agreement
Privacy Policy
Support
Sample Center
Forum
Live Demo
Customized Demo
Code Samples
Newsletter
Subscribe
Unsubscribe
API Reference
Program Guide
Spire.Doc for .NET
Spire.Doc for Java
Spire.XLS for .NET
Spire.XLS for Java
Spire.Presentation for .NET
Spire.Presentation for Java
Spire.PDF for .NET
Spire.PDF for Java
Tutorials
Corporation
About Us
Contact Us
Partner
Become Our Reseller
Affiliate
Paid Support
Our Customers
Reviews
Login/Register
Search
日本語
Products
.NET APIs
Java APIs
C++ APIs
Python APIs
Javascript APIs
Mobile APIs
Cloud APIs
AI Products
.NET Libraries
Spire.Office for .NET
Spire.OfficeViewer for .NET
Spire.Doc for .NET
Spire.DocViewer for .NET
Spire.XLS for .NET
Spire.Spreadsheet for .NET
Spire.Presentation for .NET
Spire.PDF for .NET
Spire.PDFViewer for .NET
Spire.PDFViewer for ASP.NET
Spire.DataExport for .NET
Spire.Barcode for .NET
Spire.Email for .NET
Spire.OCR for .NET
Free Products
Free Spire.Office for .NET
Free Spire.Doc for .NET
Free Spire.DocViewer for .NET
Free Spire.XLS for .NET
Free Spire.Presentation for .NET
Free Spire.PDF for .NET
Free Spire.PDFViewer for .NET
Free Spire.PDFConverter for .NET
Free Spire.DataExport for .NET
Free Spire.Barcode for .NET
Free Spire.Email for .NET
WPF Libraries
Spire.Office for WPF
Spire.Doc for WPF
Spire.DocViewer for WPF
Spire.XLS for WPF
Spire.PDF for WPF
Spire.PDFViewer for WPF
Java Libraries
Spire.Office for Java
Spire.Doc for Java
Spire.XLS for Java
Spire.Presentation for Java
Spire.PDF for Java
Spire.Barcode for Java
Spire.OCR for Java
Free Products
Free Spire.Office for Java
Free Spire.Doc for Java
Free Spire.XLS for Java
Free Spire.Presentation for Java
Free Spire.PDF for Java
Free Spire.Barcode for Java
C++ Libraries
Spire.Office for C++
Spire.Doc for C++
Spire.XLS for C++
Spire.PDF for C++
Spire.Presentation for C++
Spire.Barcode for C++
Python Libraries
Spire.Office for Python
Spire.Doc for Python
Spire.XLS for Python
Spire.PDF for Python
Spire.Presentation for Python
Spire.Barcode for Python
Javascript Libraries
Spire.XLS for Javascript
Android Libraries
Spire.Office for Android via Java
Spire.Doc for Android via Java
Spire.XLS for Android via Java
Spire.Presentation for Android via Java
Spire.PDF for Android via Java
Free Android Products
Free Spire.Office for Android via Java
Free Spire.Doc for Android via Java
Free Spire.XLS for Android via Java
Free Spire.Presentation for Android via Java
Free Spire.PDF for Android via Java
Swift Libraries
Spire.XLS for Swift
Cloud Libraries
Spire.Cloud.Office
Spire.Cloud.Word
Spire.Cloud.Excel
Spire.Cloud.Presentation
.NET AI
Spire.XLS AI for .NET
Purchase
Order Online
Download Centre
Temporary License
Purchase Policies
Renewal Policies
Find A Reseller
Purchase FAQS
Support FAQs
How to Apply License
License Agreement
Privacy Policy
Support
Forum
Live Demo
Customized Demo
Code Samples
Newsletter
Subscribe
Unsubscribe
API Reference
Blog
Videos
Tutorials
Spire.Doc
Spire.XLS
Spire.Presentation
Spire.PDF
Spire.Barcode
Spire.Email
Spire.OCR
Spire.DocViewer
Spire.PDFViewer
Spire.SpreadSheet
Spire.Cloud
Spire.Doc for .NET
Spire.Doc for Java
Spire.Doc for CPP
Spire.Doc for Python
Spire.XLS for .NET
Spire.XLS for Java
Spire.XLS for CPP
Spire.XLS for Python
Spire.Presentation for .NET
Spire.Presentation for Java
Spire.Presentation for CPP
Spire.Presentation for Python
Spire.PDF for .NET
Spire.PDF for Java
Spire.PDF for CPP
Spire.PDF for Python
Spire.Barcode for .NET
Spire.Barcode for Java
Corporation
About Us
Contact Us
Partner
Become Our Reseller
Affiliate
Paid Support
Our Customers
Reviews
.NET
Spire.Doc for .NET
Program Guide for .NET
Conversion
Document Operation
Mail Merge
Form Field
Security
Paragraph
Page Setup
Page Background
Text
Image and Shape
Hyperlink
Comment
Table
Bookmark
Header and Footer
Footnote
Font
Print
Textbox
List
Chart
Others
Program Guide for WPF
Demos
Quick Guide
Find and Replace
Formating
Context
Convertors
Protect
Mail Merge
Misc
Setup
Quick Start for .NET
Quick Start for .NET Core
Quick Start for .NET Standard
Quick Start for WPF
OpenXML
VSTO
NPOI
Spire.DocViewer for .NET
Program Guide
View Word Documents
Demos
Quick Guide
Spire.XLS for .NET
Program Guide for .NET
Conversion
Data Import/Export
Worksheet
Security
Link
Document Operation
Comment
Chart
Cells
Data
Image
Formula
Header and Footer
Print
Objects
Conditional Formatting
Pivot Table
Smart Marker
Program Guide for WPF
Demos
Quick Guide
Validation
Marker Designer
XML
Styles
Images
Charts
DataTable
Formulas
Hyperlinks
Comment
RichText
Freezepane
Group
Filters
Page Setup
VBA
Protection
Stream
Excel2007
Misc
Silverlight
Getting Started
OpenXML
VSTO
NPOI
Spire.Spreadsheet for .NET
Program Guide
Spire.Presentation for .NET
Program Guide
Conversion
Paragraph and Text
Document Operation
Image and Shapes
Table
Chart
Audio and Video
Comment and Note
Hyperlink
Security
Watermark
SmartArt
Print
Other
Getting started
OpenXML
VSTO
Spire.PDF for .NET
Program Guide for .NET
Conversion
Security
Document Operation
Page Setting
Extract/Read
Image
Text
Bookmark
Header and Footer
Table
Shapes
Link
Watermark
Attachments
List
Form Field
Annotation
Action
Print
Other
Program Guide for WPF
Demos
Quick Guide
Drawing
Formating
Page
Table
Grid
WaterMark
List
Interaction
Security
Conversion
Document Settings
Document Operation
Quick Start for .NET Core
Quick Start for .NET Standard
Spire.PDFViewer for .NET
Program Guide
View PDF Documents
Demos
Quick Guide
PDF Document Viewer
Spire.DataExport for .NET
Program Guide
Datatable Export
ListView Export
Demos
Quick Guide
Cell
Demo
Html
Getting Started
Spire.Barcode for .NET
Program Guide
Create and Scan Barcode
Demos
Spire.Email for .NET
Program Guide
Send, Receive, Extract Emails
Manipulate Folders
Spire.OCR for .NET
Program Guide
Recognize Text
Java
Spire.Doc for Java
Program Guide
Hyperlink
Page Background
Text
Document Operation
Security
Image and Shape
Page Setup
Comment
Paragraph
Bookmarks
Table
Header and Footer
Print
FootNote
Textbox
Form Field
Font
Conversion
Mail Merge
Watermark
List
Chart
Others
Spire.XLS for Java
Program Guide
Print
Worksheet
Document Operation
Data
Formula
Image and Shape
Link
Cells
Comment
Chart
Conversion
Data Import/Export
Security
Header and Footer
Conditional Formatting
Objects
Pivot Table
Watermark
Spire.Presentation for Java
Program Guide
Watermark
Image and Shapes
Paragraph and Text
Document Operation
Table
Security
Comment and Note
Chart
Conversion
Smartart
Hyperlink
Audio and Video
Print
Other
Spire.PDF for Java
Program Guide
Document Operation
Form Fields
Page Setting
Watermark
Shape
Extract/Read
Conversion
Image
Security
Text
Table
Annotation
Header and Footer
List
Link
Attachment
Print
Action
Bookmark
Font
Spire.Barcode for Java
Getting Started
Spire.OCR for Java
Program Guide
Recognize Text
CPP
Spire.Doc for CPP
Program Guide
Conversion
Document Operation
Page Setup
Text
Page Background
Table
Image and Shape
Form Field
Paragraph
Watermark
Security
Bookmark
Font
List
Comment
Getting Started
Spire.XLS for CPP
Program Guide
Conversion
Document Operation
Worksheet
Security
Data
Cells
Chart
Formula
Hyperlink
Getting Started
Spire.Presentation for CPP
Program Guide
Conversion
Comment and Note
Getting Started
Spire.PDF for CPP
Program Guide
Conversion
Document Operation
Attachments
Watermark
Page Setting
Extract/Read
Image
Form Field
Header and Footer
Getting Started
Python
Spire.Doc for Python
Program Guide
Conversion
Page Background
Watermark
Mail Merge
Document Operation
Text
Image and Shape
Table
Hyperlink
Paragraph
Security
Bookmark
Page Setup
Font
List
Textbox
Comments
Footnote
Header and Footer
Form Field
Others
Getting Started
Spire.XLS for Python
Program Guide
Conversion
Document Operation
Worksheet
Chart
Image
Data
Data Import/Export
Link
Cells
Comment
Objects
Header and Footer
Formula
Pivot Table
Conditional Formatting
Security
Getting Started
Spire.Presentation for Python
Program Guide
Conversion
Image and Shapes
Document Operation
SmartArt
Comment and Note
Security
Hyperlink
Watermark
Table
Paragraph and Text
Chart
Audio and Video
Other
Getting Started
Spire.PDF for Python
Program Guide
Conversion
Document Operation
Page Setting
Extract/Read
Image
Watermark
Annotation
Security
Font
Text
Link
List
Form Field
Bookmark
Attachment
Shapes
Header and Footer
Table
Action
Getting Started
Spire.Barcode for Python
Create and Scan Barcode
Cloud
Program Guide
Getting Started
AI
Spire.XLS AI for .NET
Licensing
Purchase
Benchmark
API Reference
Spire.Doc
Spire.DocViewer
Spire.XLS
Spire.Xls Namespace
AlertStyleType Enumeration
AutoFormatOptions Enumeration
AutoFormatType Enumeration
AverageType Enumeration
AxisLineIdentifierType Enumeration
AxisTextDirectionType Enumeration
AxisType Enumeration
AxisTypes Enumeration
BaseFormatType Enumeration
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
ChartLinePatternType Enumeration
ChartLineWeightType Enumeration
ChartMarkerType Enumeration
ChartParagraphType Enumeration
ChartPieType Enumeration
ChartPlotEmptyType Enumeration
ChartShadow Class
ChartSheet Class
CheckState 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
DataBar Class
DataLabelPositionType Enumeration
DataSourceType Enumeration
DBConnection Class
DeleteOption Enumeration
DocumentProperty Class
DropLineStyleType Enumeration
ErrorBarIncludeType Enumeration
ErrorBarType Enumeration
ExcelAddInFunction Class
ExcelCalculationMode Enumeration
ExcelChartType Enumeration
ExcelClearOptions Enumeration
ExcelColors Enumeration
ExcelComboType Enumeration
ExcelComment Class
ExcelCommentObject Class
ExcelFindOptions Enumeration
ExcelFont Class
ExcelGradient Class
ExcelInterior Class
ExcelPatternType Enumeration
ExcelPicture Class
ExcelSaveType Enumeration
ExcelShapeType Enumeration
ExcelSheetType Enumeration
ExcelTotalsCalculation Enumeration
ExcelVersion Enumeration
ExpandCollapseFlags Enumeration
ExportTableOptions Class
ExternalConnection Class
ExternalLink Class
FileFormat Enumeration
FilterConditionType Enumeration
FilterDataType Enumeration
FindType Enumeration
FontUnderlineType Enumeration
FontVertialAlignmentType Enumeration
Format3D 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
PageOrientationType Enumeration
PageSetup Class
PagesOrderType Enumeration
PaperSizeType Enumeration
PathFillMode Enumeration
PivotAutoFomatTypes Enumeration
PivotBuiltInStyles Enumeration
PivotCache Class
PivotDataType Enumeration
PivotField Class
PivotFieldFormatType Enumeration
PivotFieldSortType Enumeration
PivotItemType Enumeration
PivotPageAreaFieldsOrderType Enumeration
PivotTable Class
PivotTableElement Enumeration
PivotTableFields Class
PivotTableLayoutType 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
SelectionType Enumeration
ShapeArrowLengthType Enumeration
ShapeArrowStyleType Enumeration
ShapeArrowWidthType Enumeration
ShapeDashLineStyleType Enumeration
ShapeFillType Enumeration
ShapeGlow Class
ShapeLayerChangeType Enumeration
ShapeLineStyleType Enumeration
ShapeReflection Class
SheetProtectionType Enumeration
SortComparsionType Enumeration
SortedWayType Enumeration
SortOrientationType Enumeration
Sparkline Class
SparklineCollection Class
SparklineEmptyCells Enumeration
SparklineGroup Class
SparklineGroupCollection Class
SparklineType Enumeration
SpartlineVerticalAxisType Enumeration
SplitType Enumeration
SubtotalTypes Enumeration
TableBuiltInStyles Enumeration
TextRotationType Enumeration
TextSaveOptions Class
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
Workbook Constructor
Workbook Methods
AcceptAllTrackedChanges Method
AddDigitalSignature Method
AddPivotTableStyle Method
CaculateFormulaValue Method
CalculateAllValue Method
ChangePaletteColor Method
ColumnWidthToPixels Method
ContainsFont Method
CopyTheme Method
CopyToClipboard Method
CreateEmptySheet Method
CreateEmptySheets Method
CreateFont Method
CreatePivotStyle Method
Dispose Method
FindAllBool Method
FindAllDateTime Method
FindAllNumber Method
FindAllString Method
FindAllTimeSpan Method
FindBool Method
FindDateTime Method
FindNumber Method
FindString Method
FindTimeSpan Method
GetChartSheetByName Method
GetCustomFontParsedResult Method
GetDigitalSignatures Method
GetMatchingColor Method
GetOleSize Method
GetPaletteColor Method
GetSafeSheetName Method
GetSplitPageInfo Method
GetSplitPageTable Method
GetThemeColor Method
InitCalcEngine Method
IsPasswordProtected Method
LoadFromFile Method
LoadFromHtml Method
LoadFromMHtml Method
LoadFromStream Method
LoadFromXml Method
LoadTemplateFromFile Method
PasteFromClipboard Method
PixelsToColumnWidth Method
Protect Method
ProtectWorkbook Method
RejectAllTrackedChanges Method
RemoveAllDigitalSignatures Method
Replace Method
ResetPalette Method
Save Method
SaveAsImage Method
SaveAsTemplate Method
SaveAsXml Method
SaveChartAsEmfImage Method
SaveChartAsImage Method
SaveToFile Method
SaveToFile Method (String)
SaveToFile Method (String, ExcelVersion)
SaveToFile Method (String, FileFormat)
SaveToFile Method (String, TextSaveOptions)
SaveToFile Method (String, String)
SaveToFile Method (String, FileFormat, Boolean)
SaveToHtml Method
SaveToHttpResponse Method
SaveToStream Method
SetMaxDigitWidth Method
SetOleSize Method
SetThemeColor Method
SetWriteProtectionPassword Method
UnProtect Method
UnProtectWorkbook Method
Workbook Properties
Worksheet Class
WorksheetCopyType Enumeration
WorksheetVisibility Enumeration
XlsConditionValue Class
XlsDocumentProperty Class
XLSXBorderJoinType Enumeration
XLSXChartBevelType Enumeration
XLSXChartLightingType Enumeration
XLSXChartMaterialType Enumeration
XLSXChartPrespectiveType Enumeration
XLSXChartShadowInnerType Enumeration
XLSXChartShadowOuterType Enumeration
XLSXPivotItemType Enumeration
XmlOpenType Enumeration
Spire.Xls.Charts Namespace
Spire.Xls.Collections Namespace
Spire.Xls.Converters.DrawingML Namespace
Spire.Xls.Core Namespace
Spire.Xls.Core.Converter.General.Word Namespace
Spire.Xls.Core.Converter.General.Word.Collections Namespace
Spire.Xls.Core.Converter.General.Word.Core Namespace
Spire.Xls.Core.Converter.General.Word.Documents Namespace
Spire.Xls.Core.Converter.General.Word.Documents.XML Namespace
Spire.Xls.Core.Converter.General.Word.Fields Namespace
Spire.Xls.Core.Converter.General.Word.Fields.OMath Namespace
Spire.Xls.Core.Converter.General.Word.Formatting Namespace
Spire.Xls.Core.Converter.General.Word.Interface Namespace
Spire.Xls.Core.Converter.Spreadsheet Namespace
Spire.Xls.Core.Interface Namespace
Spire.Xls.Core.Interfaces Namespace
Spire.Xls.Core.MergeSpreadsheet.Interfaces Namespace
Spire.Xls.Core.Spreadsheet Namespace
Spire.Xls.Core.Spreadsheet.AutoFilter Namespace
Spire.Xls.Core.Spreadsheet.Charts Namespace
Spire.Xls.Core.Spreadsheet.Collections Namespace
Spire.Xls.Core.Spreadsheet.ConditionalFormatting Namespace
Spire.Xls.Core.Spreadsheet.Ole Namespace
Spire.Xls.Core.Spreadsheet.PivotTables Namespace
Spire.Xls.Core.Spreadsheet.Security Namespace
Spire.Xls.Core.Spreadsheet.Shapes Namespace
Spire.Xls.Core.Spreadsheet.Sorting Namespace
Spire.Xls.Core.Spreadsheet.Tables Namespace
Spire.Xls.Core.Spreadsheet.TemplateMarkers Namespace
Spire.PDF
Spire.PdfViewer
Spire.Presentation
Spire.BarCode
Spire.Officeviewer
Spire.Spreadsheet
Spire.Office for Java
Spire.Doc for Java
Spire.PDF for Java
Spire.Presentation for Java
Spire.Barcode for Java
Spire.XLS for Java
Spire.Doc for Python
Tutorials
API Reference
Spire.XLS
Spire.Xls Namespace
Workbook Class
Workbook Methods
SaveToFile Method