Bugzilla Bug Xml导出为excel
下面是我做一个程序：用java语言将Bugzilla系统的Bug Xml转化为excel文件。
?
用java处理excel文件的第三方包: pio-3.7-20101029.jar
?
主要代码：
?
读取Xml：
?
???ID++;??}??if(sInfor.isFrequency()){???this.frequency_Id=ID;???sh.setColumnWidth(this.frequency_Id, 10*256);???// new Frequency cell???Cell cellFrequency=row.createCell(frequency_Id);???cellFrequency.setCellValue("Frequency");???cellFrequency.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isVersion()){???this.version_Id=ID;???sh.setColumnWidth(this.version_Id, 15*256);???// new severity cell???Cell cellVersion=row.createCell(version_Id);???cellVersion.setCellValue("Version");???cellVersion.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isLanguage()){???this.language_Id=ID;???sh.setColumnWidth(this.language_Id, 15*256);???// new language cell???Cell cellLanguage=row.createCell(language_Id);???cellLanguage.setCellValue("language");???cellLanguage.setCellStyle(rowTitleStyle);??????ID++;??}??if(sInfor.isReporter_realname()){???this.reporter_realname_Id=ID;???sh.setColumnWidth(this.reporter_realname_Id, 20*256);???// new Reporter real name cell???Cell cellReporterRealName=row.createCell(reporter_realname_Id);???cellReporterRealName.setCellValue("Reporter");???cellReporterRealName.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isOpened_time()){???this.opened_time_Id=ID;???sh.setColumnWidth(this.opened_time_Id, 20*256);???// new Opened time cell???Cell cellOpened=row.createCell(opened_time_Id);???cellOpened.setCellValue("Opened");???cellOpened.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isReporter()){???this.reporter_Id=ID;???sh.setColumnWidth(this.reporter_Id, 20*256);???// new Reporter cell???Cell cellReporter=row.createCell(reporter_Id);???cellReporter.setCellValue("Report Email");???cellReporter.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isAssign_realname()){???this.assign_realname_Id=ID;???sh.setColumnWidth(this.assign_realname_Id, 20*256);???// new assign real name cell???Cell cellAssignRealName=row.createCell(assign_realname_Id);???cellAssignRealName.setCellValue("Assign");???cellAssignRealName.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isAssign()){???this.assign_Id=ID;???sh.setColumnWidth(this.assign_Id, 20*256);???// new assign cell???Cell cellAssign=row.createCell(assign_Id);???cellAssign.setCellValue("Assign Email");???cellAssign.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isChanged_time()){???this.changed_time_Id=ID;???sh.setColumnWidth(this.changed_time_Id, 20*256);???// new severity cell???Cell cellChanged=row.createCell(changed_time_Id);???cellChanged.setCellValue("Changed");???cellChanged.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isComments()){???this.comments_Id=ID;???sh.setColumnWidth(this.comments_Id, 60*256);???// new comments cell???Cell cellComments=row.createCell(comments_Id);???cellComments.setCellValue("Comments");???cellComments.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isReopen_version()){???this.reopen_version_Id=ID;???sh.setColumnWidth(this.reopen_version_Id, 20*256);???// new severity cell???Cell cellReopened=row.createCell(reopen_version_Id);???cellReopened.setCellValue("Reopen version");???cellReopened.setCellStyle(rowTitleStyle);???ID++;??}??if(sInfor.isClose_version()){???this.close_version_Id=ID;???sh.setColumnWidth(this.close_version_Id, 20*256);???// new severity cell???Cell cellClosed=row.createCell(close_version_Id);???cellClosed.setCellValue("Close version");???cellClosed.setCellStyle(rowTitleStyle);???ID++;??}?????//合并第一行单元格??sh.addMergedRegion(new CellRangeAddress(0,0,0,ID-1));???}??/**? * 将workbokk 通过fileOutputStream输入为excel文件? * @param wb? */?public void OutputExcel(String strPath) throws Exception{??FileOutputStream fileOut =null;????try{???fileOut=new FileOutputStream(strPath);?? ???wb.write(fileOut);?? ??} finally{???if(fileOut!=null){?????????fileOut.close();???}?????}?}}?
