Developer Guide

This Developer Guide provides information on using Aspose.Cells in a variety of practical scenarios as MS Excel menu.

File

Info

• Document Properties
• Security Features

New

• Creating a New Workbook

Open

• Different Ways to Open Files
• Opening Different Microsoft Excel Versions Files
• 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 and Preview

Rendering and Conversion

• Convert Workbook to Different Formats
• Convert Excel Workbook to PDF
• Convert Excel file to PDF format compatible with PDFA-1a
• Convert Workbook to Different Image Formats
• Track Document Conversion Progress
• Convert Excel to HTML
• 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

Conditional Formatting

• Conditional Formatting
• Apply Advanced 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

Insert

PivotTable

• Create Pivot Table
• Formatting Pivot Table

Table

• Create and Format Table
• Tables and Ranges

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

Icons

• Insert Icons to Worksheet in Aspose.Cells

Links

• Working with Hyperlinks to Link Data

Comments

• Add Comment In Worksheet
• How to change the Comment Font Color
• 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 Charts
• Customizing Charts
• Create Pivot Tables and Pivot Charts

Sparklines

• Insert Sparklines
• Using Sparklines and Settings 3D Format

OleObject

• Managing OLE Objects

Slicer

• Create Slicer
• 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 Worksheet in Aspose.Cells

Symbols

Page Layout

Themes

• Themes and Colors

Page Setup

• Setting Margins
• Setting Page Options
• Setting Print Options
• Managing Page Breaks
• Insert Background Image to Excel
• Get Paper Width and Height of Page Setup of Worksheet
• Setting Print Options
• 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

• View Gridlines and Heading
• Print Gridlines and Heading

Formulas

Function Library

• Supported Formula Functions

Defined Names

• Create Access and Copy Named Ranges
• Format and Modify Named Ranges

Formula Auditing

• Precedents and Dependents

Calculation

• Ways to Calculate Formulas

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
• Remove duplicate rows in a Worksheet

Outline

• Creating Subtotals

Review

Comments

• Add Comment In Worksheet
• Managing Comments in a Worksheet
• Add a Picture to an Excel Comment
• How to change the Comment Font Color
• Change Text Direction of the Comment
• Set the Comment of Table or List Object inside the Worksheet
• Set Margins of Comment or Shape inside the Worksheet
• Disable Downlevel Revealed Comments while saving to HTML
• Threaded Comments

Protect

• Protecting and Unprotecting Workbooks
• Protect and unProtect Worksheets
• Protecting Worksheets
• Unprotect a Worksheet
• Advanced Protection Settings
• Create Shared Workbook
• Password Protect or Unprotect the Shared Workbook

Changes

• Convert Revision of XLSB to XLSM

View

Workbook Views

• Page Break Preview

Show

• View Gridlines and Heading

Zoom

• Zoom

Window

• Freeze Panes
• Split Cells in Worksheet

Developer

Controls

• Workbook VBA Project

XML

• XML Maps