Kendo Grid Export To Excel All Pages Angular

Kendo Grid Export Data To PDF and Export Data To Excel; AngularJS Tutorial AngularJS setup and Installation. One to export the grid data as a excel spreadsheet and the other as a PDF. type as AppendToSheet in exportProperties. Angular Grid Angular Data Grid component for Enterprise Apps. NET application or website, you can now easily transfer the grid data to Excel or PDF. In my last blog post, we looked at a new feature of Kendo UI Grid released as part of our Q3 2014 – namely Export to Excel. net-mvc , razor , kendo-ui , kendo-grid , kendo-asp. In my previous post I introduced you to the new feature on how to export the grid to PDF, even some of the options. Kendo Grid with external. This example shows how to enable the Export to Excel functionality of the Telerik for ASP. Once you've got all the great data presented, filtered, etc. For clients, it seems that all your work is just nothing if this omnipresent feature is not there (with the little icon obviously). NET MVC Framework In this article we are going to demonstrate jqGrid, JQuery Grid plugin which is used to display tabular data on the form. The exporter can export all data, visible data or selected data. net-mvc I have a pageable and filterable grid which I set up to export to excel using the new Kendo Grid Excel feature. Kendo UI Grid: advanced features Shall I need to have the "Export to PDF" defined as a button in the toolbar. To get started with the Ignite UI CLI and Ignite UI for Angular: npm i -g igniteui-cli ig new --framework=angular cd ig add grid ig start Adding IgniteUI for Angular to Existing Project. I will use angular datatable button directive which is based on datatable button library. When using built in pagination, the data is fully loaded before export. How to create a 3D Terrain with Google Maps and height maps in Photoshop - 3D Map Generator Terrain - Duration: 20:32. The igGridExcelExporter component allows you to export data from the igGrid into a Microsoft Excel document. The Kendo UI Grid for Angular enables you to bind it to an array or GridDataResult objects by setting the data property of the tag. Bug tracker Roadmap (vote for features) About Docs Service status. Free jQuery Plugins and Tutorials jQuery Script - Free jQuery Plugins and Tutorials. I have used different approaches to export to Excel from a Web application. All these import and export operations occur solely on the client, without having to maintain any server-side services. This is a common task for ASP. You can show the progress information, when the exporting process takes long time to complete using the exportProgressChanged event. It accepts both boolean and SelectableSettings parameters. 🔥 Images Gallery 🔥 Home Design. Added Seed Project for Angular 2. The default configuration Kendo UI Grid exports the current page of the data with sorting, filtering, grouping and aggregates applied. Basic Grid with fixed sizes (800 x 400) set by "gridHeight" & "gridWidth" Wiki HOWTO link. As simple as that, your users will be able to utilize copy and paste between across their apps, using the browser clipboard for this purpose "behind the scenes". To get started with the Ignite UI CLI and Ignite UI for Angular: npm i -g igniteui-cli ig new --framework=angular cd ig add grid ig start Adding IgniteUI for Angular to Existing Project. Integrate DHTMLX Grid into Angular, React, Vue. Let's define our FlexGrid in our component template and assign it a local variable of flex and bind it to some data. The jquery grid component delivers advanced data visualization features and built-in support for client and server-side paging, editing, sorting and filtering. Using Kendo UI with Angular 2 The Angular 2 CLI has all of the build steps for SASS already wired up, so this “just works”. how to you allow the user to download it and continue playing with it?. Added the between operator option in menu filter for filtering grid records based on the specified range. jQWidgets team. In this blog post we will take a look at how to use the Excel export feature of the Kendo UI Grid. Core feature of ag-Grid supporting Angular, React, Javascript and more. The appropriate type of data binding depends on the scenario and features of your project. Highcharts - Interactive JavaScript charts for your web pages. js and NPM are installed in your system. 1 16 July 17 - Provide Sample Demo Forms VERSION 1. jQuery Grid Export to Excel - This example ilustrates how to export portions or the whole data shown in a Shield UI grid component to Excel. To enable the Excel export, import the ExcelModule and add the kendo-grid-excel component to the Kendo UI Grid for Angular. Exporting Angular Kendo UI Grid to Excel: There is a kendo-grid-csv-download project you can attempt to use. Best Regards, Dimitar. Download ASP. Including the igniteui-angular and igniteui-cli packages to your project: ng add igniteui-angular. Highcharts - Interactive JavaScript charts for your web pages. , grouping, is lost and grid summaries are converted to strings. After all of the research, I have implemented it in my application. Instead of that the server should directly generate Excel import based on postData. Kendo Grid Export to Excel -All Pages not working I have a pageable and filterable grid which I set up to export to excel using the new Kendo Grid Excel feature. The export result preserves the structure and layout of the original grid. ng add @progress/kendo-angular-excel-export Manual Setup. How to create a 3D Terrain with Google Maps and height maps in Photoshop - 3D Map Generator Terrain - Duration: 20:32. open() method to open Excel application and pass the table's content. Install with Bower Install with NPM View Source on Github {{doc | humanizeDoc | directiveBrackets:doc. You should create a button or similar that calls this when you want to perform the export from the UI. List of All new features in SQL Server 2012 by. I researched it and found some docs but it doesn’t give any proper example for angular. One such feature is CSV Export which is used to take data out of the grid and into another application for further processing such as Excel. Best Regards, Dimitar. when a user clicks this button, I wanna make ONE EXCEL FILE with 5 sheets which have their own different grid data. If you are using dhtmlxGrid in your ASP. rdl report as symbols. Kendo Grid with external. Hi all, I am using angular js for UI and ASP. Learn how to build custom functionality when working with the Angular Grid by Kendo UI with the help of the ExcelCommandDirective. The grid doesn’t export the current CSS theme in the Excel file. There is an open source Angular viewer, that provides reasonable viewing and navigation, but doesn't support save to file. Therefore, the table formatting, e. jQWidgets team. Highcharts - Interactive JavaScript charts for your web pages. See more: kendo ui sample application, print kendo grid pdf mvc, create pdf web application, pdf flash application, export hyperlinks sheet excel pdf, export community builder user pdf files, export site page content pdf joomla, illustrator export pre press print pdf, pdf web application book, view pdf file application iphone development, html. Version 20 is available for download now, take it for a free two month trial. Here is the 10 best angular datatables which I prefer to use for advance table features. NET Forums / General ASP. Vamos a utilizar el control Kendo-UI Grid de Telerik para configurar la exportación de su contenido a PDF o Excel. Sheets with an added revenue row. In angular, we can implement above advance table features. To reduce the time required for rendering the loaded rows, set the scrolling. It is making these processes: Gets the HTML code of your table inside your div element. To enable Excel export in the pivot table, set the allowExcelExport as true. The Report Viewer provides events and properties to control and customize the exporting functionality. Telerik kendo ui angular grid to bind json. the default theme for Kendo UI For Angular 2 is pretty amazing. All credits are included in the documentation. Exporting to Different Formats. To develop this app, we have used HTML, CSS and AngularJS. jQWidgets team. Kendo Grid with external. I have a KendoUi Grid with excel inbuilt toolbar template, I am binding data to kendoGrid with ajax request for each page request I am doing ajax call to server and binding data to my grid. Kendo Grid Export To Excel All Pages Angular. NET WebForm Sample Code. The answer demonstrates how one can generate XLSX file and another answer provides the demo with an implementation of the export in ASP. js and NPM are installed in your system. Kendo Grid Export Data To PDF and Export Data To Excel 02:02. Learn how to build custom functionality when working with the Angular Grid by Kendo UI with the help of the DataBindingDirective. Kendo UI Grid Export to ExcelThe Kendo UI grid provides server-agnostic client Excel export functionality. Join today to get access to thousands of courses. If you want to export selected rows you must include the ui-grid-selection directive on your grid. Basic Grid with fixed sizes (800 x 400) set by "gridHeight" & "gridWidth" Wiki HOWTO link. rdl report as symbols. 当我们尝试从Kendo UI Grid for Angular导出网格数据时,其中一个网格列(日期列)不会格式化实际日期值。这是我的代码。. How to export a range of data from Excel to HTML or web page file? If you need to export a range of data as a web page (HTML file), how do you deal with it? This article will talk about ways about how to export Excel data in selection to an HTML file quickly. NET Forums / General ASP. Embed Excel Formulas. Exporting data from Data Grid was a high ask feature and we provided that in our latest release of the product. how to you allow the user to download it and continue playing with it?. Learn software, creative, and business skills to achieve your personal and professional goals. AngularJS UI Grid UI Grid formerly known as ng-grid which is purely built on angularjs library and it covered all core grid features like sorting, paging, filtering, exporting, etc. Fix bindKey method to select a row only if it is jqgrid row and when there is a id. You have to include the Excel toolbar command. Kendo Grid Export to Excel -All Pages not working Tag: asp. The following restrictions apply when exporting data on the client side: Only XLSX files are supported. On my current project, I have been asked to provide the users with the ability to export the contents of any Kendo UI Grid to Excel. The answer demonstrates how one can generate XLSX file and another answer provides the demo with an implementation of the export in ASP. 1 16 July 17 - Provide Sample Demo Forms VERSION 1. This is achieved by using the built-in export and save functionality provided by the Shield UI library. What I am trying to achieve is a functionality like below:. net-mvc I have a pageable and filterable grid which I set up to export to excel using the new Kendo Grid Excel feature. Exporting grid data was one of the top ask feature for Kendo UI Grid. The save function takes a FlexGrid instance as input, converts its data and formatting to Excel and returns an object containing content for the Excel file. Following example shows about how to upload the file usin. Here is my code. This sample shows how easy it is to export the Infragistics Ignite UI data grid to Excel with sorting, filtering, hiding, and summaries enabled. About AngularJS We all know Angular JS is an open-source web application framework, maintained by Google and the community, that assists with creating single-page applications. GLYPHICONS is a library of precisely prepared monochromatic icons and symbols, created with an emphasis to simplicity and easy orientation. This page contains the appropriate DevExpress editors for each Grid View column. rdl report as symbols. $ cnpm install @progress/kendo-angular-excel-export. It is a much better way to export Gridviews to Excel. For clients, it seems that all your work is just nothing if this omnipresent feature is not there (with the little icon obviously). Export in native Excel Format which will maintain the column widths and also allow exporting of styles. Basic Grid with fixed sizes (800 x 400) set by "gridHeight" & "gridWidth" Wiki HOWTO link. If you love the item, Dont forget to rate it out! CHANGELOG VERSION 1. NET MVC Framework In this article we are going to demonstrate jqGrid, JQuery Grid plugin which is used to display tabular data on the form. We set a property exportcol which will then overwrite dynamically set hidden column; Fix setGridWidth method in case grid overflow-y is set to scroll. Angular is a platform for building mobile and desktop web applications. Export event handling. I wasted my whole day in it, but not find any solution. The exporting functionality is encapsulated in the IgxExcelExporterService class and the data is exported in MS Excel table format. Kendo Grid Export to Excel -All Pages not working Tag: asp. The good thing is this is a data grid control that can be used for any kind of data where Export , Add / Edit / Delete buttons, their title and Search control. Bootstrap Icons. Learn how to build custom functionality when working with the Angular Grid by Kendo UI with the help of the EqualFilterOperatorComponent. Creating a Grid: First we will create a simple Kendo. So if you want to extract any text from the PDF your not able to. First of all you need to inject uiGridExporterService. In angular, we can implement above advance table features. toCSV(, [array of field names to export without template]); This include file contains a function for producing a CSV file from the contents of the Kendo Grid. Today, I came across a scenario where I need to customize the inbuilt export to excel functionality in kendo grid while exporting the grid data, i. I have read the documentation here and I managed to export all data but e. jQWidgets Grid for Angular 8 is a professional datagrid component built with Typescript, Angular and the jQWidgets framework. Kendo Grid with external. The igGridExcelExporter component allows you to export data from the igGrid into a Microsoft Excel document. This screen almost looks like the previous article, Angular 2 to Angular 4 with Angular Material UI Components project's screen except Export to Excel button and Sorting up/down icons. In this post, I will show you how to export an excel file in angular 6. Excel Export. Kendo Grid Export To Excel All Pages Angular. This is a common task for ASP. I researched it and found some docs but it doesn’t give any proper example for angular. By default, the Grid exports its current data. e where I need to get some of the column data which is hidden in grid while downloading it as excel, which can easily done using show/hide column and bind function of kendo grid. By default the grid exports only the current page. Telerik kendo ui angular grid to bind json. All Telerik. However, you can maintain such information by exporting grid data in the DataAware mode. The appropriate type of data binding depends on the scenario and features of your project. I have used different approaches to export to Excel from a Web application. Javascript: Export HTML Table to Excel With Custom File Name. NET WebForm Sample Code. Kendo Grid export to excel working on Local , but not on STAGE I am trying to export to excel in Kendo Grid using AngularJs, It is working fine on Local, but not STAGE. , grouping, is lost and grid summaries are converted to strings. I have read the documentation here and I managed to export all data but e. This is a common task for ASP. The Angular Grid/Data Grid/Data Table, is a feature-rich control for displaying data in a tabular format. dhtmlxGrid can load data from different data sources: XML. js and NPM are installed in your system. Add a drag-and-drop target inside the grid. Here's some options and guidance of when to use each one. How to export a range of data from Excel to HTML or web page file? If you need to export a range of data as a web page (HTML file), how do you deal with it? This article will talk about ways about how to export Excel data in selection to an HTML file quickly. Version 20 is available for download now, take it for a free two month trial. Vamos a usar la plantilla Kendo UI ASP. To enable the Excel export, import the ExcelModule and add the kendo-grid-excel component to the Kendo UI Grid for Angular. It understands UTC/GMT and the continental US time zone abbreviations, but for general use, use a time zone offset, for example, '+0430' (4 hours, 30 minutes east of the Greenwich meridian) If not specified, the timezone of the browser will be used. Join the community of millions of developers who build compelling user interfaces with Angular. Here is the 10 best angular datatables which I prefer to use for advance table features. We base all our Angular grid UI interactions on familiar Excel functionality to make it easy for your users to get started with the grid. For external pagination, use the exportAllDataPromise function to load all grid data. To enable it, include the corresponding command to the grid toolbar and configure the export settings accordingly. The Kendo UI grid provides client Excel export functionality (server-agnostic) which can be directly utilized to serve the purpose to share data in the aforementioned ways. using HTML5. Same sheet. When using grid, it is often useful and important to export your data to MS Excel in order to make it accessible offline, share it with your colleagues, etc. I have used different approaches to export to Excel from a Web application. Use the FOR JSON clause to simplify client applications by delegating the formatting of JSON output from the app to SQL Server. The Angular Grid/Data Grid/Data Table, is a feature-rich control for displaying data in a tabular format. Export help to store information into file in readable format. The default export options can be overriden to customize the columns, types, formatting, rows and. There is an open source Angular viewer, that provides reasonable viewing and navigation, but doesn't support save to file. NET / MVC / Data getting but not populating in kendo grid using angularjs service Data getting but not populating in kendo grid using angularjs service in mvc 5? [Answered] RSS. handsontable is a powerful, flexible, feature-rich, Excel-like CRUD data grid/table library for JavaScript, Angular, React, and Vue. Link for csharp, asp. net-mvc , razor , kendo-ui , kendo-grid , kendo-asp. Modern Living Room; White Living Room; Blue Living Room. The solution here uses ASP. how to you allow the user to download it and continue playing with it?. Notice how the grid remains fast and fluid even with large numbers of data items. Export to PDF is a joke in Kendo, it literally takes a screen cap of the visible portion of the grid. How to export a range of data from Excel to HTML or web page file? If you need to export a range of data as a web page (HTML file), how do you deal with it? This article will talk about ways about how to export Excel data in selection to an HTML file quickly. We're happy to introduce an ASP. In order for the styles to be applied, disable ViewEncapsulation on the component. net-mvc / asp. The Kendo UI Angular Grid Component displays data in a tabular format and provides a full spectrum of configuration options. The Ignite UI for Angular Excel Exporter service can export data in Microsoft® Excel® format from raw data (array) or from the following components: IgxGrid and IgxTreeGrid. Orange Box Ceo 7,804,705 views. Here's some options and guidance of when to use each one. You can also use CSV file to store data into mysql. I researched it and found some docs but it doesn’t give any proper example for angular. Support has been provided to export multiple hierarchy levels in the grid control for PDF, Excel, and Word file formats. Although each Ajax request might take a fraction of a second to complete, this approach might be preferable to a large wait up-front as all data loads. Before going to the initial setup of the project, just make sure that the latest versions of Node. 716); Telerik provides Kendo UI AngularJS integration support for licensed customers. Same sheet. The built-in behavior of the Grid is designed to export only the its current state—filtered, sorted, paged, and grouped. Angular UI Datepicker used for date controls, although you can use any other framework, plugin or styling. xlsx) import/export capabilities provided by the wijmo. JSFiddle or its authors are not responsible or liable for any loss or damage of any kind during the usage of provided code. open() method to open Excel application and pass the table's content. Excel Export The Grid provides options for exporting its data to Excel. It is a much better way to export Gridviews to Excel. jQWidgets team. Customizing the Exported Content. This article tells you how to implement Export to excel and PDF functionality in Kendo Grid with remote data binding for Angular 2. This page contains the appropriate DevExpress editors for each Grid View column. This is a simple method of creating an Excel export function on your Kendo UI grid with a Java EE server. Export All Data shows how to export all pages. If the grid is bound to remote data and allPages is set to true it will request all data items from the remote service. The default configuration Kendo UI Grid exports the current page of the data with sorting, filtering, grouping and aggregates applied. Alternative plugins: Export Table & JSON Data To Excel With jQuery - ExportToExcel; Exporting Html Tables To CSV/XLS/XLSX/Text - jQuery TableExport; HTML Table To Excel Converter - saveAsExcel. Kendo UI Grid: advanced features Shall I need to have the “Export to PDF” defined as a button in the toolbar. This is necessary to pass Section 508 a11y. Here is the 10 best angular datatables which I prefer to use for advance table features. Kendo Grid export to excel working on Local , but not on STAGE I am trying to export to excel in Kendo Grid using AngularJs, It is working fine on Local, but not STAGE. NET developers. The good thing is this is a data grid control that can be used for any kind of data where Export , Add / Edit / Delete buttons, their title and Search control. xlsx module. Export to PDF is a joke in Kendo, it literally takes a screen cap of the visible portion of the grid. JS function to trigger Excel export In your web-page with the grid - insert this JS function. When pressing the button, it will trigger the export process and the browser will download a file named "ExportedDataFile. To enable Excel export in the pivot table, set the allowExcelExport as true. 当我们尝试从Kendo UI Grid for Angular导出网格数据时,其中一个网格列(日期列)不会格式化实际日期值。这是我的代码。. Embed Excel Formulas. The following restrictions apply when exporting data on the client side: Only XLSX files are supported. Export in native Excel Format which will maintain the column widths and also allow exporting of styles. js and NPM are installed in your system. com Today, I came across a scenario where I need to customize the inbuilt export to excel functionality in kendo grid while exporting the grid data, i. Important : Keep in mind that Chrome doesn't allow you to open local files for security purposes, so you need to use a web browser like Firefox to successfully run this code. In this post, I will show you how to export an excel file in angular 6. Link for csharp, asp. To enable the Excel export, import the ExcelModule and add the kendo-grid-excel component to the Kendo UI Grid for Angular. Export All Data shows how to export all pages. How to create a 3D Terrain with Google Maps and height maps in Photoshop - 3D Map Generator Terrain - Duration: 20:32. 我想在将网格导出为pdf时排除最后一列。 这是我的pdf导出组件,我在不同的组件中使用它。 这个应用程序kendo pdf组件. js and NPM are installed in your system. Because of that resemblance the grid is also referred to as Angular Table or Angular Data Table. Join today to get access to thousands of courses. Learn how to build custom functionality when working with the Angular Grid by Kendo UI with the help of the ExcelModule. open() method to open Excel application and pass the table's content. net-mvc , razor , kendo-ui , kendo-grid , kendo-asp. Enterprise feature of ag-Grid supporting Angular, React, Javascript and more. Provided support to export the grid with the details template in Excel, PDF, and Word file formats. Kendo UI Grid with external buttons to export. This is achieved by using the built-in export and save functionality provided by the Shield UI library. The page size is set using the paging. Each sheet could be 1,2 or 3 pages. Note that in this demo, export to table formats (XLS, XLSX, and CSV) is performed in the WYSIWYG (What You See Is What You Get) mode. To enable the Excel export, import the ExcelModule and add the kendo-grid-excel component to the Kendo UI Grid for Angular. In the above examples the Excel Exporter service was exporting all available data. Kendo UI Grid: advanced features Shall I need to have the "Export to PDF" defined as a button in the toolbar. When we try to export the grid data from Kendo UI Grid for Angular, One of the grid columns (Date column) doesn't format the actual date value. The export can support themes and workbook customization while reflecting data manipulated in the grid through features Sorting, Filtering, Paging, etc. dhtmlxGrid can load data from different data sources: XML. Learn software, creative, and business skills to achieve your personal and professional goals. It is a much better way to export Gridviews to Excel. The jquery grid component delivers advanced data visualization features and built-in support for client and server-side paging, editing, sorting and filtering. Vamos a utilizar el control Kendo-UI Grid de Telerik para configurar la exportación de su contenido a PDF o Excel. If you want to export selected rows you must include the ui-grid-selection directive on your grid. See readme for more information. Here is the 10 best angular datatables which I prefer to use for advance table features. Download and install the package. The larger it is, the fewer requests are sent to the server. com/code-library/mvc/grid/export-grid-to-excel. Excel Export. Column Menu. To export the table, use window. En el siguiente enlace podéis descargar el proyecto del servicio web OData que usaremos para este artículo. Excel()) as well as specify the FileName export setting. To export in same sheet, define multipleExport. NuGet then does the same for all other packages, no matter how deep the dependency graph. In this article, we will learn how to export data in CSV format with Kendo UI in Angular. It accepts both boolean and SelectableSettings parameters. 当我们尝试从Kendo UI Grid for Angular导出网格数据时,其中一个网格列(日期列)不会格式化实际日期值。这是我的代码。. net, dotnet basics and sql server video tutorial playlists In this video, we will discuss about exporting gridview data to excel. The Kendo UI Angular Grid Component displays data in a tabular format and provides a full spectrum of configuration options. Hi all, I am using angular js for UI and ASP. But how about exporting HTML table data to Excel using jQuery. If the grid is bound to remote data and allPages is set to true it will request all data items from the remote service. If you love the item, Dont forget to rate it out! CHANGELOG VERSION 1. The Ignite UI for Angular Excel Exporter service can export data in Microsoft® Excel® format from raw data (array) or from the following components: IgxGrid and IgxTreeGrid. After all of the research, I have implemented it in my application. The solution here uses ASP. Using Kendo UI with Angular 2 The Angular 2 CLI has all of the build steps for SASS already wired up, so this “just works”. Angular Data Grid sample using out-of-box Bootstrap styling Features enabled: sorting, filtering (using both in-grid and external controls), sync with browser URLs, pagination and items-per-page functionality, optional plugin for CSV exports. Prerequisites NOTE : If anyone who is familiar with Export with PDF and Excel in Kendo Grid with Angular, then they can skip to this section, as they must already know how to set up and install Kendo UI controls. Each page of data (referred to as a draw in DataTables terminology) involves making an Ajax request to the server. The larger it is, the fewer requests are sent to the server. JavaScript data grid that looks and feels like a spreadsheet. I have used different approaches to export to Excel from a Web application. Link for csharp, asp. The article will also discuss how to export the Grid to the Excel format. In the above examples the Excel Exporter service was exporting all available data. You must have exported table data to excel using server side language like ASP. Export to PDF is a joke in Kendo, it literally takes a screen cap of the visible portion of the grid. Although each Ajax request might take a fraction of a second to complete, this approach might be preferable to a large wait up-front as all data loads. Kendo UI for Angular. We have provided a simple command which can be used in toolbar and provide export to excel or export to pdf option. Core feature of ag-Grid supporting Angular, React, Javascript and more. To apply the styles to all exported pages at once during multipage export, use the kendo-pdf-document element. Allow uploading multiple files and combine them all into one grid; Download a spreadsheet from UI-Grid directly in the browser (Let me know if you are interested in this one in the comments below and I'll do another post). All credits are included in the documentation. Hi all, this time I came up with a feature to implement the exporting an Excel file in our web apps built with Angular. Exporting to Different Formats. net-mvc I have a pageable and filterable grid which I set up to export to excel using the new Kendo Grid Excel feature. JS function to trigger Excel export In your web-page with the grid - insert this JS function. Using Kendo UI with Angular 2 The Angular 2 CLI has all of the build steps for SASS already wired up, so this "just works". Learn software, creative, and business skills to achieve your personal and professional goals. Component may contains some issues, but feel free to add it to your page! Code Demo. Be careful if you have a lot of data. The excel export provides support to export multiple grids in same sheet. I would like to make a button on this form that, when clicked, takes all of the information from the Grid Control and puts it into a Microsoft Excel spreadsheet, wo that it can be saved and data can be manipulated.