Aspose.Cells FOSS — Thư viện bảng tính Java mã nguồn mở

Aspose.Cells FOSS for Java là một thư viện thuần Java 17 cho phép các nhà phát triển tạo, tải, sửa đổi và lưu các sổ làm việc Excel .xlsx mà không cần bất kỳ phụ thuộc thời gian chạy thương mại nào của Aspose. Thư viện cung cấp một API công khai sạch sẽ dưới gói com.aspose.cells_foss và được phát hành dưới giấy phép MIT.

Thư viện bao phủ mô hình đối tượng bảng tính cốt lõi: sổ làm việc, bảng tính, ô, kiểu dáng và các bộ sưu tập. Các khả năng được hỗ trợ bao gồm giá trị ô (chuỗi, số, boolean, ngày/giờ và công thức), định dạng ô (phông chữ, viền, nền, căn chỉnh và định dạng số), AutoFilters, xác thực dữ liệu, định dạng có điều kiện, siêu liên kết, ô hợp nhất, tên đã định nghĩa, thiết lập trang và bảo vệ bảng tính.

Aspose.Cells FOSS for Java được xây dựng bằng Maven 3.9+ và nhắm tới Java 17+. Thêm nó vào dự án của bạn bằng một phụ thuộc Maven duy nhất. Việc lưu hiện tại chỉ giới hạn ở định dạng .xlsx.

Workbook and Worksheet Management

Create new workbooks with new Workbook() using the try-with-resources pattern
Access worksheets via getWorksheets().get(index) or by name
Rename worksheets with setName(), add and remove sheets, set the active sheet
Control worksheet visibility and tab colour via WorksheetViewModel

Who Uses This Feature

Generating report workbooks in server-side Java applications
Automating multi-sheet Excel document creation in batch pipelines
Building template-based spreadsheet generation workflows
Splitting or merging workbooks programmatically without Excel installed

Cell Values and Formulas

Set cell values with cell.putValue() for String, int, double, boolean, and LocalDateTime
Read the value type via CellValueType: STRING, NUMBER, BOOLEAN, DATE_TIME, or FORMULA
Store formula strings with cell.setFormula(); value type becomes FORMULA
Access a string representation of any cell value via cell.getStringValue()

Who Uses This Feature

Populating data tables and financial models in server-generated spreadsheets
Writing calculated fields that Excel will re-evaluate on open
Reading and converting cell data for downstream processing
Building typed data exports from Java domain objects

Cell Formatting and Styles

Apply fonts, borders, and fills via the Style class from cell.getStyle()
Control alignment via HorizontalAlignment (LEFT, CENTER, RIGHT) and AlignmentValue
Set number formats using style.setCustom() or built-in NumberFormat patterns
Adjust row height and column width with getRows().get(n).setHeight() and getColumns().get(n).setWidth()

Who Uses This Feature

Producing professionally formatted reports without Excel on the server
Highlighting data with bold fonts and custom number formats
Ensuring column widths fit exported data without manual adjustment
Applying consistent branding styles across generated worksheets

AutoFilter, Validation, and Conditional Formatting

Set an AutoFilter range with ws.getAutoFilter().setRange()
Add filter columns and custom filter criteria via FilterColumn and AutoFilterCustomFilter
Define data validation rules using ValidationType and OperatorType with sheet.getValidations().add()
Apply conditional formatting via FormatConditionCollection and FormatCondition

Who Uses This Feature

Building interactive data tables where end users apply filters in Excel
Enforcing numeric or list-based input constraints in shared spreadsheets
Highlighting out-of-range values automatically with conditional colour rules
Generating audit-ready worksheets with visible data-quality rules

Page Setup and Worksheet Protection

Configure print settings with PageSetup: paper size, orientation, fit-to-page, print area
Toggle gridlines and headings for printing via PrintOptionsModel
Protect worksheets and fine-tune permissions using WorksheetProtectionModel
Store hyperlinks in worksheets via Hyperlink and HyperlinkCollection

Who Uses This Feature

Generating print-ready invoices and reports from Java back-end services
Locking formula cells while allowing data entry in unprotected ranges
Embedding navigation links between sheets in generated workbooks
Creating standardised output that prints correctly without manual page setup

Create a Workbook, Write Values, and Save

Create a workbook, set cell values and styles, adjust row and column dimensions, and save to an .xlsx file using Workbook.save().

import com.aspose.cells_foss.Cell;
import com.aspose.cells_foss.Style;
import com.aspose.cells_foss.Workbook;
import com.aspose.cells_foss.Worksheet;

