[flex_india:5797] Re: Saving data as a csv

hi leena,
hope this code extract will be helpfull to you

function to convert the data into html 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
            str+= '<table border ="1" width="'+dg.width+'"><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");
                //dg.columns[i].headerText != undefined ||
                if(dg.showHeaders != false) {
                    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) {                                           
                            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;
        }

invoke the aspx page and pass the html table string as url variables:-

variables.htmltable = convertDGToHTMLTable(dgg1)//dgg1-datagrid
var variables:URLVariables = new URLVariables();
public var urlExcelExport:String="http://localhost:2581/excelconvert/Default.aspx";
var u:URLRequest = new URLRequest(urlExcelExport);              
                u.data = variables;
                u.method = URLRequestMethod.POST;
                navigateToURL(u,"_blank");        

aspx page code:-
        Response.Clear();
        Response.Buffer = true;
        Response.ContentType = "application/vnd.ms-excel";
        Response.Charset = "";
        this.EnableViewState = false;
            Response.AddHeader("Content-Disposition", "filename=" + fname + ".xls" + '"');
            Response.Write(Request.Params["htmltable"]);   
            Response.End();

there could be another approach as well
where in instead of passing on the whole data as html string pass on only the params that result in this data and hit the db again using those params.

hope the two appraches help

-saurabh narula
http://saurabhnarula.wordpress.com