Java tutorial
package kr.co.blackducksoftware.rg.displayexcel; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.util.ArrayList; import java.util.Date; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFFont; import org.apache.poi.hssf.usermodel.HSSFRichTextString; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.CellRangeAddress; import org.apache.poi.hssf.util.HSSFColor; import org.apache.poi.hssf.util.Region; import kr.co.blackducksoftware.rg.login.Login; import kr.co.blackducksoftware.rg.tools.TimeStamp; import kr.co.blackducksoftware.rg.identifiedfiles.FileVals; public class Style { /** * FOR OSSSW written by byunghoon */ /** * OSSW_Cover ? */ public static HSSFCellStyle osswCoverCellStyel; public static HSSFCellStyle osswCoverCellStyelfont; public static HSSFFont osswCoverFont; /** * OSSW_Summary ? */ public static HSSFCellStyle osswSummaryCellStyel_1; public static HSSFCellStyle osswSummaryCellStyel_2; public static HSSFCellStyle osswSummaryCellStyel_3; public static HSSFCellStyle osswSummaryCellStyel_4; public static HSSFCellStyle osswSummaryCellStyel_5; public static HSSFCellStyle osswSummaryCellStyel_6; public static HSSFFont osswSummaryFont_1; public static HSSFFont osswSummaryFont_2; /** * OSSW_BOM ? */ public static HSSFCellStyle osswBOMCellStyel_1; public static HSSFCellStyle osswBOMCellStyel_2; public static HSSFCellStyle osswBOMCellStyel_3; public static HSSFCellStyle osswBOMCellStyel_4; public static HSSFFont osswBOMFont_1; public static HSSFFont osswBOMFont_2; /** * written by Ron Cho */ public static HSSFCellStyle coverlineStyle; public static HSSFCellStyle centerStyle; public static HSSFCellStyle regularStyle; public static HSSFCellStyle mainHeaderStyle; public static HSSFCellStyle firstSubHeaderCellStyle; public static HSSFCellStyle secondSubHeaderCellStyle; public static HSSFCellStyle firstMergedCellStyle; public static HSSFCellStyle secondMergedCellStyle; public static HSSFCellStyle componentCellStyle; public static HSSFCellStyle greyCellStyle; public static HSSFCellStyle anaDesCellStyle; public static HSSFCellStyle fReviewCellStyle; public static HSSFCellStyle finalReviewCellStyle; public static HSSFCellStyle src2ndrowCellStyle; public static HSSFCellStyle src2ndrowMidCellStyle; public static HSSFCellStyle src2ndrowFinalCellStyle; public static HSSFCellStyle finalHeaderCellStyle; public static HSSFCellStyle exampleCellStyle; public static HSSFCellStyle BMRStyle; public static HSSFCellStyle menuLineStyle; public static HSSFCellStyle summaryCellStyle; public static HSSFCellStyle analCellStyle; public static HSSFCellStyle exbCellStyle; public static HSSFCellStyle rightOpenCellStyle; public static HSSFCellStyle TrightOpenCellStyle; public static HSSFCellStyle BRightOpenCellStyle; public static HSSFCellStyle dateCellStyle; public static HSSFCellStyle leftOpenCellStyle; public static HSSFCellStyle TleftOpenCellStyle; public static HSSFCellStyle BLeftOpenCellStyle; public static HSSFCellStyle leftOpenMediumRightCellStyle; public static HSSFCellStyle TleftOpenMediumRightCellStyle; public static HSSFCellStyle BLeftOpenMediumRightCellStyle; public static HSSFCellStyle LROpenCellStyle; public static HSSFCellStyle BLROpenCellStyle; public static HSSFCellStyle TLROpenCellStyle; public static HSSFCellStyle projectInformationCellStyle; public static HSSFCellStyle CHCellStyle; public static HSSFCellStyle projectInformationCellStyle2; public static HSSFFont mainHeaderFont; public static HSSFFont blackFont; public static HSSFFont whiteFont; public static HSSFFont linkFont; public static HSSFFont exampleFont; public static HSSFFont projectInformationFont; public static HSSFFont summaryFont; public static HSSFFont analFont; public static HSSFFont greyFont; public static void coverStyle(HSSFWorkbook myWorkbook) { coverlineStyle = myWorkbook.createCellStyle(); coverlineStyle.setFillForegroundColor(HSSFColor.LIGHT_BLUE.index); } @SuppressWarnings("deprecation") public static void createSheetHeaders(HSSFSheet currentSheet) { HSSFRow mainHeader = currentSheet.createRow(1); // HSSFRow topMergedHeaders = currentSheet.createRow(1); /** * ???? ??? ???? */ HSSFRichTextString sourceCodeIdentificationReportHeader = new HSSFRichTextString( "?? ???? SW ????? ???? ???"); mainHeader.createCell(0).setCellValue(sourceCodeIdentificationReportHeader); currentSheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 7));// 7->6?? // ???? // for // comment mainHeader.getCell(0).setCellStyle(mainHeaderStyle); /* * Menu 1 */ HSSFRow menu1 = currentSheet.createRow(3); HSSFRichTextString menuString = new HSSFRichTextString( "1. ?????? ????"); menu1.createCell(0).setCellValue(menuString); currentSheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 7));// 7->6?? // ???? // for // comment menu1.getCell(0).setCellStyle(menuLineStyle); /* * BOM (menu2) */ HSSFRow BOMHead = currentSheet.createRow(11);// 12?? ???? BOMHead.createCell(0).setCellValue( "2. ?????? ??????? ???(Bill of Materials)"); currentSheet.autoSizeColumn((short) 0, true); BOMHead.getCell(0).setCellStyle(menuLineStyle); /** * ?? ??? ???? ???? */ HSSFRichTextString homepageHeader = new HSSFRichTextString("??????"); HSSFRichTextString matchedObHeader = new HSSFRichTextString("??? ??"); HSSFRichTextString matchedFilesCountHeader = new HSSFRichTextString("File / Folder"); HSSFRichTextString componentHeader = new HSSFRichTextString("Component"); HSSFRichTextString versionHeader = new HSSFRichTextString("Version"); // HSSFRichTextString licenseHeader = new // HSSFRichTextString("Total Lines"); HSSFRichTextString identifierHeader = new HSSFRichTextString("Component"); HSSFRichTextString identifiedDateHeader = new HSSFRichTextString("Version"); HSSFRichTextString commentHeader = new HSSFRichTextString("????????"); HSSFRichTextString firstLineHeader = new HSSFRichTextString("Matched First Line");// firstline HSSFRichTextString matchedRatioHeader = new HSSFRichTextString("Matched Ratio");// MachedRatioPercent HSSFRichTextString realCommentHeader = new HSSFRichTextString("Comment");// add // for // comment HSSFRichTextString licenseHeader = new HSSFRichTextString("?????");// add // for // license HSSFRichTextString jointHeader = new HSSFRichTextString("????????");// add // for // license HSSFRichTextString fileCountHeader = new HSSFRichTextString("?? ???? ??");// add // for // license HSSFRichTextString percentHeader = new HSSFRichTextString("%");// add // for // license // currentSheet.addMergedRegion(new CellRangeAddress(1, 1, 9, 13)); /* * 2?? ?? ??????? ???. */ HSSFRow BOM = currentSheet.createRow(12);// 13?? ???? // topMergedHeaders.createCell(0).setCellValue(categoryHeader); BOM.createCell(0).setCellValue(matchedObHeader); BOM.createCell(1).setCellValue(componentHeader); BOM.createCell(2).setCellValue(versionHeader); BOM.createCell(3).setCellValue(homepageHeader); BOM.createCell(4).setCellValue(licenseHeader); BOM.createCell(5).setCellValue(jointHeader); BOM.createCell(6).setCellValue(fileCountHeader); // BOM.createCell(7).setCellValue(commentHeader); /* * 2?? ?? ?????? ? ?? */ for (int a = 0; a < BOM.getLastCellNum(); a++) { BOM.getCell(a).setCellStyle(firstMergedCellStyle); currentSheet.autoSizeColumn((short) a, true); } /* * ????sw????? ???? (menu3) */ int BOMCount = 0;// ?? HSSFRow OSSSMenu = currentSheet.createRow(15 + BOMCount);// 3?? ?? ???? ???? OSSSMenu.createCell(0) .setCellValue("3. ????SW????? ????"); currentSheet.autoSizeColumn((short) 0, true); OSSSMenu.getCell(0).setCellStyle(menuLineStyle); /* * 3?? ?? ??????? ???. */ HSSFRow OSSS = currentSheet.createRow(16 + BOMCount);// 3?? ???? // topMergedHeaders.createCell(0).setCellValue(categoryHeader); OSSS.createCell(0).setCellValue(licenseHeader); OSSS.createCell(1).setCellValue(jointHeader); OSSS.createCell(2).setCellValue(fileCountHeader); OSSS.createCell(3).setCellValue(percentHeader); // OSSS.createCell(7).setCellValue(commentHeader); for (int a = 0; a < OSSS.getLastCellNum(); a++) { OSSS.getCell(a).setCellStyle(firstMergedCellStyle); currentSheet.autoSizeColumn((short) a, true); } /* * ????? ????? (menu4) */ int OSSSCount = 0;// ?? HSSFRow analMenu = currentSheet.createRow(19 + BOMCount + OSSSCount);// 4?? // ?? // ???? // ???? analMenu.createCell(0).setCellValue("4. ????? ?????"); currentSheet.autoSizeColumn((short) 0, true); analMenu.getCell(0).setCellStyle(menuLineStyle); /* * 4?? ?? ??????? ???. */ HSSFRow anal = currentSheet.createRow(20 + BOMCount + OSSSCount);// 3?? // ???? anal.createCell(0).setCellValue("????? ?????"); anal.getCell(0).setCellStyle(analCellStyle); currentSheet.autoSizeColumn((short) 0, true); } public static void finalizeWorksheet(HSSFSheet currentWorkSheet) { HSSFRow currentRow = currentWorkSheet.getRow(0); } public static void setFonts(HSSFWorkbook myWorkbook) { /** * written by byunghoon * ossw_cover font ? */ osswCoverFont = myWorkbook.createFont(); osswCoverFont.setFontName("Arial"); osswCoverFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); osswCoverFont.setColor(HSSFColor.BLACK.index); osswCoverFont.setFontHeightInPoints((short) 20); /** * written by byunghoon * ossw_Summary font ? */ osswSummaryFont_1 = myWorkbook.createFont(); osswSummaryFont_1.setFontName("Arial"); osswSummaryFont_1.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); osswSummaryFont_1.setColor(HSSFColor.BLACK.index); osswSummaryFont_1.setFontHeightInPoints((short) 15); osswSummaryFont_2 = myWorkbook.createFont(); osswSummaryFont_2.setFontName("Arial"); osswSummaryFont_2.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); osswSummaryFont_2.setColor(HSSFColor.BLACK.index); osswSummaryFont_2.setFontHeightInPoints((short) 12); /** * written by byunghoon * ossw_BOM font ? */ osswBOMFont_1 = myWorkbook.createFont(); osswBOMFont_1.setFontName("Arial"); osswBOMFont_1.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); osswBOMFont_1.setColor(HSSFColor.BLACK.index); osswBOMFont_1.setFontHeightInPoints((short) 15); osswBOMFont_2 = myWorkbook.createFont(); osswBOMFont_2.setFontName("Arial"); osswBOMFont_2.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL); osswBOMFont_2.setColor(HSSFColor.BLACK.index); osswBOMFont_2.setFontHeightInPoints((short) 12); /** * Set the font for my styles */ blackFont = myWorkbook.createFont(); // blackFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); blackFont.setFontName("???? ???"); blackFont.setColor(HSSFColor.BLACK.index); blackFont.setFontHeightInPoints((short) 10); analFont = myWorkbook.createFont(); analFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); analFont.setFontName("HY??????M"); analFont.setColor(HSSFColor.BLACK.index); analFont.setFontHeightInPoints((short) 13); summaryFont = myWorkbook.createFont(); summaryFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); summaryFont.setFontName("Arial"); summaryFont.setColor(HSSFColor.BLACK.index); summaryFont.setFontHeightInPoints((short) 10); whiteFont = myWorkbook.createFont(); whiteFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); whiteFont.setFontName("???? ???"); whiteFont.setColor(HSSFColor.WHITE.index); whiteFont.setFontHeightInPoints((short) 10); mainHeaderFont = myWorkbook.createFont(); mainHeaderFont.setFontName("???? ???"); mainHeaderFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); mainHeaderFont.setColor(HSSFColor.BLUE.index); mainHeaderFont.setFontHeightInPoints((short) 14); linkFont = myWorkbook.createFont(); linkFont.setItalic(true); linkFont.setFontName("Calibri"); linkFont.setColor(HSSFColor.WHITE.index); linkFont.setFontHeightInPoints((short) 10); exampleFont = myWorkbook.createFont(); // exampleFont.setItalic(true); exampleFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); exampleFont.setFontName("???? ???"); exampleFont.setColor(HSSFColor.BLUE.index); exampleFont.setFontHeightInPoints((short) 16); projectInformationFont = myWorkbook.createFont(); // projectInformationFont.setItalic(true); projectInformationFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); projectInformationFont.setFontName("???? ???"); projectInformationFont.setColor(HSSFColor.BLACK.index); projectInformationFont.setFontHeightInPoints((short) 14); greyFont = myWorkbook.createFont(); // greyFont.setItalic(true); greyFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); greyFont.setFontName("???? ???"); greyFont.setColor(HSSFColor.BLACK.index); greyFont.setFontHeightInPoints((short) 11); } /** * * ?? ???? ???? ???? * */ public static void setStyles(HSSFWorkbook myWorkbook) { /** * Written by byunghoon * ossw_Cover ? ? */ osswCoverCellStyel = myWorkbook.createCellStyle(); osswCoverCellStyel.setFillForegroundColor(HSSFColor.DARK_BLUE.index); osswCoverCellStyel.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); osswCoverCellStyelfont = myWorkbook.createCellStyle(); osswCoverCellStyelfont.setFont(osswCoverFont); //osswcoverCellStyelfont.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); osswCoverCellStyelfont.setAlignment(HSSFCellStyle.ALIGN_CENTER); osswCoverCellStyelfont.setWrapText(false); /** * Written by byunghoon * ossw_Summary ? ? */ // osswSummaryCellStyel_1 = myWorkbook.createCellStyle(); osswSummaryCellStyel_1.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); osswSummaryCellStyel_1.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); osswSummaryCellStyel_1.setBorderTop(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_1.setBorderBottom(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_1.setBorderLeft(HSSFCellStyle.BORDER_THIN); //osswSummaryCellStyel_1.setTopBorderColor(HSSFColor.BLACK.index); // osswSummaryCellStyel_2 = myWorkbook.createCellStyle(); osswSummaryCellStyel_2.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); osswSummaryCellStyel_2.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); osswSummaryCellStyel_2.setBorderTop(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_2.setBorderBottom(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_2.setBorderRight(HSSFCellStyle.BORDER_THIN); //osswSummaryCellStyel_2.setBottomBorderColor(HSSFColor.BLACK.index); // osswSummaryCellStyel_3 = myWorkbook.createCellStyle(); osswSummaryCellStyel_3.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); osswSummaryCellStyel_3.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); osswSummaryCellStyel_3.setFont(osswSummaryFont_1); osswSummaryCellStyel_3.setAlignment(HSSFCellStyle.ALIGN_CENTER); osswSummaryCellStyel_3.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); osswSummaryCellStyel_3.setBorderTop(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_3.setBorderBottom(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_3.setWrapText(false); // osswSummaryCellStyel_4 = myWorkbook.createCellStyle(); osswSummaryCellStyel_4.setFont(osswSummaryFont_2); osswSummaryCellStyel_4.setAlignment(HSSFCellStyle.ALIGN_LEFT); osswSummaryCellStyel_4.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); osswSummaryCellStyel_4.setBorderBottom(HSSFCellStyle.BORDER_THIN); // osswSummaryCellStyel_5 = myWorkbook.createCellStyle(); osswSummaryCellStyel_5.setFont(osswSummaryFont_2); osswSummaryCellStyel_5.setAlignment(HSSFCellStyle.ALIGN_LEFT); osswSummaryCellStyel_5.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); osswSummaryCellStyel_5.setBorderTop(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_5.setBorderBottom(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_5.setBorderLeft(HSSFCellStyle.BORDER_THIN); // osswSummaryCellStyel_6 = myWorkbook.createCellStyle(); osswSummaryCellStyel_6.setFont(osswSummaryFont_2); osswSummaryCellStyel_6.setBorderTop(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_6.setBorderBottom(HSSFCellStyle.BORDER_THIN); osswSummaryCellStyel_6.setBorderRight(HSSFCellStyle.BORDER_THIN); /** * Written by byunghoon * ossw_BOM ? ? */ osswBOMCellStyel_1 = myWorkbook.createCellStyle(); osswBOMCellStyel_1.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); osswBOMCellStyel_1.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); osswBOMCellStyel_1.setAlignment(HSSFCellStyle.ALIGN_CENTER); osswBOMCellStyel_1.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); osswBOMCellStyel_1.setBorderTop(HSSFCellStyle.BORDER_THIN); osswBOMCellStyel_1.setBorderBottom(HSSFCellStyle.BORDER_THIN); osswBOMCellStyel_1.setBorderLeft(HSSFCellStyle.BORDER_THIN); osswBOMCellStyel_1.setBorderRight(HSSFCellStyle.BORDER_THIN); osswBOMCellStyel_1.setFont(osswBOMFont_1); /** * Main Header Style */ mainHeaderStyle = myWorkbook.createCellStyle(); mainHeaderStyle.setFont(mainHeaderFont); // mainHeaderStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); mainHeaderStyle.setWrapText(false); /** * MenuLine Style */ menuLineStyle = myWorkbook.createCellStyle(); menuLineStyle.setFont(blackFont); // mainHeaderStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); menuLineStyle.setWrapText(false); /** * Anal Cell Style */ analCellStyle = myWorkbook.createCellStyle(); analCellStyle.setFillForegroundColor(HSSFColor.ORANGE.index); analCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); analCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); analCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); analCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); analCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); analCellStyle.setBorderLeft(HSSFCellStyle.BORDER_MEDIUM); analCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); analCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); analCellStyle.setRightBorderColor(HSSFColor.BLACK.index); analCellStyle.setBorderTop(HSSFCellStyle.BORDER_MEDIUM); analCellStyle.setTopBorderColor(HSSFColor.BLACK.index); analCellStyle.setFont(analFont); analCellStyle.setWrapText(false); /** * anaDes Cell Style */ anaDesCellStyle = myWorkbook.createCellStyle(); anaDesCellStyle.setFillForegroundColor(HSSFColor.DARK_BLUE.index); anaDesCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); anaDesCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); anaDesCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); anaDesCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); anaDesCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); anaDesCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); anaDesCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); anaDesCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); anaDesCellStyle.setRightBorderColor(HSSFColor.BLACK.index); anaDesCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); anaDesCellStyle.setTopBorderColor(HSSFColor.BLACK.index); anaDesCellStyle.setFont(whiteFont); anaDesCellStyle.setWrapText(false); /** * 1st review Cell Style (fReview) */ fReviewCellStyle = myWorkbook.createCellStyle(); fReviewCellStyle.setFillForegroundColor(HSSFColor.VIOLET.index); fReviewCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); fReviewCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); fReviewCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); fReviewCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); fReviewCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); fReviewCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); fReviewCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); fReviewCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); fReviewCellStyle.setRightBorderColor(HSSFColor.BLACK.index); fReviewCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); fReviewCellStyle.setTopBorderColor(HSSFColor.BLACK.index); fReviewCellStyle.setFont(whiteFont); fReviewCellStyle.setWrapText(false); /** * finalHeaderCell Style (fReview) */ finalHeaderCellStyle = myWorkbook.createCellStyle(); finalHeaderCellStyle.setFillForegroundColor(HSSFColor.DARK_TEAL.index); finalHeaderCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); finalHeaderCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); finalHeaderCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); finalHeaderCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); finalHeaderCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); finalHeaderCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); finalHeaderCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); finalHeaderCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); finalHeaderCellStyle.setRightBorderColor(HSSFColor.BLACK.index); finalHeaderCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); finalHeaderCellStyle.setTopBorderColor(HSSFColor.BLACK.index); finalHeaderCellStyle.setFont(whiteFont); finalHeaderCellStyle.setWrapText(false); /** * finalReview Cell Style (fReview) */ finalReviewCellStyle = myWorkbook.createCellStyle(); finalReviewCellStyle.setFillForegroundColor(HSSFColor.DARK_GREEN.index); finalReviewCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); finalReviewCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); finalReviewCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); finalReviewCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); finalReviewCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); finalReviewCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); finalReviewCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); finalReviewCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); finalReviewCellStyle.setRightBorderColor(HSSFColor.BLACK.index); finalReviewCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); finalReviewCellStyle.setTopBorderColor(HSSFColor.BLACK.index); finalReviewCellStyle.setFont(whiteFont); finalReviewCellStyle.setWrapText(false); /** * src2ndrow Cell Style (fReview) */ src2ndrowCellStyle = myWorkbook.createCellStyle(); src2ndrowCellStyle.setFillForegroundColor(HSSFColor.LIGHT_BLUE.index); src2ndrowCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); src2ndrowCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); src2ndrowCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); src2ndrowCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); src2ndrowCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); src2ndrowCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); src2ndrowCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); src2ndrowCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); src2ndrowCellStyle.setRightBorderColor(HSSFColor.BLACK.index); src2ndrowCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); src2ndrowCellStyle.setTopBorderColor(HSSFColor.BLACK.index); src2ndrowCellStyle.setFont(blackFont); src2ndrowCellStyle.setWrapText(false); /** * src2ndrowMid Cell Style (fReview) */ src2ndrowMidCellStyle = myWorkbook.createCellStyle(); src2ndrowMidCellStyle.setFillForegroundColor(HSSFColor.CORAL.index); src2ndrowMidCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); src2ndrowMidCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); src2ndrowMidCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); src2ndrowMidCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); src2ndrowMidCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); src2ndrowMidCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); src2ndrowMidCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); src2ndrowMidCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); src2ndrowMidCellStyle.setRightBorderColor(HSSFColor.BLACK.index); src2ndrowMidCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); src2ndrowMidCellStyle.setTopBorderColor(HSSFColor.BLACK.index); src2ndrowMidCellStyle.setFont(blackFont); src2ndrowMidCellStyle.setWrapText(false); /** * src2ndrowFinal Cell Style (fReview) */ src2ndrowFinalCellStyle = myWorkbook.createCellStyle(); src2ndrowFinalCellStyle.setFillForegroundColor(HSSFColor.LIGHT_GREEN.index); src2ndrowFinalCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); src2ndrowFinalCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); src2ndrowFinalCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); src2ndrowFinalCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); src2ndrowFinalCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); src2ndrowFinalCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); src2ndrowFinalCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); src2ndrowFinalCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); src2ndrowFinalCellStyle.setRightBorderColor(HSSFColor.BLACK.index); src2ndrowFinalCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); src2ndrowFinalCellStyle.setTopBorderColor(HSSFColor.BLACK.index); src2ndrowFinalCellStyle.setFont(blackFont); src2ndrowFinalCellStyle.setWrapText(false); /** * First Merged Cell Style */ firstMergedCellStyle = myWorkbook.createCellStyle(); firstMergedCellStyle.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); firstMergedCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); firstMergedCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); firstMergedCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); firstMergedCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); firstMergedCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); firstMergedCellStyle.setBorderLeft(HSSFCellStyle.BORDER_MEDIUM); firstMergedCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); firstMergedCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); firstMergedCellStyle.setRightBorderColor(HSSFColor.BLACK.index); firstMergedCellStyle.setBorderTop(HSSFCellStyle.BORDER_MEDIUM); firstMergedCellStyle.setTopBorderColor(HSSFColor.BLACK.index); firstMergedCellStyle.setFont(blackFont); firstMergedCellStyle.setWrapText(false); /** * summary Cell Style * */ summaryCellStyle = myWorkbook.createCellStyle(); summaryCellStyle.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); summaryCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); // summaryCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); summaryCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); summaryCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); summaryCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); summaryCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); summaryCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); summaryCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); summaryCellStyle.setRightBorderColor(HSSFColor.BLACK.index); summaryCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); summaryCellStyle.setTopBorderColor(HSSFColor.BLACK.index); summaryCellStyle.setFont(summaryFont); summaryCellStyle.setWrapText(false); /** * Second Merged Cell Style */ secondMergedCellStyle = myWorkbook.createCellStyle(); secondMergedCellStyle.setFillForegroundColor(HSSFColor.ROSE.index); secondMergedCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); secondMergedCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); secondMergedCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); secondMergedCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); secondMergedCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); secondMergedCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); secondMergedCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); secondMergedCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); secondMergedCellStyle.setRightBorderColor(HSSFColor.BLACK.index); secondMergedCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); secondMergedCellStyle.setTopBorderColor(HSSFColor.BLACK.index); secondMergedCellStyle.setFont(blackFont); secondMergedCellStyle.setWrapText(false); /** * Border Med Right Cell Style */ BMRStyle = myWorkbook.createCellStyle(); BMRStyle.setAlignment(HSSFCellStyle.ALIGN_LEFT); BMRStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); BMRStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); BMRStyle.setRightBorderColor(HSSFColor.BLACK.index); BMRStyle.setWrapText(true); /** * Regular Cell Style */ regularStyle = myWorkbook.createCellStyle(); regularStyle.setAlignment(HSSFCellStyle.ALIGN_LEFT); regularStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); regularStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); regularStyle.setBottomBorderColor(HSSFColor.BLACK.index); regularStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); regularStyle.setLeftBorderColor(HSSFColor.BLACK.index); regularStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); regularStyle.setRightBorderColor(HSSFColor.BLACK.index); regularStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); regularStyle.setTopBorderColor(HSSFColor.BLACK.index); regularStyle.setWrapText(true); /** * componentCellStyle Cell Style */ componentCellStyle = myWorkbook.createCellStyle(); // componentCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); componentCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); componentCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); componentCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); componentCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); componentCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); componentCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); componentCellStyle.setRightBorderColor(HSSFColor.BLACK.index); componentCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); componentCellStyle.setTopBorderColor(HSSFColor.BLACK.index); componentCellStyle.setFont(blackFont); componentCellStyle.setWrapText(true); /** * greyCellStyle Cell Style */ greyCellStyle = myWorkbook.createCellStyle(); greyCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); greyCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); greyCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); greyCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); greyCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); greyCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); greyCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); greyCellStyle.setRightBorderColor(HSSFColor.BLACK.index); greyCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); greyCellStyle.setTopBorderColor(HSSFColor.BLACK.index); greyCellStyle.setFont(greyFont); greyCellStyle.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index); greyCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); greyCellStyle.setWrapText(false); /** * LROpenCellStyle Cell Style */ LROpenCellStyle = myWorkbook.createCellStyle(); // LROpenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); LROpenCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); LROpenCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); LROpenCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // LROpenCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // LROpenCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); // LROpenCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // LROpenCellStyle.setRightBorderColor(HSSFColor.BLACK.index); LROpenCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); LROpenCellStyle.setTopBorderColor(HSSFColor.BLACK.index); LROpenCellStyle.setWrapText(true); /** * TLROpenCellStyle Cell Style */ TLROpenCellStyle = myWorkbook.createCellStyle(); // TLROpenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); TLROpenCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); TLROpenCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); TLROpenCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // TLROpenCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // TLROpenCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); // TLROpenCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // TLROpenCellStyle.setRightBorderColor(HSSFColor.BLACK.index); TLROpenCellStyle.setBorderTop(HSSFCellStyle.BORDER_MEDIUM); TLROpenCellStyle.setTopBorderColor(HSSFColor.BLACK.index); TLROpenCellStyle.setWrapText(true); /** * BLROpenCellStyle Cell Style */ BLROpenCellStyle = myWorkbook.createCellStyle(); // LROpenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); BLROpenCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); BLROpenCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); BLROpenCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // BLROpenCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // BLROpenCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); // BLROpenCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // BLROpenCellStyle.setRightBorderColor(HSSFColor.BLACK.index); BLROpenCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); BLROpenCellStyle.setTopBorderColor(HSSFColor.BLACK.index); BLROpenCellStyle.setWrapText(true); /** * leftOpenCellStyle Cell Style */ leftOpenCellStyle = myWorkbook.createCellStyle(); leftOpenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); leftOpenCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); leftOpenCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); leftOpenCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // leftOpenCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // leftOpenCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); leftOpenCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); leftOpenCellStyle.setRightBorderColor(HSSFColor.BLACK.index); leftOpenCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); leftOpenCellStyle.setTopBorderColor(HSSFColor.BLACK.index); leftOpenCellStyle.setWrapText(true); /** * TleftOpenCellStyle Cell Style */ TleftOpenCellStyle = myWorkbook.createCellStyle(); TleftOpenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); TleftOpenCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); TleftOpenCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); TleftOpenCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // TleftOpenCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // TleftOpenCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); TleftOpenCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); TleftOpenCellStyle.setRightBorderColor(HSSFColor.BLACK.index); TleftOpenCellStyle.setBorderTop(HSSFCellStyle.BORDER_MEDIUM); TleftOpenCellStyle.setTopBorderColor(HSSFColor.BLACK.index); TleftOpenCellStyle.setWrapText(true); /** * BLeftOpenCellStyle Cell Style */ BLeftOpenCellStyle = myWorkbook.createCellStyle(); BLeftOpenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); leftOpenCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); BLeftOpenCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); BLeftOpenCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // BLeftOpenCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // BLeftOpenCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); BLeftOpenCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); BLeftOpenCellStyle.setRightBorderColor(HSSFColor.BLACK.index); BLeftOpenCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); BLeftOpenCellStyle.setTopBorderColor(HSSFColor.BLACK.index); BLeftOpenCellStyle.setWrapText(true); /** * leftOpenMediumRightCellStyle Cell Style */ leftOpenMediumRightCellStyle = myWorkbook.createCellStyle(); leftOpenMediumRightCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); leftOpenMediumRightCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); leftOpenMediumRightCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); leftOpenMediumRightCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // leftOpenMediumRightCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // leftOpenMediumRightCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); leftOpenMediumRightCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); leftOpenMediumRightCellStyle.setRightBorderColor(HSSFColor.BLACK.index); leftOpenMediumRightCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); leftOpenMediumRightCellStyle.setTopBorderColor(HSSFColor.BLACK.index); leftOpenMediumRightCellStyle.setWrapText(true); /** * TleftOpenMediumRightCellStyle Cell Style */ TleftOpenMediumRightCellStyle = myWorkbook.createCellStyle(); TleftOpenMediumRightCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); TleftOpenMediumRightCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); TleftOpenMediumRightCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); TleftOpenMediumRightCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // TleftOpenMediumRightCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // TleftOpenMediumRightCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); TleftOpenMediumRightCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); TleftOpenMediumRightCellStyle.setRightBorderColor(HSSFColor.BLACK.index); TleftOpenMediumRightCellStyle.setBorderTop(HSSFCellStyle.BORDER_MEDIUM); TleftOpenMediumRightCellStyle.setTopBorderColor(HSSFColor.BLACK.index); TleftOpenMediumRightCellStyle.setWrapText(true); /** * BLeftOpenMediumRightCellStyle Cell Style */ BLeftOpenMediumRightCellStyle = myWorkbook.createCellStyle(); BLeftOpenMediumRightCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); BLeftOpenMediumRightCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); BLeftOpenMediumRightCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); BLeftOpenMediumRightCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // BLeftOpenMediumRightCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // BLeftOpenMediumRightCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); BLeftOpenMediumRightCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); BLeftOpenMediumRightCellStyle.setRightBorderColor(HSSFColor.BLACK.index); BLeftOpenMediumRightCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); BLeftOpenMediumRightCellStyle.setTopBorderColor(HSSFColor.BLACK.index); BLeftOpenMediumRightCellStyle.setWrapText(true); /** * rightOpenCellStyle Cell Style */ rightOpenCellStyle = myWorkbook.createCellStyle(); // rightOpenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); rightOpenCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); rightOpenCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); rightOpenCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); rightOpenCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); rightOpenCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); // rightOpenCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); // rightOpenCellStyle.setRightBorderColor(HSSFColor.BLACK.index); rightOpenCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); rightOpenCellStyle.setTopBorderColor(HSSFColor.BLACK.index); rightOpenCellStyle.setWrapText(true); /** * TrightOpenCellStyle Cell Style */ TrightOpenCellStyle = myWorkbook.createCellStyle(); // TrightOpenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); TrightOpenCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); TrightOpenCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); TrightOpenCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); TrightOpenCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); TrightOpenCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); // TrightOpenCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); // TrightOpenCellStyle.setRightBorderColor(HSSFColor.BLACK.index); TrightOpenCellStyle.setBorderTop(HSSFCellStyle.BORDER_MEDIUM); TrightOpenCellStyle.setTopBorderColor(HSSFColor.BLACK.index); TrightOpenCellStyle.setWrapText(true); /** * BRightOpenCellStyle Cell Style */ BRightOpenCellStyle = myWorkbook.createCellStyle(); BRightOpenCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); BRightOpenCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); BRightOpenCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); BRightOpenCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); BRightOpenCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); BRightOpenCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); // BRightOpenCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); // BRightOpenCellStyle.setRightBorderColor(HSSFColor.BLACK.index); BRightOpenCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); BRightOpenCellStyle.setTopBorderColor(HSSFColor.BLACK.index); BRightOpenCellStyle.setWrapText(true); /** * dateCellStyle Cell Style */ dateCellStyle = myWorkbook.createCellStyle(); // dateCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); dateCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); dateCellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); dateCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); dateCellStyle.setBorderLeft(HSSFCellStyle.BORDER_MEDIUM); dateCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); // dateCellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); // dateCellStyle.setRightBorderColor(HSSFColor.BLACK.index); dateCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); dateCellStyle.setTopBorderColor(HSSFColor.BLACK.index); dateCellStyle.setFont(blackFont); dateCellStyle.setWrapText(false); /** * exampleCellStyle Cell Style */ exampleCellStyle = myWorkbook.createCellStyle(); exampleCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); exampleCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); exampleCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); exampleCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); exampleCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); exampleCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); exampleCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); exampleCellStyle.setRightBorderColor(HSSFColor.BLACK.index); // exampleCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // exampleCellStyle.setTopBorderColor(HSSFColor.BLACK.index); exampleCellStyle.setFont(exampleFont); exampleCellStyle.setWrapText(true); /** * exb Cell Style */ exbCellStyle = myWorkbook.createCellStyle(); exbCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); exbCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); exbCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); exbCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // exbCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // exbCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); exbCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); exbCellStyle.setRightBorderColor(HSSFColor.BLACK.index); // exampleCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // exampleCellStyle.setTopBorderColor(HSSFColor.BLACK.index); exbCellStyle.setFont(exampleFont); exbCellStyle.setWrapText(false); /** * projectInformationCellStyle Cell Style */ projectInformationCellStyle = myWorkbook.createCellStyle(); // projectInformationCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); // projectInformationCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); projectInformationCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); projectInformationCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // projectInformationCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // projectInformationCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); // projectInformationCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); // projectInformationCellStyle.setRightBorderColor(HSSFColor.BLACK.index); // projectInformationCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // projectInformationCellStyle.setTopBorderColor(HSSFColor.BLACK.index); projectInformationCellStyle.setFont(projectInformationFont); projectInformationCellStyle.setWrapText(false); /** * CHCellStyle Cell Style */ CHCellStyle = myWorkbook.createCellStyle(); // CHCellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); CHCellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // CHCellStyle.setBorderBottom(HSSFCellStyle.BORDER_MEDIUM); // CHCellStyle.setBottomBorderColor(HSSFColor.BLACK.index); // CHCellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); // CHCellStyle.setLeftBorderColor(HSSFColor.BLACK.index); // CHCellStyle.setBorderRight(HSSFCellStyle.BORDER_MEDIUM); // CHCellStyle.setRightBorderColor(HSSFColor.BLACK.index); // CHCellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); // CHCellStyle.setTopBorderColor(HSSFColor.BLACK.index); CHCellStyle.setFont(projectInformationFont); CHCellStyle.setWrapText(false); /** * Set font for style */ regularStyle.setFont(blackFont); } }