读取Word文档中的表格

        //读取Word文档中的表格
        // DataTable 需要添加引用  using System.Data;
        public static DataTable Run()
        {
            try
            {
                //DataTable 申明DataTable变量，保存从Word获取到的数据
                DataTable dt = new DataTable();
                DataColumn dc1 = new DataColumn("One", Type.GetType("System.String"));
                DataColumn dc2 = new DataColumn("TwoText", Type.GetType("System.String"));
                DataColumn dc3 = new DataColumn("TwoHtml", Type.GetType("System.String"));
                dt.Columns.Add(dc1);
                dt.Columns.Add(dc2);
                dt.Columns.Add(dc3);

                int number = 1;//记录有数据的文档数目
                int troublecount = 0;//记录没有数据的文档数目

                string Content = "";//申明变量，保存word文档内容
                //获取目录下的所有文件
                //DirectoryInfo  FileInfo  需要添加引用  using System.IO;
                DirectoryInfo dir = new DirectoryInfo("E:/20190917");
                FileInfo[] fileList = dir.GetFiles();
                foreach (var item in fileList)
                {
                    object fileName = item.FullName;
                    object confirmCovert = false;
                    //判断文档类型是否为word文档
                    if (item.Extension.ToUpper() == ".DOC" || item.Extension.ToUpper() == ".DOCX")
                    {
                        //获取word文档内容
                        //Application  Document需要添加引用   using Microsoft.Office.Interop.Word;
                        Application app = new Application();
                        Document doc = null;

                        doc = app.Documents.Open(ref fileName, ref confirmCovert);
                        app.Visible = false;
                        Content = doc.Content.Text;

                        string[] arr = Content.Split('
');
                        if (arr.Count() < 2)
                        {
                            troublecount++;
                            Console.WriteLine("文件{0}中没有正文！！！！！！！！。{1}", fileName, troublecount);
                            continue;
                        }
                        else
                        {
                            //抓取表格内容
                            DataRow dr = dt.NewRow();
                            dr["One"] = arr[0].ToString();
                            int contentIndex = Content.IndexOf("表格显示：");
                            List<string> lst = GetContent(doc, Content, contentIndex);

                            dr["TwoText"] = lst[0].ToString();
                            dr["TwoHtml"] = lst[1].ToString();
                            dt.Rows.Add(dr);

                            number++;
                        }

                        doc.Close();
                        app.Quit();

                    }
                    WriteOuputInformation(string.Format("{0}:文档已经存入数据库。{1}", fileName, number));
                }
                Console.WriteLine("所有文件已读取完毕,共读取了{0}条数据,没有数据的Word文档总条数为{1}", number, troublecount);
                return dt;
            }
            catch (Exception exp)
            {
                WriteErrorInformation(string.Format("Exception: {0}", exp.Message));
                return null;
            }
        }

#region[获取表格纯文本内容和富文本内容]
        static List<string> GetContent(Document doc, string Content, int contentIndex)
        {
            List<string> lst = new List<string>();
            string contentText = Content.Substring(contentIndex + 6);
            string contentHtml = contentText;

            int R = 0;//保存行索引
            int C = 0;//保存列索引
            //表格格式
            if (doc.Tables.Count > 0)
            {
                string text = contentText;
                //遍历<table>
                for (int i = 1; i <= doc.Tables.Count; i++)
                {
                    //读取到word文档中table的内容
                    string wordtable = doc.Tables[i].Range.Text;
                    string htmltable = "";
                    htmltable += "<table cellspacing='0' bordercolor='black' border='1' cellpadding='5' text-align='center'>";
                    //遍历行
                    for (int row = 1; row <= doc.Tables[i].Rows.Count; row++)
                    {
                        htmltable += "<tr>";
                        //遍历列
                        for (int column = 1; column <= doc.Tables[i].Columns.Count; column++)
                        {
                            htmltable += "<td>";
                            //R = getTableRowIndex(row, column, doc, i);
                            //C = getTablecolumnIndex(row, column, doc, i);
                            //htmltable += doc.Tables[i].Cell(R, C).Range.Text.Replace("
", "").Replace("a", "");
                            R = getTableRowIndex(row, column, doc, i);
                            C = getTablecolumnIndex(row, column, doc, i);
                            htmltable += doc.Tables[i].Cell(row, column).Range.Text.Replace("
", "").Replace("a", "");
                            htmltable += "</td>";
                            contentText += "  ";

                        }
                        htmltable += "</tr>";
                    }
                    htmltable += "</table>";
                    contentHtml = contentHtml.Replace(wordtable, htmltable);
                }
                contentHtml = "<p>" + contentHtml;
                contentHtml = contentHtml.Replace("
", "</p><p>");
                contentHtml += "</p>";
            }
            else//文本格式
            {
                contentText = Content.Substring(contentIndex + 6);
                contentHtml = "<p>";
                contentHtml += contentText;
                contentHtml = contentHtml.Replace("
", "</p><p>");
                contentHtml += "</p>";
            }
            lst.Add(contentText);
            lst.Add(contentHtml);
            return lst;
        }
        #endregion

#region[操作后给出提示信息]
        static void WriteErrorInformation(string errorInformation)
        {
            Console.ForegroundColor = ConsoleColor.Red;
            Console.WriteLine("Error: " + errorInformation);
            Console.ForegroundColor = ConsoleColor.Gray;
        }
        static void WriteOuputInformation(string outputInformation)
        {
            Console.ForegroundColor = ConsoleColor.DarkGreen;
            Console.WriteLine("-->>" + outputInformation);
            Console.ForegroundColor = ConsoleColor.Gray;
        }
        #endregion