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.