Browse our Products

<dependency>
    <groupId>com.aspose</groupId>
    <artifactId>aspose-cells</artifactId>
    <version>16.12.0</version>
</dependency>
copied!  
                                                
                                                  compile(group: 'com.aspose', name: 'aspose-cells', version: '16.12.0')
                                                
                                              
copied!  
<dependency org="com.aspose" name="aspose-cells" rev="16.12.0">
    <artifact name="aspose-cells" ext="jar"/>
</dependency>
copied!  
libraryDependencies += "com.aspose" % "aspose-cells" % "16.12.0"
copied!  

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.10October 11, 2024
24.9September 12, 2024
24.8August 8, 2024
24.7July 12, 2024
24.6June 17, 2024
24.5May 10, 2024
24.4April 10, 2024
24.3March 12, 2024
24.2February 6, 2024
24.1January 11, 2024
23.12December 14, 2023
23.11November 10, 2023
23.10October 13, 2023
23.9September 15, 2023
23.8August 10, 2023
23.7July 13, 2023
23.6June 12, 2023
23.5May 10, 2023
23.4April 12, 2023
23.3March 8, 2023
23.2February 9, 2023
23.1January 10, 2023
22.12December 12, 2022
22.11November 11, 2022
22.10October 12, 2022
22.9September 13, 2022
22.8August 5, 2022
22.7July 11, 2022
22.6June 13, 2022
22.5May 11, 2022
22.4April 13, 2022
22.3March 11, 2022
22.2February 16, 2022
22.1January 11, 2022
21.12December 9, 2021
21.11November 9, 2021
21.10October 15, 2021
21.9September 16, 2021
21.8August 12, 2021
21.7July 14, 2021
21.6June 18, 2021
21.5May 14, 2021
21.4April 15, 2021
21.3March 12, 2021
21.2February 5, 2021
21.1January 15, 2021
20.12December 18, 2020
20.11November 12, 2020
20.10October 19, 2020
20.9September 10, 2020
20.8August 13, 2020
20.7July 15, 2020
20.6June 12, 2020
20.5May 21, 2020
20.4April 17, 2020
20.3March 20, 2020
20.2February 20, 2020
20.1January 17, 2020
19.12December 19, 2019
19.11November 19, 2019
19.10October 21, 2019
19.9September 23, 2019
19.8August 21, 2019
19.7July 18, 2019
19.6June 21, 2019
19.5May 22, 2019
19.4April 18, 2019
19.3March 19, 2019
19.2February 20, 2019
19.1January 18, 2019
18.12December 20, 2018
18.11November 20, 2018
18.10October 19, 2018
18.9September 19, 2018
18.8August 16, 2018
18.7July 13, 2018
18.6June 22, 2018
18.5May 21, 2018
18.4April 20, 2018
18.3March 19, 2018
18.2February 9, 2018
18.1January 22, 2018
17.12December 18, 2017
17.11November 21, 2017
17.10October 20, 2017
17.9September 20, 2017
17.8August 17, 2017
17.7July 19, 2017
17.6June 16, 2017
17.5May 17, 2017
17.4.0April 24, 2017
17.3.0March 17, 2017
17.02.0February 17, 2017
17.1.0January 13, 2017
16.12.0December 15, 2016
16.11.0November 14, 2016
16.10.0October 13, 2016
9.0.0September 14, 2016
8.9.2August 22, 2016
8.9.1August 15, 2016
8.9.0July 18, 2016
8.8.3June 28, 2016
8.8.2June 3, 2016
8.8.1May 26, 2016
8.8.0April 22, 2016
8.7.2March 29, 2016
8.7.1February 26, 2016
8.7.0January 27, 2016
8.6.3December 24, 2015

 
 English