Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Java-Beginners HSSF WORKSHEET FORMATTING
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


AXIS
HSSF WORKSHEET FORMATTING
1 Answer(s)      4 years and 11 months ago
Posted in : Java Beginners


I am using the following code in my jsp to import thr o/p to excel on the server.




<%
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheet"); %>




<% int i=1; %>


<% try{
HSSFRow row = sheet.createRow((short)i);
row.createCell((short)0).setCellValue("BIN");
row.createCell((short)1).setCellValue("NAME");
row.createCell((short)2).setCellValue("NAME");
row.createCell((short)3).setCellValue("NAME");
row.createCell((short)4).setCellValue("NAME");




FileOutputStream fileOut = new FileOutputStream("c:\\Filename");

wb.write(fileOut);

fileOut.close();
}

catch ( Exception ex ){
} %>


It works fine but I want to change the properties of the cols in excel through my code.

properties:
text should be bold
it should be aligned right.


PLZZZZZZ HELP

Advertisement
View Answers

December 26, 2009 at 2:25 PM


Hi Friend,

Use font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD)method of HSSFFont class to bold the text and cellStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT) method of HSSFCellStyle class.

Try the following code:

<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCellStyle"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFFont"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%
try{
HSSFWorkbook hwb = new HSSFWorkbook();
HSSFSheet sheet = hwb.createSheet("new sheet");
HSSFRow row = sheet.createRow((short) 1);
HSSFCell cell = row.createCell((short) 1);
cell.setCellValue("Hello World");
HSSFFont font = hwb.createFont();
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
HSSFCellStyle cellStyle = hwb.createCellStyle();
cellStyle.setFont(font);
cell.setCellStyle(cellStyle);
cellStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT);
FileOutputStream fileOut = new FileOutputStream
("c:\\fontsExcel.xls");
hwb.write(fileOut);
fileOut.close();
out.println("Your excel file has been generated");
} catch ( Exception ex ) {
}
%>

For more information, visit the following links:

http://www.roseindia.net/jsp/poi/workingWithFonts.shtml
http://www.roseindia.net/jsp/poi/workingAlign.shtml

Thanks



