做好一个列表后，想导入字段相同的Excel表格数据，怎么没有找到导入功能的选项呢？SharePoint2010 不支持Excel导入么？还是需要激活什么功能或者安装什么辅助工具呢？
这个有很多的方案，其中使用sharepoint 的数据视图最简单，但是这个是复制粘贴的。或者自己写代码开发。
Import Excel data to SharePoint List
Import from Spreadsheet is a tool developed for MOSS x86 and x64 platform allowing mapping fields and import data into SharePoint lists.
If you need a solution that is targeted for SharePoint 2010, 2013 and SharePoint Online then please visit us at SP Importer . Thanks for your feedback. Visit Technovert Products for more tools available for SharePoiint community.
By default SharePoint will provide us an option to edit in spreadsheet or download list items in spread sheet. But, it doesn't have an option to import the excel data to SharePoint list. When we have data in excel format and want to import that data to a sharepoint list, then how to do. That is why we took it as a challenge and implemented this.
And second reason is, this feature has a nice and wonderful feature of column mapping. You can manually choose column to column mapping, so that the column names not needed to be exactly same. This is one of the best option in this feature.
This feature works for both SharePoint and WSS.
The installation is simple and it is using the codeplex sharepoint installer package to install the feature. As it is developed as a SharePoint feature, you can get this feature associated with each list under the actions tab once you have activated it. You can call this feature by going to specific SharePoint list, under actions menu item and just click on the feature name. Then it will take to a page which has a nice user interface to upload an excel, then choose specific sheet and then map the fields as you want.
This feature is now available for both 32 and 64 bit architectures. (New released 1.5 Version is for x64 bit). Please make sure the data connectivity Office Driver is installed on the server.
Last edited Feb 13 at 10:38 AM by Technovert, version 9