Shulou(Shulou.com)06/03 Report--

Excel writes notes

Import org.apache.poi.hssf.usermodel.HSSFCell

Import org.apache.poi.hssf.usermodel.HSSFWorkbook

Import org.apache.poi.ss.usermodel.Row

Import org.apache.poi.ss.usermodel.Cell

Import org.apache.poi.ss.usermodel.Sheet

Public class Demo3 {

Static String FILENAMEPATH = "E:\\ data.xls"

Public static void main (String [] args) throws Exception {

/ / TODO Auto-generated method stub

HSSFWorkbook exb = new HSSFWorkbook (); / / define a new workbook

Sheet sheet = exb.createSheet ("first shell page"); / / create a

Row row = sheet.createRow (0); / / create a row

Cell cell = row.createCell (0); / / create a column

Cell.setCellValue (new Date ()); / / set the value to the cell

/ / write value

Row.createCell (1) .setCellValue (1)

Row.createCell (2) .setCellValue ("first string")

Row.createCell (3) .setCellValue (true)

Row.createCell (4) .setCellValue (HSSFCell.CELL_TYPE_NUMERIC)

Row.createCell (5) .setCellValue (false)

/ / row.createCell (1) .setCellValue (2)

FileOutputStream fileOut = new FileOutputStream (FILENAMEPATH); / / Open the file

Exb.write (fileOut); / / write to a file

FileOut.close (); / / close the file

System.out.println ("Operation successful")

}

}

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.