list 将 Excel 工作表数据导入 Sharepoint 列表的工具
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11013412/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Tool to import Excel sheet data to Sharepoint list
提问by devan
Are there any tools to import Excel sheet data to Sharepoint list ? I have found a toolto do that. Are there any alternatives to do this task?
是否有任何工具可以将 Excel 工作表数据导入 Sharepoint 列表？我找到了一个工具来做到这一点。有没有其他方法可以完成这项任务？
[should be support any Excel version and any SharePoint version]
[应该支持任何 Excel 版本和任何 SharePoint 版本]
采纳答案by Vedran Rasol
IMHO
恕我直言
Simple copy/paste form Excel to DataSheet view can cover simpler scenarios (if you are copying text and/or numeric values) If you need to copy some other data like usernames things can get difficult.
简单的复制/粘贴表单 Excel 到数据表视图可以涵盖更简单的场景（如果您正在复制文本和/或数值）如果您需要复制一些其他数据，如用户名，事情可能会变得困难。
Bulk copy and paste into a SharePoint List
One alternative is to code your own solution using eg. console application and web services (2007 and 2010) or using client object model (2010). It is not difficult to even write PowerShell script to do some specific and/or semi-generic import job.
一种替代方法是使用例如编码您自己的解决方案。控制台应用程序和 Web 服务（2007 年和 2010 年）或使用客户端对象模型（2010 年）。甚至编写 PowerShell 脚本来执行一些特定的和/或半通用的导入工作也不难。
There are so many different possibilities (eg. how excel file is formatted) that finding universal tool is not an easy task. If you are able to make some Excel formatting standards then developing own solution is much more effective then buying some robust universal tool.
有很多不同的可能性（例如excel文件的格式），找到通用工具并不是一件容易的事。如果您能够制定一些 Excel 格式标准，那么开发自己的解决方案比购买一些强大的通用工具更有效。
回答by Manish
Sharepoint have OOB features to import the excel sheet.
Sharepoint 具有 OOB 功能来导入 Excel 工作表。
you can check it over here.
你可以在这里查看。
http://sharepointbuzzer.com/2010/10/22/import-excel-sheet-as-sharepoint-list/
http://sharepointbuzzer.com/2010/10/22/import-excel-sheet-as-sharepoint-list/
回答by Amay Kulkarni
Copy the data from excel and open the list in Datasheet view in IE Browserand then paste it in second column.
从 excel 复制数据并在IE 浏览器的数据表视图中打开列表，然后将其粘贴到第二列中。
