We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to export Grid in web form to excel

Thread ID:

Created:

Updated:

Platform:

Replies:

63322 Jul 2,2007 12:14 PM Jul 3,2007 01:48 AM ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
rebecca
Asked On July 2, 2007 12:14 PM

Hi,

I am wondering how to export grid in web form to excel? Is it the same as export grid from window form? Can anyone show me an example?

Thanks,
Rebecca

Gokul B [Syncfusion]
Replied On July 2, 2007 01:58 PM

Hi Rebecca,

Attached is the sample in which the GridGroupingControl content is converted into Excel.

http://websamples.syncfusion.com/samples/Grid.Web/5.1.0.51/F63322/GridGrouping_Forum63322/main.htm

Before Run our sample please make sure that your application is added with following assembly reference.

* Syncfusion.GridConverter.Web
* Syncfusion.XLSIO.Base

Let us know if you need any other help.

Regards,
Gokulkumar B

Rekha Mallavarapu
Replied On July 2, 2007 04:59 PM

Hi,

Is it possible to export the colorcoding of columns in gridgrouping control to excel?

Thanks,

Rekha

Valli [Syncfusion]
Replied On July 3, 2007 01:48 AM

Hi Rekha,

Attached is a sample link which helps you to export the GridGrouping data to excel along with the backcolor applied to the cells.

http://websamples.syncfusion.com/samples/Grid.Web/5.1.0.51/Forum-63322/main.htm

In this sample I have applied 'Red' color to the Cell with the value 'London' in the 'City' column and 'Yellow' color to the cell 'Germany' in the 'Country' column.

When you click the Export button the data of the GridGrouping control gets exported to the Excel along with the background color which has been applied to the cell.

Please let me know if this satisfies your requirement.

Regards,
Valli

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;