This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. You’ll remember last time that we’d built a spreadsheet that searched Craigslist via the RSS feed that’s available for search results, and pulled the information into Excel using the little-used XML Map feature. Today, we’ll continue on where we left off, adding the ability to search multiple sites, and adding a little progress indicator in case the search takes a long time.
This blog post is brought to you by Dan Battagin a Lead Program Manager on the Excel team. OK, so I’m going to talk a bit about a relatively unknown feature in Excel: XML data import. It was introduced in Excel 2003, but we’ve done a pretty good job hiding it since Excel 2007 by putting it on the Developer tab of the Ribbon.
This week a friend of mine told me about a SharePoint related “incident” at his company where it was discovered that someone had posted a spreadsheet that contained sensitive employee data. The file was not properly secured (discovered via a keyword search) and quickly was removed; no damage was done. Nonetheless, it got me thinking about the appropriate steps to take during such a scenario… and, if you know me, that means having a plan.