flex ǰ̨µ¼³öExcel
/**=========main.mxml=========*/
/* µ¼³öexcel */
private function exp():void{
if(dgEnterprise.dataProvider==null){
Alert.show("Êý¾ÝΪ¿Õ£¬ÎÞ·¨µ¼³öexcel","ÓÑÇéÌáʾ");
}else{
ExportExccel.loadDGInExcel(dgEnterprise,"/ssfxSystem/excelexport.jsp?tableName=ÆóÒµÐÅÏ¢");
}
}
/**=========excelexport.jsp=========*/
<%@page import="java.util.Date"%>
<%@page import="java.text.SimpleDateFormat"%><%@ page language="java"%>
<%@ page contentType="application/msexcel;charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("UTF-8");
String name="";
if (request.getParameter("tableName") != null) {
name = request.getParameter("tableName");
} else {
name = "report";
}
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
Date d1 = new Date();
String date = formatter.format(d1);
response.setHeader("Content-disposition", "attachment; filename="
+" "+name+ "-" + date + ".xls");
String str = request.getParameter("htmltable");
out.print(str);
%>
/**=========ExportExcel.as=========*/
package utils
{
import flash.errors.*;
import flash.events.*;
import flash.external.*;
import flash.net.URLRequest;
import flash.net.URLRequestMethod;
import flash.net.URLVariables;
import flash.net.navigateToURL;
import mx.controls.DataGrid;
public class ExportExccel
{
public function ExportExccel()
{
}
private static function convertDGToHTMLTable(dg:DataGrid):String {
//Set default values
var font:String = dg.getStyle('fontFamily');
var size:String = dg.getStyle('fontSize');
var str:String = '';
var colors:String = '';
var style:String = 'style="font-family:'+font+';font-size:'+size+'pt;"';
var hcolor:Array;
//Retrieve the headercolor
if(dg.getStyle("headerColor") != undefined) {
hcolor = [dg.getStyle("headerColor")];
} else {
hcolor = dg.getStyle("headerColors");
}
//Set the htmlta
Ïà¹ØÎĵµ£º
ÏÖÔÚ¸»webÓ¦ÓÃÒѾÊǸö´óÇ÷ÊÆ£¬Ô½À´Ô½¶àµÄ´«Í³¿Í»§¶ËÓ¦Óö¼Ïà¼Ì±»webÓ¦ÓÃËùÌæ´ú¡£µ«ÊǼøÓÚwebÓ¦ÓõÄÈõ½»»¥ÐÔ£¬ºÜ¶àÒµÎñ¸ºÔð¡¢ÈË»ú½»»¥Ç¿µÄÓ¦Óô¿js»¹ÊDz»ÄܺܺÃʤÈΣ¬Õâ¿ÖÊÇĿǰ»¹Óкܶà»îÔ¾csÓ¦ÓôæÔÚµÄÒ»¸öÖ÷ÒªÔÒò¡£Ç°²»¾Ã£¬¹«Ë¾Ò²ÔÚ×ö¼èÄѵÄÑ¡ÔñwebÓ¦ÓÃǰ̨¿ª·¢¿ò¼ÜÑ¡ÐÍÎÊÌ⣬×îº ......
ºÜ¶à¿ª·¢ÈËÔ±¶¼ÖªµÀÈçºÎʹÓÃʼþ»úÖÆ£¬µ«È´²»Àí½âʼþ»úÖÆµÄ»ù±¾¹¤×÷ÔÀí¡£ÔÚÕâÀïÎÒÃÇ̽ÌÖÒ»ÏÂActionScript 3µÄʼþ»úÖÆ(ÎÞÂÛÊÇÐÂÊÖ»¹ÊÇÀÏÊÖ£¬ÎÒÏàÐÅ¿´µ½×îºó¿Ï¶¨¶ÔÄãÓÐËù°ïÖú )¡£
1. Ê×ÏÈÀ´¿´Ò»ÏÂʼþ»úÖÆÖеö»ù±¾¸ÅÄ
event objects(ÕâÀïÎÒÃǹÃÇÒ½ÐËüʼþ¶ÔÏó)£ºËùÓеÄʼþ¶ÔÏó¶¼ÊÇflash.events.Event»òÕ߯ä×ÓÀà¡ ......
×î½üÓöµ½¸öÎÊÌ⣬¿ª·¢webÏîÄ¿µÄʱºò£¬¿ÉÄÜflexÖ»ÓÃÀ´ÊµÏÖÏîÄ¿µÄ²¿·ÖÄ£¿é¡£µ±flexÐèÒªÔÚ¿Í»§¶ËдÈë/¶ÁȡһЩ״̬ÐÅÏ¢µÄʱºò£¬ÎÒÃÇ»áÏëµ½ÓÃcookie¡£flexÊDz»Ö§³ÖcookieµÄ£¬Ö»ÓÐSharedObjectÕâ¸ö±¾µØ¶ÔÏó¡£ËùÒÔ½â¾öµÄ°ì·¨¾ÍÓÐÁ½¸ö£º
flexͨ¹ýµ÷ÓÃjsÀ´ÊµÏÖ¶ÔcookieµÄ²Ù×÷£»
jsͨ¹ýflexʵÏÖ¶ÔSharedObjectµÄ²Ù×÷£»
ÕâÁ½ÖÖ·½·¨ ......
ÖÐÎÄÔÚÏß°ïÖúÎĵµ£ºhttp://livedocs.adobe.com/flex/3_cn/langref/
http://examples.adobe.com/flex3/componentexplorer/explorer.html¡£
ÆäËûÍøÕ¾£º
http://bbs.actionscript3.cn
http://www.airia.cn
http://www.anyflex.cn/bbs
http://www.5uflash.com/flex-air
http://www.52ria.com
http:// ......
¹ØÓÚflexÈçºÎÏòij¸öÒ³Ãæ´«µÝ²ÎÊý£¬ÎÒÒÔǰÓÐÕâ·½ÃæµÄ±Ê¼Ç£¬flexͨ
¹ý·ÇAmfPHP;¾¶Óëºǫ́½»»¥
ÖÐURLLoader+URLRequest+URLVariables·½·¨Ò²¿ÉÒÔÓÃÓÚÏòflexÒ³Ãæ´«²ÎÊý¡£ºó
̨php¶Ë½ÓÊÕ²ÎÊýºÜ¼òµ¥£¬ÏÖÔÚÌÖÂÛÒ»ÏÂflex¶ËÈçºÎ´¦ÀíÒ³Ãæurl´«µÝ¹ýÀ´µÄ²ÎÊý¡£
ÍøÉÏÕâ·½ÃæÎÄÕ²»ÉÙ£¬²»¹ý¶¼¶àÉÙÓÐЩÎÊÌ⣬ÎÒ×ܽáһϣ¬Ð´ÔÚÕâÀï¡£
·½· ......