使用C 讀取Word表格數(shù)據(jù)

1、讀取 Word 表格數(shù)據(jù)的方法/將讀取Word表格封裝與方法中。public string ReadWord(string fileName, int rowIndex, int colIndex) ApplicationClass cls = null;Document doc = null;Table table = null;object missing = Missing.Value;object path = fileName; cls = new ApplicationClass();try(ref path, ref missing, ref missing, ref missi

2、ng,ref missing, ref missing, ref missing, ref missing,ref missing, ref missing, ref missing, ref missing,ref missing, ref missing, ref missing, ref missing);table = doc.Tables1;text = text.Substring(0, text.Length - 2);/ 去除尾部的 markreturn text;catch (Exception ex)return ex.Message;finallyif (doc != n

3、ull)doc.Close(ref missing, ref missing, ref missing);cls.Quit(ref missing, ref missing, ref missing);這個(gè)方法用于讀取 Word 表格中某個(gè)單元格的數(shù)據(jù)。其中的參數(shù)分別為文件名(包括路徑)，行 號，列號。class WordTableReadprivate string fileName;private ApplicationClass cls = null;private Document doc = null;private Table table = null;private object

4、 missing = Missing.Value;/Word 是否處于打開狀態(tài)private bool openState;/*/ / 自定義構(gòu)造方法/ / 包含路徑的文件名 public WordTableRead(string fileName)this.fileName = fileName;/*/ / 打開Word文檔/ public void Open()object path = fileName;cls = new ApplicationClass();try(ref path, ref missing, ref missing, ref missing, ref missing

5、, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);openState = true;catchopenState = false;/*/ / 返回指定單元格中的數(shù)據(jù)/ / 表格號 / 行號 / 列號 / 單元格中的數(shù)據(jù) public string ReadWord(int tableIndex, int rowIndex, int colIndex) /Give the value to the tow Int32 params.tryif (openState = true)table = doc.TablestableIndex;text = text.Substring(0, text.Length - 2);/ 去除尾部的markreturn text;elsereturn ;catchreturn Error;/*/ / 關(guān)閉Word文檔/ public void Close()if (openState = true)if (doc != null)doc.C