Aspose.Cells FOSS
Java
Create Workbooks

Hogyan hozzunk létre munkafüzeteket az Aspose.Cells FOSS for Java segítségével

Áttekintés

Ez az útmutató bemutatja, hogyan hozhat létre egy Excel munkafüzetet, tölthet fel cellákat beírt értékekkel, alkalmazhat formázást, és mentheti az eredményt a .xlsx.

1. lépés: Munkafüzet létrehozása 

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. lépés: cellaértékek beállítása 

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. lépés: Formázás alkalmazása 

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. lépés: AutoFilter hozzáadása 

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");
}

Lásd még

 Magyar