converting xml to ms excel using vb.net ?

[renaissance1983]

i need to convert xml file to ms excel worksheet using vb.net...

[Cerebrus]

Re: converting xml to ms excel using vb.net ?


renaissance1983 wrote:
[color=blue]
> i need to convert xml file to ms excel worksheet using vb.net...[/color]

Try this : (and let us know if it works !)

<http://www.a1vbcode.co m/snippet-3404.asp>

[renaissance1983]

Re: converting xml to ms excel using vb.net ?

what if we directly save the xml file after using OpenXml as xls, does
it create any issues?

[Cerebrus]

Re: converting xml to ms excel using vb.net ?


renaissance1983 wrote:[color=blue]
> what if we directly save the xml file after using OpenXml as xls, does
> it create any issues?[/color]

Try renaming an existing .xml file to .xls in Windows Explorer. See if
it opens within MS Excel ! That'll answer your question... ;-)