如何将Excel数据导入Sharepoint？ [英] How to import excel data to Sharepoint?
问题描述
*一旦我设法验证我的帐户就会添加链接和图片* ....
有谁知道如何验证我的帐户？我没有收到电子邮件这样做...
我一直试图通过以下方式加载excel文件的数据：
在Internet Explorer中：网站> 设置 图标> 添加应用 > 导入电子表格
希望这有帮助......
-------------------------------------------- -------------------------------------------------- -------
请不要忘记"标记回复作为答案 "
如果他们帮助，还设置"喜欢"，这对我们来说是一个促进博客$ b的推动力$ b J
点击 此处 到
了解详情。访问专用的 社区
论坛 &NBSP;至&的共享下，&的探索&NBSP;和&NBSP; <强烈的>谈话，向有关Microsoft Kaizala的专家发表。
*will add links and images once I manage to verify my account* ....
Does anyone know how to verify my account? I did not get an email to do so...
I have been trying to load the data of an excel file through:
In Internet Explorer: site > Settings icon > Add an app > Import Spreadsheet
But unfortunately I get an unexpected error...
Here I found a suggestion on what to do:
So I went ahead and made sure that the website is trusted and tried again, but still the same problem.
I have also tried to load this data through excel export, explained here:
I got this error saying that:
"Cannot connect to server at this time. Your list cannot be published"
I found a workaround on this website:
but this implies that I have to make the site public, but that is a big no no.
re there any other ways to do this?
Any help would be appreatiated.
Want I want to do is to be able to use the data from an excel file column in the drop down menu of a column on a sharepoint library, so that when the user is requested to fill this field, he has to choose from the options on the drop down menu.
This seemed to answer my question...
but unfortunately I can't get this to work and I get the above error.
Hi Rita,
I had this issue in the past .. it could be due to IE certificate security Setting.
Check your IE certificate security Setting
Open your Internet Explorer.
1. Click on Tools, then Internet Options
2. Go to Advanced tab
3. Scroll down to security and then uncheck the "Check for server certification revocation"
4. Restart your browser and then try again to import the list again. This should work.
Please refer below link
http://nazishalirizvi.blogspot.com/2013/09/cannot-connect-to-server-at-this-time.html
Hope this helps...
-----------------------------------------------------------------------------------------------------
Please don't forget to "mark the replies as answers" if they helped, also set "like" it’s a boost for us to keep blogging J
Click here to learn more. Visit the dedicated Community forum to share, explore and talk to experts about Microsoft Kaizala.
这篇关于如何将Excel数据导入Sharepoint？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
