如何自动将Excel导入Sharepoint列表? [英] How to Import an excel to Sharepoint list AUTOMATICALLY?

问题描述

这是现场表演:

-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. 

这篇关于如何自动将Excel导入Sharepoint列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！