{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 时光不老，我们不散 的问题《Tool to import Excel sheet data to Sharepoint list》','https://www.manongdao.com/q-720830.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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]
相关问题
- how to split a list into a given number of sub-lis
- Excel sunburst chart: Some labels missing
- C#: How do i get 2 lists into one 2-tuple list in
- F#: Storing and mapping a list of functions
- Select first row from multiple dataframe and bind
相关文章
- List可以存储接口类型的数据吗？
-
C# List
.FindAll 时 空指针异常 - What is the complexity of bisect algorithm?
- Given a list and a bitmask, how do I return the va
- Get column data by Column name and sheet name
- programmatically excel cells to be auto fit width
- Unregister a XLL in Excel (VBA)
- Why does slice [:-0] return empty list in Python
Sharepoint have OOB features to import the excel sheet.
you can check it over here.
http://sharepointbuzzer.com/2010/10/22/import-excel-sheet-as-sharepoint-list/
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.
Copy the data from excel and open the list in Datasheet view in IE Browser and then paste it in second column.