My first Export to Excel 2003 and Excel 2007/2010

Walkthrough: Your first Export to Excel with the Gridview to Excel Export Tool Release 3.0

This walkthrough illustrates how to create a simple Web Site with the capability to export data to Excel.

The full process is made up of two main steps:

• First step is the Web Site creation
• Second step  is creating a simple Web Page with a sqldatasource, a gridview and the capability to export data to Excel 2007/2010..

Creating the Web Site

To create a new ASPX Web Site, perform following steps:

1. Run Visual Studio Select File -> New Web Site. Choose Visual Basic and ASP.NET Web Site. Select either .Net Framewotk 3.5 or .Net Framewotk 4.0.
   
2. Press Ok. The Web Site will be created and Solution Explorer will show like next one:
   
3. In the Solution Explorer window right-click the Web Site and select "Add reference". Add a reference to the GEETMultiScheet30.dll you can find in the GEETbin folder inside the "Gridview To Excel Export Tool" normally C:\Program Files (x86)\Cefalà Ing. Ettore\GridviewExcelExportTool\3.0.0\GEETBin.
   
4. Press Ok. After a few seconds next window will show up.
   
   Double click the Default.aspx page and select the Design View.

Add the capability to Export data to Excel

Here we'll modify the default.aspx page in order to display some data with a Gridview and to export them to Excel by means of the "Gridview to Excel Export Tool". In this case a Gridview and a SqlDataSource will be used to feed the Export Tool. The tool offers anyway the chance to export data also from many other data sources.

Please follow next steps:

1. From the Toolbox drop a Gridview web-control on the default.aspx design page surface.
   
2. Click the Gridview tag and select Configure datasource, select New. In the next form select the SQL Database icon and press OK
   
3. In next form set the Sql Server machine name, set the appropriate authentication and select the AdventureWorks demo database.
   
4. Press Ok. Then press Ok in next form to save the connection string in the web.config file.
5. Select "Create Sql Statement". Next window will popup.
   
6. Copy following text and paste it in the Sql Statement area.
   SELECT ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone FROM Person.Contact
   Then press Finish.
7. Now your default.aspx page should look like this.
   
8. Select the Gridview and set the "AllowPaging" property to true.
   
9. From the toolbox add a Button to the page, Set its Text property to Export to Excel 2007/2010, then double click it. The behind window code page will open.
10. Copy the following text and replace all the text in the code page window.
    Imports GEETMultiSheet30 Partial Class _Default Inherits System.Web.UI.Page Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click ' instantiate the export to Excel engine Dim g As New GEETStandard(ExcelOutputFormat.xlsx) ' create and add an ExcelSheet from the Gridview and its datasource g.CreateAndAddExcelSheetFromGridview("My first VB export to Excel 2007/2010", Me.SqlDataSource1, Me.GridView1, True, False) ' output it to the user g.GEETOutputResponse(HttpContext.Current.Response, "MyExport", True, HttpCacheability.ServerAndPrivate, 0) End Sub Public Overrides Sub VerifyRenderingInServerForm(ByVal control As System.Web.UI.Control) 'MyBase.VerifyRenderingInServerForm(control) End Sub End Class
11. Your code page should now look like this:
    
12. Save All, press Ctrl-F5.The browser will open and will show next page:
    
13. Press the "Export to Excel 2007" Button. Next window will popup:
    
14. Press "Ok" to open the Excel sheet and following Excel 2007/2010 (xlsx) sheet will display:
    

For any issue please write to support@gridviewtoexcel.com