泛微OA实现导入Excel至明细（E9、不保存表单版）

该功能设计到前端、后端

思路是通过文件id获取到文件下载路径，通过第三方工具解析获取到的文件下载路径，再通过官方提供的函数遍历到明细表内

1、获取文件下载路径

    /**
     * 获取文件信息
     *
     * @param values 文件id
     * @return FileDataDao  filelink为文件下载路径
     */
    public FileDataDao getDatas(String values) {
        String sql = "" +
                "select " +
                "doc.docId, " +
                "right(doc.imagefilename ,len(doc.imagefilename) - Charindex('.',doc.imagefilename)) as [fileExtendName], " +
                "doc.imagefileid, " +
                "doc.operatedate as [uploaddate], " +
                "files.fileSize as [filesize], " +
                "files.secretLevel, " +
                "doc.versionId, " +
                "doc.imagefilename as [filename], " +
                "case when doc.operateuserid = 1 then '系统管理员' else ISNULL(emp.lastname,'') end as [username] " +
                "from docimagefile doc " +
                "left join imagefile files on files.imagefileid = doc.imagefileid " +
                "left join hrmresource emp on emp.id = doc.operateuserid " +
                "where  docid in (?) ";
        RecordSet rs = new RecordSet();
        if (rs.executeQuery(sql, values)) {
            while (rs.next()) {
                FileDataDao fileDataDao = new FileDataDao(
                        Util.null2String(rs.getString("fileExtendName")),
                        Util.nul