Asp.Net用OWC操作Excel的实例代码
150 浏览量
2020-10-27
01:52:47
上传
评论
收藏 37KB PDF 举报
Asp.Net用用OWC操作操作Excel的实例代码的实例代码
介绍了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();
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();
评论0
最新资源