DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21884>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21884 Functions to hide gridlines of excel sheet using HSSF package not working Summary: Functions to hide gridlines of excel sheet using HSSF package not working Product: POI Version: unspecified Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Major Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I have been using the apache.poi.hssf package for my project, version 1.10.0. I have made an excel sheet using HSSFSheet class in org.apache.poi.hssf.usermodel package. This class has the following 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. On the printout there are no gridlines but on the excel sheet that i view on my PC i still see them in the background. Where am i going wrong? The code is given below. import org.apache.poi.poifs.filesystem.POIFSFileSystem; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.hssf.util.*; HSSFWorkbook wb; HSSFSheet sheet; HSSFRow sheet_row; ..... { .... FileReader fr= new FileReader("abc.txt"); BufferedReader br = new BufferedReader(fr); String sheetName="abc"; String fileName ="xyz.xls"; FileOutputStream fileOut = new FileOutputStream(fileName); wb = new HSSFWorkbook(); sheet = wb.createSheet(sheetName); /* Problem area */ sheet.setGridsPrinted(false); sheet.setPrintGridlines(false); .... .... wb.write(fileOut); fileOut.close(); fr.close(); } --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
