JXL基础应用

package com.hurricane.jxl;import java.io.File;import java.io.IOException;import java.text.DateFormat;import java.text.SimpleDateFormat;import java.util.Date;import org.apache.log4j.Logger;import jxl.Cell;import jxl.DateCell;import jxl.Sheet;import jxl.Workbook;import jxl.format.Alignment;import jxl.format.Colour;import jxl.read.biff.BiffException;import jxl.write.DateTime;import jxl.write.Label;import jxl.write.Number;import jxl.write.WritableCellFormat;import jxl.write.WritableFont;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;/** * Hello world! * */public class App {private static Logger logger = Logger.getLogger(App.class);    public static void main( String[] args ) throws Exception{//    write();    read();    }        private void format() throws Exception {// TODO Auto-generated method stub    File file = new File("E:/test.xls");    Workbook inbook = Workbook.getWorkbook(file);    WritableWorkbook workbook = Workbook.createWorkbook(file, inbook);    WritableSheet sheet2 = workbook.getSheet(1);    sheet2.mergeCells(1, 1, 3, 1);    Label label2 = new Label(1, 1, "又是一个数据");    WritableFont font = new WritableFont(WritableFont.TIMES, 16, WritableFont.BOLD);    font.setColour(Colour.BLUE);    WritableCellFormat format = new WritableCellFormat(font);    format.setAlignment(Alignment.CENTRE);    label2.setCellFormat(format);    sheet2.addCell(label2);    workbook.write();    workbook.close();}        private static void update() throws Exception {// TODO Auto-generated method stub    File file = new File("E:/test.xls");    Workbook inbook = Workbook.getWorkbook(file);    WritableWorkbook workbook = Workbook.createWorkbook(file, inbook);    WritableSheet sheet = workbook.getSheet(0);    Label label = new Label(2, 0, "又是一个数据");    Label label2 = new Label(2, 0, "又是一个数据");    sheet.addCell(label);    WritableSheet sheet2 = workbook.createSheet("第二页", 1);    sheet2.addCell(label2);    workbook.write();    workbook.close();}        private static void read() throws BiffException, IOException {// TODO Auto-generated method stub    File file = new File("E:/test.xls");    Workbook workbook = Workbook.getWorkbook(file);    Sheet sheet = workbook.getSheet(0);    Cell cell = sheet.getCell(0, 0);    logger.info(cell.getContents());    cell = sheet.getCell(1, 0);    logger.info(cell.getContents());    cell = sheet.getCell(2,0);    if (cell instanceof DateCell) {DateCell dateCell = (DateCell) cell;Date date = dateCell.getDate();DateFormat format = new SimpleDateFormat("yyyy-MM=dd-HH");logger.info(format.format(date));}    logger.info(cell.getContents());    workbook.close();}        private static void write() throws Exception{// TODO Auto-generated method stub    File file = new File("E:/test.xls");    WritableWorkbook workbook = Workbook.createWorkbook(file);    WritableSheet sheet1 = workbook.createSheet("第一页", 0);    Label label = new Label(0, 0, "这是第一个值");    Number number = new Number(1, 0, 3.1415926);    DateTime time = new DateTime(2, 0, new Date());    sheet1.addCell(label);    sheet1.addCell(number);    sheet1.addCell(time);    workbook.write();    workbook.close();}}