Excel操作

方法一：

引入ExcelLibrary.dll

 

Code:

//Create the data set and table DataSet ds = new DataSet("New_DataSet"); DataTable dt = new DataTable("New_DataTable"); //Set the locale for each ds.Locale = System.Threading.Thread.CurrentThread.CurrentCulture; dt.Locale = System.Threading.Thread.CurrentThread.CurrentCulture; //Open a DB connection (in this example with OleDB) SqlConnection con = new SqlConnection(dbConnectionStr); con.Open(); //Create a query and fill the data table with the data from the DB string sql = "SELECT * FROM Users;"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataAdapter adptr = new SqlDataAdapter(); adptr.SelectCommand = cmd; adptr.Fill(dt); con.Close(); //Add the table to the data set ds.Tables.Add(dt); //Here's the easy part. Create the Excel worksheet from the data set ExcelLibrary.DataSetHelper.CreateWorkbook("MyExcelFile.xls", ds);

 

Details:http://code.google.com/p/excellibrary/

 

方法二：

http://www.cnblogs.com/rlecir/archive/2010/07/16/1779033.html