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 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. 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.
Regards,
Arshi
g GE Industrial Systems
________________________________________
Arshi Singh
Graduate Engineer Tr, GE-IBC
GE Industrial Systems
Center Point, HUDA Lane
Begumpet, Secunderabad 500 003
email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Tel: 91-40-27881480 (D), 1800
"THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE
ADDRESSEE and may contain confidential and privileged information.
If the reader of this message is not the intended recipient,
you are notified that any dissemination, distribution or copy of this
communication is strictly Prohibited.
If you have received this message by error, please notify us
immediately, return the original mail to the sender and delete the
message from your system."
