excel.txt

来自「C#操作Excel程序」· 文本 代码 · 共 21 行

前些日子，有很多朋友说需要C#导出到Excel的代码，现共享给大家
/// /// 读取Excel文档 /// /// 
文件名称
/// 返回一个数据集 
public DataSet ExcelToDS(string Path)
{ 
	string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;"; 
	OleDbConnection conn = new OleDbConnection(strConn); 
	conn.Open(); 
	string strExcel = ""; 
	OleDbDataAdapter myCommand = null; 
	DataSet ds = null; 
	strExcel="select * from [sheet1$]"; 
	myCommand = new OleDbDataAdapter(strExcel, strConn); 
	ds = new DataSet(); 
	myCommand.Fill(ds,"table1"); 
	return ds; 
}
/// /// 写入Excel文档 /// /// 
文件名称
public bool SaveFP2toExcel(string Path) { try { string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); System.Data.OleDb.OleDbCommand cmd=new OleDbCommand (); cmd.Connection =conn; //cmd.CommandText ="UPDATE [sheet1$] SET 姓名='2005-01-01' WHERE 工号='日期'"; //cmd.ExecuteNonQuery (); for(int i=0;i