简单的将数据插入excel表

 

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data.OleDb;
using System.Data;
namespace CardProject.admin.resource
{
    public partial class test2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        public void daochu()
        {
            string filePath = Server.MapPath("~/" + Guid.NewGuid().ToString() + ".xls");

            File.Copy(Server.MapPath("~/Book1.xls"), filePath);

            // 使用OleDb驱动程序连接到副本

            OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=Excel 8.0;");

            u