Aspose.Cells for Java 20.9

Document Features
Open Plain or Encrypted Excel files from different sources.
Save Excel files in different formats (XLS, XLSX/XLSM, XLTX, XLTM, XLSB, CSV, SpreadsheetML, Tab Delimited/TSV, HTML etc.).
Convert Excel file to PDF, XPS & TIFF.
Read & write OpenDocument Spreadsheet (ODS ) format.
Modify document properties.

Display Options

Hide or show a Worksheet.
Display or hide tabs, scroll bars, gridlines & row and column headers.
Preview page breaks.
Set zoom level for the worksheet.
Make selected data remain visible while scrolling using freeze panes.

Worksheet Protection

Protect contents, objects and scenarios of a worksheet.

Page Setup Options

Set page orientation, scaling, paper size, print quality etc.
Set page margins like top, left, right, bottom etc.
Set headers and footers.
Set print area, print title etc.

Page Breaks

Insert horizontal & vertical page breaks at a specified cell.

Rows & Columns Features

Adjust column width as required.
Auto size the width and height of cells according to their contents.
Insert or delete rows and columns.
Hide or show rows and columns.
Group or ungroup rows and columns.

Data Management Features

Add data to desired cells.
Import data from different data sources.
Retrieve data from cells as per data types.
Export cells data to array.
Find specific data.
Set formulae with built-in or add-in functions.
Set array & R1C1 reference style formula.
Add hyperlinks.
Create or access named ranges.
Apply data validation & auto-filtering.
Apply subtotals to worksheet tables.

Formatting Features

Apply number format settings.
Format cells as date.
Set text alignment.
Merge multiple cells.
Apply different kinds of font settings for the cells.
Apply different colors to cells, fonts, gridlines, graphic etc.

Advanced Features

Formula Calculation Engine.
Create, manipulate & change the source data of a pivot table.
Manipulate VBA code or Macros.