posts - 0,  comments - 20,  trackbacks - 0

原文:http://hi.baidu.com/xiaoheilong/blog/item/9fe0d800464eaf19738b6550.html

string connstr = System.Configuration.ConfigurationManager.ConnectionStrings["DqpiHrConnectionString"].ToString();
          SqlConnection conn = new SqlConnection(connstr);
          SqlDataAdapter sda = new SqlDataAdapter(sql1.Text, conn);

          DataSet ds = new DataSet();
          conn.Open();
          sda.Fill(ds);
          conn.Close();

          OWC10.SpreadsheetClass xlsheet;
          xlsheet= new OWC10.SpreadsheetClass();
          DataRow dr;
          int i = 0;
          for(int ii=0;ii<ds.Tables[0].Rows.Count;ii++)
          {
              dr = ds.Tables[0].Rows[ii];
            
             
            
              //合并单元格
              xlsheet.get_Range(xlsheet.Cells[i+1, 1], xlsheet.Cells[i+1, 8]).set_MergeCells(true);
            
              xlsheet.get_Range(xlsheet.Cells[i + 5, 1], xlsheet.Cells[i + 5, 3]).set_MergeCells(true);
              xlsheet.get_Range(xlsheet.Cells[i + 5, 4], xlsheet.Cells[i + 5, 6]).set_MergeCells(true);
              xlsheet.get_Range(xlsheet.Cells[i + 5, 7], xlsheet.Cells[i + 5, 8]).set_MergeCells(true);

              xlsheet.ActiveSheet.Cells[i + 1, 1] = dr["姓名"].ToString() + "自然情况";
              //字体加粗
              xlsheet.get_Range(xlsheet.Cells[i + 1, 1], xlsheet.Cells[i + 1, 14]).Font.set_Bold(true);
              //单元格文本水平居中对齐
              xlsheet.get_Range(xlsheet.Cells[i + 1, 1], xlsheet.Cells[i + 1, 14]).set_HorizontalAlignment(OWC10.XlHAlign.xlHAlignCenter);
              //设置字体大小
              xlsheet.get_Range(xlsheet.Cells[i + 1, 1], xlsheet.Cells[i + 1, 14]).Font.set_Size(14);
              //设置列宽
              xlsheet.get_Range(xlsheet.Cells[i + 1, 8], xlsheet.Cells[i + 1, 8]).set_ColumnWidth(20);
            


              //画边框线
              xlsheet.get_Range(xlsheet.Cells[i + 1, 1], xlsheet.Cells[i+5, 8]).Borders.set_LineStyle(OWC10.XlLineStyle.xlContinuous);


              //写入数据    (这里由DS生成)

              xlsheet.ActiveSheet.Cells[i + 2, 1] = "姓名";
              xlsheet.ActiveSheet.Cells[i + 2, 2] = dr["姓名"].ToString();
              xlsheet.ActiveSheet.Cells[i + 2, 3] = "曾用名";
              xlsheet.ActiveSheet.Cells[i + 2, 4] = dr["曾用名"].ToString();
              xlsheet.ActiveSheet.Cells[i + 2, 5] = "出生年月";
              xlsheet.ActiveSheet.Cells[i + 2, 6] = DateTime.Parse(dr["出生年月"].ToString()).Year.ToString() + "-" + DateTime.Parse(dr["出生年月"].ToString()).Month.ToString();
              xlsheet.ActiveSheet.Cells[i + 2, 7] = " 参加工作时间";
              xlsheet.ActiveSheet.Cells[i + 2, 8] = DateTime.Parse(dr["参加工作时间"].ToString()).Year.ToString() + "-" + DateTime.Parse(dr["参加工作时间"].ToString()).Month.ToString();

              xlsheet.ActiveSheet.Cells[i + 3, 1] = "性别";
              xlsheet.ActiveSheet.Cells[i + 3, 2] = dr["性别"].ToString();
              xlsheet.ActiveSheet.Cells[i + 3, 3] = "民族";
              xlsheet.ActiveSheet.Cells[i + 3, 4] = dr["民族"].ToString();
              xlsheet.ActiveSheet.Cells[i + 3, 5] = "政治面貌";
              xlsheet.ActiveSheet.Cells[i + 3, 6] = dr["政治面貌"].ToString();
              xlsheet.ActiveSheet.Cells[i + 3, 7] = "职称";
              xlsheet.ActiveSheet.Cells[i + 3, 8] = dr["职称"].ToString();

              xlsheet.ActiveSheet.Cells[i + 4, 1] = "学历";
              xlsheet.ActiveSheet.Cells[i + 4, 2] = dr["学历"].ToString();
              xlsheet.ActiveSheet.Cells[i + 4, 3] = "学位";
              xlsheet.ActiveSheet.Cells[i + 4, 4] = dr["学位"].ToString();
              xlsheet.ActiveSheet.Cells[i + 4, 5] = "职务";
              xlsheet.ActiveSheet.Cells[i + 4, 6] = dr["职务"].ToString();
              xlsheet.ActiveSheet.Cells[i + 4, 7] = "档案号码";
              //Excel不支持0开头输入,加上姓氏首字母正好是编号全称
              xlsheet.ActiveSheet.Cells[i + 4, 8] = dr["姓氏首字母"].ToString() + dr["档案号码"].ToString();


              xlsheet.ActiveSheet.Cells[i + 5, 1] = "现从事专业:" + dr["现从事专业"].ToString();
              xlsheet.ActiveSheet.Cells[i + 5, 4] = "工作单位:" + dr["工作单位"].ToString();
              xlsheet.ActiveSheet.Cells[i + 5, 7] = "身份证:" + dr["身份证号"].ToString();

              i += 6;
          }
          try
          {
              string D = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() +
              DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString()+
              DateTime.Now.Millisecond.ToString();

              xlsheet.Export(Server.MapPath("./")+"\\"+D+".xls", OWC10.SheetExportActionEnum.ssExportActionNone, OWC10.SheetExportFormat.ssExportXMLSpreadsheet);
              Response.Write("<script>window.open('"+D+".xls')</script>");
          }
          catch
          {
          }
      }

posted on 2010-05-06 11:55 Documents 阅读(201) 评论(0)  编辑  收藏 所属分类: OtherWebASP.NET

只有注册用户登录后才能发表评论。


网站导航:
 
<2019年12月>
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234

留言簿

文章分类

文章档案

J2EE

搜索

  •  

最新评论