Hi, I have been using the apache.poi.hssf package for my project. I have made an excel sheet using HSSFSheet class in org.apache.poi.hssf.usermodel package. This class has 2 member functions for setting properties of gridlines on the sheet. void setGridsPrinted(boolean value) void setPrintGridlines(boolean newPrintGridlines) I tried to hide the gridlines using both these functions but they are not working. Where am i going wrong? The exact code is given below. import org.apache.poi.poifs.filesystem.POIFSFileSystem; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.hssf.util.*; static HSSFWorkbook wb; static HSSFSheet sheet; static HSSFRow sheet_row; ..... { .... FileReader fr= new FileReader("Daily1.txt"); BufferedReader br = new BufferedReader(fr); String sheetName="Daily"; String fileName ="out.xls"; FileOutputStream fileOut = new FileOutputStream(fileName); wb = new HSSFWorkbook(); sheet = wb.createSheet(sheetName); sheet.setGridsPrinted(false); sheet.setPrintGridlines(false); .... .... wb.write(fileOut); fileOut.close(); fr.close(); Kindly help me find the problem.
Ask questions on the mail list, post bugs in bugzilla.
*** Bug 21872 has been marked as a duplicate of this bug. ***