java设置excel单元格格式为百分比_java导出Excel格式设置

jxltest.java

import java.io.File;

import java.io.FileOutputStream;

import jxl.Workbook;

import jxl.format.BorderLineStyle;

import jxl.format.VerticalAlignment;

import jxl.write.Label;

import jxl.write.Number;

import jxl.write.WritableFont;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

public class jxltest

{

public static void main(String [] args)

{

String templatePath = "c:\\template.xls";//模板文件名

String outFileStr = "c:\\test.xls";//测试文件名(输出文件)

try

{

//创建小字体：Arial,大小为8号,非粗体，非斜体

WritableFont wf = new WritableFont(WritableFont.ARIAL, 8,WritableFont.NO_BOLD, false);

//字体颜色为红色

wf.setColour(jxl.format.Colour.RED);

//创建大字体：Arial,大小为18号,粗体，非斜体

Wri