asp.net动态获取Excel表名的函数代码

public string GetExcelFirstTableName(string excelFileName) 
{ 
string tableName = null; 
if (File.Exists(excelFileName)) 
{ 
using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet." + 
"OLEDB.4.0;Extended Properties=\"Excel 8.0\";Data Source=" + excelFileName)) 
{ 
conn.Open(); 
DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); 
for (int i = 0; i < dt.Rows.Count; i++) 
{ 
tableName += dt.Rows[i][2].ToString().Trim(); 
view sourceprint?1 } 
} 
} 
return tableName; 
} 

asp.net读取excel动态获取表名 
 代码如下:

string a=File1.PostedFile.FileName.ToString(); 
string excelFilePath=a; 
Excel.Application myExcel=new Excel.ApplicationClass( ) ; 
object oMissing = System.Reflection.Missing.Value ; 
myExcel.Application.Workbooks.Open(excelFilePath,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing) ; 
Excel.Workbook myBook = myExcel.Workbooks[1] ; 
Excel.Worksheet mySheet = (Excel.Worksheet)myBook.Worksheets[1] ; 
Response.Write(mySheet.Name); 
string Name=mySheet.Name; 
System.Data.DataTable dt=new System.Data.DataTable("mytable"); 
dt.Columns.Add("F1", System.Type.GetType("System.String")); 
dt.Columns.Add("F2", System.Type.GetType("System.String")); 
dt.Columns.Add("F3", System.Type.GetType("System.String")); 
dt.Columns.Add("F4", System.Type.GetType("System.String")); 
dt.Columns.Add("F5", System.Type.GetType("System.String")); 
DataSet myDs = new DataSet(); 
myDs.Tables.Add(dt); 
DataRow myRow; 
myDs.Clear(); 
for( int i = 2 ; i <= 4 ; i ++ ) //第一行为标题，不读取 
{ 
myRow = myDs.Tables["mytable"].NewRow(); 
for( int j = 1 ; j <= 5 ; j ++ ) 
{ 
Excel.Range r=(Excel.Range)mySheet.Cells[i,j]; 
string strValue=r.Text.ToString(); 
string aa=strValue; 
string columnname="F"+j.ToString(); 
myRow[columnname]=strValue; 
} 
myDs.Tables["mytable"].Rows.Add(myRow); 
// } 
myExcel.Quit(); 
DataGrid1.DataSource=myDs.Tables["mytable"].DefaultView; 
DataGrid1.DataBind(); 

  
  




声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com