ASP.NET对Excel单元格进行操作并且插入数据

        protected void Button3_Click(object sender, EventArgs e)
        {
            try
            {
                DataSet ds = new BLL.TrafficLine().GetAllList();
                System.Data.DataTable dt = ds.Tables[0];
                DataView dv = dt.DefaultView;
                ////////////////////////////////////
                Excel._Application app = new Excel.ApplicationClass();

                app.Visible = false;
                app.UserControl = true;
                object missing = System.Reflection.Missing.Value;
                Workbooks workbooks = app.Workbooks;
                _Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
                _Worksheet worksheet =(_Worksheet ) workbook.Worksheets.get_Item(1);

                worksheet.get_Range(worksheet.Cells[3, 1], worksheet.Cells[3, 3]).Merge(missing);
                worksheet.get_Range(worksheet.Cells[3, 1], worksheet.Cells[3, 1]).Value2 = DateTime.Now.ToLocalTime().ToString();
                worksheet.get_Range(worksheet.Cells[3, 1], worksheet.Cells[3, 1]).Font.Bold = true;
worksheet.get_Range(worksheet.Cells[3, 1], worksheet.Cells[3, 1]).Borders.Weight = 4;   //设置单元格的逼边框厚度,为了打印能显示出线条
                worksheet.Cells[3, 4] = ds.Tables[0].Rows[1]["LineName"].ToString();
                string str = DateTime.Now.Millisecond.ToString();
               app.Save(str);  //str为一个唯一值
            }
            catch { }
            finally
            {
                foreach (System.Diagnostics.Process pro in System.Diagnostics.Process.GetProcessesByName("EXCEL"))
                {
                    pro.Kill();
                }
            } 
        }