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Ó¦ÓÃǰ̨¿ª·¢¿ò¼ÜÑ¡ÐÍÎÊÌ⣬×îº ......
ǰһÕóÔÚÂÛ̳ÉÏ¿´µ½Ò»¸öÐֵܣ¬ÏëÔÚFlex ChartÖÐΪͼÀýÉèÖÃ3DЧ¹û,½ü¼¸Ìì²éÕÒÁËЩ×ÊÁÏ£¬¶¯ÊÖ×öÁ˸öDEMO¹©´ó¼Ò²Î¿¼!
DEMOÑÝʾµØÖ·http://xingjunli.webs.com/flash/flexChartDemo.swf,ÏÈÀ´¸öͼƬ¿´¿´×îÖÕЧ¹û:
Ïà¹ØÖªÊ¶µã
......
·µ»ØÊý¾ÝµÄ¸ñʽresultFormatÓм¸ÖÖÀàÐÍ£¬object¡¢array¡¢xml¡¢flashvars¡¢textºÍe4x£¬Ä¬ÈϵÄÉèÖÃΪobject¡£
RESULT_FORMAT_ARRAY : String = "array"
[] ½á¹û¸ñʽ“array”Óë“object”ÏàËÆ£¬µ«ÊÇÆä·µ»ØµÄֵʼÖÕΪÊý×飻ÕâÑù£¬Èç¹û´Ó½á¹û¸ñʽ“object”·µ»ØµÄ½á¹ûÉв»ÊÇÊý×飬Ôò½«°Ñ¸ÃÏî ......
Summary(¸ÅÊö)£º Adobe Flex µÄ dataGrid ÓкÜÇ¿´óµÄ¹¦ÄÜ£¬±ÈÈçItemRenderer,headerRendererµÈ£¬¿ÉÒÔ·½±ãµØÊµÏÖ×Ô¼ºÏëÒªµÄ¹¦ÄÜ¡£µ«¶ÔdataGridÖ±½Ó±à¼²¢±£´æµ½Service¶Ë£¬¾ÍÓеãÂé·³ÁË¡£
Requirement(ÐèÇó)£º ¶ÔdataGrid½øÐе¥Î»¸ñ±à¼£¬ÈôÓб仯£¬±£´æµ½Service; ·ñÔò²»±£´æ¡£
Solution(½â¾ö·½°¸): ÔËÓÃDataGrid µÄ  ......
±¾ÆªÎÄÕÂÊÇ¡¶Flash Builder 4 beta (Gumbo) UI¡¢¹¦ÄܵÄÐÂÌåÑé¡·µÚÈýƪÎÄÕ£¬×ÅÖØ½éÉܵÄFlex SDK 4(Gumbo)ÐÂÔö¼ÓµÄÃüÃû¿Õ¼ä£¨NameSpace£©¡£
ÖÚËùÖÜÖª£¬Flex SDK 4(Gumbo)Ôö¼ÓÁËһЩÃüÃû¿Õ¼ä£¬Çë¿´ÈçÏ£º
xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:mx="library://ns.adobe.com/flex/halo"
xmlns:s="library://ns.a ......