从多个数据网格导出到多个Excel工作表 [英] Exporting to multiple excel sheets from multiple datagrids

查看:73
本文介绍了从多个数据网格导出到多个Excel工作表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述



我有一种方案,可以将三个不同数据网格(显示在网站的选项卡中)中的数据导出为三个不同工作表的Excel文档.我还需要编辑工作表的名称并设置工作表的格式. (Asp.net,VB)

谢谢.



I have a scenario to export data from three different data grids ( displayed in tabs in the website) into a Excel document as three different sheets. I also require, editing the name of the worksheet and formatting the sheet. (Asp.net , VB)

Thanks.

推荐答案

帮助实现此目的的代码.


它在这里不能这样工作.

这是询问者的期望:
1. 先尝试您要做什么!您可能会发现它并不难.
2.制定看起来像问题/无法解决的问题.

试试看,告诉他们是否遇到问题.
成员将很乐意为您提供帮助.
help is appreciated on the code to achieve this..
No.

It does not work like this here.

Here is what is expected of enquirers:
1. TRY first what you want to do! You may find that it''s not that hard.
2. Formulate what was done by you that looks like an issue/not working.

Try them and tell if you face issues.
Members will be more than happy to help like this.


从此处开始: http://forums.asp.net/t/1173887.aspx [ http://support.microsoft.com/kb/317719 [ http://blog.weareon .net/export-datatable-to-excel-in-asp-net-without-using-excel-interop-part-ii/ [ http://forums.asp.net/t/1635223.aspx/1 [ ^ ]

请不要害怕使用GOOGLE.
Start here: Exporting DataGrid to Excel, Word and Text Files[^]

Other useful links:
http://forums.asp.net/t/1173887.aspx[^]
http://support.microsoft.com/kb/317719[^]
http://blog.weareon.net/export-datatable-to-excel-in-asp-net-without-using-excel-interop-part-ii/[^]
http://forums.asp.net/t/1635223.aspx/1[^]

Please, don''t be affraid to use GOOGLE.


这篇关于从多个数据网格导出到多个Excel工作表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