topic Re: Exportação de Excel in Brasil https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206431#M42382 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/118017">Same Formating of qlikview pivot table in Excel</A></P><P>Neste link tem a resposta correta e com exemplo</P></BODY></HTML> Thu, 20 Oct 2016 01:44:33 GMT 2016-10-20T01:44:33Z Exportação de Excel https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206425#M42376 <HTML><HEAD></HEAD><BODY><P>Existe alguma forma de exportar em Excel sem perder a formatação de planilha dinâmica ?</P></BODY></HTML> Wed, 19 Oct 2016 20:02:16 GMT https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206425#M42376 2016-10-19T20:02:16Z Re: Exportação de Excel https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206426#M42377 <HTML><HEAD></HEAD><BODY><P>Via macro é possível!</P></BODY></HTML> Wed, 19 Oct 2016 20:05:59 GMT https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206426#M42377 paulovendruscol 2016-10-19T20:05:59Z Re: Exportação de Excel https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206427#M42378 <HTML><HEAD></HEAD><BODY><P>tens algum modelo ou exemplo ?</P></BODY></HTML> Wed, 19 Oct 2016 21:49:48 GMT https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206427#M42378 2016-10-19T21:49:48Z Re: Exportação de Excel https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206428#M42379 <HTML><HEAD></HEAD><BODY><P>Hola buenas tardes</P><P></P><P>MACRO:</P><P></P><P>'◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄</P><P>Function Rpt_Excel(objID)</P><P>SET&nbsp;&nbsp;&nbsp;&nbsp; Chrt=ActiveDocument.GetSheetObject(objID)</P><P>SET x = Chrt.GetProperties</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Chrt.SendToExcel</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SET Chrt = Nothing</P><P>SET x&nbsp;&nbsp; = Nothing</P><P>End Function</P><P></P><P></P><P>SUB Enviar_Excel()</P><P>CALL Rpt_Excel("<STRONG>CH09</STRONG>")</P><P>End Sub</P><P>'◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄◄</P></BODY></HTML> Wed, 19 Oct 2016 22:40:10 GMT https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206428#M42379 el_aprendiz111 2016-10-19T22:40:10Z Re: Exportação de Excel https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206429#M42380 <HTML><HEAD></HEAD><BODY><P>Buenas tardes.</P><P></P><P>A macro exporta a tabela como simples, preciso que exporto no formato dinamica</P></BODY></HTML> Wed, 19 Oct 2016 23:04:07 GMT https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206429#M42380 2016-10-19T23:04:07Z Re: Exportação de Excel https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206430#M42381 <HTML><HEAD></HEAD><BODY><P>boa noite</P><P></P><P>não consigo enviar nenhum modelo agora. Veja se o tópico abaixo ajuda:</P><P><A href="https://community.qlik.com/thread/156252">Pivot table export to excel</A></P></BODY></HTML> Wed, 19 Oct 2016 23:49:25 GMT https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206430#M42381 paulovendruscol 2016-10-19T23:49:25Z Re: Exportação de Excel https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206431#M42382 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/118017">Same Formating of qlikview pivot table in Excel</A></P><P>Neste link tem a resposta correta e com exemplo</P></BODY></HTML> Thu, 20 Oct 2016 01:44:33 GMT https://community.qlik.com/t5/Brasil/Exporta%C3%A7%C3%A3o-de-Excel/m-p/1206431#M42382 2016-10-20T01:44:33Z