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
Ïà¹ØÎĵµ£º
ǰһÕóÔÚÂÛ̳ÉÏ¿´µ½Ò»¸öÐֵܣ¬ÏëÔÚFlex ChartÖÐΪͼÀýÉèÖÃ3DЧ¹û,½ü¼¸Ìì²éÕÒÁËЩ×ÊÁÏ£¬¶¯ÊÖ×öÁ˸öDEMO¹©´ó¼Ò²Î¿¼!
DEMOÑÝʾµØÖ·http://xingjunli.webs.com/flash/flexChartDemo.swf,ÏÈÀ´¸öͼƬ¿´¿´×îÖÕЧ¹û:
Ïà¹ØÖªÊ¶µã
......
Ò»¡¢Application³£ÓõÄʼþ
initialize=============>³õʼ»¯
createcomplate==========>ÔªËØ¼ÓÔØÍê
initialize·¢ÉúÔÚcreatecomplate֮ǰ¡£
¶þ¡¢Êý¾ÝÇëÇó˵Ã÷
HTTPService==========>httpÊý¾ÝÇëÇó¡£
SOAP(Simple Object Access Protocal)=======> webService
AMF(Adobe Action Message Format)========&g ......
ÖÐÎÄÔÚÏß°ïÖúÎĵµ£º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´«µÝ¹ýÀ´µÄ²ÎÊý¡£
ÍøÉÏÕâ·½ÃæÎÄÕ²»ÉÙ£¬²»¹ý¶¼¶àÉÙÓÐЩÎÊÌ⣬ÎÒ×ܽáһϣ¬Ð´ÔÚÕâÀï¡£
·½· ......
×î½ü½Ó´¥Á˺ܶණÎ÷£¬²»Í£µÄÅä»·¾³£¬Ã¿´Î°æ±¾ÎÊÌâ¶¼µÃÕÛÌÚÒ»·¬¡£
MicrostrategyÌṩÁËÒ»¸öFlex²å¼þ£¬ÓÃÀ´¿ª·¢ÏÔʾ±¨±íÊý¾ÝµÄFlashÄ£°å¡£
ÀûÓÃflex¿ª·¢¼òµ¥±¨±í¹ý³Ì£º
1.°²×°£ºMicrostrategy8.1
2.°²×°Flex Builder 2.2¡£
3.ÔÚFlex BuilderÖа²×°visualization builder²å¼þ
·½·¨£º½«\Microstrategy\SDK\t ......