http://examples.codecharge.com/ExampleP ... oExcel.php
Main page
Export to Excel
Description
This example demonstrates how to implement data export to Microsoft® Excel®.
A single Web page is used with a grid that outputs the same data in both Web and Excel modes. An event code is used to determine if Excel mode was specified via a URL parameter, and to set the appropriate content type. The code is also used to force up to 10,000 data records to be output in Excel mode.
Usage
Click on the "Export to Excel" link.
Steps to Recreate
Use the Grid Builder to create the employees grid that is based on the employees table from Intranet database.
On Step 4 select No Sorting.
On Step 5 select (No Theme).
Add the ToExcelLink Link control above the Grid and set its Default Value property to "Export to Excel", set the Preserve Parameters property to None and the Href Source property to the current page. Then add the Link Parameter with the following values: Data Source Type = Expression, Parameter Source = 1 and Parameter name = export.
Add the appropriate programming code to the Before OnInitializeView Page event and Before Select Grid event., as provided with the example.
Make cosmetic changes as needed by modifying the text and captions within the HTML.
Database Tables Used
Database: IntranetDB
Tables: employees
Events Used
The page's OnInitializeView event is used to specify the file name and required "ContentType" and "Content-Disposition" header.
The grid's Before Select is used to hide the navigator (except in .NET) and display all records in the Excel mode.
The grid's Before Show event is used to hide the navigator in .NET.
Export excel
CodeCharge Studio 2.x, 3.x, 4.x, 5.x
前往
- Software
- ↳ CodeCharge Studio
- ↳ CodeCharge
- ↳ DemoCharge
- ↳ SuperPDF
- ↳ 551einv
- ↳ E3進銷存
- 程式語言
- ↳ PHP
- ↳ CodeLobster PHP Edition
- ↳ Yii
- ↳ CodeIgniter
- ↳ Phalcon
- ↳ Symfony
- ↳ FuelPHP
- ↳ Zend Framework 2
- ↳ laravel
- ↳ WordPress
- ↳ ASP.NET/C#
- ↳ ASP/VBScript
- ↳ JSP
- ↳ Java Servlets
- ↳ ColdFusion
- ↳ Perl
- ↳ Java Script
- ↳ jQuery
- ↳ HTML + CSS
- ↳ jQuery
- ↳ nodejs
- ↳ VB6
- ↳ Git
- ↳ App Inventor 2
- ↳ bash
- ↳ C++/ VC/ OpenCV
- ↳ OpenCV
- ↳ go
- ↳ cordova
- ↳ python
- ↳ Xamarin
- ↳ Assembly
- 資料庫
- ↳ MySQL
- ↳ PostgreSQL
- ↳ ORACLE
- ↳ Access
- ↳ SQL Server
- ↳ SQLite
- ↳ MariaDB
- ↳ Mongodb
- 作業系統
- ↳ Linux
- ↳ Ubuntu
- ↳ CentOS
- ↳ Mint
- ↳ Mandriva
- ↳ Debian
- ↳ Red Hat Enterprise Linux
- ↳ Oracle Linux
- ↳ Fedora
- ↳ Kali Linux
- ↳ OpenSUSE
- ↳ Elementary OS
- ↳ Microsoft
- ↳ Server 2008 R2
- ↳ Server 2012 R2
- ↳ Server 2012
- ↳ 8
- ↳ 10
- ↳ System Center 2016
- ↳ NOVELL
- ↳ FreeBSD
- ↳ VMware
- ↳ VirtualBox
- ↳ Mac OS X
- ↳ Solaris
- ↳ iOS
- ↳ Android
- ↳ Cloud
- ↳ OpenStack
- ↳ Docker
- ↳ Proxmox VE
- ↳ CloudReady
- ↳ chrome
- 網頁伺服器
- ↳ apache
- ↳ tomcat
- ↳ nginx
- ↳ IIS
- ↳ JBoss
- ↳ weblogic
- ↳ WebHosting
- 硬體
- ↳ 硬體及週邊
- ↳ RouterOS
- ↳ LEGO NXT
- ↳ Arduino
- ↳ MSP430
- ↳ Raspberry Pi
- ↳ OpenERP
- ↳ Storage
- ↳ Server
- ↳ Brocade
- ↳ MODELS
- ↳ FortiGate
- 軟體
- ↳ sublime
- ↳ LibreNMS