Working with Excel Data in SharePoint 2010
Integration between Excel spreadsheets and SharePoint has been a hot topic for years, and Microsoft has provided a number of methods to integrate the two products. This section reviews some different basic methods of working with Excel data in SharePoint to prepare for additional discussions around Excel Services.
To begin with, a SharePoint list has many similarities with an Excel spreadsheet, so many organizations simply move the content from the spreadsheet to SharePoint by creating a list; replicating the column headings, order, and type of content; and then cutting and pasting from the worksheet into the SharePoint list. This is a fairly painstaking process, so many users instead use the Import ...
Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
