Visual Studio Export GridView To Excel Control
Export GridView To Excel Control is an ASP.NET server control which allows exporting contents of GridView into Microsoft Excel or OpenOffice Spreadsheets using Aspose.Cells. It adds Export to Excel button on top of the GridView control. Clicking the button dynamically exports the content of the GridView control to a Microsoft Excel or OpenOffice Spreadsheet and then automatically downloads the exported file to the disk location selected by the user in just couple of seconds.
This initial version of the control provides the following features:
- Get an offline copy of your favorite online GridView content for editing, sharing and printing.
- Inherited from default ASP.NET GridView control and hence have all its features and properties.
- Export GridView to Xlsx, Xlsb, Xls, Txt, Csv, Ods.
- Works with all .NET versions starting from .NET 2.0.
- Ability to customize/localize Export button text.
- Apply look and feel of your own theme on Export button using css.
- Option to add custom heading on top of the exported document
- Option to save each exported document on server at configurable disk path
- Option to export current page or all pages when paging is enabled
This control allows you to export GridView in the following different file formats.
- Export GridView to Excel
- Export GridView to Xlsx
- Export GridView to Xlsb
- Export GridView to Xls
- Export GridView to Txt
- Export GridView to Csv
- Export GridView to Ods
System Requirements and Supported Platforms
Export GridView To Excel Control for Visual Studio can be used on any system that have IIS and .NET framework 2.0 or greater installed.
Export GridView To Excel Control for Visual Studio is supported of all version of ASP.NET running on .NET framework 2.0 or greater. You can use any of the following Visual Studio versions to use this control in your ASP.NET applications
- Visual Studio 2005
- Visual Studio 2008
- Visual Studio 2010
- Visual Studio 2012
- Visual Studio 2013
You can download Export GridView To Excel Control from one of the following locations
It is very simple and easy to install Export GridView To Excel Control, please follow these simple steps
For Visual Studio 2010, 2012 and 2013
- Extract the downloaded zip file
- Double click the VSIX file Aspose.Excel.GridViewExport.vsix
- A dialog will appear showing you the available and supported Visual Studio versions installed on your machine
- Select the ones you want to add the Export GridView To Excel Control to.
- Click Install
You will get a success dialog once the installation is completed.
Note: Please make sure to restart Visual Studio for the changes to take effect.
For Visual Studio 2005, 2008 and Express editions
Please follow these steps to integrate Export GridView To Excel Control in Visual studio for easy drag and drop just like other ASP.NET controls
- Extract the downloaded zip file
- Make sure to run Visual Studio as Administrator
On the Tools menu, click Choose Toolbox Items.
- Click Browse. The Open dialog box appears.
- Browse to the extracted folder and select Aspose.Excel.GridViewExport.dll
- Click OK.
When you open an aspx or ascx control in the left side Toolbox you will see ExportGridViewToWord under General Tab
Once installed, it is very easy to start using this control in your ASP.NET applications
|For .NET framework 4.0 and above||For .NET framework 2.0 and above||**|
|For applications running in .NET framework 4.0 and above in Visual Studio 2010 and above, you should see ExportGridViewToExcel control in Aspose Tab in Toolbar as shown below. You can simply drag drop this control onto your ASP.NET page, control or master page just like any other .NET control and get started.||In order you use this control in applications running in .NET 2.0 in any visual studio version make sure that you have added ExportGridViewToExcel to your toolbox as per instructions on 188.8.131.52 Downloading and Installing under heading For Visual Studio 2005, 2008 and Express editions
You should see ExportGridViewToExcel control in General Tab in Toolbar as shown below. You can simply drag drop this control onto your ASP.NET page, control or master page just like any other .NET control and get started.
Manually adding ExportGridViewToExcel control
If you have any issues using the above methods which uses Visual Studio Toolbox, you can manually add this control to your ASP.NET application running on any .NET framework greater than 2.0
- If you are using Visual Studio make sure to Run it as Administrator
- Add reference to Aspose.Excel.GridViewExport.dll available in extracted download package in your ASP.NET project or web application. Make sure your web application/Visual Studio have full access to this folder otherwise you might get Access is denied exception.
- Add this line to the top of the page, control or MasterPage
<%@ Register assembly="Aspose.Excel.GridViewExport" namespace="Aspose.Excel.GridViewExport" tagprefix="aspose" %>
- Add the following to a place on your ASP.NET page, control or masterpage where you want the control to be added
<aspose:ExportGridViewToExcel ID="ExportGridViewToExcel1" runat="server"></aspose:ExportGridViewToExcel>
Common questions and issues you might face while using this Control
|1||I cannot see ExportGridViewToExcel control in Toolbox||
Visual Studio 2010 and higher
1. Make sure that you have installed this control using VSIX extension file found in downloaded package. To verify go to Tools -> Extension and Updates. Unders Installed you should see ‘Aspose Export Export GridView To Excel Control’. If don’t see it please try re-installing it
2. Make sure your web application is running in .NET framework 4.0 or higher, for lower versions of .NET framework please check the above alternate method.
3. Make sure that you have manually added this control to your Toolbox as per above instructions.
|2||I am getting ‘Access is denied’ error when running the application||
1. If you are experiencing this problem on production then make sure that you copy both Aspose.Excel.dll and Aspose.Excel.GridViewExport.dll to your bin folder.
2. If you are using Visual Studio make sure to run it as Administrator even if you are already logged-in as administrator.
Aspose .NET Export GridView To Excel Control Properties
The following properties are exposed to configure and use cool features provided by this control
|Property Name||Type||Example/Possible values||Description|
|ExportButtonText||string||Export to Excel||You can use this property to override existing default text|
|ExportButtonCssClass||string||btn btn-primary||Css Class that is applied to the outer div of the export button. To apply css on button you can use .yourClass input|
GridView Export Example Report
|You can use html tags to add style to your heading|
|ExportOutputFormat||enum||Xlsx, Xlsb, Xls, Txt, Csv, Ods||Output format of the exported document. Supported formats are Xlsx, Xlsb, Xls, Txt, Csv, Ods|
|Local output Disk path on server where a copy of the export is automatically saved. Application must have write access to this path.|
|ExportDataSource||object||allRowsDataTable||Sets the object from which this data-bind control retrieves its list of data items. The object must have all the data that need to be exported. This property is used in addition to normal DataSource property and is useful when custom paging is enabled and current page only fetches rows to be displayed on screen.|
|LicenseFilePath||string||Local path on server to the license file. For example c:
|An example of Export GridView to Excel control with all properties used is shown below|
<aspose:ExportGridViewToExcel Width="800px" ID="ExportGridViewToExcel1" ExportButtonText="Export to Excel" CssClass="table table-hover table-bordered" ExportButtonCssClass="myClass" ExcelOutputFormat="xlsx" ExportOutputPathOnServer="c:\\temp" ExportFileHeading="<h1>Example Report</h1>" OnPageIndexChanging="ExportGridViewToExcel1_PageIndexChanging" PageSize="5" AllowPaging="True" LicenseFilePath="c:\inetpub\Aspose.Cells.lic" runat="server" CellPadding="4" ForeColor="#333333" GridLines="Both"> </aspose:ExportGridViewToExcel>
Please check the video below to see the module in action.
Support, Extend and Contribute
From the very first days of Aspose, we knew that just giving our customers good products would not be enough. We also needed to deliver good service. We are developers ourselves and understand how frustrating it is when a technical issue or a quirk in the software stops you from doing what you need to do. We’re here to solve problems, not create them.
This is why we offer free support. Anyone who uses our product, whether they have bought them or are using an evaluation, deserves our full attention and respect.
You can log any issues or suggestions related to this control using any of the following platforms
Extend and Contribute
Aspose .NET Export GridView To Excel Control for Visual Studio is open source and its source code is available on the major social coding websites listed below. Developers are encouraged to download the source code and extend the functionality as per their own requirements.
You can get the latest source code from one of the following locations
How to configure the source code
You need to have the following installed in order to open and extend the source code
- Visual Studio 2010
Please follow these simple steps to get started
- Download/Clone the source code.
- Open Visual Studio 2010 and Choose File > Open Project
- Browse to the latest source code that you have downloaded and open Aspose.Excel.GridViewExport.sln
Source code overview
There are three projects in the solution
- Aspose.Excel.GridViewExport - Contains VSIX package and Server control for .NET 4.0.
- Aspose.Excel.GridViewExport_DotNet_2.0 - Extended GridView control for .NET 2.0
- Aspose.Excel.GridViewExport.Website - Web project for testing the Excel Exportable GridView control