poi 文件无法找到

2009-07-03 11:42:22 277 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Buhuishangdang 墨衍会员 · AI 创作全网分发关注 + 加入社区

POI读取Word文件之后，文件一直被占用，无法删除 POI读取Word文件之后，文件一直被占用，无法删除使用poi读取word文件之后，文件就无法删除，一直正在使用在操作完word文件之后也关闭了流，并在操作完成之后删除源文件，代码看着好像是没有问题 FileOutputStream out = null; File tmpFile = null; try { String tmpFilePath = "tmp.docx"; tmpFile = new File(tmpFilePath); XWPFDocument doc = new 阅读详情

最近做一项目，客户要求一上传excel功能，在网上找了一些资料，有了大概的做法.....

我用的struts做的上传，由于数据可能比较大，所以是先把excel压缩成zip进行上传，上传后再进行解压，解析excel的信息，然后插入库。下面是一些代码







                  ZipInputStream in = null;

		List errors=null;

		// FileInputStream(path+fileName));

		try {

			in = new ZipInputStream(new FileInputStream(path + "\\" + fileName));

			ZipEntry entry = new ZipEntry(path + "\\" + fileName);

			while ((entry = in.getNextEntry()) != null) {

				String entryName = entry.getName();

				if (entry.isDirectory()) {

					File file1 = new File(path + "\\" + entryName);

					file1.mkdirs();

					// System.out.println("创建文件夹" + entryName);

				} else {

					System.out.println(path + "\\" + entryName);

						POIFSFileSystem poi = new POIFSFileSystem(new          FileInputStream(path+"\\"+fileName));			HSSFWorkbook book = new HSSFWorkbook(poi);                    

				}

			}



		} catch (FileNotFoundException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (IOException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} finally {

			try {

				in.closeEntry();

			} catch (IOException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

		}

文件已经上传成功，而且接压缩也没有问题，路径是对的，可是在去取excel的时候出错了:





D:\work\projects\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\JS\tmp\ko.zip

D:\work\projects\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\JS\tmp\test.xls

java.io.FileNotFoundException: D:\work\projects\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\JS\tmp\test.xls (系统找不到指定的文件。)

	at java.io.FileInputStream.open(Native Method)

	at java.io.FileInputStream.<init>(Unknown Source)

	at java.io.FileInputStream.<init>(Unknown Source)

	at ie.js.tyxxc.service.impl.TyxxcSiteDenizenServiceImpl.isQualified(TyxxcSiteDenizenServiceImpl.java:116)

	at ie.js.tyxxc.service.impl.TyxxcSiteDenizenServiceImpl.upload(TyxxcSiteDenizenServiceImpl.java:81)

	at ie.js.tyxxc.service.impl.TyxxcSiteDenizenServiceImpl$$FastClassByCGLIB$$c398d221.invoke(<generated>)

	at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

	at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:696)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:631)

	at ie.js.tyxxc.service.impl.TyxxcSiteDenizenServiceImpl$$EnhancerByCGLIB$$4df71e08.upload(<generated>)

	at ie.js.tyxxc.action.TyxxcSiteDenizenAction.parse(TyxxcSiteDenizenAction.java:259)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)