在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
这个问题来自论坛提问,同理可以获得access等数据库的表结构信息。 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 ); } } } /* 何问起 hovertree.com */ 推荐:http://www.cnblogs.com/roucheng/p/excelhanshu.html |
请发表评论