Extracted from the original post
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 management system in Excel that features two related worksheets: Applications and Environments. Applications is a list of software and Environments is a list of servers and owners where the software exists.
For complete post click here
No comments:
Post a Comment