Struts2 Java 数据导出到Excel的简易教程

try    {  
            //  打开文件   
String path=QueryAllMater.class.getResource("/").toString();
System.out.println("输出权利经："+path);
path=path.substring(6, path.length()-17);
path=path.replace("%20", " ");

System.out.println(path);
            WritableWorkbook book  =  Workbook.createWorkbook( new  File( path+"/sheet/"+username+".xls" ));  
            //  生成名为“第一页”的工作表，参数0表示这是第一页   
            WritableSheet sheet  =  book.createSheet( " 第一页 " ,  0 );  
            //  在Label对象的构造子中指名单元格位置是第一列第一行(0,0)  
            //  以及单元格内容为test   
            
            Label label  =   new  Label( 0 ,0 ," 编号 " );  
            Label labe2  =   new  Label( 1 ,0 ," 名称 " );  
            Label labe3  =   new  Label( 2 ,0 ," 规格 " );  
            Label labe4  =   new  Label( 3 ,0 ," 库存量 " );  
            Label labe5  =   new  Label( 4 ,0 ," 总数量 " );  
            Label labe6  =   new  Label( 5 ,0 ," 单位 " );  
            Label labe7  =   new  Label( 6 ,0 ," 类别 " );  
            Label labe8  =   new  Label( 7 ,0 ," 仓库 " );  
            Label labe9  =   new  Label( 8 ,0 ," 库位 " );  
            Label labe10  =   new  Label( 9 ,0 ," 加工件号 " );  
            Label label1  =   new  Label( 10 ,0 ," 加工数量 " );  
            Label label2  =   new  Label( 11 ,0 ," 维护周期 " );  
            Label label3  =   new  Label( 12 ,0 ," 上次保养 " );  
            Label label4  =   new  Label( 13 ,0 ," 上次报检 " );  
            Label label5  =   new  Label( 14 ,0 ," 价格 " );  
            Label label6  =   new  Label( 15 ,0 ," 备注 " );