BuildExcelConnectionString excel 连接字符串

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

andycode

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

阅读量1.1k

点赞数

分类专栏： C#小知识点文章标签： excel properties string basic xml ext

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

15 篇文章 0 订阅

订阅专栏

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