SOFTWARE SOLUTIONS FOR CIVIL ENGINEERING

Civil Fast Forward

THE OFFICIAL CADMAGIS BLOG

Edit XML Earthwork Report in Microsoft Excel

You can easily import your data from the XML file to Microsoft Excel.

You can import only the nodes which you want and which are useful for your computations and analyses.

 

The fast forward solution which illustrates how to do it you can see below:

 

1. Set the File Tab and choose Options,

2. Next choose the Customize Ribbon and switch on the Developer Tab,

3. From the Developer Tab you need the XML functions called Source and Import,

4. Choose XML Maps and Add a new map from the XML file,

5. Select your XML file and Open it,

6. Find the nodes to import,

7. Drag your XML nodes to the Spreadsheet.

Watch a short movie (duration 6 minutes) where these steps are shown.