在java中使用jxl操作excel
来源:互联网 发布:蛋鸡存栏量数据 编辑:程序博客网 时间:2024/05/22 00:55
jxl是一个韩国人写的Java操作excel的工具, 在java的开源世界中,有两套比较有影响的API可供使用,一个是POI,一个是jExcelAPI(即jxl)。jxl功能相对POI比较弱一点。
但jExcelAPI对中文支持非常好,API是纯Java的, 不依赖Windows系统,即使运行在Linux下,也同样能够正确的处理Excel文件。 需要补充说明的是,jxl对图形和图表的支持很有限,而且 仅仅识别PNG格式的图片。
下面就是我对jxl一些常见操作进行介绍,比如读取excel,新建excel合并单元格等待操作。
并根据网络上搜集到的资料对jxl和POI进行一次简单的比较。
1、下载类库包jxl.jar
2、名词解释
3、使用jxl读取excel文件
4、向excel文件中写内容
5、合并单元格
POI和jxl的比较
POI不支持写入图片(jxl支持,但是只支持png格式的图片)
POI对公式的支持比较好,jxl对公式的支持不如POI。所以财务软件用POI较好
多少数据量时出现内存溢出:
使用POI:运行到2800条左右就报内存溢出,使用jxl到3000条左右报内存溢出
读取excel速率:POI优于jxl
插入数据速率:jxl优于POI
JSP使用commons-fileupload实现文件上传
1、准备:
将commons-fileupload-1.1.zip和commons-io-1.1.zip复制到"\WEB-INF\lib"目录下
2、首先是Servlet:FileUpload.java
package servlet;import java.io.File;import java.io.IOException;import java.io.PrintWriter;import java.util.*;import java.util.regex.Pattern;import java.util.regex.Matcher;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.apache.commons.fileupload.FileItem;import org.apache.commons.fileupload.FileUploadException;import org.apache.commons.fileupload.disk.DiskFileItemFactory;import org.apache.commons.fileupload.servlet.ServletFileUpload;public class FileUpload extends HttpServlet {private String uploadPath="E:\\addnetFile\\";//要上传文件的目录private File tempPath=new File("E:\\tempFile\\");//存放上传的文件的目录public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setContentType("text/html;charset=GB2312");response.setCharacterEncoding("gb2312");PrintWriter out=response.getWriter();out.println("请求内容的长度为:"+request.getContentLength());out.println("请求内容的类型为:"+request.getContentType());DiskFileItemFactory factory=new DiskFileItemFactory();factory.setRepository(tempPath);factory.setSizeThreshold(4096);ServletFileUpload upload=new ServletFileUpload(factory);upload.setSizeMax(1000000);List<?> fileitems=null;try{fileitems=upload.parseRequest(request);Iterator<?> iterator=fileitems.iterator();String regex=".+\\\\(.+)$";String[] errortype={".exe",".com",".cgi",".asp"};Pattern p=Pattern.compile(regex);while(iterator.hasNext()){FileItem item=(FileItem) iterator.next();if(!item.isFormField()){String name=item.getName();long size=item.getSize();if(name==null||name.equals("")&&size==0)continue;Matcher m=p.matcher(name);if(m.find()){for(int temp=0;temp<errortype.length;temp++){if(m.group(1).endsWith(errortype[temp]))throw new IOException(name+":wrong type");}try{item.write(new File(tempPath,m.group(1)));out.println(name+" "+size+"<br/>");out.println("上传成功");}catch(Exception e){out.println("333"+e);}}else{throw new IOException("fail to upload");}}}}catch(IOException e){out.println("222"+e);}catch(FileUploadException e1){e1.printStackTrace();out.println("111"+e1);}}public void init() throws ServletException {if(!new File(uploadPath).isDirectory())new File(uploadPath).mkdir();if(!tempPath.isDirectory())tempPath.mkdir();}public void destroy(){super.destroy();}}
3、其次是html:Uploadfile.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <title>Uploadfilel.html</title> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="this is my page"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <!--<link rel="stylesheet" type="text/css" href="./styles.css">--> </head> <body> <form action="/Firstjsp/servlet/FileUpload" method="post" enctype="multipart/form-data" name="form1"> <input type="file" name="file"/> <input type="submit" name="submit" value="upload"/> </form> <form action="/Firstjsp/servlet/FileUpload" method="post" enctype="multipart/form-data" name="uploadform"> <table> <tr> <td> 文件1:<input type="file" name="X" size="40"/> </td> </tr> <tr> <td> 文件2:<input type="file" name="Y" size="40"/> </td> </tr> <tr> <td> 文件3:<input type="file" name="Z" size="40"/> </td> </tr> </table> <input type="submit" name="upload" value="开始上传"/> </form> </body></html>
4、最后是配置web.xml
<servlet> <description>This is the description of my J2EE component</description> <display-name>This is the display name of my J2EE component</display-name> <servlet-name>FileUpload</servlet-name> <servlet-class>servlet.FileUpload</servlet-class> </servlet><servlet-mapping> <servlet-name>FileUpload</servlet-name> <url-pattern>/servlet/FileUpload</url-pattern>
首先运行html,servlet处理上传请求
网上相关的例子比较多,这里只给出最简单的一个,使用commons-fileupload组件完成上传。首先你需要下载组件,按说从官网上下载文件应该就可以了,不过貌似最新的这个少了一个jar包,所以我往网盘里传了一份,大家自行下载:http://u.115.com/file/f4694e2ffc http://u.115.com/file/f4e87888d0 ,把这俩文件放到工程WEN-INF的lib目录下。
首先建立一个Servlet:UploadServlet.java:
package com.web;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.commons.fileupload.*;import java.util.*;import java.io.*;import org.apache.commons.fileupload.servlet.*;import org.apache.commons.fileupload.disk.DiskFileItemFactory;/** * 上传文件的Servlet * @author 胡阳 * */public class UploadServlet extends HttpServlet { public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { System.out.println("dddd"); res.setContentType("text/html; charset=GB18030"); PrintWriter out = res.getWriter(); System.out.println(req.getContentLength()); System.out.println(req.getContentType()); DiskFileItemFactory factory = new DiskFileItemFactory(); // 允许设置内存中存储数据的门限,单位:字节 factory.setSizeThreshold(4096); // 如果文件大小大于SizeThreshold,则保存到临时目录 factory.setRepository(new File("D:\\")); ServletFileUpload upload = new ServletFileUpload(factory); // 最大上传文件,单位:字节 upload.setSizeMax(1000000); try { List fileItems = upload.parseRequest(req); Iterator iter = fileItems.iterator(); if (iter.hasNext()) { FileItem item = (FileItem) iter.next(); String fileName = item.getName(); // 忽略其他不是文件域的所有表单信息 if (!item.isFormField()) { try { //取得文件名 fileName = fileName.substring(fileName.lastIndexOf("\\") + 1, fileName.length()); // 保存上传的文件到指定的目录指定文件名中 item.write(new File("D:\\",fileName)); } catch (Exception e) { out.println(e); } } else { throw new IOException("fail to upload"); } } } catch (FileUploadException e) { out.println(e); } }}
然后是web.xml文件:
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:javaee="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <servlet> <servlet-name>UploadServlet</servlet-name> <servlet-class>com.web.UploadServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>UploadServlet</servlet-name> <url-pattern>/servlet/UploadServlet</url-pattern> </servlet-mapping></web-app>
上传文件的页面:upload.jsp
<%@ page language="java" contentType="text/html; charset=GB18030" pageEncoding="GB18030"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=GB18030"><title>Insert title here</title></head><body>//注意action地址,还有enctype要写成multipart/form-data,和method="POST"<form name="uploadform" method="POST" action="./servlet/UploadServlet" ENCTYPE="multipart/form-data"> <table border="1" width="450" cellpadding="4" cellspacing="2" bordercolor="#9BD7FF"> <tr> <td width="100%" colspan="2"> 文件:<input name="x" size="40" type="file"> </td> </tr> </table> <br/><br/> <table> <tr><td align="center"><input name="upload" type="submit" value="开始上传"/></td></tr> </table></form></body></html>
更多内容可以参考这里:http://www.blogjava.net/freeman1984/archive/2007/09/28/149358.html
- 在java中使用jxl操作excel
- 在java中使用jxl操作excel
- 在java中使用jxl操作excel
- JAVA中使用JXL操作EXCEL
- Java使用jxl操作Excel
- java 使用jxl 操作Excel
- 使用java操作Excel入门 ---- jxl介绍
- (转)java 使用jxl 操作excel
- Java使用jxl操作Excel文件
- Java使用jxl.jar操作Excel
- 使用jxl操作Excel
- java Jxl 操作Excel
- java操作excel jxl
- java jxl excel操作
- 【Java】JXL 操作 Excel
- java操作excel---jxl
- java操作excel-jxl
- jxl--java操作excel
- poj 3190 Stall Reservations (贪心+优先队列)
- 好记性不如烂笔头
- 输出位数的填充C++
- Heaters
- HDOJ--2032 杨辉三角问题(水题)
- 在java中使用jxl操作excel
- Codeforces 801C Voltage Keepsake
- Problem F: 二进制类(1)__运算符重载 hzauoj
- 设计一个只能在堆上或栈上的类
- uva12545比特变换器
- Visual Studio 2010 使用
- 编译安装PHP,解决问题 Don't know how to define struct flock on this system, set --enable-opcache=no
- 对大数(BigInteger)进行开方运算
- C#之Switch分支语句