dfd

最新推荐文章于 2024-09-11 15:33:18 发布

hjd2357

最新推荐文章于 2024-09-11 15:33:18 发布

阅读量415

点赞数

文章标签： file javascript path null object string

本文链接：https://blog.csdn.net/hjd2357/article/details/6461619

版权

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);
        }