I have a file that is in .xml format I need to edit some info in it preferably in Excel and than drop it back into .xml any ideas oh wise and all knowing tech guys?
Printable View
I have a file that is in .xml format I need to edit some info in it preferably in Excel and than drop it back into .xml any ideas oh wise and all knowing tech guys?
XML is just text. Use any text editor, such as notepad.
you can save as to XML from Excel when you're done too
It is a text file. If your changes are simple, the "open in notepad, Find, change, save" method should work.
If your changes are more complex, you can find an XML editor. I know there are a number of free ones, but I don't have any personal experience with them.
http://lmgtfy.com/?q=xml+editor
H.
Haha love lmgtfyQuote:
Originally Posted by Hoosier
on a work comp so all that stuff is locked down as freeware sharing. Posting from my phone think I got it figured it out though font did not transfer completely right so I will need to adjust. And also the file has abunch of borders and line spaces in html so I got into the source code and changed what was needed just need to fix the font and I should be gtg.
Notepad (assuming Microsoft platform) seems straightforward, and for simple typo fixes it is -- but XML cares deeply about special characters (such as the ampersand), and character encodings sometimes bite. It may look good but then an XML parser down the line may puke it back out.
I'd recommend an XML editor. If you have this need now, you'll have it again. Best to have a good tool.
Depending on how sensitive the data you're trying to manipulate is, you might be able to find an on-line XML editor service, where you upload the file, edit it on the web, and download it. Sounds like you've got it sorted though.Quote:
Originally Posted by DFBrews
Does your work prevent personal computers on their network?
H.
If you know what you're doing (i.e. can understand/read/write xml), then use a text editor. Otherwise, I'd try something else (excel perhaps or altova).