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
Ïà¹ØÎĵµ£º
strategyMarketsOfCurrentStrategy.addEventListener(CollectionEvent.COLLECTION_CHANGE, strategyMarketsDataChangedHandler);
strategyMarketsOfCurrentStrategy.removeAll(); &nbs ......
¹ØÓÚFlex»òFlashµÄ¿çÓò·ÃÎʵĽâ¾ö·½°¸£¬ÊÂÇéµÄÆðÒòÊÇ£¬ÓÉÎÒ¹«¿ªµÄÒ»¸öwebservice£¨²»Çå³þÕâ¸öwebservice¸ÉʲôµÄÇë¿´ÕâÀ¿ªÊ¼µÄ£¬kenshinµÄÅóÓÑsensunÔÚÕâ¸ö¹«¿ªµÄwebserviceµÄ»ù´¡ÉÏÖÆ×÷ÁËÒ»¸öweather²éѯµÄ£¬ÔÚ±¾»ú²âÊÔok£¬Ò»Äõ½ÍøÉÏ£¬¾Í»á³öÏÖerror£¨ÊÇ¿çÓò·ÃÎʵĴíÎ󣩣¬ºóÀ´£¬kenshinÖÕÓÚÕÒµ½ÁËÕâ¸öÎÊÌâµÄ½â¾ö·½° ......
·µ»ØÊý¾ÝµÄ¸ñʽresultFormatÓм¸ÖÖÀàÐÍ£¬object¡¢array¡¢xml¡¢flashvars¡¢textºÍe4x£¬Ä¬ÈϵÄÉèÖÃΪobject¡£
RESULT_FORMAT_ARRAY : String = "array"
[] ½á¹û¸ñʽ“array”Óë“object”ÏàËÆ£¬µ«ÊÇÆä·µ»ØµÄֵʼÖÕΪÊý×飻ÕâÑù£¬Èç¹û´Ó½á¹û¸ñʽ“object”·µ»ØµÄ½á¹ûÉв»ÊÇÊý×飬Ôò½«°Ñ¸ÃÏî ......
flash.util.TimerÀà
flash.util.TimerÀàÔÊÐíͨ¹ýÌí¼Óʱ¼äʼþ»òÑÓʱÀ´µ÷Ó÷½·¨¡£Í¨¹ýTimer¹¹ÔìÆ÷´´½¨ÊµÀý¶ÔÏ󣬴«µÝÒ»¸öºÁÃëÊý×Ö×÷Ϊ¹¹Ôì²ÎÊý×÷Ϊ¼ä¸ôʱ
¼ä£¬ÏÂÃæµÄÀý×ÓʵÀý»¯Ò»¸öTimer¶ÔÏóÿ¸ö1ÃëÖÓ·¢³öʼþÐźţº
var timer.Timer = new Timer(1000);
......