excel编辑

package com.exceldemo;

import java.io.FileOutputStream;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.CellFormat;
import jxl.write.Boolean;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.NumberFormat;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;


public class HyperlinkReadSample {
	public static void main(String[] args) throws IOException, WriteException {
		
		
		String [] title = {"编号","产品名称","产品价格","产品数量","生产日期","产地","是否出口"};
		String filePath = "D:\\1.xls";
		FileOutputStream os = new FileOutputStream(filePath);
		WritableWorkbook wwb=Workbook.createWorkbook(os);
		//设置Sheet 名称
		WritableSheet sheet = wwb.createSheet("产品清单(工作布)", 0);
		//添加标题
		Label label;
		for (int i = 0; i < title.length; i++) {
			label = new  Label(i, 0, title[i]);
			sheet.addCell(label);
		}
		//添加单元格
		Number number = new Number(0, 1, 20071001);
		sheet.addCell(number);
		
		label = new Label(1, 1, "人参");
		sheet.addCell(label);
		NumberFormat nf = new NumberFormat("#.##");

		WritableCellFormat wcf = new WritableCellFormat();
		Number nb = new Number(2,1,2.45,wcf);
		sheet.addCell(nb);
		
		jxl.write.Number numb=new Number(3, 1, 200);
		sheet.addCell(numb);
		
		// 日期
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		String newdate = sdf.format(new Date());
		label = new Label(4, 1, newdate);
		sheet.addCell(label);
		//address
		label = new Label(5, 1, "大北京");
		sheet.addCell(label);
		// 布尔型
		Boolean boole = new Boolean(6, 1, true);
		sheet.addCell(boole);
		
		//合并单元格 第4行前三个单元格
		sheet.mergeCells(0, 3, 2, 3);
		label=new Label(0, 3, "和并了这三个单元格");
		sheet.addCell(label); 
		
		
		//定义子体
		CellFormat cf = wwb.getSheet(0).getCell(1, 0).getCellFormat();
		WritableCellFormat wc = new WritableCellFormat();
		wc.setAlignment(Alignment.CENTRE);//属性居中 FILL GENERAL JUSTIFY RIGHT 
		// 设置边框
		wc.setBorder(Border.ALL, BorderLineStyle.THIN);
		
		//设置颜色
		wc.setBackground(jxl.format.Colour.RED);
		label = new Label(1,5,"字体",wc);
		sheet.addCell(label); 
		WritableFont wfont = new WritableFont( WritableFont.createFont("隶书"),20);
		WritableCellFormat font = new WritableCellFormat(wfont);
		label = new Label(2,5,"隶书",font);
		sheet.addCell(label); 
		
		
		wwb.write();
		wwb.close();
		System.out.println("====end====");
		
	}

}

编号	产品名称	产品价格	产品数量	生产日期	产地	是否出口
20071001	人参	2.45	200	2015-05-22	大北京	TRUE
和并了这三个单元格
	字体	隶书

编号	产品名称	产品价格	产品数量	生产日期	产地	是否出口
20071001	人参	2.45	200	2015-05-22	大北京	TRUE
和并了这三个单元格
	字体	隶书