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



Home Answers Viewqa Java-Beginners HSSF WORKSHEET FORMATTING

Have Programming Question? Ask it here!
 
 
 


AXIS
HSSF WORKSHEET FORMATTING
1 Answer(s)      4 years and 7 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
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
< 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 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 <
Formatting a Number Using a Custom Format
Formatting a Number Using a Custom Format In this section, you will learn how to format a number using a custom format. A number can be formatted in different ways. Java has designed several classes to format the number. Using
Formatting and Parsing a Time for a Locale Using Default Formats
Formatting and Parsing a Time for a Locale Using Default Formats... formats. There are different classes for formatting and parsing number, message.... It provides four default formatting styles- SHORT, MEDIUM, LONG and FULL
Formatting and Parsing a Date Using Default Formats
Formatting and Parsing a Date Using Default Formats In this section, you... for formatting and parsing dates. These are SHORT, MEDIUM, LONG and FULL. There is one.... This method gets the date formatter with the given formatting style. The format
Java Text Tutorials
and time formatting, number formatting, parsing, iteration over characters... three main groups of classes and interfaces: Iteration over text Formatting... can give any custom date and time formatting, message formatting. You can compare
Mysql Date Format
Mysql Date Format       Mysql Date Format explains you the way of formatting Date...'. To understand this example we show you the following Syntax used for formatting
Examples of POI3.0
can use  HSSF if you needed to read or write an Excel file using... are using the built in format for formatting our data in excel sheet
Java SimpleDateFormat Example
to format the user defined date-time formatting. To format the date
DateInterval::format
DateInterval class in PHP DateInterval::format function is used for formatting the interval. It returns the format interval.  Description on PHP DateInterval Format public string DateInterval::format ( string $format
Built in Data Format in Excel Using POI 3.0
in format for formatting our data in excel sheet.  POI version 3.0 provides... user defined formatting facility and also provides a list of build-in data format
Currency Format Example
. In the code given below we are formatting Currency according to the locale. Methods... : NumberFormat class provides the functionality for formatting and parsing currency
Number Format Example
. In the code given below we are formatting number according to the locale...() : NumberFormat class provides the functionality for formatting and parsing
Get Time Now
Get Time Now       Format is an abstract class that is used for formatting local-sensitive information like  date, number and message. The Format class derived from
APT Editor
document format that uses "formatting hints" to transform a plain text... the document and looks for "formatting hints", such as indentation... write your documentation in text files without thinking much about formatting
ZipCodeFormatter in Flex4
ZipCodeFormatter in Flex4: The ZipCodeFormatter class is used for format a zip code. You can use formatString property for formatting a zip code. There are many format for zip code
The PHP Date() Function
The PHP Date() Function The PHP date() function is used for formatting the date and time. It formats a timestamp (a sequence of characters representing... formatting. For example: <?php echo date("Y/m/d") . "<br />
Eclipse Tidy
Eclipse Tidy         HTML Tidy Eclipse plug-in provides two very useful tasks of HTML Tidy: Formatting and Checking (X)HTML or XML code. It doesn't provide any editor
I18N
are formatting number according to the locale  ... below we are formatting Currency according to the locale.  
Get Time And Date
; dates as year, month, day, hour, minute, and second values and date formatting... millisecond. 2)SimpleDateFormat- is a  formatting concrete class
Convert String into date
Convert String into date In this example we are going to convert String into date. SimpleDateFormat is a concrete class for formatting the dates which is inside package "java.text.* "  which have a date format which
B - Java Glossary
B - Java Glossary       Java bigdecimal When working with financial, business applications, the programmer should know about the BigDecimal class and numeric formatting
 

 

 

DMCA.com