APACHE POI

[Hussain Mohd]

hi

i am trying to read data from excel file using poi
but while reading a string value i used getStringCellValue() but this is depricated and in return i used HSSFRichTextString but iam facing an exception like no such methid error.

it was prompting as

org.apache.poi.hssf.usermodel.HSSFRichTextString
Note: This element neither has attached source nor attached Javadoc and hence no Javadoc could be found.

can anybody help me resolve this problem asap
[ April 12, 2008: Message edited by: Hussain Mohd ]

[Ulf Dittmer]

Welcome to JavaRanch.

It sounds as if there may be multiple versions of the POI jar file around - a newer one that is used for compiling, and an older one that is used at runtime. Make sure you're using the same (new) jar file everywhere.

[Prashant Langade]

Hi

I am facing a strange issue in center alignment of text using poi in my project.

I am unable to set the text in center align mode. here is my code.
The code for setting text in center align mode is

 cellStyle.setAlignment(cellFormat.getAlignFormat().
								getHorizontalAlignment().getValue());
   

  Sheet sheet = getSheet(activeSheetIndex);
		
		Font font = sheet.getSheet().getWorkbook().createFont();
		
		CellStyle cellStyle = sheet.getSheet().getWorkbook().
		createCellStyle();
		
		for (int rowIndex = rowIndex1; rowIndex <= rowIndex2; rowIndex++) {
			
			Row row = sheet.getNotNullRow(rowIndex);
			
			for (int columnIndex = columnIndex1; columnIndex <= columnIndex2; 
			columnIndex++) {
				
				if (row != null) {
					
					Cell cell = POIUtil.getNotNullCell(row, columnIndex);
					
					
					// Setting font format object's properties(i.e bold)
					if(cellFormat.getFontFormat().isBold()) {
						font.setBoldweight(Font.BOLDWEIGHT_BOLD);
					} else {
						font.setBoldweight(Font.BOLDWEIGHT_NORMAL);
					}
					
					font.setItalic(cellFormat.getFontFormat().isItalic());
					
					/*
					 * Setting align format object's properties 
					 * (i.e horizontal alignment)
					 */
					if (cellFormat.getAlignFormat().getHorizontalAlignment()
							!= null) {
						
						System.out.println("Before "+cellStyle.getAlignment());
						cellStyle.setAlignment(cellFormat.getAlignFormat().
								getHorizontalAlignment().getValue());
						System.out.println("After "+cellStyle.getAlignment());
					}
					
					/*
					 * Setting border format object's properties(i.e style 
					 * on the border)
					 */
					if (cellFormat.getBorderFormat().geteStyle() != null) {
						cellStyle.setBorderBottom(cellFormat.
								getBorderFormat().geteStyle().getValue());
					}
									
					/*
					 * Setting number format object's properties 
					 * (i.e custom format set on the border)
					 */
					if (cellFormat.getNumberFormat().isCustomFormat()) {
						
						new HSSFDataFormatter().formatRawCellContents(
							cell.getNumericCellValue(), 0, 
								cellFormat.getNumberFormat().getCustomFormat());
					}
					
					/*
					 * Setting cell format object's properties(i.e vertical 
					 * alignment to be set on the cell)
					 */
					cellStyle.setVerticalAlignment(
							cellFormat.getVerticalAlignment());
					
					cellStyle.setFont(font);
					
					cell.setCellStyle(cellStyle);
					System.out.println("After Last "+cell.getCellStyle().getAlignment());
				}
			}
		}  

Can any one help me?

[Jaikiran Pai]

Prashant Langade wrote:Hi

I am facing a strange issue in center alignment of text using poi in my project.

Prashant, please create a separate topic in the "Other Open Source Projects" forum, since your question doesn't relate to Tomcat.

[haripriya kaligotla]

Hi,
We are tryiing to write 60k rows and 100 cols to an excel sheet but getting the below exception:

"Exception in thread "main" java.lang.OutOfMemoryError: Java heap space"

Any help to get rid of this would be appreciated. Thanks.

[Jaikiran Pai]

haripriya,

Welcome to JavaRanch.

Please create a separate topic with the relevant details, to discuss your issue.