Browse our Products
<dependency>
<groupId>com.aspose</groupId>
<artifactId>aspose-cells</artifactId>
<version>24.9</version>
</dependency>
compile(group: 'com.aspose', name: 'aspose-cells', version: '24.9')
<dependency org="com.aspose" name="aspose-cells" rev="24.9">
<artifact name="aspose-cells" ext="jar"/>
</dependency>
libraryDependencies += "com.aspose" % "aspose-cells" % "24.9"
Java API for Excel File Formats
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.
Supported Read & Write Formats
Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, CSV, TSV, XML, OTS, TabDelimited, SpreadsheetML
OpenOffice®: ODS, SXC, FODS
Text: TXT, JSON
Web: HTML, MHTML
Numbers: Apple’s iWork office suite Numbers app documents
Other: EPUB
Suported Output Only Formats
Microsoft Word®: DOCX
Microsoft PowerPoint®: PPTX
Microsoft Excel®: XLAM
Fixed Layout: PDF, PDF/A, XPS
Data Interchange: DIF
Vector Graphics: SVG
Image: TIFF,PNG, BMP, JPEG, GIF
Metafile: EMF
Markdown: MD
Other: SQL, XTHML
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
Version | Release Date |
---|---|
24.9 | September 12, 2024 |
24.8 | August 8, 2024 |
24.7 | July 12, 2024 |
24.6 | June 17, 2024 |
24.5 | May 10, 2024 |
24.4 | April 10, 2024 |
24.3 | March 12, 2024 |
24.2 | February 6, 2024 |
24.1 | January 11, 2024 |
23.12 | December 14, 2023 |
23.11 | November 10, 2023 |
23.10 | October 13, 2023 |
23.9 | September 15, 2023 |
23.8 | August 10, 2023 |
23.7 | July 13, 2023 |
23.6 | June 12, 2023 |
23.5 | May 10, 2023 |
23.4 | April 12, 2023 |
23.3 | March 8, 2023 |
23.2 | February 9, 2023 |
23.1 | January 10, 2023 |
22.12 | December 12, 2022 |
22.11 | November 11, 2022 |
22.10 | October 12, 2022 |
22.9 | September 13, 2022 |
22.8 | August 5, 2022 |
22.7 | July 11, 2022 |
22.6 | June 13, 2022 |
22.5 | May 11, 2022 |
22.4 | April 13, 2022 |
22.3 | March 11, 2022 |
22.2 | February 16, 2022 |
22.1 | January 11, 2022 |
21.12 | December 9, 2021 |
21.11 | November 9, 2021 |
21.10 | October 15, 2021 |
21.9 | September 16, 2021 |
21.8 | August 12, 2021 |
21.7 | July 14, 2021 |
21.6 | June 18, 2021 |
21.5 | May 14, 2021 |
21.4 | April 15, 2021 |
21.3 | March 12, 2021 |
21.2 | February 5, 2021 |
21.1 | January 15, 2021 |
20.12 | December 18, 2020 |
20.11 | November 12, 2020 |
20.10 | October 19, 2020 |
20.9 | September 10, 2020 |
20.8 | August 13, 2020 |
20.7 | July 15, 2020 |
20.6 | June 12, 2020 |
20.5 | May 21, 2020 |
20.4 | April 17, 2020 |
20.3 | March 20, 2020 |
20.2 | February 20, 2020 |
20.1 | January 17, 2020 |
19.12 | December 19, 2019 |
19.11 | November 19, 2019 |
19.10 | October 21, 2019 |
19.9 | September 23, 2019 |
19.8 | August 21, 2019 |
19.7 | July 18, 2019 |
19.6 | June 21, 2019 |
19.5 | May 22, 2019 |
19.4 | April 18, 2019 |
19.3 | March 19, 2019 |
19.2 | February 20, 2019 |
19.1 | January 18, 2019 |
18.12 | December 20, 2018 |
18.11 | November 20, 2018 |
18.10 | October 19, 2018 |
18.9 | September 19, 2018 |
18.8 | August 16, 2018 |
18.7 | July 13, 2018 |
18.6 | June 22, 2018 |
18.5 | May 21, 2018 |
18.4 | April 20, 2018 |
18.3 | March 19, 2018 |
18.2 | February 9, 2018 |
18.1 | January 22, 2018 |
17.12 | December 18, 2017 |
17.11 | November 21, 2017 |
17.10 | October 20, 2017 |
17.9 | September 20, 2017 |
17.8 | August 17, 2017 |
17.7 | July 19, 2017 |
17.6 | June 16, 2017 |
17.5 | May 17, 2017 |
17.4.0 | April 24, 2017 |
17.3.0 | March 17, 2017 |
17.02.0 | February 17, 2017 |
17.1.0 | January 13, 2017 |
16.12.0 | December 15, 2016 |
16.11.0 | November 14, 2016 |
16.10.0 | October 13, 2016 |
9.0.0 | September 14, 2016 |
8.9.2 | August 22, 2016 |
8.9.1 | August 15, 2016 |
8.9.0 | July 18, 2016 |
8.8.3 | June 28, 2016 |
8.8.2 | June 3, 2016 |
8.8.1 | May 26, 2016 |
8.8.0 | April 22, 2016 |
8.7.2 | March 29, 2016 |
8.7.1 | February 26, 2016 |
8.7.0 | January 27, 2016 |
8.6.3 | December 24, 2015 |
Aspose Total Aspose Cells Aspose Java API spreadsheet java library spreadsheet java class Maven XLS XLSX XLSB XLSM XLT XLTX XLTM XLAM CSV TSV TabDelimited TXT HTML MHTML ODS SpreadsheetML Numbers JSON DIF PDF XPS SVG TIFF PNG BMP EMF JPEG GIF Markdown SXC FODS DOCX PPTX Windows Linux Mac J2SE print rendering spreadsheet encryption workbook excel to XPS worksheet to XPS workbook to XPS excel to HTML excel to PDF conversion convert PDFA worksheet to image worksheet to SVG JSON to CSV CSV to JSON import