PDA

View Full Version : xml generator from excel document



bootiteq
January 16th, 2008, 10:04 PM
Example of how to use excel to create XML. May be of use to people who understand a little excel.

Open attached file
Click cell D1
View formula

formula added to D1:
="<gig><![CDATA[<b>"&A1 & "</b><br>"&B1& "]]></gig>"


---------------------------

prg9
January 17th, 2008, 11:43 AM
xml generator from excel document -- Example of how to use excel to create XML. May be of use to people who understand a little excel.

Sounds really interesting bootiteq! :thumb2:

It doesn't have anything to do with this does it:
Microsoft is warning users of a flaw in Excel which is already being targeted by hackers (http://www.informationweek.com/blog/main/archives/2008/01/hackers_targeti.html)

:) Kidding (lets hope its not right) :hugegrin:

bootiteq
January 21st, 2008, 08:58 AM
Ha Ha - I had no idea! - attached an image for those who think im dodgy.

Good thing about excel is you can copy and paste a table from almost anywhere into the cells.