BuildExcelConnectionString excel 连接字符串

关注

转载最新推荐文章于 2026-04-27 09:01:51 发布 1.2k 阅读 AI 写同款· GEO 优化 ›

adoconnection连接excel连接串 ADOConstr= "Provider=Microsoft.Jet.OLEDB.4.0;" "User ID=admin;" "Data Source="+ExcelFile+";" "Mode=Share Deny None;" "Extended Properties=Excel 8 阅读详情

public string BuildExcelConnectionString(string filename) {
            string ext = System.IO.Path.GetExtension(filename);

            // Support for Excel 2007 XML format
            if (ext.ToLower() == ".xlsx")
                return string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES\";", filename);

            // Support for Excel 2007 binary format
            if (ext.ToLower() == ".xlsb")
                return string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0;HDR=YES\";", filename);

            // Support for Excel 2007 binary format
            if (ext.ToLower() == ".xlsm")
                return string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Macro;HDR=YES\";", filename);

            // Basic support for Excel 97 through 2003.
            return string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=YES\";", filename);
        }

收录于