How to write column by column data in Excel using Apache POI?

Question

I want to write column by column to an Excel file but I don't know how to do this. Is it possible to make it? I looked in the docs and see no methods to write column by column. Here is my code:

private void writeColumnByColumn() throws IOException {
    XSSFWorkbook workbook = new XSSFWorkbook();
    XSSFSheet sheet = workbook.createSheet();
    String[] strings = {"a", "b", "c"};
    Row row = sheet.createRow(0);
    for (int i = 0; i < 3; i++) {
        // here i want to write "a" in the first column, "b" in the second and "c" in the third
    }
    
    FileOutputStream outputStream = new FileOutputStream("ok.xlsx");
    try (outputStream) {
        workbook.write(outputStream);
    }
}

Does this answer your question? Write column by column using Apache POI — Chris Maggiulli
– Chris Maggiulli, Commented Aug 30, 2021 at 12:27

Stefan · Accepted Answer · 2021-08-31 09:42:36Z

1

This should do the work.

  private void writeColumnByColumn() throws IOException {
   XSSFWorkbook workbook = new XSSFWorkbook();
   XSSFSheet sheet = workbook.createSheet();
   String[] strings = {"a", "b", "c"};
   Row row = sheet.createRow(0);
   for (int i = 0; i < 3; i++) {
          Cell cell = row.createCell(i);
          cell.setCellValue(strings[i]);
   } 
 
   FileOutputStream outputStream = new FileOutputStream("ok.xlsx");
   try (outputStream) {
       workbook.write(outputStream);
   }
  }

edited Aug 31, 2021 at 9:42

answered Aug 30, 2021 at 12:40

Stefan

1001 silver badge14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to write column by column data in Excel using Apache POI?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related