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();

	}
}