Import XML Data The Travel Office provided you with your supervisors’ flights for today in an XML…
Import XML Data The Travel Office provided you with your supervisors’ flights for today in an XML document. You will import that into your workbook and create a function to identify the status of those flights.
a. Use Windows Explorer to copy e09c1flights.xml. Rename the copied file e09c1flights_LastnameFirstname.xml. Open e09c1flights_LastnameFirstname.xml in Notepad, and then verify that the flight numbers and departure times still match two in the Departures worksheet. If not, change the data in the XML document, and then save it.
b. Insert a new worksheet in your Excel workbook, and then name it Today.
c. Create a connection to the e09c1flights_Lastname Firstname.xml file.
d. Type Status in cell C1 in the Today worksheet.
e. Enter a function in column C of the Today worksheet to look up the flight number and display the status from the Remarks column in the appropriate worksheet.
f. Edit the XML file by adding details for a third flight of your choice using correct XML tags. Check the data in the Departures worksheet first. Save the XML file.
g. Refresh the XML data only. Do not refresh all connections.