Apache POI Shift Row

by Online Tutorials Library July 14, 2022

Apache POI Shift Row

To shift row from top to bottom or vice versa, Apache POI provides shiftRows() method to perform rows shifting. This method takes startrow, endrow and number of rows to shift.

Lets see an example to understand the whole shifting procedure.

Apache POI Shift Row Example

  package poiexample;  import java.io.FileOutputStream;  import java.io.OutputStream;  import org.apache.poi.hssf.usermodel.HSSFWorkbook;  import org.apache.poi.ss.usermodel.Cell;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  public class ShiftRowsExample {  public static void main(String[] args) {  try (OutputStream os = new FileOutputStream(“tutoraspire.xls”)) {  Workbook wb = new HSSFWorkbook();              Sheet sheet = wb.createSheet(“Sheet”);  Row row     = sheet.createRow(1);  Row row2    = sheet.createRow(2);  Cell cell   = row.createCell(1);  Cell cell2  = row2.createCell(1);  cell2.setCellValue(“Hello, tutoraspire”);          sheet.shiftRows(1, 2, -1);          wb.write(os);      }catch(Exception e) {      System.out.println(e.getMessage());      }  }  }  

Output:

Before shift

After shifting one row to top.

Next TopicApache POI Styling Shapes

Apache POI Shift Row

Apache POI Shift Row

Apache POI Shift Row Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like