Working with Core Cell Operations

Bekerja dengan Operasi Sel Inti

Gambaran Umum

API sel inti mendukung nilai bertipe, penyimpanan formula, inspeksi tipe nilai melalui CellValueType, dan representasi string yang seragam melalui getStringValue().

Menyimpan Nilai Bertipe

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

try (Workbook workbook = new Workbook()) {
    Worksheet sheet = workbook.getWorksheets().get(0);

    Cell a1 = sheet.getCells().get("A1");
    a1.putValue("Revenue");

    Cell b1 = sheet.getCells().get("B1");
    b1.putValue(42500.75);

    Cell c1 = sheet.getCells().get("C1");
    c1.putValue(true);

    Cell d1 = sheet.getCells().get("D1");
    d1.setFormula("=B1*1.2");

    // Type inspection
    System.out.println(a1.getType());  // STRING
    System.out.println(b1.getType());  // NUMBER
    System.out.println(c1.getType());  // BOOLEAN
    System.out.println(d1.getType());  // FORMULA

    workbook.save("typed.xlsx");
}

Nilai Enum CellValueType

Enum Value	Description
`STRING`	Nilai teks yang disimpan oleh `putValue(String)`
`NUMBER`	Nilai numerik yang disimpan oleh `putValue(int)` atau `putValue(double)`
`BOOLEAN`	Nilai boolean yang disimpan oleh `putValue(boolean)`
`DATE_TIME`	Nilai tanggal/waktu yang disimpan oleh `putValue(LocalDateTime)`
`FORMULA`	String formula yang disimpan oleh `setFormula(String)`
`BLANK`	Sel kosong — tidak ada nilai yang diatur

Mendapatkan Nilai String

cell.getStringValue() mengembalikan string yang tidak bergantung pada locale, cocok untuk ditampilkan atau diproses lebih lanjut terlepas dari tipe nilai dasarnya:

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

try (Workbook workbook = new Workbook()) {
    Worksheet sheet = workbook.getWorksheets().get(0);
    Cell b1 = sheet.getCells().get("B1");
    b1.putValue(123);
    System.out.println(b1.getStringValue());  // "123" — no decimal point
    workbook.save("string-values.xlsx");
}

Penyimpanan Formula

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

try (Workbook workbook = new Workbook()) {
    Worksheet sheet = workbook.getWorksheets().get(0);
    Cell b1 = sheet.getCells().get("B1");
    b1.putValue(100.0);
    Cell c1 = sheet.getCells().get("C1");
    c1.setFormula("=B1*1.2");
    System.out.println(c1.getType() == CellValueType.FORMULA);  // true
    workbook.save("formulas.xlsx");
}