添加到指定的有标题 的Excel中

来源:互联网 发布:华钦软件拖欠工资 编辑:程序博客网 时间:2024/05/23 13:35

#region 导出Excel
        private void button1_Click(object sender, EventArgs e)
        { 
            DataTable dt = sys_bll.get_DataTable_strWhere("select  * from EKC_ERP_OutLook  );
            //导出到execl  
            try
            {
                //没有数据的话就不往下执行  
                if (dt.Rows.Count == 0)
                {
                    return;
                }
                //实例化一个Excel.Application对象  
                Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
                Microsoft.Office.Interop.Excel.Worksheet exsh = new Microsoft.Office.Interop.Excel.Worksheet();
                excel.Visible = true;
                Microsoft.Office.Interop.Excel.Workbook xbook = excel.Workbooks.Open(@"C:/Documents and Settings/Administrator/桌面/11.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                                                 Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                int rowIndex = 2;//标题下行 如加标题 2改成1
                int colIndex = 0;
 
                //遍历行
                foreach (DataRow row in dt.Rows)
                {
                    colIndex = 0;
                    for (colIndex = 0; colIndex < dt.Columns.Count; colIndex++)
                    {
                        excel.Cells[rowIndex, colIndex + 1] = row[colIndex].ToString();
                    }
                    rowIndex++;
                }
            
                //设置禁止弹出保存和覆盖的询问提示框  
                excel.DisplayAlerts = false;
                excel.AlertBeforeOverwriting = false;  
                xbook.Save(); 
                //确保Excel进程关闭  
                excel.Workbooks.Close();
                excel.Quit();
                excel = null;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.Message, "错误提示");
            }
        }
        #endregion

原创粉丝点击