dfd

     public void Exp_Click()

        {

            System.Data.DataTable dv = LoadDataTable();

            Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();

            if (app == null)

            {

                return ;

            }

            app.Visible = false;

            app.UserControl = true;

            Microsoft.Office.Interop.Excel.Workbooks workbooks = app.Workbooks;

            Microsoft.Office.Interop.Excel._Workbook workbook = workbooks.Add("d://abc.xls");

            Microsoft.Office.Interop.Excel.Sheets sheets = workbook.Worksheets;

            Microsoft.Office.Interop.Excel._Worksheet worksheet = (Microsoft.Office.Interop.Excel._Worksheet)sheets.get_Item(1);

            if (worksheet == null)

            {

                return ;

            }

            worksheet.Cells[2, 2] = "sss";

            worksheet.Cells[2, 15] = string.Format("{0:D}", DateTime.Now.Date);

            int rowNum = 0;

            for (int i = 0; i < dv.Rows.Count; i++)

            {

                rowNum++;

                worksheet.Cells[4 + i, 1] = string.Format("{0:D3},{1:D2}", rowNum, rowNum);

                worksheet.Cells[4 + i, 2] = dv.Rows[i][0].ToString();

                worksheet.Cells[4 + i, 3] = dv.Rows[i][1].ToString();

                worksheet.get_Range(worksheet.Cells[4 + i, 1], worksheet.Cells[4 + i, 3]).Borders.Color =

                    System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Black);

            }

            object save_path = "d://cm.xls";

            workbook.SaveAs(save_path, Missing.Value, Missing.Value, Missing.Value, Missing.Value,

                Missing.Value, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value,

                Missing.Value, Missing.Value, Missing.Value, Missing.Value);

            workbooks.Close();

            app.Quit();

            string file = save_path.ToString();

            //window.location.href

            Response.Write("<script language='javascript' type='text/javascript' >window.location.href='" + file + "'</script>");

            Response.Flush();

            Response.End();

            //return file;

            //File.Delete(file);

        }