读取Excel,获取Excel的数据库 表名等等

[money_live]

		/// <summary>
		/// Excel 转换 XML
		/// </summary>
		/// <param name="_excelPath"></param>
		public void ExcelConversionXML(string _excelPath) { 
                        

			string connection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + _excelPath + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
			try {
				OleDbConnection conn = new OleDbConnection(connection); 
                                string tbName = null; // 表名
				OleDbDataAdapter oda = new OleDbDataAdapter("select * from ["+ tbName +"$]", conn);//

				oda.Fill(ds, "商品信息");
				oda = new OleDbDataAdapter("select * from [右边$]", conn);
				oda.Fill(ds, "商品信息");

				conn.Close();
			} catch (Exception ex) {
			}
		}

不知道怎么获取 Excel 内数据库名,所有的表名
等等

[hxwangcong]

OleDBConnection里有个函数是GetSchema，参数是Tables，就可以获得当前数据库的所有表名，如果没记错的话应该是这样

[gxlqssjf]

去看看有关数据库连接的书，一般是挺简单的，呵呵

[money_live]

/// <summary>
		/// Excel 转换 XML
		/// </summary>
		/// <param name="_excelPath"></param>
		public void ExcelConversionXML(string _excelPath) {
			string connection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + _excelPath + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
			try {
				OleDbConnection conn = new OleDbConnection(connection);

				// 当前数据库有的表名
				string[] tbName = null;	// TODO: ????????????????????????????????????????????????????????

				foreach (string item in tbName) {
					oda = new OleDbDataAdapter("select * from [" + item + "$]", conn);
					oda.Fill(ds, conn.Database);
				}
				conn.Close();
			} catch {
				throw;
			}
		}

[Annie_Cai]

                DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
                string tableName = schemaTable.Rows[0][2].ToString().Trim();//获取第一个工作页的名称；

OleDbDataAdapter oda = new OleDbDataAdapter("select * from [" + tableName + "]", conn);

[NowtAngell]

...你读出来的表可以给他.NAME
或用默认的表名 然后赋值给Excel的表名