使用VB.NET正则表达式删除Excel XML转换

Question

我在已从Excel工作表转换为XML的文件中显示了以下行：

 <Worksheet ss:Name="Sheet1">
  <Names>
   <NamedRange ss:Name="Print_Area" ss:RefersTo="=Sheet1!R30C1:R8642C15"/>
  </Names>
  <Table ss:ExpandedColumnCount="14" ss:ExpandedRowCount="8655" x:FullColumns="1"
   x:FullRows="1" ss:StyleID="s16">
   <Column ss:Index="2" ss:StyleID="s16" ss:AutoFitWidth="0" ss:Width="41.25"/>
   <Column ss:StyleID="s16" ss:AutoFitWidth="0" ss:Width="36"/>
   <Column ss:StyleID="s16" ss:AutoFitWidth="0" ss:Width="35.25"/>
   <Column ss:StyleID="s16" ss:AutoFitWidth="0" ss:Width="38.25" ss:Span="1"/>
   <Column ss:Index="8" ss:StyleID="s16" ss:AutoFitWidth="0" ss:Width="31.5"/>
   <Column ss:Index="11" ss:StyleID="s16" ss:AutoFitWidth="0" ss:Width="30"/>
   <Column ss:StyleID="s16" ss:AutoFitWidth="0" ss:Width="33.75"/>
   <Column ss:StyleID="s16" ss:AutoFitWidth="0" ss:Width="28.5"/>
   <Row ss:StyleID="s18">
    <Cell ss:StyleID="s17"><Data ss:Type="String">UNITED STATES</Data></Cell>
    <Cell ss:StyleID="s17"/>
    <Cell ss:StyleID="s17"/>
    <Cell ss:StyleID="s17"/>
    <Cell ss:StyleID="s17"/>
    <Cell ss:StyleID="s17"/>
    <Cell ss:StyleID="s17"/>
   </Row>

我只尝试删除<Column .. />行。我“认为”我已经很好地处理了VB.NET中的正则表达式，但我似乎无法与这几行相匹配。我尝试了以下匹配字符串：

'Using (RegexOptions.Multiline)
Private Const Column_MatchExpression As String = "^[\s]*<Column[\s\S]+$"
Private Const Column_MatchExpression As String = "   <Column[\s\S]+$"
Private Const Column_MatchExpression As String = "^   <Column[\s\S]+$"
Private Const Column_MatchExpression As String = "^[\s]+<Column[\s\w\W]+$"

任何关于这个问题的想法都将不胜感激。

Answer 1

关于

"^\s*<Column.*/>\s*$"

Answer 2

\<Column[^>]*\>

应该行得通