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.Presentation for C++
Spire.PDF for C++
Spire.Barcode for C++
Python Libraries
Spire.Office for Python
Spire.Doc for Python
Spire.XLS for Python
Spire.Presentation for Python
Spire.PDF for Python
Spire.Barcode for Python
JavaScript Libraries
Spire.Doc for JavaScript
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
Document Operation
Worksheet
Data Import/Export
Link
Security
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
Document Operation
Paragraph and Text
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
Document Operation
Page Setting
Security
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
Conversion
Document Operation
Hyperlink
Page Background
Text
Security
Image and Shape
Page Setup
Comment
Paragraph
Bookmarks
Table
Header and Footer
Print
FootNote
Textbox
Form Field
Font
Mail Merge
Watermark
List
Chart
Others
Spire.XLS for Java
Program Guide
Conversion
Document Operation
Print
Worksheet
Data
Formula
Image and Shape
Link
Cells
Comment
Chart
Data Import/Export
Security
Header and Footer
Conditional Formatting
Objects
Pivot Table
Watermark
Spire.Presentation for Java
Program Guide
Conversion
Document Operation
Image and Shapes
Watermark
Paragraph and Text
Table
Security
Comment and Note
Chart
Smartart
Hyperlink
Audio and Video
Print
Other
Spire.PDF for Java
Program Guide
Conversion
Document Operation
Form Fields
Watermark
Page Setting
Shape
Extract/Read
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
Document Operation
Page Background
Mail Merge
Watermark
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
Document Operation
Image and Shapes
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
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
AutoSortScope Class
PivotCalculatedFieldsCollection Class
PivotConditionalFormat Class
PivotConditionalFormatCollection Class
PivotDataField Class
PivotDataFields Class
PivotItem Class
PivotReportFilter Class
PivotReportFilters Class
PivotStyle Class
PivotTableStyle Class
XlsPivotCache Class
XlsPivotCache Fields
XlsPivotCache Methods
XlsPivotCache Properties
CalculatedItemIndex Property
CreatedVersion Property
EnableRefresh Property
HasNamedRange Property
Index Property
IsBackgroundQuery Property
IsInvalidData Property
IsOptimizedCache Property
IsRefreshOnLoad Property
IsSaveData Property
IsSupportSubQuery Property
IsUpgradeOnRefresh Property
MinRefreshableVersion Property
NeedDataArray Property
Parent Property
RangeName Property
RefreshDate Property
RefreshedBy Property
RefreshedVersion Property
SourceRange Property
SourceType Property
SupportAdvancedDrill Property
XlsPivotCacheField Class
XlsPivotField Class
XlsPivotTable Class
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.Core.Spreadsheet.PivotTables Namespace
XlsPivotCache Class
XlsPivotCache Properties