Asp.Net用OWC操作Excel



	 

	 

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

	 

	     &nbs

补充：Web开发 , ASP.Net ,