如何通过Excel中的展开和折叠操作，将网格数据导出到excel？ [英] How to export grid data to excel along group headers/ summary records with expand and collapse action in Excel?

问题描述

我已经使用Extjs 4完成了应用程序。我需要将网格数据导出到excel。我有网格包含许多记录，按组标题/摘要（折叠/展开操作）显示记录。 同样的事情我需要导出网格数据excel相同的活动需要崩溃/扩展在Excel表单。我已经尝试我能够导出网格记录与组headers.summary为excel，酷它正在工作，但崩溃/展开不发生在Excel表。我需要通过编写代码实现这个功能。有谁能告诉我如何实现这一个？是否可以使用extjs？非常感谢。谢谢。

解决方案

这样的东西不会开箱即用。但是有一些ExtJS到Excel的出口商： http：/ /www.sencha.com/forum/showthread.php?136598-Export-store-to-Excel

我们内部做的是生成我们的Excel后端使用.NET，所以我们有更多的控制。

I have done application using Extjs 4. I have requirement need to export grid data to excel. I have grid it contains many records, showing records by group headers/summary(collapse/Expand actions ). The same thing i need to export grid data to excel the same activity need collapse/expand in excel sheet. I have tried i am able to export grid records with group headers.summary to excel, cool it is working but collapse/expand is not happening in excel sheet. I need to implement this feature by writing a code. Can anybody tell me how to achieve this one? is it possible or not by using extjs? great appreciated. Thank you.

解决方案

Something like this doesn't come out of the box. There is however some exporter from ExtJS to Excel: http://www.sencha.com/forum/showthread.php?136598-Export-store-to-Excel

We we internally do is generate our Excel backend with .NET so we have more control.

这篇关于如何通过Excel中的展开和折叠操作，将网格数据导出到excel？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！