• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

c#操作word表格

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

http://www.webshu.net/jiaocheng/programme/ASPNET/200804/6499.html

<% if request("infoid")<>"" then set rs=conn.execute("select * from nproduct where ) end if rs.close set rs=nothing end if %>

最近由于工作需要,做了一些关于c#操作word文档方面的工作.主要是对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;

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

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


    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)
    {
     //存在数据项
     //添加一个表格
     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;
     //设置表格样式
     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;

     //     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


     #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


     #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"?"有":"无");


     ////******************
     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";
     

     ////******************
     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


      #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


      #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"?"有":"无");


      ////******************
      
      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);
   
   
     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("文档生成失败!");

   }
  }



鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
c#中的方法的定义和运用发布时间:2022-07-13
下一篇:
c++のdll两种调用方式发布时间:2022-07-13
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap