自定义列表导出到Excel，稍后在视图中添加一列 [英] Custom list export to Excel, adding a column later in the view

问题描述

亲爱的，

我有一个自定义列表并导出到Excel可用。

我将导出的数据连接到很多其他地方Excel，但现在结果我需要在自定义列表中添加其他列。没问题，添加到视图中的那些，只需刷新它们就可以在现有的Excel中使用。

但是，这些字段不在右侧作为附加列而不是正确的顺序。

显然，如果我做一个新的出口，他们会在正确的地方，但现有的连接/出口没有。

如果我复制和粘贴新的导出到现有的主excel，我已经松了很多连接和宏编码。

有没有一种简单的方法来解决这个问题？

问候，

BAZINGA！

解决方案

您可以尝试将连接文件从新导出导出到现有导出。以下是描述.odc文件的文章

此链接将指导您通过¥b $ b

https： //support.office.com/en-ie/article/create-edit-and-manage-connections-to-external-data-89d44137-f18d-49cf-953d-d22a2eea2d46

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/use-an-office -data-connection-odc-with-reports？view = sql-server-2017

问候，

Dinu

Apps4Rent

Dear all,

I have a customized list and export to Excel available.
I connected that exported data to lot of other places in the Excel, however now it turned out I need additional columns in the customized list. No problem, added those, added to the view, they are available in the existing Excel just by refreshing those.

HOWEVER, the fields are not on the right hand side as additional columns and not in the correct sequence.
Obviously if I do a new export they would be on the correct place, but the existing connection/export does not.
IF I copy&paste the new export to the existing master excel, I loose a lot of connections and macro coding done already.

Is there a simple way to get this fixed?

regards,

BAZINGA!

解决方案

You can try exporting the Connection File from New Export to existing export. Below is the article which describes about .odc files

This Links will guide you thru

https://support.office.com/en-ie/article/create-edit-and-manage-connections-to-external-data-89d44137-f18d-49cf-953d-d22a2eea2d46

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/use-an-office-data-connection-odc-with-reports?view=sql-server-2017

Regards,
Dinu
Apps4Rent

这篇关于自定义列表导出到Excel，稍后在视图中添加一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！