How to apply xml in Microsoft excel

Asked By ripon25 0 points N/A Posted on - 10/05/2011

Let me want to know how to xml in microsoft excel for creating data base.Is it very easy to use web data in excel by xml?

• Status: Open
• Question Views: 992
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By analus09 0 points N/A #87284

How to apply xml in Microsoft excel

To make things much easier for you.. u can first download the XML file. I can give you here instructions then you will just have to follow the process, for you to download it successfully. Save it  at the most convenient place in your hard disk.

In only one list, you can eventually view your data using VIEW DATA IN AN XML LIST.

There is also a fast way to create business reports and other types of file that u don't want users to change by using READ-ONLY WORK.

You should at least link or bind a cell in your worksheet to an element in the XML if you will use the XML Source to create a map.

This is the most flexible and powerful option in your XML data.

 

THIS IS HOW TO DOWNLOAD YOUR XML

 

On the File menu, click Open.

In the Files of type list, select XML files (*.xml).

In the Look in box, navigate to the XML file you want to open, 

select the file, and then click Open.

The Open XML dialog box appears.

Click one of the options in the Open XML dialog box (As an XML list), and then click OK.

 

 

THIS IS HOW TO IMPORT,EXPORT AND SAVE DATA ON YOUR XML

 

IMPORT DATA

Select one of the mapped cells in a worksheet.

On the Data menu, point to XML, and then click Import. The Import XML dialog box appears.

Use the Look in list to locate the file that you want to import, and then click Import.

EXPORT DATA

On the Data menu, point to XML, and then click Export. The Export XML dialog box appears.

Use the Save in list to navigate to the folder to which you want to export the data, and then click Export.

SAVE DATA

On the File menu, click Save As.

From the Save as type list, select XML data (*.xml).

Click Save.

 

START BY PREPARING THE WORKSHEET

Start Excel and open the sample file.

When the Open XML dialog box appears, click Use the XML Source task pane, and then click OK.

 

In cell A1, type Employee, and in cell A3, type Manager.

In cell C1, type Department, and in cell C3, type Date Submitted.

Format the text as you like to give it emphasis.

ADD THE MAP

Drag the ns1:EmployeeName element from the XML Source task pane to cell B1, and then drag the ns1:Department element to cell D1.

Drag the ns1:ManagerName element to cell B3, and then drag the ns1:Date element to cell D3.

Under ns1:ExpenseItem, select ns1:Description and drag it to cell B5.

Still under ns1:ExpenseItem: Drag the ns1:Account element to cell C5, drag ns1:Date to cell D5, and then drag ns1:Total to cell E5.

Save the file. This adds the map to the file and binds the data in the source file to the map.

You're now ready to…

 

IMPORT DATA INTO THE MAP

Select any one of the mapped cells. On the Data menu, point to XML, and then click Import.

The Import XML dialog box appears.

 

Use the Look in list to locate the sample file, and then click Import.

Excel populates the mapped fields. Notice that Excel automatically applies XML list formatting to the repeating elements (in this case, the expense items) in the map.

 

YOU WILL HAVE TO FOLLOW ALL THE STEPS AND WAYS FOR YOU TO MAKE USE OF THIS XML FILE SUCCESSFULLY and I can assure you that with all this steps, u can be able to make use of this most often with all your data sheets works and files.

About analus09

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/05/2011
• Question Category: MS Excel