最近由于工作需要,做了一些关于C#操作Word表格文档方面的工作.主要是是C#操作Word表格的操作,以下是部分代码,关于操作不规则表格的.那么让我们来看看具体的实施吧:
- using System;
- using System.Collections;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Web;
- using System.Web.SessionState;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.HtmlControls;
- using System.Configuration;
- using System.IO;
- using System.Reflection;
- using System.Runtime.InteropServices ;
- using System.Threading;
- //C#操作Word表格
- public void MakeMyTable(DataTable DT,string strFilePath)
- {
- string strEnd = this.txtEnd.Text.Trim().ToString();
- string strStart = this.txtStart.Text.Trim().ToString();
- //生成文档分页中的起始和终止页
- string strSign = "("+strStart + "-" + strEnd + ")";
- //杀掉所有word进程以保证速度
- //KillWordProcess();
- object Nothing = System.Reflection.Missing.Value;
- object missing = System.Reflection.Missing.Value;
- object filename= strFilePath;
- Word.Application wordApp=new Word.ApplicationClass();
- Word.Document wordDoc=wordApp.Documents.Add(
- ref Nothing,ref Nothing,ref Nothing,ref Nothing);
- //C#操作Word表格
- try
- {
- //生成过程中屏蔽返回按扭,不允许中途停止
- Button2.Enabled = false;
- #region 生成文档
- //设置文档宽度
- wordApp.Selection.PageSetup.LeftMargin =
- wordApp.CentimetersToPoints(float.Parse("2"));
- wordApp.ActiveWindow.ActivePane.HorizontalPercentScrolled = 11 ;
- wordApp.Selection.PageSetup.RightMargin =
- wordApp.CentimetersToPoints(float.Parse("2"));
- Object start = Type.Missing;
- Object end = Type.Missing;
- Object unit = Type.Missing;
- Object count = Type.Missing;
- wordDoc.Range(ref start, ref end).
- Delete(ref unit, ref count);
- //C#操作Word表格
- object rng = Type.Missing;
- string strInfo = this.txtNameCh.
- Text.ToString()+"明细表"+strSign+"\r\n";
- start = 0;
- end = 0;
- wordDoc.Range(ref start, ref end).
- InsertBefore(strInfo);
- wordDoc.Range(ref start, ref end).
- Font.Name = "Verdana";
- wordDoc.Range(ref start, ref end).
- Font.Size = 20;
- wordDoc.Range(ref start, ref end).
- ParagraphFormat.Alignment = Word.WdParagraphAlignment.
- wdAlignParagraphCenter;
- start = 8;
- end = strInfo.Length;
- wordDoc.Range(ref start, ref end).
- InsertParagraphAfter();//插入回车
- if(DT.Rows.Count>0)
- {
- //C#操作Word表格之存在数据项
- //添加一个表格
- object missingValue = Type.Missing;
- object location = strInfo.Length;
- //注:若location超过已有字符的长度将会出错。一定要比"明细表"串多一个字符
- Word.Range rng2 = wordDoc.Range(ref location, ref location);
- wordDoc.Tables.Add(rng2, 13, 6, ref missingValue, ref missingValue);
- wordDoc.Tables.Item(1).Rows.HeightRule =
- Word.WdRowHeightRule.wdRowHeightAtLeast;
- wordDoc.Tables.Item(1).Rows.Height = wordApp.
- CentimetersToPoints(float.Parse("0.8"));
- wordDoc.Tables.Item(1).Range.Font.Size = 10;
- wordDoc.Tables.Item(1).Range.Font.Name = "宋体";
- wordDoc.Tables.Item(1).Range.ParagraphFormat.Alignment =
- Word.WdParagraphAlignment.wdAlignParagraphCenter;
- wordDoc.Tables.Item(1).Range.Cells.VerticalAlignment =
- Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter;
- //C#操作Word表格之设置表格样式
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderLeft).LineStyle =
- Word.WdLineStyle.wdLineStyleSingle;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderLeft).LineWidth =
- Word.WdLineWidth.wdLineWidth050pt;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderLeft).Color =
- Word.WdColor.wdColorAutomatic;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderTop).LineStyle =
- Word.WdLineStyle.wdLineStyleSingle;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderTop).LineWidth =
- Word.WdLineWidth.wdLineWidth050pt;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderTop).Color =
- Word.WdColor.wdColorAutomatic;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderBottom).LineStyle =
- Word.WdLineStyle.wdLineStyleSingle;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderBottom).LineWidth =
- Word.WdLineWidth.wdLineWidth050pt;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderBottom).Color =
- Word.WdColor.wdColorAutomatic;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderHorizontal).LineStyle =
- Word.WdLineStyle.wdLineStyleSingle;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderHorizontal).LineWidth =
- Word.WdLineWidth.wdLineWidth050pt;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderHorizontal).Color =
- Word.WdColor.wdColorAutomatic;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderVertical).LineStyle =
- Word.WdLineStyle.wdLineStyleSingle;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderVertical).LineWidth =
- Word.WdLineWidth.wdLineWidth050pt;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderVertical).Color =
- Word.WdColor.wdColorAutomatic;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderRight).LineStyle =
- Word.WdLineStyle.wdLineStyleSingle;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderRight).LineWidth =
- Word.WdLineWidth.wdLineWidth050pt;
- wordDoc.Tables.Item(1).Borders.
- Item(Word.WdBorderType.wdBorderRight).Color =
- Word.WdColor.wdColorAutomatic;
- //C#操作Word表格
- //wordDoc.Tables.Item(k).Borders.
- Item(Word.WdBorderType.wdBorderDiagonalDown).
- LineStyle = Word.WdLineStyle.wdLineStyleSingle;
- //wordDoc.Tables.Item(k).Borders.
- Item(Word.WdBorderType.wdBorderDiagonalDown).
- LineWidth = Word.WdLineWidth.wdLineWidth050pt;
- //wordDoc.Tables.Item(k).Borders.
- Item(Word.WdBorderType.wdBorderDiagonalDown).
- Color = Word.WdColor.wdColorAutomatic;
- //第一行显示
- wordDoc.Tables.Item(1).Cell(1,2).
- Merge(wordDoc.Tables.Item(1).Cell(1,3));
- wordDoc.Tables.Item(1).Cell(1,4).
- Merge(wordDoc.Tables.Item(1).Cell(1,5));
- //第二行显示
- wordDoc.Tables.Item(1).Cell(2,5).
- Merge(wordDoc.Tables.Item(1).Cell(2,6));
- wordDoc.Tables.Item(1).Cell(1,4).
- Merge(wordDoc.Tables.Item(1).Cell(2,5));
- #region 插入数据行
- wordDoc.Tables.Item(1).Cell(1, 1).Range.Text = "cell11";
- //wordDoc.Tables.Item(k).Cell(1, 2).Range.Text =
- DT.Rows[i]["cell11"].ToString();
- ////******************
- wordDoc.Tables.Item(1).Cell(1, 3).Range.Text = "cell13";
- //wordDoc.Tables.Item(k).Cell(1, 4).Range.Text =
- DT.Rows[i]["cell13"].ToString();
- ////******************
- wordDoc.Tables.Item(1).Cell(2, 1).Range.Text = "cell21";
- //wordDoc.Tables.Item(k).Cell(2, 2).Range.Text =
- DT.Rows[i]["cell21"].ToString();
- ////******************
- wordDoc.Tables.Item(1).Cell(2, 3).Range.Text = "cell23";
- //wordDoc.Tables.Item(k).Cell(2, 4).Range.Text =
- DT.Rows[i]["cell23"].ToString();
- #endregion
- //C#操作Word表格
- #region 第三行显示
- wordDoc.Tables.Item(1).Cell(3,2).
- Merge(wordDoc.Tables.Item(1).Cell(3,3));
- wordDoc.Tables.Item(1).Cell(3,2).
- Merge(wordDoc.Tables.Item(1).Cell(3,3));
- ////******************
- wordDoc.Tables.Item(1).Cell(3, 1).Range.Text = "cell31";
- ////******************
- wordDoc.Tables.Item(1).Cell(3, 3).Range.Text = "cell33";
- #endregion
- #region 第五行显示
- wordDoc.Tables.Item(1).Cell(5,2).
- Merge(wordDoc.Tables.Item(1).Cell(5,3));
- wordDoc.Tables.Item(1).Cell(5,2).
- Merge(wordDoc.Tables.Item(1).Cell(5,3));
- wordDoc.Tables.Item(1).Cell(5,2).
- Merge(wordDoc.Tables.Item(1).Cell(5,3));
- wordDoc.Tables.Item(1).Cell(5,2).
- Merge(wordDoc.Tables.Item(1).Cell(5,3));
- #endregion
- #region 第四行显示
- ////******************
- wordDoc.Tables.Item(1).Cell(4, 1).Range.Text = "cell41";
- ////******************
- wordDoc.Tables.Item(1).Cell(4, 3).Range.Text = "cell43";
- ////******************
- wordDoc.Tables.Item(1).Cell(4, 5).Range.Text = "cell45";
- #endregion
- //C#操作Word表格
- #region 第六行显示
- wordDoc.Tables.Item(1).Cell(6,2).
- Merge(wordDoc.Tables.Item(1).Cell(6,3));
- wordDoc.Tables.Item(1).Cell(6,2).
- Merge(wordDoc.Tables.Item(1).Cell(6,3));
- wordDoc.Tables.Item(1).Cell(6,2).
- Merge(wordDoc.Tables.Item(1).Cell(6,3));
- wordDoc.Tables.Item(1).Cell(6,2).
- Merge(wordDoc.Tables.Item(1).Cell(6,3));
- ////******************
- wordDoc.Tables.Item(1).Cell(5, 1).
- Range.Text = "cell51";
- wordDoc.Tables.Item(1).Cell(5, 2).
- Range.ParagraphFormat.Alignment =
- Word.WdParagraphAlignment.wdAlignParagraphLeft;
- ////******************
- wordDoc.Tables.Item(1).Cell(6, 1).Range.Text = "cdll61";
- wordDoc.Tables.Item(1).Cell(6, 2).
- Range.ParagraphFormat.Alignment =
- Word.WdParagraphAlignment.wdAlignParagraphLeft;
- #endregion
- #region 第七行显示
- wordDoc.Tables.Item(1).Cell(7,2).
- Merge(wordDoc.Tables.Item(1).Cell(7,3));
- wordDoc.Tables.Item(1).Cell(7,2).
- Merge(wordDoc.Tables.Item(1).Cell(7,3));
- wordDoc.Tables.Item(1).Cell(7,2).
- Merge(wordDoc.Tables.Item(1).Cell(7,3));
- wordDoc.Tables.Item(1).Cell(7,2).
- Merge(wordDoc.Tables.Item(1).Cell(7,3));
- ////******************
- wordDoc.Tables.Item(1).Cell(7, 1).Range.Text = "cell71";
- wordDoc.Tables.Item(1).Cell(7, 2).Range.
- ParagraphFormat.Alignment = Word.WdParagraphAlignment.
- wdAlignParagraphLeft;
- #endregion
- #region 第八行显示
- wordDoc.Tables.Item(1).Cell(8,1).
- Merge(wordDoc.Tables.Item(1).Cell(8,2));
- wordDoc.Tables.Item(1).Cell(8,2).
- Merge(wordDoc.Tables.Item(1).Cell(8,3));
- wordDoc.Tables.Item(1).Cell(8,2).
- Merge(wordDoc.Tables.Item(1).Cell(8,3));
- wordDoc.Tables.Item(1).Cell(8,2).
- Merge(wordDoc.Tables.Item(1).Cell(8,3));
- #endregion
- #region 第九行显示
- wordDoc.Tables.Item(1).Cell(9,1).Merge(wordDoc.Tables.Item(1).Cell(9,2));
- wordDoc.Tables.Item(1).Cell(9,3).Merge(wordDoc.Tables.Item(1).Cell(9,4));
- ////******************
- wordDoc.Tables.Item(1).Cell(9, 1).Range.Text = "cell91";
- //wordDoc.Tables.Item(k).Cell(9, 2).Range.Text =
- (DT.Rows[i]["cell91"].ToString()=="1"?"有":"无");
- //C#操作Word表格
- ////******************
- wordDoc.Tables.Item(1).Cell(9, 3).Range.Text = "cell93";
- #endregion
- #region 第十行显示
- wordDoc.Tables.Item(1).Cell(10,1).Merge(wordDoc.Tables.Item(1).Cell(10,2));
- wordDoc.Tables.Item(1).Cell(10,3).Merge(wordDoc.Tables.Item(1).Cell(10,4));
- ////******************
- wordDoc.Tables.Item(1).Cell(10, 1).Range.Text = "cell101";
- ////******************
- wordDoc.Tables.Item(1).Cell(10, 3).Range.Text = "cdll103";
- //wordDoc.Tables.Item(k).Cell(10, 4).Range.Text =
- (DT.Rows[i]["Label"].ToString()=="1"?"有":"无");
- #endregion
- #region 第十一行显示
- wordDoc.Tables.Item(1).Cell(11,1).
- Merge(wordDoc.Tables.Item(1).Cell(11,2));
- wordDoc.Tables.Item(1).Cell(11,3).
- Merge(wordDoc.Tables.Item(1).Cell(11,4));
- ////******************
- wordDoc.Tables.Item(1).Cell(11, 1).Range.Text = "cell111";
- ////******************
- wordDoc.Tables.Item(1).Cell(11, 3).Range.Text = "cell113";
- #endregion
- #region 第十二行显示
- wordDoc.Tables.Item(1).Cell(12,1).
- Merge(wordDoc.Tables.Item(1).Cell(12,2));
- wordDoc.Tables.Item(1).Cell(12,3).
- Merge(wordDoc.Tables.Item(1).Cell(12,4));
- ////******************
- wordDoc.Tables.Item(1).Cell(12, 1).Range.Text = "cell121";
- ////******************
- wordDoc.Tables.Item(1).Cell(12, 3).Range.Text = "cell123";
- #endregion
- #region 第十三行显示
- wordDoc.Tables.Item(1).Cell(13,1).
- Merge(wordDoc.Tables.Item(1).Cell(13,2));
- wordDoc.Tables.Item(1).Cell(13,3).
- Merge(wordDoc.Tables.Item(1).Cell(13,4));
- ////******************
- wordDoc.Tables.Item(1).Cell(13, 1).Range.Text = "cell131";
- //C#操作Word表格
- ////******************
- wordDoc.Tables.Item(1).Cell(13, 3).Range.Text = "cell133";
- #endregion
- wordDoc.Tables.Item(1).Select();
- wordApp.Application.Selection.Cut();
- //重新成声所有表
- for(int i = 0; i<=DT.Rows.Count-1;i++)
- {
- wordApp.Application.Selection.Paste();
- int k = i+1;
- #region 更新数据
- #region 插入数据行
- wordDoc.Tables.Item(k).Cell(1, 2).Range.Text =
- DT.Rows[i]["1"].ToString();
- ////******************
- wordDoc.Tables.Item(k).Cell(1, 4).Range.Text =
- DT.Rows[i]["2"].ToString();
- ////******************
- wordDoc.Tables.Item(k).Cell(2, 2).Range.Text =
- DT.Rows[i]["3"].ToString();
- ////******************
- wordDoc.Tables.Item(k).Cell(2, 4).Range.Text =
- DT.Rows[i]["4"].ToString();
- #endregion
- //C#操作Word表格
- #region 第三行显示
- ////******************
- wordDoc.Tables.Item(k).Cell(3, 2).Range.Text =
- DT.Rows[i]["5"].ToString();
- ////******************
- wordDoc.Tables.Item(k).Cell(3, 4).Range.Text =
- DT.Rows[i]["6"].ToString();
- #endregion
- #region 第五行显示
- ////******************
- wordDoc.Tables.Item(k).Cell(5, 2).Range.Text = DT.Rows[i]["7"].ToString();
- wordDoc.Tables.Item(k).Cell(5, 2).Range.ParagraphFormat
- .Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
- #endregion
- #region 第四行显示
- ////******************
- wordDoc.Tables.Item(k).Cell(4, 2).Range.Text = DT.Rows[i]["8"].ToString();
- ////******************
- wordDoc.Tables.Item(k).Cell(4, 4).Range.Text = DT.Rows[i]["9"].ToString();
- ////******************
- wordDoc.Tables.Item(k).Cell(4, 6).Range.Text = DT.Rows[i]["0"].ToString();
- #endregion
- #region 第六行显示
- ////******************
- wordDoc.Tables.Item(k).Cell(6, 2).Range.Text =
- DT.Rows[i]["11"].ToString();
- wordDoc.Tables.Item(k).Cell(6, 2).Range.ParagraphFormat
- .Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
- #endregion
- //C#操作Word表格
- #region 第七行显示
- ////******************
- wordDoc.Tables.Item(k).Cell(7, 2).Range.
- Text = DT.Rows[i]["12"].ToString();
- wordDoc.Tables.Item(k).Cell(7, 2).Range.
- ParagraphFormat.Alignment = Word.WdParagraphAlignment.
- wdAlignParagraphLeft;
- #endregion
- #region 第八行显示
- ////******************
- string strTechlevel = DT.Rows[i]["Level"].ToString();
- string returnTechlevel = "";
- switch(strTechlevel)
- {
- case "1":
- returnTechlevel = "Level1";
- break;
- case "2":
- returnTechlevel = "Level2";
- break;
- case "3":
- returnTechlevel = "Level3";
- break;
- case "0":
- returnTechlevel = "Level4";
- break;
- default:
- returnTechlevel = "Level5";
- break;
- }
- wordDoc.Tables.Item(k).Cell(8, 2).
- Range.Text = returnTechlevel;
- #endregion
- #region 第九行显示
- ////******************
- wordDoc.Tables.Item(k).Cell(9, 2).Range.Text =
- (DT.Rows[i]["14"].ToString()=="1"?"有":"无");
- //C#操作Word表格
- ////******************
- wordDoc.Tables.Item(k).Cell(9, 4).Range.Text =
- (DT.Rows[i]["15"].ToString()=="1"?"是":"否");
- #endregion
- #region 第十行显示
- ////******************
- wordDoc.Tables.Item(k).Cell(10, 2).Range.Text =
- (DT.Rows[i]["16"].ToString()=="1"?"有":"无");
- ////******************
- wordDoc.Tables.Item(k).Cell(10, 4).Range.Text =
- (DT.Rows[i]["17"].ToString()=="1"?"有":"无");
- #endregion
- #region 第十一行显示
- ////******************
- wordDoc.Tables.Item(k).Cell(11, 2).Range.Text =
- (DT.Rows[i]["18"].ToString()=="1"?"是":"否");
- ////******************
- wordDoc.Tables.Item(k).Cell(11, 4).Range.Text =
- (DT.Rows[i]["19"].ToString()=="1"?"是":"否");
- #endregion
- #region 第十二行显示
- ////******************
- wordDoc.Tables.Item(k).Cell(12, 2).Range.Text =
- (DT.Rows[i]["20"].ToString()=="1"?"是":"否");
- ////******************
- wordDoc.Tables.Item(k).Cell(12, 4).Range.Text =
- (DT.Rows[i]["21"].ToString()=="1"?"是":"否");
- #endregion
- #region 第十三行显示
- wordDoc.Tables.Item(k).Cell(13, 2).Range.Text =
- (DT.Rows[i]["22"].ToString()=="1"?"是":"否");
- ////******************
- wordDoc.Tables.Item(k).Cell(13, 4).Range.Text =
- (DT.Rows[i]["23"].ToString()=="1"?"是":"否");
- #endregion
- #endregion
- //插入分页
- if(i!=DT.Rows.Count-1)
- {
- object mymissing = System.Reflection.Missing.Value;
- object myunit = Word.WdUnits.wdStory;
- wordApp.Selection.EndKey(ref myunit,ref mymissing);
- object pBreak= (int)Word.WdBreakType.wdPageBreak;
- wordApp.Selection.InsertBreak( ref pBreak );
- }
- }
- wordDoc.SaveAs(ref filename,
- ref missing,ref missing, ref missing,
- ref missing,ref missing,ref missing,
- ref missing,ref missing,ref missing, ref missing);
- //C#操作Word表格
- wordDoc.Close(ref Nothing, ref Nothing, ref Nothing);
- wordApp.Quit(ref Nothing, ref Nothing, ref Nothing);
- if ( wordDoc != null )
- {
- System.Runtime.InteropServices.Marshal.
- ReleaseComObject(wordDoc);
- wordDoc = null;
- }
- if ( wordApp != null )
- {
- System.Runtime.InteropServices.Marshal.
- ReleaseComObject(wordApp);
- wordApp = null;
- }
- GC.Collect();
- //KillWordProcess();
- string strUrl = "MakeWordFile.aspx?username="
- +Request.QueryString["username"].ToString();
- utility.ShowPopMessage("文档生成完毕!",strUrl);
- }
- else
- {
- utility.ShowPopMessage("无任何数据!");
- }
- #endregion
- }
- catch
- {
- wordDoc.Close(ref Nothing, ref Nothing, ref Nothing);
- wordApp.Quit(ref Nothing, ref Nothing, ref Nothing);
- if ( wordDoc != null )
- {
- System.Runtime.InteropServices.Marshal.
- ReleaseComObject(wordDoc);
- wordDoc = null;
- }
- if ( wordApp != null )
- {
- System.Runtime.InteropServices.Marshal.
- ReleaseComObject(wordApp);
- wordApp = null;
- }
- GC.Collect();
- utility.ShowPopMessage("文档生成失败!");
- }
- }
C#操作Word表格的实现实例就向你介绍到这里,希望对你学习和了解C#操作Word表格有所帮助。
【编辑推荐】