Exportar AvancedDatagrid com

[Re JMD]

Pessoal,

 

Como faço para exportar esse datagrid para excel da mesma formatação que ele é montado no grid flex com os columgroups.

 

<mx:AdvancedDataGrid x="-4" y="72" id="adgDados" width="100%" height="416" initialize="gc.refresh()"

horizontalScrollPolicy="on"

change="getVlDesvioAberto(event)"

>

<!--Esse GroupingCollection2 e apara o caso de criar uma tree e aprupar pelo a coluna GroupingField, se no Datagid nao tiver a nescessidade

de agrupar os valor e so remover esse bloco e adicionar um dataProvide no Advanced datagrid-->

<mx:dataProvider>

<mx:GroupingCollection2 id="gc" source="{dados}">

</mx:GroupingCollection2>

</mx:dataProvider>

<mx:groupedColumns>

<mx:AdvancedDataGridColumn headerText="Conta" id="colConta" width="380" />

<mx:AdvancedDataGridColumnGroup headerText="Janeiro" id="adgcgJaneiro" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoJan"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoJan" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioJan" styleFunction="alteraCorFonteGridJan" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Fevereiro" id="adgcgFevereiro" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoFev"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoFev" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioFev" styleFunction="alteraCorFonteGridFev" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Março" id="adgcgMarco" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoMar"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoMar" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioMar" styleFunction="alteraCorFonteGridMar" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Abril" id="adgcgAbril" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoAbr"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoAbr" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioAbr" styleFunction="alteraCorFonteGridAbr" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Maio" id="adgcgMaio" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoMai"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoMai" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioMai" styleFunction="alteraCorFonteGridMai" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Junho" id="adgcgJunho" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoJun"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoJun" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioJun" styleFunction="alteraCorFonteGridJun" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Julho" id="adgcgJulho" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoJul"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoJul" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioJul" styleFunction="alteraCorFonteGridJul" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Agosto" id="adgcgAgosto" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoAgo"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoAgo" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioAgo" styleFunction="alteraCorFonteGridAgo" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Setembro" id="adgcgSetembro" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoSet"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoSet" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioSet" styleFunction="alteraCorFonteGridSet" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Outubro" id="adgcgOutubro" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoOut"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoOut" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioOut" styleFunction="alteraCorFonteGridOut" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Novembro" id="adgcgNovembro" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoNov"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoNov" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioNov" styleFunction="alteraCorFonteGridNov" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumnGroup headerText="Dezembro" id="adgcgDezembro" >

<mx:AdvancedDataGridColumn headerText="Previsto" labelFunction="formatValorPrevistoDez"/>

<mx:AdvancedDataGridColumn headerText="Realizado" labelFunction="formatValorRealizadoDez" />

<mx:AdvancedDataGridColumn headerText="Desvio" labelFunction="formatValorDesvioDez" styleFunction="alteraCorFonteGridDez" />

</mx:AdvancedDataGridColumnGroup>

<mx:AdvancedDataGridColumn headerText="Previsto Acumulado " labelFunction="formatValorPrevistoAcumulado" width="200" />

<mx:AdvancedDataGridColumn headerText="Realizado Acumulado" labelFunction="formatValorRealizadoAcumulado" width="200" />

<mx:AdvancedDataGridColumn headerText="Desvio Acumulado" labelFunction="formatValorDesvioAcumulado" />

</mx:groupedColumns>

</mx:AdvancedDataGrid>

[Re JMD]

Resolvido:

 

http://mugunda.blogspot.com/2011/05/flex-export-advanced-datagrid-to-excel.html