本文使用c#通过oledb可获取excel文件表的结构信息，同理也可以获得access等数据库的表结构信息，实现如下：

来源：互联网发布：caffe adam 编辑：程序博客网时间：2024/05/22 14:18

using System;
namespace ConsoleApplication11
{
    class Program
     {
        public static void Main()
         {
            getExcelFileInfo(@"c:a.xls");
        }
        private static void getExcelFileInfo(string Path)
         {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
            System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(strConn);
            conn.Open();
            System.Data.DataTable table = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);

            foreach (System.Data.DataRow drow in table.Rows)
             {
                string TableName = drow["Table_Name"].ToString();
                Console.WriteLine(TableName+":");
                System.Data.DataTable tableColumns = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns, new object[] { null, null, TableName ,null});
                foreach (System.Data.DataRow drowColumns in tableColumns.Rows)
                 {
                    string ColumnName = drowColumns["Column_Name"].ToString();
                    Console.WriteLine(" "+ColumnName);
                }
            }
            Console.ReadKey(true);
        }
    }

本文来自: IT知道网(http://www.itwis.com) 详细出处参考：http://www.itwis.com/html/net/c/20081210/3091.html