Excel File Creation Code

This tutorial explains how to generate Excel files in Java using poi jar file. Download poi jar

import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
 *
 * @author manojkumar
 */
public class xlsfile {
    public static void main(String[] args) {
        
        try {
            HSSFWorkbook wb=new HSSFWorkbook();
            HSSFSheet sheet=wb.createSheet("Student Information");
            HSSFRow rowhed=sheet.createRow((short)0);
            rowhed.createCell((short)0).setCellValue("Full Name");
            rowhed.createCell((short)1).setCellValue("Full Address");
            rowhed.createCell((short)2).setCellValue("Mobil No.");
            HSSFRow row=sheet.createRow((short)1);
            row.createCell((short)0).setCellValue("Manoj");
             row.createCell((short)1).setCellValue("Harpalpur");
              row.createCell((short)2).setCellValue("81200638");
              FileOutputStream filepath=new FileOutputStream("F://a.xls");
              wb.write(filepath);
              System.err.println("Done");
              filepath.close();
        } catch (Exception e) {
            System.err.println(e);
        }
    }   
}

DOWNLOAD ANY ONLINE VIDEOS

Online Videos Link:

Excel File Creation Code

OUR TECH-PROJECTS

DOWNLOAD ANY ONLINE VIDEOS

LABELS

Development Accessories

POPULAR POSTS