Thursday, January 20, 2011

How to Create XML Data From Excel 2003


1. Click the 'Start' or Windows button in the lower left corner of your screen, then select 'Programs' or 'All Programs.'
2. Scroll through your list of installed applications and select 'Microsoft Office,' then click 'Microsoft Excel 2003.'
3. Click 'File' at the top of the window and select 'New' to generate a new spreadsheet, or click 'Open' and navigate to a previously created Excel file.
4. Click 'File' at the top of the screen then select the 'Open' option to navigate to your XML source file and open it.
5. Select the 'Use XML Source task pane' option and click the 'OK' button.
6. Add XML elements from the pane on the right side of the screen to generate an XML map on your spreadsheet.
7. Make any edits or additions to your spreadsheet file.
8. Click 'File' at the top of the screen, then select the 'Save As' option.
9. Select the drop down menu next to the 'Save as type' wording and choose the 'XML Data' option.
10. Type a name for your file into the 'File name' text window, then select a location for your Excel XML Data file and click the 'Save' button.

Blogger news