请问如何才能把一个excel文件的内容导入到dataset中呢? 谢谢! 看这里http://dev.csdn.net/Develop/article/15/15544.shtm 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 OleDbConnection myConnection = new OleDbConnection(); myConnection.ConnectionString =" Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source=Excel数据文件;Extended Properties=Excel 8.0;"; myConnection.Open(); OleDbCommand myCommand = myConnection.CreateCommand(); myCommand.CommandText = "select * from [sheet1$]"; OleDbDataAdapter myAdapter = new OleDbDataAdapter(); myAdapter.SelectCommand = myCommand; DataSet mySet = new DataSet(); myAdapter.Fill(mySet); //我在网上找的;public string [] GetSheetNameList( string excelFilePath , string[] colList ){ Excel.Application myExcel=new Excel.Application ( ) ; try{ object oMissing = System.Reflection.Missing.Value ; myExcel.Application.Workbooks.Open excelFilePath,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing ) ; Excel.Workbook myBook = myExcel.Workbooks[1] ; int sheetNum = myBook.Worksheets.Count ; string [] col = null ; ArrayList totalName = new ArrayList(); for( int i = 1 ; i <= sheetNum ; i ++ ){ col = this.GetColumnsNameList( excelFilePath , i ) ; if( col==null || col.Length == 0 || col.Length != colList.Length ) continue ; for( int j = 0 ; j < col.Length ; j ++ ) { if( col[j].Trim() != colList[j].Trim() ) continue ; } Excel.Worksheet xlsheet = (Excel.Worksheet)myBook.Worksheets[i] ; totalName.Add( xlsheet.Name ) ; } //===========2003.11.28============= string [] sheetName = new String[ totalName.Count ] ; for( int i = 0 ; i < totalName.Count ; i ++ ) { sheetName[i] = totalName[i].ToString().Trim(); } myExcel.Application.Workbooks.Close( ) ; Marshal.ReleaseComObject( myExcel ) ; return sheetName; } catch{ Marshal.ReleaseComObject( myExcel ) ; return null ; } } 关于delegate的一点疑问 紧急求助 winform如何获取页面返回值 c#连接ORACLE出现 哪种方法读取大型XML文件效率高? 现在有可用的无功能限制版的.net混淆器吗? C# 产生均匀分布随机数并求方差和期望 SharpDevelop这样的IDE能胜任大型项目的开发吗? 兄弟姐妹请帮忙!谢谢了 假如MONO成功移植,那么原先针对WINDOWS的.NET API函数会不会全都不能用了?? textbox有关中文输入的问题 C#开发GIS的请进!
myConnection.ConnectionString =" Provider=Microsoft.Jet.OLEDB.4.0;"
+"Data Source=Excel数据文件;Extended Properties=Excel 8.0;";
myConnection.Open();
OleDbCommand myCommand = myConnection.CreateCommand();
myCommand.CommandText = "select * from [sheet1$]";
OleDbDataAdapter myAdapter = new OleDbDataAdapter();
myAdapter.SelectCommand = myCommand;
DataSet mySet = new DataSet();
myAdapter.Fill(mySet);
public string [] GetSheetNameList( string excelFilePath , string[] colList )
{
Excel.Application myExcel=new Excel.Application ( ) ;
try{
object oMissing = System.Reflection.Missing.Value ; myExcel.Application.Workbooks.Open excelFilePath,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing ) ; Excel.Workbook myBook = myExcel.Workbooks[1] ;
int sheetNum = myBook.Worksheets.Count ;
string [] col = null ;
ArrayList totalName = new ArrayList();
for( int i = 1 ; i <= sheetNum ; i ++ ){
col = this.GetColumnsNameList( excelFilePath , i ) ;
if( col==null || col.Length == 0 || col.Length != colList.Length )
continue ;
for( int j = 0 ; j < col.Length ; j ++ )
{
if( col[j].Trim() != colList[j].Trim() )
continue ;
}
Excel.Worksheet xlsheet = (Excel.Worksheet)myBook.Worksheets[i] ;
totalName.Add( xlsheet.Name ) ;
}
//===========2003.11.28=============
string [] sheetName = new String[ totalName.Count ] ;
for( int i = 0 ; i < totalName.Count ; i ++ )
{
sheetName[i] = totalName[i].ToString().Trim();
}
myExcel.Application.Workbooks.Close( ) ;
Marshal.ReleaseComObject( myExcel ) ;
return sheetName;
}
catch{
Marshal.ReleaseComObject( myExcel ) ;
return null ;
}
}