Unisci Celle

Aspose.Cells - Unisci Celle

La classe Cells ha alcuni metodi utili per il compito. Ad esempio, il metodo merge unisce le celle in una singola cella all’interno di un intervallo specificato delle celle.

Java

 //Create a Workbook.

Workbook wbk = new Workbook();

//Create a Worksheet and get the first sheet.

Worksheet worksheet = wbk.getWorksheets().get(0);

//Create a Cells object to fetch all the cells.

Cells cells = worksheet.getCells();

//Merge some Cells (C6:E7) into a single C6 Cell.

cells.merge(5,2,2,3);

//Input data into C6 Cell.

worksheet.getCells().get(5,2).setValue("This is a test of merging");

//Save the Workbook.

wbk.save(dataDir + "merge_Aspose.xls");

Apache POI SS - HSSF XSSF - Unione celle

Sheet.addMergedRegion può essere utilizzato per unire le celle.

Java

 Workbook wb = new HSSFWorkbook();

Sheet sheet = wb.createSheet("new sheet");

Row row = sheet.createRow((short) 1);

Cell cell = row.createCell((short) 1);

cell.setCellValue("This is a test of merging");

sheet.addMergedRegion(new CellRangeAddress(

        1, //first row (0-based)

        1, //last row  (0-based)

        1, //first column (0-based)

        2  //last column  (0-based)

));

Scarica il codice in esecuzione

Scarica il codice di esempio