O365 SharePoint导出到Excel脚本 [英] O365 SharePoint Export to Excel Script

问题描述

我希望在O365版本的SharePoint中自动执行导出到Excel"功能.我的办公室希望使用我们的SharePoint网站来存储不可复制的数据.我们有一些认证，对备份有严格的要求 而导出到Excel功能是我发现的本地备份的最佳选择.我希望使用Power Shell脚本将Excel文件保存到文件夹并使用当前日期命名该文件.

I am looking to automate the Export to Excel function in the O365 version of SharePoint.  My office would like to use our SharePoint site to store data that will not be reproducible.  We have a couple accreditations that have strict backup requirements and the Export to Excel function is the best option I have found for a local backup.  I am hoping for a Power Shell script that will save the excel file to a folder and name the file with the current date.  

推荐答案

检查以下论坛主题: 通过Powershell将SharePoint Online列表导出到csv .它显示了将列表项导出到csv(可在Excel中打开)的示例热.可能您需要添加逻辑以从doclib中导出列表项附件和文档.

check the following forum thread: Export SharePoint Online list to csv via Powershell. It shows example hot to export list items to csv which may be opened in Excel. Probably you need to add logic to export list items attachments and documents from doclibs.

这篇关于O365 SharePoint导出到Excel脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！