如何将数据透视表导出到Excel

如何将数据透视表导出到Excel

本文介绍了如何将数据透视表导出到Excel 2007的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在将一个关键表子表单导出到Excel 2007中,我正在使用以下代码

I am exporting a pivate table subform into Excel 2007 and I am using the following code

Me.Form.PivotTable.export FileName,plExportActionOpenInExcel

Me.Form.PivotTable.export FileName, plExportActionOpenInExcel

我有两个问题:

1执行上述代码后总会出现以下警告信息:

1 there is always a warning message as following after excute the above code:

您尝试打开的文件,'file name.xls'的格式与 指定的格式不同文件扩展名。在打开文件之前,验证文件是否已损坏且来自受信任的来源。你想现在打开文件吗?

The file you are trying to open, 'file name.xls' is in a different format than specified by  the file extension. Verify that file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

2。单击"确定"后,数据透视表可以在打开的Excel中显示,但第二个问题是目标文件夹中还有一个额外的XML文件。

2. After I click OK, the pivot table can be shown in opened excel but the second issue is there is an additional XML file in the target folder.

我的问题是如何避免警告消息并且还摆脱了xml文件。

My questions are how to avoid the warning message and also get rid of the xml files.

谢谢

Wenyan

 

 

推荐答案

请检查这个知识库文章: 其中描述了原因并且引入了变通方法。

Please check this KB article: http://support.microsoft.com/kb/948615 which describes the reason and intoduces the workaround.

似乎原因是:

警告消息是用户通知功能已添加到Excel 2007.警告消息可以帮助防止可能发生的意外问题
,因为文件的实际内容与文件之间可能不兼容姓名扩展名。



我希望这可以提供帮助您可以在尝试文章中的解决方法后随时跟进。

The warning message is a user-notification function that was added to Excel 2007. The warning message can help prevent unexpected problems that might occurbecause of possible incompatibility between the actual content of the file and the file name extension.

I hope this can help you and just feel free to follow up after you have tried the workaround in the article.

最诚挚的问候,


这篇关于如何将数据透视表导出到Excel 2007的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-05 00:18