BuildExcelConnectionString excel 连接字符串

最新推荐文章于 2022-02-07 23:24:34 发布

转载最新推荐文章于 2022-02-07 23:24:34 发布 · 1.2k 阅读

文章标签：

#excel #properties #string #basic #xml #ext

C#小知识点专栏收录该内容

15 篇文章

订阅专栏

本文介绍如何根据Excel文件类型构建相应的连接字符串，支持从Excel 97到2007的不同格式。

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);
        }