File Info Document Properties New Creating a New Workbook Open Opening Files with Different Formats Get Warnings while Loading Excel File Read Numbers Spreadsheet Developed by Apple Inc. using Aspose.Cells Save Different Ways to Save Files Encrypting Excel Files Save Workbook to Strict Open XML Spreadsheet Format Print Print Rendering and Printing Export Convert Workbook to Different Formats Convert Excel Workbook to PDF Convert Excel file to PDF format compatible with PDFA-1a Converting Worksheet to Different Image Formats Track Document Conversion Progress Convert Excel to HTML with tooltip Convert JSON to CSV Convert CSV to JSON Options Workbook Settings Home Data Accessing Cells of a Worksheet Add and Retrieve Data Worksheets Rows and Columns Style Number Alignment Font Border Fill Dealing with Font Settings Change Cells Alignment and Keep Existing Formatting Conditional Formatting Conditional Formatting Apply Conditional Formatting in Worksheets Apply Shading to Alternate Rows and Columns with Conditional Formatting Sort Data Sorting Sort Data in Column with Custom Sort List Specifying Sort Warning While Sorting Data Filter Data Filtering Apply Advanced Filter of Microsoft Excel to Display Records Meeting Complex Criteria Get All Hidden Rows Indices after Refreshing AutoFilter Find&Select Find or Search Data Cells Inserting and Deleting Rows and Columns Managing Rows, Columns and Cells Insert PivotTable Create Pivot Table Formatting Pivot Table Table Creating a List Object Format a List Object - Table Picture Insert a Linked Picture from Web Address Insert a Picture Based on Cell Reference Insert Picture in Aspose.Cells Shape Inserting a Line to Worksheet Inserting a line arrow to Worksheet Inserting a Rectangle to Worksheet Inserting a Cube to Worksheet Inserting a callout quad arrow to Worksheet Inserting a multiplication sign to Worksheet Inserting a multidocument to Worksheet Inserting a Five-pointed star to Worksheet Inserting a thought bubble cloud to Worksheet Links Working with Hyperlinks to Link Data Add Image Hyperlinks Editing Hyperlinks of Worksheet Comments How to change the Comment Font Color Change Text Direction of the Comment Threaded Comments SmartArt Determine if Shape is Smart Art Shape Extract Text from the Gear Type SmartArt Shape Convert the Smart Art to Group Shape Chart Creating and Customizing Charts Create Pivot Tables and Pivot Charts Chart Formatting OleObject Managing OLE Objects Slicer Create Slicer to a Pivot Table Create Slicer to Excel Table Formatting Slicer Text Box Add Text Box to Worksheet in Aspose.Cells Applying text alignment to partial text inside the TextBox Header&Footer Setting Headers and Footers WordArt Add WordArt Watermark to Worksheet Add WordArt Watermark to Chart Symbols Icons insert Icons to Worksheet Page Layout Themes Excel 2007 Themes and Colors Extract Theme Data from Excel File Page Setup Setting Margins Setting Page Options Setting Print Options Managing Page Breaks Insert Background Image to Excel Remove Existing PrinterSettings of Worksheets in Excel file Implement Custom Paper Size of Worksheet for Rendering Copy Page Setup Settings Determine if Paper Size of Worksheet is Automatic Scale to Fit Scale Width and Height Sheet Options Print Gridlines and Heading Formulas Function Library Supported Formula Functions Defined Names Named Ranges Formula Auditing Calculation Ways to Calculate Formulas Returning a Range of Values using AbstractCalculationEngine Aspose.Cells Formula Calculation Engine Calculation of Excel 2016 MINIFS and MAXIFS functions Implement Custom Calculation Engine to extend the Default Calculation Engine of Aspose.Cells Calculation of Array Formula of Data Tables Data Get & Transform data XML Maps Retrieving SQL Connection Data How to get OData Connection Information Modify existing SQL Data Connection using Aspose.Cells Working with External Data Connection of type WebQuery Queries & Connections Reading and Writing Query Table of Worksheet Sort Sort Specifying Sort Warning While Sorting Data Filter Filter Get All Hidden Rows Indices after Refreshing AutoFilter Advanced Filter Data Tools Text to Columns Data Validation Get Validation Applied on a Cell Outline Creating Subtotals Review Comments Add a Picture to an Excel Comment How to change the Comment Font Color Change Text Direction of the Comment Set Margins of Comment or Shape inside the Worksheet Disable Downlevel Revealed Comments while saving to HTML Threaded Comments Protect Create Shared Workbook Password Protect or Unprotect the Shared Workbook Changes Convert Revision of XLSB to XLSM View Workbook Views Page Break Preview Show Show and Hide Elements Zoom Zoom Window Freeze Panes Applying and Removing Split Panes Developer Controls Workbook VBA Project XML XML Maps AI Document Assistant
Info
New
Open
Save
Print
Export
Options
Data
Style
Conditional Formatting
Sort
Filter
Find&Select
Cells
PivotTable
Table
Picture
Shape
Links
Comments
SmartArt
Chart
OleObject
Slicer
Text Box Add Text Box to Worksheet in Aspose.Cells Applying text alignment to partial text inside the TextBox Header&Footer Setting Headers and Footers WordArt Add WordArt Watermark to Worksheet Add WordArt Watermark to Chart Symbols Icons insert Icons to Worksheet
Header&Footer
WordArt
Symbols
Icons
Themes
Page Setup
Scale to Fit
Sheet Options
Function Library
Defined Names
Formula Auditing
Calculation
Get & Transform data
Queries & Connections
Data Tools
Outline
Protect
Changes
Workbook Views
Show
Zoom
Window
Controls
XML
