Flex EXCEL导出

最新推荐文章于 2014-01-03 10:00:17 发布
最新推荐文章于 2014-01-03 10:00:17 发布
阅读量954 收藏
点赞数
文章标签： flex excel datagrid string colors variables
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/aisoo/article/details/5831723
版权

flex端：

     <?xml version = "1.0" encoding = "utf-8"?>
<mx:Application xmlns:mx = "http://www.adobe.com/2006/mxml"
                layout = "absolute">

    <mx:Script>
        <![CDATA[
            import flash.errors.*;
            import flash.events.*;
            import flash.external.*;
            import flash.net.URLRequest;
            import flash.net.URLVariables;
            import mx.collections.ArrayCollection;

            [Bindable]
            private var datalist:ArrayCollection =
                            new ArrayCollection([{ 姓名: "张三", 性别: "男", 年龄: "23", 生日: "1984-01-12" },
                                                 { 姓名: "李四", 性别: "男", 年龄: "27", 生日: "1983-11-2" }]);

            /**
             * Convert the datagrid to a html table
             * Styling etc. can be done externally
             *
             * @param: dg Datagrid Contains the datagrid that needs to be converted
             * @returns: String
             */
            private 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 htmltabel based upon knowlegde from the datagrid
                //解决乱码<head><meta http-equiv="Content-Type" content="text/htm; charset=utf-8"></head>
                str +=
                                '<head><meta http-equiv="Content-Type" content="text/htm; charset=utf-8"></head><table width="' + dg.width + '" border="1"><thead><tr width="' + dg.width + '" style="background-color:#' + Number((hcolor[0])).toString(16) + '">';

                //Set the tableheader data (retrieves information from the datagrid header    
                for (var i:int = 0; i < dg.columns.length; i++)
                {
                    colors = dg.getStyle("themeColor");

                    if (dg.columns[i].headerText != undefined)
                    {
                        str += "<th " + style + ">" + dg.columns[i].headerText + "</th>";
                    }
                    else
                    {
                        str += "<th " + style + ">" + dg.columns[i].dataField + "</th>";
                    }
                }
                str += "</tr></thead><tbody>";
                colors = dg.getStyle("alternatingRowColors");

                //Loop through the records in the dataprovider and
                //insert the column information into the table
                for (var j:int = 0; j < dg.dataProvider.length; j++)
                {
                    str += "<tr width=/"" + Math.ceil(dg.width) + "/">";

                    for (var k:int = 0; k < dg.columns.length; k++)
                    {

                        //Do we still have a valid item?      
                        if (dg.dataProvider.getItemAt(j) != undefined &&
                                        dg.dataProvider.getItemAt(j) != null)
                        {

                            //Check to see if the user specified a labelfunction which we must
                            //use instead of the dataField
                            if (dg.columns[k].labelFunction != undefined)
                            {
                                str +=
                                                "<td width=/"" + Math.ceil(dg.columns[k].width) + "/" " + style + ">" + dg.columns[k].labelFunction(dg.dataProvider.getItemAt(j),
                                                                                                                                                                              dg.columns[k].dataField) + "</td>";

                            }
                            else
                            {
                                //Our dataprovider contains the real data
                                //We need the column information (dataField)
                                //to specify which key to use.
                                str +=
                                                "<td width=/"" + Math.ceil(dg.columns[k].width) + "/" " + style + ">" + dg.dataProvider.getItemAt(j)[dg.columns[k].dataField] + "</td>";
                            }
                        }
                    }
                    str += "</tr>";
                }
                str += "</tbody></table>";

                return str;
            }

            private function loadDGInExcel(dg:DataGrid, url:String):void
            {

                //Pass the htmltable in a variable so that it can be delivered
                //to the backend script
                var variables:URLVariables = new URLVariables();
                variables.htmltable = convertDGToHTMLTable(dg);

                //Setup a new request and make sure that we are
                //sending the data through a post
                var u:URLRequest = new URLRequest(url);
                u.data = variables; //Pass the variables
                u.method = URLRequestMethod.POST; //Don't forget that we need to send as POST

                //Navigate to the script
                //We can use _self here, since the script will through a filedownload header
                //which results in offering a download to the user (and still remaining in you Flex app.)
                navigateToURL(u, "_self");
            }
        ]]>
    </mx:Script>

    <mx:DataGrid id = "statdatagrid"
                 dataProvider = "{datalist}"
                 width = "460"
                 x = "107"
                 y = "100">
    </mx:DataGrid>

    <mx:Button label = "导出Excel"
               x = "485"
               y = "70"
               click = "loadDGInExcel(statdatagrid,'excelexport.jsp');"/>
</mx:Application>

 

后台jsp：

        <%@ page language="java"%>
       <%@ page contentType="application/vnd.ms-excel;charset=UTF-8"
                                                                        pageEncoding="UTF-8"%>
       <%
         request.setCharacterEncoding("UTF-8");
         response.setHeader("Content-disposition","attachment; filename=test.xls");
         String str = request.getParameter("htmltable");
         out.print(str);
     %>

 

