By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,657 Members | 1,045 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,657 IT Pros & Developers. It's quick & easy.

how do you read in data from excel spreadsheet for xml

P: n/a
i need to read the data in a spreadsheet and use the data for attribute to
put into xml file. i search the web but all the example that i see is to
create macro by VBA.

can someone give me an example on reading the data on a spreadsheet?

let's say i have a spreadsheet with the following data i need the name,
address and type.

Name Address Type File ENC SUBNET
AHU-1 1 22 C:\TEST.XML 1 1
AHU-2 2 22 C:\TEST.XML 1 1
AHU-3 3 22 C:\TEST.XML 1 1
AHU-4 4 22 C:\TEST.XML 1 1
AHU-5 5 22 C:\TEST.XML 1 1
AHU-6 6 22 C:\TEST.XML 1 1
AHU-7 7 22 C:\TEST.XML 1 1
AHU-8 8 22 C:\TEST.XML 1 1
AHU-9 9 22 C:\TEST.XML 1 1
AHU-10 10 22 C:\TEST.XML 1 1
AHU-11 11 22 C:\TEST.XML 1 2
AHU-12 12 22 C:\TEST.XML 1 2
AHU-13 13 22 C:\TEST.XML 1 2
AHU-14 14 22 C:\TEST.XML 1 2
AHU-15 15 22 C:\TEST.XML 1 2
AHU-16 16 22 C:\TEST.XML 1 2
AHU-17 17 22 C:\TEST.XML 1 2
AHU-18 18 22 C:\TEST.XML 1 2
AHU-19 19 22 C:\TEST.XML 1 2
AHU-20 20 22 C:\TEST.XML 1 2

Jul 7 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.