|
Free Spire.XLS for Java is a professional Java Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets without using Microsoft Office or Microsoft Excel. Free Spire.XLS for Java supports both for the old Excel 97-2003 format (.xls) and for the new Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format. Spire.XLS for Java offers a wide range of features of operating Excel worksheets on Java applications, such as create, read, edit, convert and print Excel worksheets, find and replace data, create charts, create auto filters, read and write hyperlinks, merge/unmerge cells and files, group/ungroup rows and columns, freeze/unfreeze Panes, encrypt/decrypt Excel workbooks etc. Friendly Reminder: |
 |
|||
|
Commercial Edition $999
Compared with Free Spire.XLS for Java, the commercial edition of Spire.XLS for Java has no limitation on the number of worksheets and rows. It is more comprehensive in processing Excel files.  |
Free Edition $0
Free version is limited to 5 sheets per workbook and 200 rows per sheet. This limitation is enforced during reading or writing XLS files. When converting Excel files to PDF files, you can only get the first 3 pages of PDF file.  |
|
.NET
|
||||||||||||||||
|
||||||||||||||||
|
Excel
Version |
||||||||||
|
||||||||||
|
Operation
|
||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||
|
Conversion
|
|
|||||||||||||||||||||||||||||
|
Only Free Spire.XLS for Java, No Microsoft Office
Free Spire.XLS for Java is a totally independent Excel library, Microsoft Office or Microsoft Excel is not required in order to use Spire.XLS for Java. |
High Quality File Conversion
Free Spire.XLS for Java allows converting files from Excel to PDF, Excel to HTML, Excel to CSV, Excel to Text, Excel to Image, Excel to XML, Excel to SVG, Excel to PostScript and Excel to XPS. And on the other hand, most of popular files can be transferred to Excel back. |
Easy Integration
Free Spire.XLS for Java can be easily integrated into Java applications. |
|
Support a Rich Set of Excel Elements
Free Spire.XLS for Java supports a rich set of Excel elements, including comment, pivot table, charts, shapes, tables, images, hyperlinks, reports, text/image watermark, Excel formula and many more. Free Spire.XLS for Java also embeds many flexible options for displaying worksheets, such as page breaks, zoom-setting, freeze panes, headers/footers, print excel files, print paper size and print area etc. |
-
Convert Excel to PDF
Whenever you need to share an important Excel report with a partner, it's best to convert the file to PDF to ensure it looks the same as it does on your device.
-
Convert Excel to Image
When you want to display an Excel file in a video or send it to others in a ready-only format, you can convert it to image.
-
Convert Excel to XPS
XPS (XML Paper Specification) is a fixed-layout file format designed to preserve document fidelity and provide device-independent document appearance. If you just want to distribute, archive or print an Excel file, convert it to XPS would be an option.
-
Create a Chart
Chart is a fantastic tool to visually group and analyze data. It provides the reader with the structure of the data set and displays the data in a graphical representation, making it easier for most users to see the data.
-
Create a Pivot Table
Pivot table is a kind of interactive table that allow users to quickly categorize, calculate, summarize and analyze large amounts of data in a concise tabular format.
-
Export Data from Database to Excel
When data is exported from a database to Excel, it can be analyzed and visualized, as well as viewed and processed by users who are not database users.
-
Export Data from Excel to Word
If you want to reference Excel data in a Word report, you can export the specified cell ranges or entire worksheet as a Word table and preserve the original layout and formatting.
-
Apply Data Validation
Data validation in Excel controls what kind of data can be entered into a certain cell, which ensures that all data entries are accurate and consistent.
-
Apply Conditional Formatting
Conditional formatting is a helpful feature that allows applying special formats to cells meeting specific criteria. It is often used to emphasize or differentiate data stored in worksheets.
-
Find and Highlight
You can find all cells containing a specific value and highlight them with the same background color to make the value outstanding and more easily to be found out.
-
Group Rows or Columns
For worksheets with large amounts of data, grouping rows or columns that contain similar information can make the worksheet more compact and understandable.
-
Insert Formulas and Functions
Formula is an expression that calculates values in a cell or in a range of cells, while function is a predefined formula already available in Excel. Both formulas and functions are very useful when you need to calculate numbers or solve math problems in Excel.
-
Merge Excel Files
Merging Excel files with associated content can help us work with worksheet data more easily and also make it easier to share and read the contents of our workbooks.
