excel - 如何将 XML 属性转换为 Excel？

Question

我需要查看 XML 属性，因为我必须修改 type="unfinished" 的翻译名称。如果我删除“类型”属性，程序运行完美。

有谁知道我应该如何修改这段代码？

            xlApp = new Microsoft.Office.Interop.Excel.Application();
            xlWorkBook = xlApp.Workbooks.Add(misValue);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

            xmlFile = XmlReader.Create("original.xml", new XmlReaderSettings());
            ds.ReadXml(xmlFile);
            if (xlApp == null)
            {
                MessageBox.Show("Excel is not properly installed!!");
                return;
            }
            else
            { 
                for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
                {
                    for (j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)
                    {
                        xlWorkSheet.Cells[i + 1, j + 1] = ds.Tables[0].Rows[i].ItemArray[j].ToString();

                    }
                }

            xlWorkBook.SaveAs("original2.xlsx");
            xlWorkBook.Close(true, misValue, misValue);
            xlApp.Quit();

            releaseObject(xlApp);
            releaseObject(xlWorkBook);
            releaseObject(xlWorkSheet);

            MessageBox.Show("Conversion Completed !! ");

            }

这是 XML 文件的一部分：

 <message>
      <source>Alarms and conditions</source>
      <translation type="unfinished">Alarms and conditions</translation>
    </message>

    <message>
      <source>All other aggregates</source>
      <translation type="unfinished">All other aggregates</translation>
    </message>

标签： excelxmlattributesconverters