JXL导出EXCEL合并单元格、文字对齐方式

这次能做出来，主要是感谢各位在网上提供的资料，在此记录

导出的结果是，大家看哈，若有可取之处可继续

代码比较多，大家主要看哈我用红色标注部分即可

----------------------------------------------------------------------------代码分割线-------------------------------------------------

public void createNoLotteryAlarmExcel(String filePath,String fileName,List<NoLotteryAlarm> alarmLimits) throws Exception{

//这里要注意每一行标题要留出要合并的位置，我这里是“”
String[] tittles={"序号","整机缺货状态","区域","彩票机号","整机余量","货道一","","货道二","","货道三","","货道四","","售货机号"};
String[] tittles2={"","","","","","票种-面额","余量","票种-面额","余量","票种-面额","余量","票种-面额","余量"};
OutputStream os=null;
WritableWorkbook ww=null;
File file=new File(filePath);
if(!file.exists()){
file.mkdir();
}
os=new FileOutputStream(filePath+fileName);
ww=Workbook.createWorkbook(os);
WritableSheet sheet=ww.createSheet(fileName, 0);

//文字对齐方式
        WritableCellFormat wcf = new WritableCellFormat();  
        wcf.setAlignment(Alignment.CENTRE);//把水平对齐方式指定为居中 
        wcf.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//把垂直对齐方式指定为居中 
这里大家可以参考我上面导出的结果看看，下面的如何合并单元格的
//合并单元格