How to read XML file and write it into Excel by using VB.Net 2.0
-
hello dotnetians, I'v to do an application through which a xml file has to be read,and to be written into excel, i'm using vb.net 2.0, as i'm freasher so do'nt know how to proceed, So, providing any code(badly needed),or any other help (ASAP) would be appreciated . thanx..........Be_Aman :omg:
-
hello dotnetians, I'v to do an application through which a xml file has to be read,and to be written into excel, i'm using vb.net 2.0, as i'm freasher so do'nt know how to proceed, So, providing any code(badly needed),or any other help (ASAP) would be appreciated . thanx..........Be_Aman :omg:
Noone is going to write the code for you. You have to write it yourself and when you get stuck, you can ask specific questions. Excel 2003 and above will already import XML data without any code from you. All you have to do is File, Open... But, if you have to write the code to do this, you'll need to brush up on reading an XML file, parsing the data, and doing Excel Interop. There are various ways of reading an XML file. If the number of records is not known, but can be large, then an XmlReader[^] would probably be appropriate. There's tons of example of doing Excel Interop on the web. The problem is the Excel object model isn't exactly the easiest thing to learn. All you have to do is Google for "vb.net excel interop[^]".
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007