Related Tutorials/Questions & Answers:
HSSF WORKSHEET FORMATTING - Java Beginners
HSSF WORKSHEET FORMATTING  I am using the following code in my jsp to import thr o/p to excel on the server. It works fine but I want to change
Apache HSSF Jar file location
Apache HSSF Jar file location  where can i get jar files for apache hssf
Advertisements
formatting program
formatting program  Hi I needs some help with this program on formating can anyone help?The details of the program are stated below, thanks. This program should be an example of how Java lets you format numbers and strings
formatting tag in HTML
formatting tag in HTML  What are the various text formatting tag in HTML
text formatting tag in HTML
text formatting tag in HTML  What are the various text formatting tag in HTML
Formatting text in HTML
Formatting text in HTML  What are the tags in HTML to format text
< problem in XSL formatting
to generate the output in XML format. but the data is having HTML formatting. So i am... formatting with out any encoding. How can we restict the encoding of < with < and > also behaving as same above. That to the formatting has
Formatting numbers in Velocity Templates?
Formatting numbers in Velocity Templates?  I need to display amount in following formats: 1099 -> 1,099.00 100 -> 100.00 100.251 -> 100.25 10999 -> 10,999.00 1110999 -> 11,10,999.00 Right now I am using
Formatting numbers in Velocity Templates?
Formatting numbers in Velocity Templates?  I need to display amount in following formats: 1099 -> 1,099.00 100 -> 100.00 100.251 -> 100.25 10999 -> 10,999.00 1110999 -> 11,10,999.00 Right now I am using
Using HSSF 3.5 to READ XLS - Java Beginners
Using HSSF 3.5 to READ XLS  I just dont seem to get this working. I have tried the examples here on this homepage but they are out of date for 3.5 since they are built on and older relese i cant get them to work. All i want
Formatting Legend in Chart in Flex4
Formatting Legend in Chart in Flex4: In this section we will discuss the formatting of the Legend in the Chart control. You can change the formatting... property for change the formatting of legend in the chart control. Example
Scanning and Formatting in Java
Scanning and Formatting in Java In this we will discuss about the Java I/O Scanning and Formatting. In the perspective of programming in Java I/O we... provides the two APIs namely scanner and the formatting. The scanner API
Formatting number as per specific locale in java
Formatting number as per specific locale in java  Hi, I am trying to print the number as per locale. I tried below, but it still prints in English locale. public class loctest { public static void main(String[] args
Java sdk/java poi hssf code to creat excel with folder structure,( i,e folders, subfolders and childrens )
Java sdk/java poi hssf code to creat excel with folder structure,( i,e folders... HSSF lines are half done, pls bear with that !! if(topFolders.size() <... hierarchy Note : here all HSSF lines are half done, pls bear
Example program to change Date formatting Symbols
Example program to change Date formatting Symbols... such examples. Now you will learn how we can change the formatting symbols for date. In this example of changing the date formatting symbols we have used
Formatting and Parsing a Time for a Locale
Formatting and Parsing a Time for a Locale In this section, you will learn how... for formatting dates, numbers, messages and other objects. These classes helps.... For formatting and parsing the time, here we have used DateFormat class
Formatting Date for a Locale Example
Formatting Date for a Locale Example       This example shows how to format Date using... use for formatting and parsing dates. It allows for formatting date into text
Formatting a Number in Exponential Notation
Formatting a Number in Exponential Notation In this section, you will learn how to format a number in Exponential Notation. Java has designed several classes for parsing and formatting the numbers like DecimalFormat class. This class
Formatting and Parsing a Number for a Locale
Formatting and Parsing a Number for a Locale In this section, you will learn how to format and parse a number for a Locale. Formatting converts a date, time, number, or message from its internal representation into a string. Parsing
Formatting a Message Containing a Number
Formatting a Message Containing a Number In this section, you will learn how... that contains a number. The class MessageFormat provides advanced message formatting. It allows advanced value formatting, dependency on Locale and precompilation
Formatting and Parsing a Date for a Locale
Formatting and Parsing a Date for a Locale In this section, you will learn how to format and parse a date for a locale. Java has provide the utility to display the dates in different languages. You can also format and parse those dates
Formatting a Message Containing a Time
Formatting a Message Containing a Time In this section, you will learn how to format a message that contains time. You can format the message in different... MessageFormat for advanced message formatting. It is having some advantage over other
Formatting a Message Containing a Date
Formatting a Message Containing a Date In this section, you will learn how to format the message containing a date. Java has also provide a way to format the message either it contains date, time or number. The class MessageFormat
Formatting and Parsing a Locale-Specific Percentage
Formatting and Parsing a Locale-Specific Percentage In this section, you... characters, we can perform formatting and parsing. Through the use of classes, we can.... This class helps in formatting and parsing numbers for any locale. You can
Formatting and Parsing Locale-Specific Currency
Formatting and Parsing Locale-Specific Currency In this section, you will learn how to format and parse the locale specific currency. Through the formatting, you can translate the binary data into user-readable textual representation
Formatting the Time Using a Custom Format
Formatting the Time Using a Custom Format In this section, you will learn how to format the time using a custom format. Formatting and parsing is now become a simple task. We have so many classes to format different objects like data
Formatting a Date Using a Custom Format
Formatting a Date Using a Custom Format In this section, you will learn how to format a date using a custom format. Java has provide many classes that allow... class which is responsible for formatting date and time. It uses unquoted letters
Formatting the out put in NSLog function
You can easily format the values of int, float, double and long while using the NSLog function. Here is the example of formatting int, float, double and long values. // //  PrintFormat.h //  DataTypes // // #import <
 

 

 

DMCA.com