快捷導(dǎo)航

C#窗體間通訊處理的幾種方法總結(jié)

更新時間：2013年11月26日 14:49:36 作者：

這篇文章主要介紹了

最近做項目遇到導(dǎo)出Excel的問題總結(jié)一下：
看代碼：

/// <summary>
        /// 生成Excel的方法
        /// </summary>
        /// <param name="ds">DataSet</param>
        /// <param name="url">Excel存在服務(wù)器的相對地址</param>
        /// <returns></returns>
        private bool ExportExcel(DataSet ds, string path)
        {
            //創(chuàng)建標(biāo)題行
            HSSFWorkbook workbook = new HSSFWorkbook();
            HSSFSheet sheet = workbook.CreateSheet("報名情況");
            HSSFRow rowtitle = sheet.CreateRow(0);

            //設(shè)置列寬
            sheet.SetColumnWidth(0, 30 * 256);
            sheet.SetColumnWidth(1, 30 * 256);
            sheet.SetColumnWidth(2, 30 * 256);
            sheet.SetColumnWidth(3, 30 * 256);
            sheet.SetColumnWidth(4, 30 * 256);
            sheet.SetColumnWidth(5, 30 * 256);
            sheet.SetColumnWidth(6, 30 * 256);
            sheet.SetColumnWidth(7, 30 * 256);
            sheet.SetColumnWidth(8, 30 * 256);
            sheet.SetColumnWidth(9, 30 * 256);

            //創(chuàng)建列
            rowtitle.CreateCell(0,HSSFCellType.STRING).SetCellValue("姓名");
            rowtitle.CreateCell(1, HSSFCellType.STRING).SetCellValue("資質(zhì)證書編號");
            rowtitle.CreateCell(2, HSSFCellType.STRING).SetCellValue("職業(yè)資格等級");
            rowtitle.CreateCell(3, HSSFCellType.STRING).SetCellValue("性別");
            rowtitle.CreateCell(4, HSSFCellType.STRING).SetCellValue("身份證號");
            rowtitle.CreateCell(5, HSSFCellType.STRING).SetCellValue("從業(yè)信息識別卡編號");
            rowtitle.CreateCell(6, HSSFCellType.STRING).SetCellValue("原機(jī)構(gòu)名稱");
            rowtitle.CreateCell(7, HSSFCellType.STRING).SetCellValue("原機(jī)構(gòu)編號");
            rowtitle.CreateCell(8, HSSFCellType.STRING).SetCellValue("變更機(jī)構(gòu)名稱");
            rowtitle.CreateCell(9, HSSFCellType.STRING).SetCellValue("變更機(jī)構(gòu)編號");

            //DataSet是一個DataTale的集合，如果只是填充了1張表，則此表的ID為0
            DataTable dt = ds.Tables[0];
            int i = 1;
            foreach (DataRow row in dt.Rows)
            {
                HSSFRow newrow = sheet.CreateRow(i);
                newrow.CreateCell(0,HSSFCellType.STRING).SetCellValue(Convert.ToString(row["R_XM"]));
                newrow.CreateCell(1, HSSFCellType.STRING).SetCellValue(Convert.ToString(row["R_newzzbh"]));
                string jibie=string.Empty;
                if (row["R_jb"].ToString()=="1")
                {
                    jibie = "一級";
                }
                else if (row["R_jb"].ToString() == "2")
                {
                    jibie = "二級";
                }
                else if (row["R_jb"].ToString() == "3")
                {
                    jibie = "三級";
                }
                newrow.CreateCell(2,HSSFCellType.STRING).SetCellValue(jibie);
                newrow.CreateCell(3,HSSFCellType.STRING).SetCellValue(Convert.ToString(row["R_XB"]));
                newrow.CreateCell(4,HSSFCellType.STRING).SetCellValue(Convert.ToString(row["user_id"]));
                newrow.CreateCell(5,HSSFCellType.STRING).SetCellValue(Convert.ToString(row["R_KH"]));
                newrow.CreateCell(6,HSSFCellType.STRING).SetCellValue(Convert.ToString(row["yjgmc"]));
                newrow.CreateCell(7,HSSFCellType.STRING).SetCellValue(Convert.ToString(row["yjgbh"]));
                newrow.CreateCell(8,HSSFCellType.STRING).SetCellValue(Convert.ToString(row["bjgmc"]));
                newrow.CreateCell(9,HSSFCellType.STRING).SetCellValue(Convert.ToString(row["bjgbh"]));
                i++;
            }
            try
            {
                using (Stream stream = File.Open(path, FileMode.OpenOrCreate, FileAccess.ReadWrite))
                {
                    workbook.Write(stream);
                }
                return true;
            }
            catch (Exception)
            {
                return false;
                throw;
            }

        }

導(dǎo)出方法：

復(fù)制代碼代碼如下:

/// <summary>
        /// 導(dǎo)出Excel
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void linkExport_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            ds = apryManager.Export();
            Random rd = new Random();
            int rd1= rd.Next(111111,999999);
            string path = this.Server.MapPath("~\\anxieExecl\\") + DateTime.Now.ToString("yyyyMMddhhmmss")+ rd1.ToString() + ".xls";
            if (!Directory.Exists(this.Server.MapPath("~\\anxieExecl\\")))
            {
                Directory.CreateDirectory(this.Server.MapPath("~\\anxieExecl\\"));
            }
            bool status = ExportExcel(ds,path);
            string Redirectpath = "~\\anxieExecl\\" + path.Substring(path.LastIndexOf("\\") + 1);
            if (status)
            {
                Response.Redirect(Redirectpath);
                File.Delete(path);
            }
            else
            {
                ClientScript.RegisterStartupScript(GetType(), "alert", "alert('生成Excel失?。?)", true);
            }
        }