从列表数据中导出Excel -Office365 [英] export excel from the list data -Office365
问题描述
我有一个包含多个选择值的列表,因此当我尝试导出到excel时,它在excel列值中显示的显示ABC,Great#(逗号#定界符).我真的不想在Excel中显示这些值.
闪电战
i have a list that contains multi select values so when i try to export to excel its displaying ABC,Great# (comma # delimiters) present in the excel column values. i really dont want to display these values in the excel.
Blitz
推荐答案
闪电战,
根据设计,如果查找字段设置为允许多个值",则当您使用导出到Excel"时,要将列表项导出到excel,查找字段的值将包含#; ID.
By design, if the lookup field set "Allow multiple values", when you use the "Export to Excel" to export list items to excel, the values of lookup filed will contains #;ID.
作为一种解决方法,我们可以创建自定义的导出到Excel"菜单选项将列表项导出到excel文件.带有示例代码的文章供您参考:
As a workaround, we can create a custom "Export to Excel" menu option to export the list items to excel file. The article with example code for your reference:
http://sharepoint-freak.blogspot .sg/2011/04/when-you-use-lookup-fields-or-any.html
最好的问候,
这篇关于从列表数据中导出Excel -Office365的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!