converting xml to ms excel using vb.net ?

7 Jun 2006 10:45 AM

renaissance1983

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

7 Jun 2006 11:06 AM

Cerebrus

renaissance1983 wrote:

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

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

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

7 Jun 2006 12:18 PM

renaissance1983

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

8 Jun 2006 12:00 AM

Cerebrus

renaissance1983 wrote:

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

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