通过在vb.net中创建2个工作表导出到excel [英] export to excel with creating 2 worksheets in vb.net

问题描述

我在通过导出到excell生成报告时遇到问题。

我们正在使用grid200的SuperflexCell网格..

这是一个不错的第三派对工具，但在导出到Excel时它有一个限制，即它只能在excel文件中创建一个工作表..



在我们的应用程序中，我们有2个网格和我们想在一个excel文件的不同表格中显示每个网格..

由于限制我们无法这样做...



请一些人解决我的问题...

我希望每个网格在一个excel文件中以不同的工作表显示。

该文件应该是免费打开的点击按钮。

我在vb.net桌面应用程序中这样做..



请帮助我..



问候，

Sarthak

I am facing a problem while generating reports by exporting to excell.
We are using "SuperflexCell" grid of "grid200"..
It is a nice 3rd party tool, but while exporting to excel it is having a limitation i.e. it can create only one worksheet in an excel file..

In our application we have 2 grids and we want to display each grid in a different sheet of a single excel file..
Due to the limitatio we are unable to do so...

Please some one solve my problem...
I want each grid to be displayed in different sheets in one excel file.
And the file should open immideately on clicking the butto.
I am doing this in vb.net desktop application..

Please help me..

Regards,
Sarthak

推荐答案

亲爱的Sartha

请查看以下链接： [ 生成XML，它将用于excel版本2003和2007 ]



测试它并告诉我它是否有效。虽然它在c＃中但转换为VB并不难。



最好的问候。

Mahsa Hassankashi。

Dear Sartha
Please look at this link: [Generating XML and it would be used for excel versions 2003, and 2007]

Test it and and tell me if it works or not. Although it is in c# but converting to VB it is not hard.

Best Regards.
Mahsa Hassankashi.

这篇关于通过在vb.net中创建2个工作表导出到excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！