Browse our Products

Java API for Excel File Formats

banner

Product Page | Docs | Demos | API Reference | Examples | Blog | Search | Free Support | Temporary License

Aspose.Cells for Java is an award-winning Excel Spreadsheet Processing API that allows Java developers to embed the ability to read, write and manipulate Excel® spreadsheets (XLS, XLSX, XLSM, XLSB, XLTX, SpreadsheetML, CSV, ODS), HTML, MHTML, PDF, and image file formats into their own Java applications without needing to rely on Microsoft Excel®.

Excel File Processing Features

Document Features

  • Open Plain or Encrypted Excel files (Excel97, Excel2007/2010/2013) from different sources.
  • Save Excel files (Excel97- Excel2007/2010/2013) in various supported formats.
  • Convert Excel files & spreadsheets to various supported formats.
  • Convert to Tagged Image File Format (TIFF).
  • Read and Write OpenDocument Spreadsheet (ODS) format.
  • Modify the document properties of Excel files.

Worksheet Features

  • Make Worksheet visible or hidden.
  • Ability to show or hide worksheet tabs, scroll bars, gridlines & headers.
  • Apply worksheet zoom level.
  • Keep the selected data visible while scrolling in freeze panes.
  • Ability to preview worksheet page breaks.
  • Protection support for worksheet content, objects as well as scenarios.
  • Perform and apply page setup configuration to worksheets.
  • Perform various actions on individual or group of rows and columns.

Data Management Features

  • Insert data in specific cells at runtime.
  • Fetch data from various data soures and import into worksheets.
  • Retrieve data from cells based on their datatype.
  • Get data from worksheet cells and export to array.
  • Apply conditional formatting.
  • Perform numerous formatting actions on data, such as, font setting.

Charting & Graphics Features

  • Supports creating various kinds of charts.
  • Add custom charts to the worksheet.
  • Add pictures to worksheets at the runtime.
  • Ability to print worksheets.

Advanced Features

  • Use robust Formula Calculation Engine to support formula calculation.
  • Manipulate VBA code or Macros.
  • Create pivot tables as well as change its source data at runtime.

Read & Write Spreadsheet Formats

Microsoft Excel: XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML
OpenOffice: ODS
Text: CSV, TSV
Web: HTML, MHTML
Numbers: Apple’s iWork office suite Numbers app documents

Save Excel Files As

Fixed Layout: PDF, PDF/A, XPS
Data Interchange: DIF
Images: JPEG, PNG, BMP, SVG, TIFF, EMF, GIF

Supported Environments

  • Microsoft Windows: Windows Desktop & Server (x86, x64)
  • macOS: Mac OS X
  • Linux: Ubuntu, OpenSUSE, CentOS, and others
  • Java Versions: J2SE 7.0 (1.7), or above

Get Started

Aspose.Cells Java APIs are hosted at the Aspose Repository. You can easily use Aspose.Cells for Java API directly in your Maven projects with simple configurations. For the detailed instructions please visit Installing Aspose.Cells for Java from Maven Repository documentation page.

Convert Table to Range with Options using Java

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(ConvertTableToRangeWithOptions.class) + "Tables/";
// Open an existing file that contains a table/list object in it
Workbook workbook = new Workbook(dataDir + "book1.xlsx");

TableToRangeOptions options = new TableToRangeOptions();
options.setLastRow(5);

// Convert the first table/list object (from the first worksheet) to normal range
workbook.getWorksheets().get(0).getListObjects().get(0).convertToRange(options);

// Save the file
workbook.save(dataDir + "ConvertTableToRangeWithOptions_out.xlsx");

Product Page | Docs | Demos | API Reference | Examples | Blog | Search | Free Support | Temporary License

VersionRelease Date
24.6June 12, 2024
24.5May 13, 2024
24.4April 9, 2024
24.3March 5, 2024
24.2February 4, 2024
24.1January 8, 2024
23.12December 8, 2023
23.11November 9, 2023
23.10October 11, 2023
23.9September 14, 2023
23.8August 15, 2023
23.7July 12, 2023
23.6June 13, 2023
23.5May 10, 2023
23.4April 12, 2023
23.3March 9, 2023
23.2February 13, 2023
23.1January 10, 2023
22.12December 13, 2022
22.11November 10, 2022
22.10October 11, 2022
22.9September 6, 2022
22.8August 3, 2022
22.7July 6, 2022
22.6June 8, 2022
22.5April 12, 2022
22.4April 12, 2022
22.3March 8, 2022
22.2February 11, 2022
22.1January 11, 2022
21.12December 7, 2021
21.11November 11, 2021
21.10October 12, 2021
21.9.1September 16, 2021
21.9September 7, 2021
21.8August 4, 2021
21.7July 6, 2021
21.6June 8, 2021
21.5May 11, 2021
21.4April 12, 2021
21.3March 12, 2021
21.2February 2, 2021
21.1January 5, 2021
20.12December 8, 2020
20.11November 3, 2020
20.10October 12, 2020
20.9September 9, 2020
20.8August 11, 2020
20.7July 15, 2020
20.6June 11, 2020
20.5May 12, 2020
20.4April 9, 2020
20.3March 12, 2020
20.2February 13, 2020
20.1January 10, 2020
19.12December 13, 2019
19.11November 14, 2019
19.10October 18, 2019
19.9September 19, 2019
19.8August 7, 2019
19.7July 9, 2019
19.6June 13, 2019
19.5May 16, 2019
19.4April 16, 2019
19.3March 15, 2019
19.2February 19, 2019
19.1January 22, 2019
18.12December 18, 2018
18.11November 19, 2018
18.10October 18, 2018
18.9September 14, 2018
18.9.0September 14, 2018
18.8August 8, 2018
18.7July 13, 2018
18.6June 11, 2018
18.5May 17, 2018
18.4April 13, 2018
18.3March 9, 2018
18.2February 8, 2018
18.1January 19, 2018
17.12December 15, 2017
17.11November 20, 2017
17.10October 23, 2017
17.9September 21, 2017
17.8August 22, 2017
17.8.0August 22, 2017
17.7July 18, 2017
17.6June 20, 2017
17.5.0May 19, 2017
17.4.0April 18, 2017
17.3.0March 20, 2017
17.02.0February 17, 2017
17.1.0January 13, 2017
16.12.0December 15, 2016
16.11.0November 11, 2016
16.10.0October 14, 2016
6.8.0September 9, 2016
6.7.0August 9, 2016
6.6.0July 13, 2016
6.5.0June 14, 2016
6.4.0May 20, 2016
6.3.0April 26, 2016
6.2.0April 1, 2016
6.1.0March 3, 2016
6.0.0January 21, 2016
5.9.0December 21, 2015

 
 English