基于jxl的导出Excel通用方法

public static File getExcelFile(String Globalfile,String targetPath,List<List> listcontent)throws Exception{

File filereturn = null;
if(Globalfile.indexOf(".")>0&&listcontent!=null){
File file = new File(Globalfile);
String name = file.getName();
name = (new Random().nextLong())+name.substring(name.lastIndexOf("."));
Workbook wb = Workbook.getWorkbook(file);
filereturn = new File(targetPath+name);
WritableWorkbook book = Workbook.createWorkbook(filereturn,wb);
WritableSheet ws = book.getSheet(0);for(int i=1;i<=listcontent.size();i++){
List listc = listcontent.get(i-1);
for(int j=0;j<listc.size();j++){
String str = listc.get(j);
Label lb = new Label(j,i,str);
ws.addCell(lb);
}
}
book.write();
wb.close();
book.close();
}
return filereturn;
}

其中Globalfile是一个Excel模版，具体的文件文件路劲；targetPath是生成新的Excel文件路劲，都是服务器端路劲；listcontent是要写入Excel的内容