This tool enables any ASPX and WinForms developer to export data in tabular form to Excel in a matter of seconds. It consists mainly of an assembly (a dll) which is installed on your machine. After referencing the dll from your Visual Studio project you can export data to Excel 2003/2007 by writing, in most cases, two lines of codes. Neither Office or VSTO or other software installation is required. You simply need .Net Framework 3.5. By using this tool you can: 1) export data from Sqldatasource, Dataview and ObjectDataSource, Dataset to Excel 2003 xml and Excel 2007 xlsx formats 2) use always the same code to export data from different data sources 3) choose which columns to export 4) either infer Excel Column Headers from Gridview Column Headers or set them manually 5) obtain Multiple Sheets Excel 2003 and/or Excel 2007 Workbook by providing one Datasource for each Excel Sheet 6) add hyperlink columns to your export by specifying the href column and text column you want to display 7) make your sheets to have a Total line either at bottom or at the top of the sheets (with real Excel formulas) 8) add computed columns to your Excel Sheet by defining your own formulas in excel R1C1 mode. 9) display a Title line on each Excel Sheet 10) provide already "filter ready" Excel Sheets sparing the user this activity 11) provide "already frozen panes" Excel Sheet so that the user can scroll data without losing sight of column headers 12) either display the Excel Export immediately to the User or zip it and send it via email 13) provide format styles for headers'' rows, columns, total row, bottom rows 14) obtain multisheet Excel Workbooks by defining one datasource for each sheet The capability to export data from Dataview virtually enables you to extract data from any datatable and, consequently, from any database or datasource which you can feed a datatable from. Read the "GEET readme.pdf" instructions on how to proceed.
VERSION HISTORY
- Version 3.0.0.10 posted on 2011-01-21
The new GEETStandard Class allows the user to choose between XML and XLSX export at instantiation time. Http Response, saving to file and sending emails are possible at the same time.
Program Details
- Category: Web Development > ASP & PHP
- Publisher: Cefalà Ing. Ettore
- License: Free Trial
- Price: $50.00
- Version: 3.0.0.10
- Platform: windows
EULA
Gridview To Excel Export Tool LICENSE TERMS GRIDVIEW TO EXCEL EXPORT TOOL These license terms are an agreement between Cefalà Ing. Ettore and you. Please read them. They apply to the software named above, which includes the media on which you received it, if any. The terms also apply to any • updates, • supplements, • Internet-based services, and • support services for this software, unless other terms accompany those items. If so, those terms apply. BY USING THE SOFTWARE, YOU ACCEPT THESE TERMS. IF YOU DO NOT ACCEPT THEM, DO NOT USE THE SOFTWARE. INSTEAD, WRITE TO [email protected] FOR A REFUND OR CREDIT. AS DESCRIBED BELOW, USING SOME FEATURES ALSO OPERATES AS YOUR CONSENT TO THE TRANSMISSION OF CERTAIN STANDARD COMPUTER INFORMATION FOR INTERNET-BASED SERVICES. IF YOU COMPLY WITH THESE LICENSE TERMS, YOU HAVE THE RIGHTS BELOW FOR EACH LICENSE YOU ACQUIRE. 1. OVERVIEW. a. Software. The software includes development tools, software programs and documentation. b. License Model. The software is licensed on a per machine basis. 2. INSTALLATION AND USE RIGHTS. a. General. The software may be installed and used to design, develop, test, demonstrate and run your programs both in test and production environment according to following available licenses. b. License. A License is required to run this software. You can either download a free Demo License during installation or acquire a purchased License through email or other means. c. Free License for workstation. This free license allows you to install and run this software without any expiration date on any Microsoft Windows workstation Operating System. d. 60 Days Demo Server License. This free license allows you to install and use this software to design, develop, test and demonstrate your programs on any Windows Server for 60 days from installation date. e. Standard Server License. This license, allows you, after paying a License fee, to run this software on a production environment on a Windows Server without any time limit. f. Accordingly to each License Type limits, any user having local or remote access to the machine on which it is installed, is allowed to use this software. 3. ADDITIONAL LICENSING REQUIREMENTS AND/OR USE RIGHTS. • Installing on third part computers. Whenever you install this software on a third part Server computer, you are required to make it known to the third part that a License is required to run the software. Then a license should be installed according to this agreement terms. In any case you should provide the third part of an appropriate tool to query the License Data of the software such as that provided with the “Demo Site” sample code which accompanies this tool (www.LicenseData.aspx). • Third Party Distribution. You may permit distributors of your programs to copy and distribute this software as far as all terms of this agreement are complied with. • indemnify, defend, and hold harmless Cefalà Ing. Ettore from any claims, including attorneys’ fees, related to the distribution or use of your programs. • Distribution Restrictions. You may not • alter any copyright, trademark or patent notice in the software; • use Cefalà Ing. Ettore’s trademarks in your programs’ names or in a way that suggests your programs come from or are endorsed by Cefalà Ing. Ettore; • include Distributable Code in malicious, deceptive or unlawful programs; or • the code be disclosed or distributed in source code form; or • others have the right to modify it. 4. INTERNET-BASED SERVICES. Cefalà Ing. Ettore provides Internet-based services with the software. It may change or cancel them at any time. • Consent for Internet-Based Services. The software features described below connect to Cefalà Ing. Ettore or service provider computer systems over the Internet. In some cases, you will not receive a separate notice when they connect. BY USING THESE FEATURES, YOU CONSENT TO THE TRANSMISSION OF THIS INFORMATION. Cefalà Ing. Ettore does not use the information to identify or contact you. • Computer Information. The following features use Internet protocols, which send to the appropriate systems computer information, such as your Internet protocol address, the type of operating system, browser and name and version of the software you are using, and the language code of the device where you installed the software. Cefalà Ing. Ettore uses this information to make the Internet-based services available to you. • Web Content Features. Features in the software can retrieve related content from Microsoft and provide it to you. To provide the content, these features send to Microsoft the type of operating system, name and version of the software you are using, type of browser and language code of the device where you installed the software. • Misuse of Internet-based Services. You may not use these services in any way that could harm them or impair anyone else’s use of them. You may not use the services to try to gain unauthorized access to any service, data, account or network by any means. 5. TRIAL EDITION SOFTWARE TERMS. The following terms apply to the Trial Edition software even if there are terms to the contrary in other parts of this agreement: • TIME-SENSITIVE SOFTWARE. If the installed License is a 60 days Demo License, the software will stop running sixty days after you install it. You can check the expiration date by running the Installation program provided ad installation. At any time either before or after expiration date you can replace the 60 days Demo License with a purchased definitive one by means of the software Installation program. • DISCLAIMER OF WARRANTY. THE TRIAL EDITION SOFTWARE IS LICENSED “AS-IS.” YOU BEAR THE RISK OF USING IT. Cefalà Ing. Ettore GIVES NO EXPRESS WARRANTIES, GUARANTEES OR CONDITIONS. YOU MAY HAVE ADDITIONAL CONSUMER RIGHTS UNDER YOUR LOCAL LAWS WHICH THIS AGREEMENT CANNOT CHANGE. TO THE EXTENT PERMITTED UNDER YOUR LOCAL LAWS, Cefalà Ing. Ettore EXCLUDES THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT. • LIMITATION ON AND EXCLUSION OF REMEDIES AND DAMAGES. FOR THE TRIAL EDITION SOFTWARE, YOU CAN RECOVER FROM MICROSOFT AND ITS SUPPLIERS ONLY DIRECT DAMAGES UP TO €5.00. YOU CANNOT RECOVER ANY OTHER DAMAGES, INCLUDING CONSEQUENTIAL, LOST PROFITS, SPECIAL, INDIRECT OR INCIDENTAL DAMAGES. • This limitation applies to • anything related to the software, services, content (including code) on third party Internet sites, or third party programs; and • claims for breach of contract, breach of warranty, guarantee or condition, strict liability, negligence, or other tort to the extent permitted by applicable law. • It also applies even if Microsoft knew or should have known about the possibility of the damages. The above limitation or exclusion may not apply to you because your country may not allow the exclusion or limitation of incidental, consequential or other damages. 6. PRODUCT KEYS. The software requires a key to install or access it. You are responsible for the use of keys assigned to you. You should not share the keys with third parties. 7. BENCHMARK TESTING. You must obtain Cefalà Ing. Ettore’s prior written approval to disclose to a third party the results of any benchmark test of this software. 10. SCOPE OF LICENSE. The software is licensed, not sold. This agreement only gives you some rights to use the software. Cefalà Ing. Ettore reserves all other rights. Unless applicable law gives you more rights despite this limitation, you may use the software only as expressly permitted in this agreement. In doing so, you must comply with any technical limitations in the software that only allow you to use it in certain ways. You may not • work around any technical limitations in the software; • reverse engineer, decompile or disassemble the software, except and only to the extent that applicable law expressly permits, despite this limitation; • make more copies of the software than specified in this agreement or allowed by applicable law, despite this limitation; • publish the software for others to copy; • rent, lease or lend the software; or • use the software for commercial software hosting services. 12. BACKUP COPY. You may make one backup copy of the software. You may use it only to reinstall the software. 13. DOCUMENTATION. Any person that has valid access to your computer or internal network may copy and use the documentation for your internal, reference purposes. 16. UPGRADE. If this software is marked as an upgrade version, you may use it only if you have a license to use the software eligible for upgrade. If you upgrade, this software takes the place of the earlier version, and this agreement takes the place of the agreement for that earlier version. You may use the earlier version only as permitted in the Downgrade clause below. 17. DOWNGRADE. You may install and use this version and an earlier version of the software at the same time. This agreement applies to your use of the earlier version. If the earlier version includes different components, any terms for those components in the agreement that comes with the earlier version apply to your use of them. Microsoft is not obligated to supply earlier versions to you. 18. TRANSFER TO A THIRD PARTY. The first user of the software may transfer it, and this agreement, directly to a third party. Before the transfer, that party must agree that this agreement applies to the transfer and use of the software. The first user must uninstall the software before transferring it separately from the device. The first user may not retain any copies. 19. EXPORT RESTRICTIONS. The software is subject to Italy export laws and regulations. You must comply with all domestic and international export laws and regulations that apply to the software. These laws include restrictions on destinations, end users and end use. 20. SUPPORT SERVICES. Cefalà Ing. Ettore provides support services for the software as described at www.e-cefala.it. 21. ENTIRE AGREEMENT. This agreement (including the warranty below), and the terms for supplements, updates, Internet-based services and support services that you use, are the entire agreement for the software and support services. 22. APPLICABLE LAW. a. Italy. If you acquired the software in Italy, Italian law governs the interpretation of this agreement and applies to claims for breach of it, regardless of conflict of laws principles. b. Outside the United States. If you acquired the software in any other country, the laws of that country apply. 23. LEGAL EFFECT. This agreement describes certain legal rights. You may have other rights under the laws of your state or country. You may also have rights with respect to the party from whom you acquired the software. This agreement does not change your rights under the laws of your state or country if the laws of your state or country do not permit it to do so. 24. LIMITATION ON AND EXCLUSION OF DAMAGES. YOU CAN RECOVER FROM Cefalà Ing. Ettore ONLY DIRECT DAMAGES UP TO THE AMOUNT YOU PAID FOR THE SOFTWARE. YOU CANNOT RECOVER ANY OTHER DAMAGES, INCLUDING CONSEQUENTIAL, LOST PROFITS, SPECIAL, INDIRECT OR INCIDENTAL DAMAGES. This limitation applies to • anything related to the software, services, content (including code) on third party Internet sites, or third party programs; and • claims for breach of contract, breach of warranty, guarantee or condition, strict liability, negligence, or other tort to the extent permitted by applicable law. • It also applies even if • repair, replacement or a refund for the software does not fully compensate you for any losses; or • Microsoft knew or should have known about the possibility of the damages. • Some states do not allow the exclusion or limitation of incidental or consequential damages, so the above limitation or exclusion may not apply to you. They also may not apply to you because your country may not allow the exclusion or limitation of incidental, consequential or other damages. ************************************************************************* LIMITED WARRANTY A. LIMITED WARRANTY. If you follow the instructions, the software will perform substantially as described in the Cefalà Ing. Ettore materials that you receive in or with the software. B. TERM OF WARRANTY; WARRANTY RECIPIENT; LENGTH OF ANY IMPLIED WARRANTIES. THE LIMITED WARRANTY COVERS THE SOFTWARE FOR ONE YEAR AFTER ACQUIRED BY THE FIRST USER. IF YOU RECEIVE SUPPLEMENTS, UPDATES, OR REPLACEMENT SOFTWARE DURING THAT YEAR, THEY WILL BE COVERED FOR THE REMAINDER OF THE WARRANTY OR 30 DAYS, WHICHEVER IS LONGER. If the first user transfers the software, the remainder of the warranty will apply to the recipient. TO THE EXTENT PERMITTED BY LAW, ANY IMPLIED WARRANTIES, GUARANTEES OR CONDITIONS LAST ONLY DURING THE TERM OF THE LIMITED WARRANTY. Some states do not allow limitations on how long an implied warranty lasts, so these limitations may not apply to you. They also might not apply to you because some countries may not allow limitations on how long an implied warranty, guarantee or condition lasts. C. EXCLUSIONS FROM WARRANTY. This warranty does not cover problems caused by your acts (or failures to act), the acts of others, or events beyond Microsoft’s reasonable control. D. REMEDY FOR BREACH OF WARRANTY. Cefalà Ing. Ettore WILL REPAIR OR REPLACE THE SOFTWARE AT NO CHARGE. IF Cefalà Ing. Ettore CANNOT REPAIR OR REPLACE IT, Cefalà Ing. Ettore WILL REFUND THE AMOUNT SHOWN ON YOUR RECEIPT FOR THE SOFTWARE. IT WILL ALSO REPAIR OR REPLACE SUPPLEMENTS, UPDATES AND REPLACEMENT SOFTWARE AT NO CHARGE. IF Cefalà Ing. Ettore CANNOT REPAIR OR REPLACE THEM, IT WILL REFUND THE AMOUNT YOU PAID FOR THEM, IF ANY. YOU MUST UNINSTALL THE SOFTWARE AND RETURN ANY MEDIA AND OTHER ASSOCIATED MATERIALS TO Cefalà Ing. Ettore WITH PROOF OF PURCHASE TO OBTAIN A REFUND. THESE ARE YOUR ONLY REMEDIES FOR BREACH OF THE LIMITED WARRANTY. E. CONSUMER RIGHTS NOT AFFECTED. YOU MAY HAVE ADDITIONAL CONSUMER RIGHTS UNDER YOUR LOCAL LAWS, WHICH THIS AGREEMENT CANNOT CHANGE. F. WARRANTY PROCEDURES. You need proof of purchase for warranty service. For warranty service or information about how to obtain a refund contact Cefalà Ing. Ettore at Cefalà Ing. Ettore Via Conca del Naviglio,5 20123 Milano MI Italy G. NO OTHER WARRANTIES. THE LIMITED WARRANTY IS THE ONLY DIRECT WARRANTY FROM Cefalà Ing. Ettore. Cefalà Ing. Ettore GIVES NO OTHER EXPRESS WARRANTIES, GUARANTEES OR CONDITIONS. WHERE ALLOWED BY YOUR LOCAL LAWS, Cefalà Ing. Ettore EXCLUDES IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT. If your local laws give you any implied warranties, guarantees or conditions, despite this exclusion, your remedies are described in the Remedy for Breach of Warranty clause above, to the extent permitted by your local laws. H. LIMITATION ON AND EXCLUSION OF DAMAGES FOR BREACH OF WARRANTY. THE LIMITATION ON AND EXCLUSION OF DAMAGES CLAUSE ABOVE APPLIES TO BREACHES OF THIS LIMITED WARRANTY. THIS WARRANTY GIVES YOU SPECIFIC LEGAL RIGHTS, AND YOU MAY ALSO HAVE OTHER RIGHTS WHICH VARY FROM COUNTRY TO COUNTRY.