Summary: | XSSFCellStyle.BORDER_xxx not working | ||
---|---|---|---|
Product: | POI | Reporter: | si3012 <si3012> |
Component: | XSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | si3012 |
Priority: | P2 | Keywords: | APIBug |
Version: | 3.17-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Attachments: | the code in Netbeans |
The tutorial author should have taken the time to check the code is effectively compiling. This leaves serious doubts about the quality of the rest of the tutorial... The following line style.setBorderBottom(XSSFCellStyle.BORDER_THIN); should have been style.setBorderBottom(CellStyle.BORDER_THIN); *** This bug has been marked as a duplicate of bug 61898 *** This was fixed in the Spreadsheet Quick Guide 8 weeks ago (13 Dec 2017) [1] and published 6 weeks ago (28 Dec 2017) [2] [1] https://svn.apache.org/viewvc?view=revision&revision=1818054 [2] https://svn.apache.org/viewvc?view=revision&revision=1819416 |
Created attachment 35714 [details] the code in Netbeans HI, I am new in Java and I am using POI for the first time I get Problem with XSSFCellStyle.BORDER_XXX wich give me in The editor (Netbeans) cannot found the Symbol please check the Attachement for more details. PS : I am usisng tutorial from Busy' Developer's Guide to HSSF and XSSF Features ////////////////the Code///////////////////////// package ExcelTo; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.sl.usermodel.Sheet; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.CellStyle; import static org.apache.poi.ss.usermodel.FillPatternType.BIG_SPOTS; import static org.apache.poi.ss.usermodel.FillPatternType.SOLID_FOREGROUND; import org.apache.poi.ss.usermodel.IndexedColors; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.util.WorkbookUtil; import org.apache.poi.ss.usermodel.CreationHelper; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.xssf.usermodel.XSSFCellStyle; import org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder; /** * * @author Jabida */ public class Depart { public static void main(String[] args) throws FileNotFoundException, IOException{ Workbook wb = new XSSFWorkbook(); org.apache.poi.ss.usermodel.Sheet sheet = wb.createSheet("Depart congé"); // Create a row and put some cells in it. Rows are 0 based. Row row = sheet.createRow(1); // Create a cell and put a value in it. Cell cell = row.createCell(1); cell.setCellValue(4); // Style the cell with borders all around. CellStyle style = wb.createCellStyle(); style.setBorderBottom(XSSFCellStyle.BORDER_THIN); style.setBottomBorderColor(IndexedColors.BLACK.getIndex()); style.setBorderLeft(CellStyle.BORDER_THIN); style.setLeftBorderColor(IndexedColors.GREEN.getIndex()); style.setBorderRight(CellStyle.BORDER_THIN); style.setRightBorderColor(IndexedColors.BLUE.getIndex()); style.setBorderTop(CellStyle.BORDER_MEDIUM_DASHED); style.setTopBorderColor(IndexedColors.BLACK.getIndex()); cell.setCellStyle(style); try ( // Write the output to a file FileOutputStream fileOut = new FileOutputStream("workbook.xlsx")) { wb.write(fileOut); fileOut.close(); } } }