package?com.poi.readServlet;

import?java.io.FileInputStream;
import?java.io.IOException;
import?java.io.PrintWriter;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFDateUtil;
import?org.apache.poi.hssf.usermodel.HSSFRow;
import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.poifs.filesystem.POIFSFileSystem;
public?class?PoiRead?extends?HttpServlet?{

	/**
	?*?The?doGet?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?get.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error?occurred
	?*/
	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		this.doPost（request?response）;
	}

	/**
	?*?The?doPost?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?post.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error?occurred
	?*/
	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

????????response.setContentType（“text/html;charset=gb2312“）;
????????PrintWriter?out?=?response.getWriter（）;
????????String?filePath?=?new?String（request.getParameter（“file“）.getBytes（
????????????????“ISO-8859-1“）?“gb2312“）;
???????//Poi?Read
????????try?{
????????????POIFSFileSystem?fs?=?new?POIFSFileSystem（new?FileInputStream（
????????????????????filePath））;
????????????//?創(chuàng)建工作簿
????????????HSSFWorkbook?workBook?=?new?HSSFWorkbook（fs）;
????????????/**
?????????????*?獲得Excel中工作表個(gè)數(shù)
?????????????*/
????????????out.println（“工作表個(gè)數(shù)?:“+workBook.getNumberOfSheets（）+“
“）;
????????????for?（int?i?=?0;?i?????????????????
????????????????out.println（“?“+i+“?***************工作表名稱：“+workBook.getSheetName（i）+“??************
“）;
????????????????//?創(chuàng)建工作表
????????????????HSSFSheet?sheet?=?workBook.getSheetAt（i）;
????????????????int?rows?=?sheet.getPhysicalNumberOfRows（）;?//?獲得行數(shù)
????????????????if?（rows?>?0）?{
????????????????????sheet.getMargin（HSSFSheet.TopMargin）;
????????????????????for?（int?j?=?1;?j?????????????????????????HSSFRow?row?=?sheet.getRow（j）;
????????????????????????if?（row?!=?null）?{
????????????????????????????int?cells?=?row.getLastCellNum（）;//獲得列數(shù)
?????????????????????????

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1162??2011-07-13?09:12??JSPExcel\.classpath

?????文件????????297??2011-07-13?10:29??JSPExcel\.mymetadata

?????文件???????1751??2011-07-12?16:23??JSPExcel\.project

?????文件????????493??2011-07-12?16:10??JSPExcel\.settings\.jsdtscope

?????文件????????395??2011-07-12?16:10??JSPExcel\.settings\org.eclipse.jdt.core.prefs

?????文件????????462??2011-07-12?16:10??JSPExcel\.settings\org.eclipse.wst.common.component

?????文件????????252??2011-07-12?16:10??JSPExcel\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2011-07-12?16:10??JSPExcel\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-07-12?16:10??JSPExcel\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????8362??2011-07-13?15:08??JSPExcel\src\com\poi\readServlet\PoiRead.java

?????文件???????1266??2011-07-12?17:12??JSPExcel\src\com\shangyu\action\WriteExcel.java

?????文件????????414??2011-07-12?17:12??JSPExcel\WebRoot\download.jsp

?????文件???????1721??2011-07-12?17:15??JSPExcel\WebRoot\download2.jsp

?????文件????????949??2011-07-13?09:18??JSPExcel\WebRoot\index.jsp

?????文件?????????36??2011-07-12?16:10??JSPExcel\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1128??2011-07-13?09:35??JSPExcel\WebRoot\readexcel.jsp

?????文件???????4885??2011-07-13?15:08??JSPExcel\WebRoot\WEB-INF\classes\com\poi\readServlet\PoiRead.class

?????文件???????1911??2011-07-13?09:12??JSPExcel\WebRoot\WEB-INF\classes\com\shangyu\action\WriteExcel.class

?????文件?????725735??2009-10-24?22:11??JSPExcel\WebRoot\WEB-INF\lib\jxl.jar

?????文件????1675036??2010-10-29?20:40??JSPExcel\WebRoot\WEB-INF\lib\poi-3.7-20101029.jar

?????文件?????264108??2010-10-29?20:40??JSPExcel\WebRoot\WEB-INF\lib\poi-examples-3.7-20101029.jar

?????文件?????498259??2010-10-29?20:40??JSPExcel\WebRoot\WEB-INF\lib\poi-ooxml-3.7-20101029.jar

?????文件????3967696??2010-10-29?20:40??JSPExcel\WebRoot\WEB-INF\lib\poi-ooxml-schemas-3.7-20101029.jar

?????文件?????840218??2010-10-29?20:40??JSPExcel\WebRoot\WEB-INF\lib\poi-scratchpad-3.7-20101029.jar

?????文件????????846??2011-07-13?09:33??JSPExcel\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2011-07-13?09:33??JSPExcel\WebRoot\WEB-INF\classes\com\poi\readServlet

?????目錄??????????0??2011-07-13?09:12??JSPExcel\WebRoot\WEB-INF\classes\com\shangyu\action

?????目錄??????????0??2011-07-13?09:15??JSPExcel\WebRoot\WEB-INF\classes\com\poi

?????目錄??????????0??2011-07-13?09:12??JSPExcel\WebRoot\WEB-INF\classes\com\shangyu

?????目錄??????????0??2011-07-13?09:33??JSPExcel\src\com\poi\readServlet

............此處省略17個(gè)文件信息