评论

收藏

[办公软件] 用Aspose.Words 从Word文档中提取表格数据

电脑办公 电脑办公 发布于:2021-06-24 13:03 | 阅读数:541 | 评论:0

  对于某些项目,开发人员需要从Word文档中提取数据并导出到数据库。最大的挑战是必须支持现有Word文档。相同格式且带多个数据块的Word文档有成千上万。该文档格式并不是设计来被另一个系统所读取的。这意味着,没有书签、合并字段、从标准指令识别实际数据的方式等。还好,所有输入字段都在表格内,但这些表格也是不同的格式,一些是单行/单元格,另一些则变化多端。我们可以用Aspose.Words来创建和操作Word文档。以C#创建一个类似的表格模型从而稍后当读取文档的时候我们可以用上它。如下所示,你可以看到创建的名为WordDocumentTable的类,带有三个属性:TableID,RowIDColumnID,如之前所说的,我们没有支持TableID/RowIDs,这些属性仅仅暗示着Word文档的位置。开始索引假定为0。
public class WordDocumentTable
{
public WordDocumentTable(int PiTableID)
{ 
    MiTableID = PiTableID;
  }
  public WordDocumentTable(int PiTableID, int PiColumnID)
  { 
    MiTableID = PiTableID; 
    MiColumnID = PiColumnID;
  }
  public WordDocumentTable(int PiTableID, int PiColumnID, int PiRowID)
  { 
    MiTableID = PiTableID; 
    MiColumnID = PiColumnID; 
    MiRowID = PiRowID;
  }
  private int MiTableID = 0;
  public int TableID
  { 
    get { return MiTableID; } 
    set { MiTableID = value; }
  }     
  private int MiRowID = 0;   
  public int RowID
  { 
    get { return MiRowID; } 
    set { MiRowID = value; }
  }
  private int MiColumnID = 0;   
  public int ColumnID
  { 
    get { return MiColumnID; } 
    set { MiColumnID = value; }
  }
  }现在来到提取环节。如下所示,你将看到我想要从文档中读取的表格单元格的集。
private List<WordDocumentTable> WordDocumentTables
{ 
get
{ 
    List&lt;WordDocumentTable&gt; wordDocTable = new List&lt;WordDocumentTable&gt;();   
    //Reads the data from the first Table of the document.   
    wordDocTable.Add(new WordDocumentTable(0));   
    //Reads the data from the second table and its second column.
    //This table has only one row.   
    wordDocTable.Add(new WordDocumentTable(1, 1));   
    //Reads the data from third table, second row and second cell.   
    wordDocTable.Add(new WordDocumentTable(2, 1, 1)); 
    return wordDocTable; 
  }
  }下面是从基于表格、行和单元格的Aspose.Words文档提取数据。
public void ExtractTableData(byte[] PobjData)
{   
using (MemoryStream LobjStream = new MemoryStream(PobjData))
{ 
    Document LobjAsposeDocument = new Document(LobjStream);  
    foreach(WordDocumentTable wordDocTable in WordDocumentTables) 
    {  
      Aspose.Words.Tables.Table table = (Aspose.Words.Tables.Table)
      LobjAsposeDocument.GetChild
      (NodeType.Table, wordDocTable.TableID, true);  
      string cellData = table.Range.Text;
      if (wordDocTable.ColumnID &gt; 0)  
      {   
        if (wordDocTable.RowID == 0)   
        {  
          NodeCollection LobjCells =
          table.GetChildNodes(NodeType.Cell, true);  
          cellData = LobjCells[wordDocTable.ColumnID].ToTxt();
        }   
        else   
        {  
          NodeCollection LobjRows =
          table.GetChildNodes(NodeType.Row, true);  
          cellData = ((Row)(LobjRows[wordDocTable.RowID])).
          Cells[wordDocTable.ColumnID].ToTxt();   
        }  
      }
      Console.WriteLine(String.Format("Data in Table {0},
          Row {1}, Column {2} : {3}",      
                  wordDocTable.TableID,     
                  wordDocTable.RowID,     
                  wordDocTable.ColumnID,     
                  cellData);       
    }
  }
}

关注下面的标签,发现更多相似文章