如何自动将Excel导入Sharepoint列表?
这是现场表演:
-Sharepoint文档库中有一个Excel文件
- There is an excel file in Sharepoint Document Library
-此excel文件将每周自动更新
- This excel file will be updated every week automatically
问题:
是否可以使用Sharepoint Designer工作流将Excel内容导入/发布到共享点列表中?每当excel文件更新时,此工作流程都会自动运行,以便列表中的数据也将更新?
Is it possible to use Sharepoint Designer Workflow to import / publish the excel content into a sharepoint list? Whenever the excel file updated, this workflow runs automatically, so that data in the list will be updated as well?
请注意:在excel文件中,显示的是"B3"而不是"A1"的标头,如下所示:
Notice that: under the excel file, the 'header' is showing from 'B3' instead of 'A1', like this:
D
A B C D
1
1
2
3 nbsp; b Header1 标头2标头3
3 Header1 Header2 Header3
4 nbsp; b&b ; a1 a2 a3
4 a1 a2 a3
克里斯,你好,我不知道有什么办法,但我会让其他人听到.可能的代码解决方案.但是,您应该做的是通过导入电子表格来反向创建列表,然后将数据保留在列表中,而不是保存在列表中. Excel.
Hi Chris- I don't know of any way to accomplish that, but I'll let others chime in. There may be a possible code solution. However, what you should do is the reverse- create a list by importing the spreadsheet, then maintain the data in the list, not in Excel.