java打印Excel

首先先下载jcom.jar和jcom.dll文件，把dll文件放在jdk的bin目录下，然后把jar引入到classpath中，就可以了，程序如下所示：package com.gyhq.soft;
/**
* 引入JCom操作Excel的jar
*/
import jp.ne.so_net.ga2.no_ji.jcom.ReleaseManager;  
import jp.ne.so_net.ga2.no_ji.jcom.excel8.ExcelApplication;  
import jp.ne.so_net.ga2.no_ji.jcom.excel8.ExcelWorkbook;  
import jp.ne.so_net.ga2.no_ji.jcom.excel8.ExcelWorkbooks;  
import jp.ne.so_net.ga2.no_ji.jcom.excel8.ExcelWorksheet;  
/**
* 打印Excel类
* @author tianmaochun
*
*/
public class PrintExcel {
/**
* 实现打印Excel的方法
* @param fileName[文件路径]
* @return[返回是否打印成功]
*/
public boolean printExcel(String fileName){  
        //查找JOM能够操作的组件
ReleaseManager rm = new ReleaseManager();  
        try{
        //创建可加载的组件
        ExcelApplication excel = new ExcelApplication(rm);  
             //创建工作薄对象
        ExcelWorkbooks xlBooks = excel.Workbooks();
        //打开工作薄
             ExcelWorkbook xlBook = xlBooks.Open(fileName);
             //打印
             ExcelWorksheet xlSheet = excel.ActiveSheet();  
             if(xlSheet!=null){
            //出现正在打印对话框
                 xlSheet.PrintOut();
                 //退出
                 excel.Quit();
             }    
        }catch(Exception e){
        e.printStackTrace();  
            return false;     
        }finally{ 
        //关闭
            rm.release();  
        }  
        return true;  
}  
public static void main(String[] args){  
//实例化打印excel类
PrintExcel prEcl = new PrintExcel();  
    try{  
       //调用打印Excel方法，并进来一个xls文件
    prEcl.printExcel("f:/tian.xls");
      
    }catch(Exception e){
    //捕获异常处理
    e.printStackTrace();      
    }  
   }  
}

评论

1 楼 34176470 2014-03-26  

Exception in thread "main" java.lang.UnsatisfiedLinkError: D:\Java_JDK\jdk1.7.0_51\bin\jcom.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary1(ClassLoader.java:1965)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1890)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1880)
at java.lang.Runtime.loadLibrary0(Runtime.java:849)
at java.lang.System.loadLibrary(System.java:1088)
at jp.ne.so_net.ga2.no_ji.jcom.IDispatch.<clinit>(IDispatch.java:287)
at PrintExcel.printExcel(PrintExcel.java:24)
at PrintExcel.main(PrintExcel.java:52)