Npoi导出Word
参考网上大神们笔记，完成Word导出。
//创建文档
XWPFDocument doc = new XWPFDocument();
//标题
XWPFParagraph p1 = doc.CreateParagraph();
XWPFRun r1 = p1.CreateRun();
r1.SetBold(true);
r1.FontSize = 23;
r1.SetText("先进个人基本信息");
r1.SetTextPosition(30);
CT_P doc_p1 = doc.Document.body.GetPArray(0);//标题居中
doc_p1.AddNewPPr().AddNewJc().val = ST_Jc.center;
//创建表格
XWPFTable table = doc.CreateTable();//行，列
table.RemoveRow(0);
#region
//for (int i = 0; i < table.Rows.Count; i++)//水平和垂直居中
//{
// for (int j = 0; j < table.Rows.Count; j++)
// {
// CT_Tc cttc = table.GetRow(i).GetCell(j).GetCTTc();
// CT_TcPr ctpr = cttc.AddNewTcPr();
// cttc.GetPList()[0].AddNewPPr().AddNewJc().val = ST_Jc.center;//水平居中
// ctpr.AddNewVAlign().val = ST_VerticalJc.center;//垂直居中
// }
//}
//SetColSpan(table.GetRow(2).GetCell(1), 2);
//SetColSpan(table.GetRow(2).GetCell(4), 2);
//SetColSpan(table.GetRow(3).GetCell(1), 2);
//SetColSpan(table.GetRow(3).GetCell(4), 2);
//SetColSpan(table.GetRow(5).GetCell(1), 2);
//SetColSpan(table.GetRow(5).GetCell(4), 2);
//SetColSpan(table.GetRow(6).GetCell(1), 7);
//SetColSpan(table.GetRow(7).GetCell(1), 7);
#endregion
//2.表格内容
XWPFTableRow row_0 = CreateRow(table);//第一行
XWPFTableCell cell_0_0 = CreateCell(row_0);
cell_0_0.SetText("姓名");
XWPFTableCell cell_0_1 = CreateCell(row_0);
cell_0_1.SetText("");
XWPFTableCell cell_0_2 = CreateCell(row_0);
cell_0_2.SetText("性别");
XWPFTableCell cell_0_3 = CreateCell(row_0);
cell_0_3.SetText("");
XWPFTableCell cell_0_4 = CreateCell(row_0);
cell_0_4.SetText("民族");
XWPFTableCell cell_0_5 = CreateCell(row_0);
cell_0_5.SetText("");
XWPFTableCell cell_0_6 = CreateCell(row_0);
cell_0_6.SetText("出生年月");
XWPFTableCell cell_0_7 = CreateCell(row_0);
cell_0_7.SetText("");
XWPFTableRow row_1 = CreateRow(table);//第二行
XWPFTableCell cell_1_0 = CreateCell(row_1);
cell_1_0.SetText("政治面貌");
XWPFTableCell cell_1_1 = CreateCell(row_1);
cell_1_1.SetText("");
XWPFTableCell cell_1_2 = CreateCell(row_1);
cell_1_2.SetText("籍贯");
XWPFTableCell cell_1_3 = CreateCell(row_1);
cell_1_3.SetText("");
XWPFTableCell cell_1_4 = CreateCell(row_1);
cell_1_4.SetText("学历");
XWPFTableCell cell_1_5 = CreateCell(row_1);
cell_1_5.SetText("");
XWPFTableCell cell_1_6 = CreateCell(row_1);
cell_1_6.SetText("参加工作时间");
XWPFTableCell cell_1_7 = CreateCell(row_1);
cell_1_7.SetText("");
XWPFTableRow row_2 = CreateRow(table);//第三行
XWPFTableCell cell_2_0 = CreateCell(row_2);
cell_2_0.SetText("所在单位");
XWPFTableCell cell_2_1 = CreateCell(row_2);
SetColSpan(cell_2_1, 2);//合并单元格
cell_2_1.SetText("");
XWPFTableCell cell_2_2 = CreateCell(row_2);
cell_2_2.SetText("所属部门");
XWPFTableCell cell_2_3 = CreateCell(row_2);
SetColSpan(cell_2_3, 2);
cell_2_3.SetText("");
XWPFTableCell cell_2_4 = CreateCell(row_2);
cell_2_4.SetText("隶属系统");
XWPFTableCell cell_2_5 = CreateCell(row_2);
cell_2_5.SetText("");
XWPFTableRow row_3 = CreateRow(table);//第四行
XWPFTableCell cell_3_0 = CreateCell(row_3);
cell_3_0.SetText("现任职务");
XWPFTableCell cell_3_1 = CreateCell(row_3);
SetColSpan(cell_3_1, 2);
cell_3_1.SetText("");
XWPFTableCell cell_3_2 = CreateCell(row_3);
cell_3_2.SetText("任现职时间");
XWPFTableCell cell_3_3 = CreateCell(row_3);
SetColSpan(cell_3_3, 2);
cell_3_3.SetText("");
XWPFTableCell cell_3_4 = CreateCell(row_3);
cell_3_4.SetText("典型类别");
XWPFTableCell cell_3_5 = CreateCell(row_3);
cell_3_5.SetText("");
XWPFTableRow row_4 = CreateRow(table);//第五行
XWPFTableCell cell_4_0 = CreateCell(row_4);
cell_4_0.SetText("职称");
XWPFTableCell cell_4_1 = CreateCell(row_4);
cell_4_1.SetText("");
XWPFTableCell cell_4_2 = CreateCell(row_4);
cell_4_2.SetText("任现职称时间");
XWPFTableCell cell_4_3 = CreateCell(row_4);
cell_4_3.SetText("");
XWPFTableCell cell_4_4 = CreateCell(row_4);
cell_4_4.SetText("职工状况");
XWPFTableCell cell_4_5 = CreateCell(row_4);
cell_4_5.SetText("");
XWPFTableCell cell_4_6 = CreateCell(row_4);
cell_4_6.SetText("是否干部");
XWPFTableCell cell_4_7 = CreateCell(row_4);
cell_4_7.SetText("");
XWPFTableRow row_5 = CreateRow(table);//第六行
XWPFTableCell cell_5_0 = CreateCell(row_5);
cell_5_0.SetText("毕业院校及专业");
XWPFTableCell cell_5_1 = CreateCell(row_5);
SetColSpan(cell_5_1, 2);
cell_5_1.SetText("");
XWPFTableCell cell_5_2 = CreateCell(row_5);
cell_5_2.SetText("毕业时间");
XWPFTableCell cell_5_3 = CreateCell(row_5);
SetColSpan(cell_5_3, 2);
cell_5_3.SetText("");
XWPFTableCell cell_5_4 = CreateCell(row_5);
cell_5_4.SetText("学位");
XWPFTableCell cell_5_5 = CreateCell(row_5);
cell_5_5.SetText("");
XWPFTableRow row_6 = CreateRow(table);//第七行
XWPFTableCell cell_6_0 = CreateCell(row_6);
cell_6_0.SetText("所获荣誉");
XWPFTableCell cell_6_1 = CreateCell(row_6);
SetColSpan(cell_6_1, 7);
cell_6_1.SetText("");
XWPFTableRow row_7 = CreateRow(table);//第八行
XWPFTableCell cell_7_0 = CreateCell(row_7);
SetColSpan(cell_7_0, 8);
XWPFParagraph aa = cell_7_0.AddParagraph();
aa.Alignment = ParagraphAlignment.CENTER;
XWPFRun aa_r = aa.CreateRun();
aa_r.FontSize = 18;
aa_r.SetTextPosition(20);
aa_r.SetText("个人简介");
XWPFParagraph bb = cell_7_0.AddParagraph();
bb.Alignment = ParagraphAlignment.CENTER;
XWPFRun bb_r = bb.CreateRun();
bb_r.SetText("123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,123123123123123123123123123123123123123123,");
#region
//table.GetRow(0).GetCell(0).SetText("姓名");//第一行
//table.GetRow(0).GetCell(1).SetText("");
//table.GetRow(0).GetCell(2).SetText("性别");
//table.GetRow(0).GetCell(3).SetText("");
//table.GetRow(0).GetCell(4).SetText("民族");
//table.GetRow(0).GetCell(5).SetText("");
//table.GetRow(0).GetCell(6).SetText("出生年月");
//table.GetRow(0).GetCell(7).SetText("");
//table.GetRow(1).GetCell(0).SetText("政治面貌");//第二行
//table.GetRow(1).GetCell(1).SetText("");
//table.GetRow(1).GetCell(2).SetText("籍贯");
//table.GetRow(1).GetCell(3).SetText("");
//table.GetRow(1).GetCell(4).SetText("学历");
//table.GetRow(1).GetCell(5).SetText("");
//table.GetRow(1).GetCell(6).SetText("参加工作时间");
//table.GetRow(1).GetCell(7).SetText("");
//table.GetRow(2).GetCell(0).SetText("所在单位");//第三行
//table.GetRow(2).GetCell(1).SetText("");
//table.GetRow(2).GetCell(2).SetText("所属部门");
//table.GetRow(2).GetCell(3).SetText("");
//table.GetRow(2).GetCell(4).SetText("隶属系统");
//table.GetRow(2).GetCell(5).SetText("");
//table.GetRow(3).GetCell(0).SetText("现任职务");//第四行
//table.GetRow(3).GetCell(1).SetText("");
//table.GetRow(3).GetCell(2).SetText("任现职时间");
//table.GetRow(3).GetCell(3).SetText("");
//table.GetRow(3).GetCell(4).SetText("典型类别");
//table.GetRow(3).GetCell(5).SetText("");
//table.GetRow(4).GetCell(0).SetText("职称");//第五行
//table.GetRow(4).GetCell(1).SetText("");
//table.GetRow(4).GetCell(2).SetText("任现职称时间");
//table.GetRow(4).GetCell(3).SetText("");
//table.GetRow(4).GetCell(4).SetText("职工状况");
//table.GetRow(4).GetCell(5).SetText("");
//table.GetRow(4).GetCell(6).SetText("是否干部");
//table.GetRow(4).GetCell(7).SetText("");
//table.GetRow(5).GetCell(0).SetText("毕业院校及专业");//第六行
//table.GetRow(5).GetCell(1).SetText("");
//table.GetRow(5).GetCell(2).SetText("毕业时间");
//table.GetRow(5).GetCell(3).SetText("");
//table.GetRow(5).GetCell(4).SetText("学位");
//table.GetRow(5).GetCell(5).SetText("");
//table.GetRow(6).GetCell(0).SetText("所获荣誉");//第七行
//table.GetRow(6).GetCell(1).SetText("");
//table.GetRow(7).GetCell(0).SetText("个人简介");//第八行
//table.GetRow(7).GetCell(1).SetText("");
#endregion
//导出
DownloadByOutputStreamBlock(new MemoryStream(ToByte(doc)), "先进个人基本信息--"+DateTime.Now.ToString("yyyyMMddHHmmss")+".docx");
/// <summary>
/// 创建行
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
private XWPFTableRow CreateRow(XWPFTable table)
{
CT_Row m_NewRow = new CT_Row();
XWPFTableRow m_row = new XWPFTableRow(m_NewRow, table);
m_row.GetCTRow().AddNewTrPr().AddNewTrHeight().val = (ulong)426;
table.AddRow(m_row);
return m_row;
}
/// <summary>
/// 创建列
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
private XWPFTableCell CreateCell(XWPFTableRow row)
{
XWPFTableCell cell = row.CreateCell();
CT_Tc cttc = cell.GetCTTc();
CT_TcPr ctpr = cttc.AddNewTcPr();
cttc.GetPList()[0].AddNewPPr().AddNewJc().val = ST_Jc.center;//水平居中
ctpr.AddNewVAlign().val = ST_VerticalJc.center;//垂直居中
ctpr.tcW = new CT_TblWidth();
ctpr.tcW.w = "1200";//默认列宽
ctpr.tcW.type = ST_TblWidth.dxa;
return cell;
}
/// <summary>
/// 合并单元格
/// </summary>
/// <param name="cell"></param>
/// <param name="Span"></param>
private void SetColSpan(XWPFTableCell cell,int Span)
{
CT_Tc cttc = cell.GetCTTc();
CT_TcPr ctpr = cttc.AddNewTcPr();
ctpr.gridSpan = new CT_DecimalNumber();
ctpr.gridSpan.val = Span.ToString();//合并单元格
cttc.GetPList()[0].AddNewPPr().AddNewJc().val = ST_Jc.center;//水平居中
ctpr.AddNewVAlign().val = ST_VerticalJc.center;//垂直居中
}
/// <summary>
/// 设置列宽
/// </summary>
/// <param name="table">表格</param>
/// <param name="ColIndex">列号。从0开始编号</param>
/// <param name="Width">列宽</param>
private void SetColWith(XWPFTable table, int ColIndex, int Width)
{
CT_TcPr m_pr = table.GetRow(0).GetCell(ColIndex).GetCTTc().AddNewTcPr();
m_pr.tcW = new CT_TblWidth();
m_pr.tcW.w = Width.ToString();
m_pr.tcW.type = ST_TblWidth.dxa;
}
/// <summary>
/// 导出文件
/// </summary>
/// <param name="stream">流</param>
/// <param name="fileName">导出文件名</param>
public void DownloadByOutputStreamBlock(System.IO.Stream stream, string fileName)
{
using (stream)
{
//将流的位置设置到开始位置。
stream.Position = 0;
//块大小
long ChunkSize = 102400;
//建立100k的缓冲区
byte[] buffer = new byte[ChunkSize];
//已读字节数
long dataLengthToRead = stream.Length;
Response.ContentType = "application/octet-stream";
Response.AddHeader("Content-Disposition",
string.Format("attachment; filename={0}", HttpUtility.UrlPathEncode(fileName)));
while (dataLengthToRead > 0 && Response.IsClientConnected)
{
int lengthRead = stream.Read(buffer, 0, Convert.ToInt32(ChunkSize));//读取的大小
Response.OutputStream.Write(buffer, 0, lengthRead);
Response.Flush();
Response.Clear();
dataLengthToRead -= lengthRead;
}
Response.Close();
}
}
private byte[] ToByte(XWPFDocument wb)
{
using (MemoryStream ms = new MemoryStream())
{
//XSSFWorkbook即读取.xlsx文件返回的MemoryStream是关闭
//但是可以ToArray(),这是NPOI的bug
wb.Write(ms);
return ms.ToArray();
}
}
