如何使用C＃将新行添加到现有XML模板 [英] How to add new rows to existing XML template using C#

问题描述

我有一个扩展名为.xls的XML文件。我也可以在excel中看到该文件。

I have one XML file with extension .xls.So I can see that file in excel also.

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet">
 <Worksheet ss:Name="Request">
  <Table ss:ExpandedColumnCount="11" ss:ExpandedRowCount="6" x:FullColumns="1"

   x:FullRows="1" ss:StyleID="s62">
<Row ss:AutoFitHeight="0" ss:Height="38.25">
    <Cell ss:StyleID="s82"><Data ss:Type="String">Number</Data><NamedCell

      ss:Name="MARKER_PO_START"/></Cell>
    <Cell ss:StyleID="s82"><Data ss:Type="String">ID</Data></Cell>
    <Cell ss:StyleID="s82"><Data ss:Type="String">Model Number</Data></Cell>
   </Row>
  </Table>
</Worksheet>
<pre lang="xml"><Worksheet ss:Name="Info" ss:Protected="1">
  <Table ss:ExpandedColumnCount="8" ss:ExpandedRowCount="9" x:FullColumns="1"

   x:FullRows="1">
   <Column ss:Width="138"/>
   <Column ss:AutoFitWidth="0" ss:Width="93"/>
   <Column ss:AutoFitWidth="0" ss:Width="89.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="169.5"/>
   <Column ss:AutoFitWidth="0" ss:Width="60"/>
   <Column ss:AutoFitWidth="0" ss:Width="64.5"/>
   <Column ss:AutoFitWidth="0" ss:Width="53.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="70.5"/>
   <Row ss:AutoFitHeight="0" ss:Height="20.25">
    <Cell ss:StyleID="s89"><Data ss:Type="String">Shipment Info:</Data></Cell>
    <Cell ss:StyleID="s90"/>
    <Cell ss:StyleID="s91"/>
    <Cell ss:StyleID="s92"/>
    <Cell ss:StyleID="s92"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
    <Cell ss:StyleID="s79"/>
   </Row>
</Table>
</Worksheet>

< /工作簿>



我想添加新的行在Table元素内部（在Request Woksheet中），以便我可以输入Number，ID等的值。当我在Microsoft Excel中打开这个Xml文件时，输入的值也应该是可见的。请建议如何解决这个问题？

</Workbook>

I want to add new Row inside Table element ( inside Request Woksheet) so that I can enter the values for Number,ID etc.And entered values should also be visible when I open this Xml file in Microsoft Excel.Please suggest how to solve this ?

推荐答案

使用System.IO.P ackaging读取现有的Excel文件并向其添加任何内容。您可以在以下链接中找到一个漂亮的示例：

http：// msdn .microsoft.com / zh-cn / library / bb508943.aspx [ ^ ]

Use System.IO.Packaging to read existing Excel file and add anything to it. You can find a beautiful example in the link below:
http://msdn.microsoft.com/en-us/library/bb508943.aspx[^]

这篇关于如何使用C＃将新行添加到现有XML模板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！