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

时间:2022-09-14 11:51:58

代码如下:


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