如何自动将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.