如何将XML文件转换为一个Excel工作表 [英] How to Convert XML Files into one Excel Sheet

问题描述

嘿，我做了很多尝试将XML文件转换为Excel工作表，但是我很无助.
我给了一个包含许多XML文件的文件夹.
XML文件具有相同的标头，只是该文件在不同的日期记录.
我还必须使用C#4.0将整个文件转换为一个excel工作表，因为我也有Silverlight4.
请指导我...​​.

Hey I tried a lot to convert XML file into Excel sheet But I m helpless.
I have given a folder which are having many XML files.
That XML files are having same headers just that file are recorded on diffrent date.
I have to convert that whole files into one excel sheet with using C# 4.0 as I have Silverlight 4 also.
Please guide me....

推荐答案

使用XMLClassObjects和ExcelObjects打开所有xml文件并将其写入一个目标excel文件中.
希望以下链接会有用

使用C#将数据写入Excel [

Using XMLClassObjects and ExcelObjects open all xml files and write it in to one destination excel file.

Hope the below links will be useful

Write Data to Excel using C#[^]

这篇关于如何将XML文件转换为一个Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！