将Excel工作表数据导入到Sharepoint列表的工具 [英] Tool to import Excel sheet data to Sharepoint list

问题描述

有没有工具将Excel表格数据导入到Sharepoint列表？
我发现一个工具来做到这一点。有没有办法做这个任务？

[应该支持任何Excel版本和任何SharePoint版本]

解决方案

IMHO

简单的复制/粘贴表单Excel到DataSheet视图可以涵盖更简单的场景（如果要复制文本和/或数字值）
如果你需要复制一些其他数据，比如用户名，事情就会变得困难。

批量复制并粘贴到SharePoint列表

另一种方法是使用例如编码自己的解决方案。控制台应用程序和Web服务（2007和2010）或使用客户端对象模型（2010）。
即使编写PowerShell脚本来执行某些特定的和/或半通用的导入作业也是不难的。

有很多不同的可能性（例如excel文件的格式如何）找到通用工具不是一件容易的事情。如果您能够制定一些Excel格式标准，那么开发自己的解决方案更有效，然后购买一些强大的通用工具。

Are there any tools to import Excel sheet data to Sharepoint list ? I have found a tool to do that. Are there any alternatives to do this task?

[should be support any Excel version and any SharePoint version]

解决方案

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.

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.

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工作表数据导入到Sharepoint列表的工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！