logo

Apache POI Create new Excel sheet

Java Code Examples for

  • org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()

Create a new sheet for Workbook and return the high level representation of Sheet.

package simplesolution.dev;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;

public class HSSFWorkbookCreateSheetExamples {
    
    public static void main(String... args) {
        Workbook workbook = new HSSFWorkbook();
        Sheet sheet = workbook.createSheet("simplesolution.dev");
        try (OutputStream outputStream = new FileOutputStream("sample.xls")) {
            workbook.write(outputStream);
        } catch (FileNotFoundException ex) {
            ex.printStackTrace();
        } catch (IOException ex) {
            ex.printStackTrace();
        }
    }
}

Happy Coding 😊

Writing Excel File Using Apache POI Library in Java

Apache POI to Create Excel Text Cell

Apache POI to Create Excel Date Time Cell in m/d/yy h:mm:ss Format

Apache POI Update Excel File Content

Tags: