English 中文(简体)
以表形式查看XML数据[已关闭]
原标题:View XML data as a table [closed]
  • 时间:2010-10-12 18:45:25
  •  标签:
  • c#
  • sql
  • xml
  • xsd

我们不允许为书籍、工具、软件库等寻求推荐的问题。你可以编辑这个问题,以便用事实和引文来回答。

Closed 2 years ago.

有没有一种方法可以使用Visual Studio通过对其应用适当的XSD来查看表格结构中的XML数据?

有没有其他工具可以方便地用于此目的?附言:我需要这个一次性使用。

最佳回答

如奥德所述,使用Excel查看XML文档。

如果您使用的是Excel 2003,请单击数据->;XML->;导入,然后选择要查看的XML。Excel将询问您从哪个单元格开始导入,然后用XML数据填充电子表格。

问题回答

Excel具有令人惊讶的良好XML支持。

如果需要,它甚至会在内部生成XSD。

XMLSpy 2011。可下载功能齐全的30天试用版此处

使用FOR XML功能,您可以在SQL server中很容易地做到这一点。

根据我对这些问题的回答对代码进行简单的改编就足够了:

我不确定这是否能回答你的问题,但我很幸运地在Firefox中打开了xml文件,将结果复制并粘贴到记事本中,然后将文本文件作为制表符分隔的文件导入Excel。

也许这是一种更简单的方法,但它对我有效。





相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签