Aspose.Cells FOSS
Java
Create Workbooks

Aspose.Cells FOSS for Java를 사용하여 워크북을 만드는 방법

개요

이 가이드는 Excel 워크북을 생성하고, 셀에 입력된 값을 채우며, 서식을 적용하고, 결과를 .xlsx에 저장하는 방법을 보여줍니다.

1단계: 워크북 만들기 

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

try (Workbook workbook = new Workbook()) {
    Worksheet sheet = workbook.getWorksheets().get(0);
    sheet.setName("Report");
    workbook.save("report.xlsx");
}

2단계: 셀 값 설정 

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

try (Workbook workbook = new Workbook()) {
    Worksheet sheet = workbook.getWorksheets().get(0);
    sheet.getCells().get("A1").putValue("Product");
    sheet.getCells().get("B1").putValue("Revenue");
    sheet.getCells().get("A2").putValue("Widget A");
    sheet.getCells().get("B2").putValue(42500.75);
    sheet.getCells().get("C2").setFormula("=B2*1.2");
    workbook.save("values.xlsx");
}

3단계: 서식 적용 

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

try (Workbook workbook = new Workbook()) {
    Worksheet sheet = workbook.getWorksheets().get(0);
    Cell b2 = sheet.getCells().get("B2");
    b2.putValue(42500.75);
    Style style = b2.getStyle();
    style.getFont().setBold(true);
    style.setCustom("#,##0.00");
    b2.setStyle(style);
    sheet.getCells().getRows().get(0).setHeight(22.0);
    sheet.getCells().getColumns().get(1).setWidth(16.0);
    workbook.save("styled.xlsx");
}

4단계: 자동 필터 추가 

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

try (Workbook workbook = new Workbook()) {
    Worksheet sheet = workbook.getWorksheets().get(0);
    sheet.getCells().get("A1").putValue("Product");
    sheet.getCells().get("B1").putValue("Region");
    sheet.getAutoFilter().setRange("A1:B1");
    workbook.save("filtered.xlsx");
}

참조

 한국어