Skip to main content

Posts

Showing posts from October, 2011

Import Excel files to SharePoint 2010

Sometimes we have a need to transfer Excel spreadsheet to the SharePoint 2010 environment. Because Excel is very popular business application, I see quite a few spreadsheets out there that are used for managing complex business operations. At some stage the decision comes up to move Excel-based system to SharePoint for certain good reasons and business users try to upload their spreadsheets to SharePoint lists and libraries. It might seem obvious that we could use out-of-the-box functionality provided by Microsoft in SharePoint 2010 which is "Import Spreadsheet" which "creates a list which duplicates the columns and data of an existing spreadsheet". What it does in reality is: allowing you to select a range of cells, creating a list with all columns as single or multiple lines text. That's it. So for real life scenarios we need a different approach to import Excel data to SharePoint appropriately. In the scenario here we have got a simplified application manage