javax.servlet.ServletException错误... [更新] [英] javax.servlet.ServletException error ... [updated]

问题描述

Hiii ...以上代码用于读取Excel文件。但不知道为什么会收到错误



javax.servlet.ServletException：java.lang.NoClassDefFoundError：org / apache / poi / xs



sf / usermodel / XSSFWorkbook。我已经附上了poi jar文件dom4j1.6.1.jar，poi-



scratchpad3.9- 20121203.jar，poi-ooxml-schemas-3.9-20121203.jar，poi-ooxml-3.9-20121203.jar，poi-



3.9-20121203.jar， commons-logging-1.1.jar

Hiii... The above code is for read an Excel file. But dont know why getting an error "

javax.servlet.ServletException: java.lang.NoClassDefFoundError: org/apache/poi/xs

sf/usermodel/XSSFWorkbook. I have already attached poi jar files dom4j1.6.1.jar,poi-

scratchpad3.9-20121203.jar,poi-ooxml-schemas-3.9-20121203.jar,poi-ooxml-3.9-20121203.jar,poi-

3.9-20121203.jar,commons-logging-1.1.jar

package com.read;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

import java.util.Iterator;
import java.util.ArrayList;
import javax.naming.spi.ObjectFactory;


import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;


import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.*;

@SuppressWarnings("serial")
public class Newjava implements java.io.Serializable{
	
	@SuppressWarnings("deprecation")
	public ObjectFactory createFactory(String file)
	 {
		System.out.println("file - " +file);
		ArrayList<newjava> arr=new ArrayList<newjava>();
		try{
			
			//FileInputStream file1=new FileInputStream("//home//suvi//ATMInformation.xlsx");
			
		
			XSSFWorkbook workbook=new XSSFWorkbook(file);
			
			XSSFSheet sheet=workbook.getSheetAt(0);
			
			Iterator<row> rowIterator=sheet.iterator();
			
			
			while(rowIterator.hasNext())
			{
		    Row row=rowIterator.next();
		    
			Iterator<cell> cellIterator=row.cellIterator();
			
			
			System.out.println("\n Row Number: "+row.getRowNum());
			
			
			while(cellIterator.hasNext())
			{
				Cell cell=cellIterator.next();
			
				switch(cell.getCellType())
				{
				 case Cell.CELL_TYPE_NUMERIC:
					 
					
					 System.out.print(cell.getNumericCellValue() +"\t");
					break;
					
					
				 case Cell.CELL_TYPE_STRING:
					 
					 System.out.print(cell.getStringCellValue() +"\t");break;
					 
				}
			}
			System.out.print(" ");
			}
			
			FileOutputStream out=new FileOutputStream("//home//suvi//ATMInformation.xlsx");
			workbook.write(out);
			out.close();

		}
		catch(FileNotFoundException e)
		{
			e.printStackTrace();
		}
		catch(IOException e)
		{
			e.printStackTrace();
		}
		return null;
	 }	

	
		/*public static void main(String[] args) {
		// TODO Auto-generated method stub
		Newjava obj=new Newjava();
	}*/

}

请帮助。

please help.

推荐答案

我只是通过在WEB-INF - > lib文件夹中添加所有jar文件来解决问题。





希望这会有所帮助。

I have simply solve the issue just by adding all the jar files in WEB-INF-->lib folder.


hope this will help.

这篇关于javax.servlet.ServletException错误... [更新]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！