Wednesday, December 01, 2004

Analyze XML data with MS Excel 2002/2003

A handy tip from Excel 2002/2003 lets you open and analyze an XML file as a native Excel file. You can use all of Excel's analysis tools, including pivot tables and pivot charts, with XML data. Use File Open, and select XML Files from the Files Of Type drop-down list. Navigate to the XML file you want to open, and click Open. Excel displays XML tags as column headings and lists the data in the rows below the appropriate column headings. For example, in an XML Orders file, every Orders element may have Ship Region as a child element. In the worksheet, Excel represents the child element as the column header /Orders/Ship Region/. Excel opens XML files as read-only files, so users can't make changes to the original file while analyzing it in Excel.

New Ms Office Articles from MSDN

Handy Tips When Using MS Word 2003 Tips and VBA code to make your MS Office applications more robust and even provide even more options to users.

Best of Blogs: Visual Studio Tools for Office, Version 2003 Links to blogs that offer first-hand experience and tips for designing, implementing, and deploying smart client solutions built with Visual Studio Tools for MS Office 2003.

No comments: