Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding XML element using Excel 2003
Is it possible to add XML element using Excel 2003?
ie, open a XML file using Excel 2003, view it as XML task pane or XML list, and add a new element and save it back as an XML? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding XML element using Excel 2003
Hi,
Yes, you can open an XML data file, work with the XML source task pane, import XML data into an existing mapping and also append XML data. Look he [Editing XML Data in Microsoft Office Excel 2003] http://msdn.microsoft.com/office/und...fficeexcel2003 Hope this helps. Anushi "Administrator" wrote in message ... Is it possible to add XML element using Excel 2003? ie, open a XML file using Excel 2003, view it as XML task pane or XML list, and add a new element and save it back as an XML? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding XML element using Excel 2003
thanks
I am not so familiar with XML, not sure if the URL referred can solve what I want for example, i have a XML file consists of following schema <ID <Name <Age <Height and if i open the file using XML (view via task pane), can I add anoher element VIA EXCEL so that the saved XML file now becomes <ID <Name <Age <Height <Weight <--- new element -----Original Message----- Hi, Yes, you can open an XML data file, work with the XML source task pane, import XML data into an existing mapping and also append XML data. Look he [Editing XML Data in Microsoft Office Excel 2003] http://msdn.microsoft.com/office/und...ng/xmloffice/a rticles/default.aspx?pull=/library/en- us/dno2k3ta/html/odc_ofeditingxmlwordexcel.asp#odc_ofeditin gxmlwordexcel_editingxmldatainmicrosoftofficeexcel 2003 Hope this helps. Anushi "Administrator" wrote in message ... Is it possible to add XML element using Excel 2003? ie, open a XML file using Excel 2003, view it as XML task pane or XML list, and add a new element and save it back as an XML? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding XML element using Excel 2003
On Thursday, July 29, 2004 10:25:15 AM UTC+1, Administrator wrote:
Is it possible to add XML element using Excel 2003? ie, open a XML file using Excel 2003, view it as XML task pane or XML list, and add a new element and save it back as an XML? I did something similar using an xml tool kit but not sure if you can add new element as in your example. http://www.liquid-technologies.com/xmldatamapper.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 adding row info | Excel Discussion (Misc queries) | |||
Excel 2003 adding page breaks | Excel Discussion (Misc queries) | |||
Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel | |||
Adding a 2nd row of sheet tabs to Excel 2003 | Excel Discussion (Misc queries) | |||
how do i map an excel column to an XML element | Excel Discussion (Misc queries) |