labview怎么把HTML文件转换为EXCLE文件

2025-03-11 05:10:54
推荐回答(1个)
回答1:

/**
     * 将指定路径的Excel文件生成Html文件
     * 
     * @param excelFilename
     *            Excel文件存放路径及文件名,可以是网络地址
     * @param htmlFilename
     *            生成后的html存放路径及文件名
     */
    public static void ExcelToHtml(String excelFilename, String htmlFilename)
    {
        ActiveXComponent xl = new ActiveXComponent("Excel.Application");
        try
        {
            Dispatch.put(xl, "Visible", new Variant(false));
            Object workbooks = xl.getProperty("Workbooks").toDispatch();
            Object workbook = Dispatch.call(workbooks, "Open", excelFilename).toDispatch();
            Dispatch.invoke(workbook, "SaveAs", Dispatch.Method, new Object[] ...{ htmlFilename, new Variant(44) }, new int[1]);
            Dispatch.call(workbooks, "Close", new Variant(false));
        }
        catch (Exception e)
        {
        }
        finally
        {
            xl.invoke("Quit", new Variant[] ...{});
            xl = null;
        }
    }