本文介绍了使用工作流或JQUERY,JSscript将SharePoint视图导出到excel,然后将唯一标识符添加到excel文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

是否可以导出SharePoint列表,转换为excel,然后在excel文件中具有唯一的标识号?

Is there a way to export a SharePoint list, to excel and then inside the excel file have a unique identifying number?

最好是工作流程...因为不确定我是否可以进行Powershell设置.是否可以使用JQuery和/或JavaScript?

a workflow would be best... as not sure if I can get powershell setup..  Is it possible to do using JQuery and or  JavaScript?

这样,鉴于他们需要导出,我可以添加一个Button来触发导出并生成唯一的ID#.

这有可能吗?据我所知,我们可以导出从列表中直接看到一个视图,但我需要一个每日唯一身份标识"要在excel文件顶部添加的数字.

that way on the view that they need to export, I can added a Button to trigger the export and unique ID # to be generated..

Is this even possible? As I know we can export  right from the list a view, but I need a Daily Unique Identifying  Number to be added at the top of the excel file.

推荐答案

在该导出中,您可以创建自己喜欢的任何字段,而不必限制SharePoint所提供的内容.

In that export, you can create whatever fields you like, and not be constrained what SharePoint has to offer.

如果没有,那么我将在列表中创建一个计算字段,该字段会自动创建您的唯一每日ID,并将其包括在视图中.

If not, then I'd create a calculated field in the list that automatically creates your unique daily ID, and just include it in the view.


这篇关于使用工作流或JQUERY,JSscript将SharePoint视图导出到excel,然后将唯一标识符添加到excel文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-28 14:31