JXLL - Excel Addins 的 Java 接口


CPL
Windows
Java

软件简介

JXLL 提供了一个 Java 的接口用来跟 Excel Addins (XLLs) 交互,可以直接执行 Addins 中提供的函数。

示例代码:

import org.boris.jxll.Addin;  
import org.boris.jxll.XLL;  
import org.boris.jxll.XLOper;

public class JXLLExample  
{  
    public static void main(String[] args) throws Exception {  
        System.out.println("Loading TestXLL.dll...");

        // Load the XLL and check the  result  
        Addin a = XLL.load("TestXLL.dll");  
        if (a == null) {  
            System.out.println("Failed to load addin");  
            return;  
        }

        // Create some random arguments  
        double a1 = Math.round(Math.random() * 60000) / 100.;  
        double a2 = Math.round(Math.random() * 4000) / 100.;  
        System.out.println("Invoking TestSum(" + a1 + "," + a2 + ")");

        // Invoke the TestSum functon  
        XLOper res = a.invoke("TestSum", new Double(a1), new Double(a2));

        // Output the result  
        System.out.println(res.num);  
    }  
}