Developer Guide

Working with Aspose.Cells Java APIs.

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