导出到Excel SharePoint列表-删除默认列项目类型和路径 [英] Export to Excel SharePoint List - Remove default column Item Type and Path

问题描述

当我使用内置功能将SharePoint列表导出到Excel时，它将导出两个额外的列，分别称为项目类型"和路径".有没有一种方法可以将这些列从导出中排除. ?

When I export a SharePoint list to Excel using the built-in functionality, it exports two extra columns called Item Type and Path. Is there a way to exclude these column from the export. ?

推荐答案

这是默认行为.它告诉您导出它的位置及其类型，如果要删除它们，则必须创建一个PowerShell脚本.或在数据表视图中打开并剪切并粘贴数据

This is default behaviour. It's telling you the location from which it was exported and its type, you'll have to create a PowerShell script if you want to remove them. Or open in Datasheet view and cut and paste the data

这篇关于导出到Excel SharePoint列表-删除默认列项目类型和路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！