求JAVA EXCEL API将查询结果导出到EXCEL文件的完整例子

Question

这是个写excel的例子
import java.io.*;
import jxl.*;
import jxl.format.*;
import jxl.write.*;/**
 * <p>Title: 个人工具包</p>
 * <p>Description: 示例代码, 向Excel文件中写入工作表</p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: Tiger, Ltd.</p>
 * @author Tim
 * @version 1.0
 */class ExcelWriting
{
    public static void main(String[] args)
    {
        if(!(args.length == 1))
        {
            System.out.println("Usage: java ExcelWriting targetfile");
            System.exit(0);
        }
        String targetfile = args[0];
        try
        {
            //创建可写入的Excel工作薄
            jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(targetfile));            //将Excel工作薄对象写入到输出流
            /*
            OutputStream os = new FileOutputStream(targetfile);
            jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
            */            //创建Excel工作表
            jxl.write.WritableSheet ws = wwb.createSheet("Test Sheet 1", 0);            //向Excel工作表添加内容            //1.添加Label对象
            jxl.write.Label labelC = new jxl.write.Label(0, 0, "This is a Label cell");
            ws.addCell(labelC);            //添加带有字型Formatting的对象
            jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES, 18, WritableFont.BOLD, true);
            jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
            jxl.write.Label labelCF = new jxl.write.Label(1, 0, "This is a Label Cell", wcfF);
            ws.addCell(labelCF);            //添加带有字体颜色Formatting的对象
            jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED);
            jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
            jxl.write.Label labelCFC = new jxl.write.Label(1, 0, "This is a Label Cell", wcfFC);
            ws.addCell(labelCF);            //2.添加Number对象
            jxl.write.Number labelN = new jxl.write.Number(0, 1, 3.1415926);
            ws.addCell(labelN);            //添加带有formatting的Number对象
            jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##");
            jxl.write.WritableCellFormat wcfN = new jxl.write.WritableCellFormat(nf);
            jxl.write.Number labelNF = new jxl.write.Number(1, 1, 3.1415926, wcfN);
            ws.addCell(labelNF);            //3.添加Boolean对象
            jxl.write.Boolean labelB = new jxl.write.Boolean(0, 2, false);
            ws.addCell(labelB);            //4.添加DateTime对象
            jxl.write.DateTime labelDT = new jxl.write.DateTime(0, 3, new java.util.Date());
            ws.addCell(labelDT);            //添加带有formatting的DateFormat对象
            jxl.write.DateFormat df = new jxl.write.DateFormat("dd MM yyyy hh:mm:ss");
            jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df);
            jxl.write.DateTime labelDTF = new jxl.write.DateTime(1, 3, new java.util.Date(), wcfDF);
            ws.addCell(labelDTF);
            //写入Exel工作表
            wwb.write();            //关闭Excel工作薄对象
            wwb.close();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}

Answer 1

读的
/**
 * <p>标题:
 * <font class=titlefont>
 * <p>读EXCEL文件类
 * </font>
 * <p>描述:
 * </font>
 * @author
 * @version 
 **/
package ces.com.excel;import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import java.util.Vector;
import java.lang.Double;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.File;
import java.util.Hashtable;
public class ReadExcel {
    /**
     *
     * @param strPass  文件路径
     * @return  Hashtable Excel数据
     * @throws IOException
     */
    public  Hashtable read(String strPass)
            throws IOException
    {   File file=new File(strPass);
    int j=0;
    int m=0;
    Hashtable hashTable=new Hashtable();
    POIFSFileSystem fs      =
            new POIFSFileSystem(new FileInputStream(file));
    HSSFWorkbook wb = new HSSFWorkbook(fs);
    for( m=0;m<wb.getNumberOfSheets();m++){    HSSFSheet sheet = wb.getSheetAt(m);//考虑多个工作表（sheet）的情况；返回一个Hashtable;
    Vector vct=new Vector();
    for( j=0;j<=sheet.getLastRowNum();j++){
        String[] element=null;
        HSSFRow row = sheet.getRow(j);        if(row!=null) {
            element=new String[row.getLastCellNum()];
            for(short i=0;i<row.getLastCellNum();i++){
                if(row.getCell(i)!=null){
                    switch(row.getCell(i).getCellType()) {
                case 0 :element[i]=(new Double(row.getCell(i).getNumericCellValue())).toString();
                    break;
                case 1 : element[i]=row.getCell(i).getStringCellValue();
                    break;
                case 2 : element[i]=row.getCell(i).getStringCellValue();
                    break;
                case 3 :break;
                default: System.out.println("ke neng you cuo le ");
            }
            }else {element[i]="null";}            }
            vct.add(element);        }    }
     hashTable.put(new Integer(m),vct);
    }    return hashTable;    }    public static void main(String[] args) {
         Hashtable hash=new Hashtable();
        ReadExcel read=new ReadExcel();
        try{
            hash=read.read("e:\\workbook.xls");
            }catch(Exception e){System.out.println("异常了啊");}
            for(int i=0;i<hash.size();i++){
                String[] temp=(String[])(((Vector)hash.get(new Integer(0))).get(0));
                System.out.println(temp[i]);
//System.out.println((Vector)hash.get(new Integer(0)));
            }    }
}

Answer 2

这个例子是从网上找到的.你看看这个例子,就知道怎么写excel,至于查询记录也是一样的写法,我以前就参照这个例子做过这个东西,不过是jsp的,把我的那个文件发到你邮箱里了,