IT令狐冲
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Flex 导出Excel FlextoExcel
10-11
Flex利用JSP导出Excel Flex利用JSP导出Excel
flex导出excel的代码
10-30
<?xml version="1.0" encoding="utf-8"?> <mx:WindowedApplication xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute"> <mx:Script> <![CDATA[ import mx.controls.CheckBox; import mx.controls.Alert; import com.as3xls.xls.ExcelFile; import com.as3xls.xls.Sheet; import flash.filesystem.*; [Bindable] private var dp:Array = [ {idx:1, names: "test1", sex: "b" }, {idx:2, names: "test2", sex: "g" } ]; public function doSelect(o:Object):void { Alert.show("行的数据分别是："+o.idx+"/"+o.names+"/"+o.sex); } private var sheet:Sheet; private function onCreate():void { var excelFile:ExcelFile = new ExcelFile(); sheet = new Sheet(); sheet.resize(10, 10); sheet.setCell(0, 0, "Today's date:"); sheet.setCell(0, 1, new Date()); excelFile.sheets.addItem(sheet); var mbytes:ByteArray = excelFile.saveToByteArray(); var stream:FileStream = new FileStream(); var docsDir:File = File.documentsDirectory.resolvePath("abc.xls"); // 定死文件名 try { docsDir.browseForSave("Save As"); docsDir.addEventListener(Event.SELECT, saveData); } catch (error:Error) { trace("Failed:", error.message) } function saveData(event:Event):void { var newFile:File = event.target as File; if (!newFile.exists) { var stream:FileStream = new FileStream(); stream.open(newFile, FileMode.WRITE); stream.writeBytes(mbytes); // 写文件流 stream.close(); } } } ]]> </mx:Script> <mx:Panel> <mx:Button label="导出" click="onCreate()"/> <mx:DataGrid id="dg1" dataProvider ="{dp}"> <mx:columns> <mx:DataGridColumn width="20" headerText="" > <mx:itemRenderer> <mx:Component> <mx:CheckBox change=" {outerDocument.doSelect(data as Object)} " /> </mx:Component> </mx:itemRenderer> </mx:DataGridColumn> <mx:DataGridColumn headerText="names" dataField="names" width="200" /> <mx:DataGridColumn headerText="sex" dataField="sex" width="300" /> </mx:columns> </mx:DataGrid> </mx:Panel> </mx:WindowedApplication>
flex dg转存excel的几种方法。
08-15 2038
==================================================== 方法一：我这里使用的是tomcat，可以使用的后台jsp或者asp，我用了jsp。这种方法使用了后台的jsp来 /***************************
flex前端+java后台实现Flex导出Excel的两种方法，
七秒一生的专栏
01-03 6331
Flex前端+Java后台，要将Flex界面中AdvancedDataGrid的数据导出成Excel文件。有2种方法：  1.直接在前台导出。      使用开源项目as3xls，下载个解决了中文乱码的as3xlsUTF8.swc包，加到Flex工程的引用库中。      AS代码，点击“导出Excel”按钮后的函数： Java代码   var sheet:She
使用jxl导出excel时怎么创建多个sheet
热门推荐
jbgtwang的专栏
08-24 1万+
虽然知道excel导出可能会出现要记录要分多个sheet的情况，但迄今为止还是没有遇到过，今天有空试了一把           export                                        -->            try{           ////////查询开始
flex导出复杂excel
05-15
AdvancedDataGrid导出复杂表头excel
flex air 导出 excel 支持中文
03-05
在Flex Air应用中导出Excel并支持中文是一项常见的需求，特别是在数据可视化和报表生成的场景下。Flex Air是Adobe提供的一款基于Flash Player的桌面应用程序开发框架，它允许开发者创建具有丰富用户界面的桌面应用...
flex导出excel具体实现
10-26
在Flex应用程序中实现数据导出为Excel文件功能，通常需要依赖特定的外部插件，本例中使用的插件是as3xls-1.0.1.swc。as3xls是一个允许Flex开发者创建、修改和导出Excel文件的库，它为ActionScript 3.0提供了一套完整...
Flex导出Excel
06-25
1. `FlexExcel.as`: 这可能是自定义的ActionScript类，用于处理Excel导出逻辑。它可能包含了创建CSV或XML文件的方法，以及将数据转换为适合Excel的格式的代码。 2. `FlexExportUtil.as`: 另一个可能的工具类，包含了...
将flex页面数据导出到excel
03-18
本篇将详细讲解如何在Flex页面上实现数据导出到Excel的功能。 Flex是一种基于Adobe Flash Player运行时的开放源代码框架，主要用于构建富互联网应用程序（RIA）。它允许开发者创建具有丰富用户体验的交互式应用，但...
Flex 前台excel导出
zjq118的专栏
09-02 1675
一、excel.as中的Action Script 处理view plaincopy to clipboardprint?import mx.controls.dataGridClasses.DataGridColumn;   import mx.rpc.events.AbstractEvent;   import mx.collections.ArrayCollection;   impor
EXCEL 操作
LEE_ZCF
12-22 1658
编辑技巧、自定义格式、数据有效性、选择性粘贴等-Excel 2007综合班Ⅰ-16101班课时1学习小结  (2010-12-05 15:34:14) Excel 2007综合班Ⅰ-16101班课时1学习小结 授课老师：函数菜鸟（木兰） 助教：weifaxiang、beiyunli 授课内容：编辑技巧、自定义格式、数据有效性、选择性粘贴等 自定义格式代码结构 数字及文本格
Flex导入Excel文件示例
俊哥
02-02 1185
1.SDK3.0 2.导入文件用FileFilter过滤。由于是示例，只写了xls 3.导入文件解析在Java端完成，前端在导入之后，从session中得到导入文件的解析结果，然后再调用Java方法销毁session [代码] [Flash/ActionScript/Flex]代码   01 "1.0" encoding
Flex4 读取Xls表格数据
幽幽残月 之 人间正道是沧桑
10-17 2524
首先定义变量            private var file:FileReference = new FileReference();            private var xls:ExcelFile;           private var state
flex 保存datagrid数据到excel中
彻底拆分，一切可控！
05-29 848
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" initialize="initData()"> <![CDATA[ import com.as3xls.xls.ExcelFile; import com.esri.ags.Units; import mx.controls.dataGridCla
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值