public class Main {
    public static void main(String[] args) {
        try (Workbook workbook = new Workbook()) {
            Worksheet sheet = workbook.getWorksheets().get(0);
            sheet.setName("Report");
            sheet.getCells().get("A1").putValue("Revenue");
            sheet.getCells().get("B1").putValue(12500.75);
            Cell total = sheet.getCells().get("B1");
            Style style = total.getStyle();
            style.getFont().setBold(true);
            style.setCustom("#,##0.00");
            total.setStyle(style);
            sheet.getCells().getRows().get(0).setHeight(22.0);
            sheet.getCells().getColumns().get(1).setWidth(14.5);
            workbook.save("report.xlsx");
        }
    }
}

Load a Workbook with Diagnostics

Load an existing .xlsx file using LoadOptions to enable repair mode, then inspect load diagnostics before saving the modified workbook.

import com.aspose.cells_foss.LoadIssue;
import com.aspose.cells_foss.LoadOptions;
import com.aspose.cells_foss.Workbook;

public class LoadWorkbook {
    public static void main(String[] args) {
        LoadOptions options = new LoadOptions();
        options.setStrictMode(false);
        options.setTryRepairPackage(true);
        options.setTryRepairXml(true);
        try (Workbook workbook = new Workbook("input.xlsx", options)) {
            if (workbook.getLoadDiagnostics().hasRepairs()) {
                for (LoadIssue issue : workbook.getLoadDiagnostics().getIssues()) {
                    System.out.println(issue.getMessage());
                }
            }
            workbook.getDocumentProperties().setAuthor("cells-foss");
            workbook.save("output.xlsx");
        }
    }
}

Data Validation and Conditional Formatting

Add a whole-number validation rule and highlight qualifying cells with bold conditional formatting in a single workbook.

import com.aspose.cells_foss.CellArea;
import com.aspose.cells_foss.FormatCondition;
import com.aspose.cells_foss.FormatConditionCollection;
import com.aspose.cells_foss.FormatConditionType;
import com.aspose.cells_foss.OperatorType;
import com.aspose.cells_foss.Style;
import com.aspose.cells_foss.Validation;
import com.aspose.cells_foss.ValidationType;
import com.aspose.cells_foss.Workbook;
import com.aspose.cells_foss.Worksheet;

public class RulesExample {
    public static void main(String[] args) {
        try (Workbook workbook = new Workbook()) {
            Worksheet sheet = workbook.getWorksheets().get(0);
            int vi = sheet.getValidations().add(new CellArea(1, 0, 10, 1));
            Validation validation = sheet.getValidations().get(vi);
            validation.setType(ValidationType.WHOLE_NUMBER);
            validation.setOperator(OperatorType.BETWEEN);
            validation.setFormula1("1");
            validation.setFormula2("100");
            int cfIndex = sheet.getConditionalFormattings().add();
            FormatConditionCollection conditions = sheet.getConditionalFormattings().get(cfIndex);
            conditions.addArea(CellArea.createCellArea("B2", "B11"));
            int condIndex = conditions.addCondition(
                FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "1", "100");
            FormatCondition condition = conditions.get(condIndex);
            Style style = condition.getStyle();
            style.getFont().setBold(true);
            condition.setStyle(style);
            workbook.save("rules.xlsx");
        }
    }
}

Aspose.Cells FOSS cho Java

Thư viện Java 17 mã nguồn mở để tạo, tải, chỉnh sửa và lưu các workbook Excel .xlsx.

Cells FOSS
for Java

Aspose.Cells FOSS — Thư viện bảng tính Java mã nguồn mở

Workbook and Worksheet Management

Who Uses This Feature

Cell Values and Formulas

Who Uses This Feature

Cell Formatting and Styles

Who Uses This Feature

AutoFilter, Validation, and Conditional Formatting

Who Uses This Feature

Page Setup and Worksheet Protection

Who Uses This Feature

Create a Workbook, Write Values, and Save

Load a Workbook with Diagnostics

Data Validation and Conditional Formatting

Tài Nguyên Hỗ Trợ và Học Tập

Aspose.Cells FOSS cho Java

Thư viện Java 17 mã nguồn mở để tạo, tải, chỉnh sửa và lưu các workbook Excel .xlsx.

Cells FOSSfor Java

Aspose.Cells FOSS — Thư viện bảng tính Java mã nguồn mở

Workbook and Worksheet Management

Who Uses This Feature

Cell Values and Formulas

Who Uses This Feature

Cell Formatting and Styles

Who Uses This Feature

AutoFilter, Validation, and Conditional Formatting

Who Uses This Feature

Page Setup and Worksheet Protection

Who Uses This Feature

Create a Workbook, Write Values, and Save

Load a Workbook with Diagnostics

Data Validation and Conditional Formatting

Tài Nguyên Hỗ Trợ và Học Tập

Cells FOSS
for Java