Apache POI Rewriting

by Online Tutorials Library July 14, 2022

Apache POI Rewriting

To rewrite the data into existing excel document, Apache POI provides various methods getRow(), getCell(), getSheet() etc.

Apache POI Rewriting Example

  package poiexample;  import java.io.FileInputStream;  import java.io.FileNotFoundException;  import java.io.FileOutputStream;  import java.io.IOException;  import java.io.InputStream;  import java.io.OutputStream;  import org.apache.poi.EncryptedDocumentException;  import org.apache.poi.openxml4j.exceptions.InvalidFormatException;  import org.apache.poi.ss.usermodel.Cell;  import org.apache.poi.ss.usermodel.CellType;  import org.apache.poi.ss.usermodel.Row;  import org.apache.poi.ss.usermodel.Sheet;  import org.apache.poi.ss.usermodel.Workbook;  import org.apache.poi.ss.usermodel.WorkbookFactory;  public class RewritingExample {  public static void main(String[] args) throws FileNotFoundException, IOException, EncryptedDocumentException, InvalidFormatException {  try (InputStream inp = new FileInputStream(“tutoraspire.xls”)) {          Workbook wb = WorkbookFactory.create(inp);          Sheet sheet = wb.getSheetAt(0);          Row row = sheet.getRow(2);          Cell cell = row.getCell(3);          if (cell == null)              cell = row.createCell(3);          cell.setCellType(CellType.STRING);          cell.setCellValue(“101”);              try (OutputStream fileOut = new FileOutputStream(“tutoraspire.xls”)) {              wb.write(fileOut);          }      }catch(Exception e) {      System.out.println(e);      }  }  }  

Output:

Apache POI Rewriting

After Rewriting 102 at place of 202.

Apache POI Rewriting

Next TopicApache POI Shift Row

Apache POI Rewriting

Apache POI Rewriting

Apache POI Rewriting Example

Apache Cordova Tutorial

Updating the Document Using XML in Apache Solr

You may also like