• Products
    • .NET APIs
    • Java APIs
    • C++ APIs
    • Python APIs
    • JavaScript APIs
    • Mobile APIs
    • Cloud APIs
    • Free 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.DataExport for .NET
    • Spire.Barcode for .NET
    • Spire.Email for .NET
    • Spire.OCR 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
    • .NET AI
    • Spire.XLS AI for .NET
    • 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
    • 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
    • Spire.OCR for Python
    • JavaScript Libraries
    • Spire.Office for JavaScript
    • Spire.Doc for JavaScript
    • Spire.XLS for JavaScript
    • Spire.PDF for JavaScript
    • Spire.Presentation 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

    Free .NET Libraries

    • Free Spire.Office
    • Free Spire.Doc
    • Free Spire.XLS
    • Free Spire.Presentation
    • Free Spire.PDF
    • Free Spire.Barcode
    • Free Spire.DocViewer
    • Free Spire.PDFViewer
    • Free Spire.PDFConverter
    • Free Spire.DataExport
    • Free Spire.Email

    Free Java Libraries

    • Free Spire.Office
    • Free Spire.Doc
    • Free Spire.XLS
    • Free Spire.Presentation
    • Free Spire.PDF
    • Free Spire.Barcode

    Free Python Libraries

    • Free Spire.Office
    • Free Spire.Doc
    • Free Spire.XLS
    • Free Spire.Presentation
    • Free Spire.PDF
    • Free Spire.Barcode

    Free JavaScript Libraries

    • Free Spire.Office
    • Free Spire.Doc
    • Free Spire.XLS
    • Free Spire.Presentation
    • Free Spire.PDF
  • 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
    • C# to VB.NET Converter
    • API Reference
    • Blog
    • Videos
  • Tutorials
    • Spire.Doc
    • Spire.XLS
    • Spire.Presentation
    • Spire.PDF
    • Spire.Barcode
    • Spire.OCR
    • Spire.Email
    • 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.Doc for JavaScript
    • Spire.XLS for .NET
    • Spire.XLS for Java
    • Spire.XLS for CPP
    • Spire.XLS for Python
    • Spire.XLS for JavaScript
    • Spire.Presentation for .NET
    • Spire.Presentation for Java
    • Spire.Presentation for CPP
    • Spire.Presentation for Python
    • Spire.Presentation for JavaScript
    • Spire.PDF for .NET
    • Spire.PDF for Java
    • Spire.PDF for CPP
    • Spire.PDF for Python
    • Spire.PDF for JavaScript
    • Spire.Barcode for .NET
    • Spire.Barcode for Java
    • Spire.Barcode for Python
    • Spire.OCR for .NET
    • Spire.OCR for Java
    • Spire.OCR for Python
  • Corporation
    • About Us
    • Contact Us
    • Partner
    • Become Our Reseller
    • Affiliate
    • Paid Support
    • Our Customers
    • Reviews
    • 日本語
  • Login/Register
  • .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
    • Spire.PDFViewer for MAUI
      • Program Guide
        • Getting Started
  • 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
    • Spire.OCR for Python
      • Program Guide
        • Recognize Text
  • JavaScript
    • Spire.Doc for JavaScript
      • React
        • Conversion
        • Document Operation
        • Font
        • Text
        • Image and Shape
        • Textbox
        • Watermark
      • Getting Started
    • Spire.XLS for JavaScript
      • React
        • Conversion
        • Document Operation
        • Cells
        • Security
        • Chart
        • Image
      • Getting Started
    • Spire.Presentation for JavaScript
      • React
        • Conversion
        • Security
      • Getting Started
    • Spire.PDF for JavaScript
      • React
        • Conversion
        • Extract/Read
        • Image
      • Getting Started
  • 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
        • IAddInFunction Interface
        • IAddInFunctions Interface
        • IArcShape Interface
        • IArcShapes Interface
        • IAutoFilter Interface
        • IAutoFilterCondition Interface
        • IAutoFilters Interface
        • IBorder Interface
        • IBorders Interface
        • IBuiltInDocumentProperties Interface
        • IButtonShape Interface
        • IButtonShapes Interface
        • IChart Interface
        • IChartAxis Interface
        • IChartBorder Interface
        • IChartCategoryAxis Interface
        • IChartDataLabels Interface
        • IChartDataPoint Interface
        • IChartDataPoints Interface
        • IChartDataTable Interface
        • IChartDropBar Interface
        • IChartErrorBars Interface
        • IChartFillBorder Interface
        • IChartFormat Interface
        • IChartFrameFormat Interface
        • IChartGridLine Interface
        • IChartInterior Interface
        • IChartLegend Interface
        • IChartLegendEntries Interface
        • IChartLegendEntry Interface
        • IChartPageSetup Interface
        • ICharts Interface
        • IChartSerie Interface
        • IChartSerieDataFormat Interface
        • IChartSeries Interface
        • IChartSeriesAxis Interface
        • IChartShape Interface
        • IChartShapes Interface
        • IChartTextArea Interface
        • IChartTrendLine Interface
        • IChartTrendLines Interface
        • IChartValueAxis Interface
        • IChartWallOrFloor Interface
        • ICheckBox Interface
        • ICheckBoxes Interface
        • ICloneParent Interface
        • IColorConditionValue Interface
        • IColorScale Interface
        • ICombinedRange Interface
        • IComboBoxes Interface
        • IComboBoxShape Interface
        • IComment Interface
        • IComments Interface
        • ICommentShape Interface
        • IConditionalFormat Interface
        • IConditionalFormats Interface
        • IConditionalFormatsCollection Interface
        • ICustomDocumentProperties Interface
        • IDataBar Interface
        • IDataSort Interface
        • IDataValidation Interface
        • IDataValidationCollection Interface
        • IDataValidationTable Interface
        • IErrorIndicator Interface
        • IExcelApplication Interface
        • IExtendedFormat Interface
        • IFont Interface
        • IGeomPath Interface
        • IGeomPathInfo Interface
        • IGeomPathShape Interface
        • IGradient Interface
        • IGroupBox Interface
        • IGroupBoxes Interface
        • IHPageBreak Interface
        • IHPageBreaks Interface
        • IHyperLink Interface
        • IHyperLinks Interface
        • IIconSet Interface
        • IInterior Interface
        • IInternalWorksheet Interface
        • ILabelShape Interface
        • ILabelShapes Interface
        • ILines Interface
        • ILineShape Interface
        • IListBox Interface
        • IListBoxes Interface
        • IListObject Interface
          • IListObject Properties
            • AutoFilters Property
            • BuiltInTableStyle Property
            • Columns Property
            • DisplayFirstColumn Property
            • DisplayHeaderRow Property
            • DisplayLastColumn Property
            • DisplayName Property
            • DisplayTotalRow Property
            • Index Property
            • Location Property
            • Name Property
            • ShowTableStyleColumnStripes Property
            • ShowTableStyleRowStripes Property
            • TotalsRowCount Property
            • Worksheet Property
        • IListObjectColumn Interface
        • IListObjects Interface
        • IMarkersDesigner Interface
        • IMigrantRange Interface
        • INamedRange Interface
        • INameRanges Interface
        • INumberFormat Interface
        • IOleObject Interface
        • IOleObjects Interface
        • IOvalShape Interface
        • IOvalShapes Interface
        • IPageSetup Interface
        • IPictures Interface
        • IPictureShape Interface
        • IPivotCache Interface
        • IPivotCaches Interface
        • IPivotCalculatedFields Interface
        • IPivotDataField Interface
        • IPivotDataFields Interface
        • IPivotField Interface
        • IPivotFields Interface
        • IPivotTable Interface
        • IPivotTableOptions Interface
        • IPivotTables Interface
        • IPrstGeomShape Interface
        • IPrstGeomShapes Interface
        • IRadioButton Interface
        • IRadioButtons Interface
        • IRectangleShape Interface
        • IRectangleShapes Interface
        • IRichTextString Interface
        • IScrollBarShape Interface
        • IScrollBarShapes Interface
        • IShape Interface
        • IShapeFill Interface
        • IShapeLineFormat Interface
        • IShapes Interface
        • ISortColumn Interface
        • ISortColumns Interface
        • ISortedRule Interface
        • ISpinnerShape Interface
        • ISpinnerShapes Interface
        • IStyle Interface
        • IStyles Interface
        • ITabSheet Interface
        • ITabSheets Interface
        • ITextBox Interface
        • ITextBoxes Interface
        • ITextBoxLinkShape Interface
        • ITextBoxShape Interface
        • ITextFrame Interface
        • IVPageBreak Interface
        • IVPageBreaks Interface
        • IWorkbook Interface
        • IWorksheet Interface
        • IWorksheetGroup Interface
        • IWorksheets Interface
        • IXLSRange Interface
        • IXLSRanges Interface
        • MsoPathInfo Class
        • TextBoxShapeBase Interface
      • 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
    • Spire.XLS for Python
Tutorials
API Reference
Spire.XLS
Spire.Xls.Core Namespace
IListObject Interface
IListObject Properties
Products
  • Spire.Doc
  • Spire.XLS
  • Spire.Presentation
  • Spire.PDF
  • Spire.Barcode
Products
  • Spire.DocViewer
  • Spire.Spreadsheet
  • Spire.PDFViewer
  • Spire.Email
  • Spire.OCR
Purchase
  • Purchase FAQs
  • Support FAQs
  • Purchase Policies
  • Renewal Policies
  • License Upgrade
Partnership
  • Partner
  • Find A Reseller
  • Become Our Reseller
  • Our Customers
  • Believe The Users
Support
  • Forum
  • Live Demo
  • Customized Demo
  • Code Samples
  • API Reference
Corporation
  • About Us
  • Contact Us
  • Our Service
  • Reviews
  • Privacy Policy
Copyright © 2024 E-ICEBLUE. All Rights Reserved.