列表视图-导出到Excel，人员选择器字段值显示为数字和# [英] List view - Export to Excel, People picker field values appearing with number and #

问题描述

你好

当尝试从导出到excel"将列表导出到excel时， ，它很容易导出，但对于人员选择器字段，它显示为#一些id ..即#5".

When try to export list into excel from "Export to excel" , its gets exported easily but for the people picker field, it appears as # some id..that is ‘#5'.

没有任何代码，可以轻松地在excel工作表视图中提取普通文本.

请提供帮助.

谢谢.

问候

Jayashri

推荐答案

您好Jayashri，

Hi Jayashri,

通常，在导出人员选择器字段时，由于它们是查找字段，因此它将在Excel工作表中将用户ID添加为数字.

Normally when people picker field is exported, it will add the user id as number in the excel sheet since they are lookup fields.

以下是解决此问题的方法:

Below are the ways you can override this issue:

http://stackoverflow. com/questions/5023686/cleaning-people-group-data-exported-from-sharepoint-2010-lists

这篇关于列表视图-导出到Excel，人员选择器字段值显示为数字和#的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！