topic Send to XL with formatting. in QlikView

Send to XL with formatting.

Sat, 06 Dec 2014 11:15:26 GMT

Hi,

My end users are expecting the report to be formatted when we click the send to xl button. Can anyone help me here?

Thanks

Venkatachalam.N

Re: Send to XL with formatting.

ecolomer — Sat, 06 Dec 2014 11:21:03 GMT

Can you explain problem a bit more,

Re: Send to XL with formatting.

Sat, 06 Dec 2014 11:25:04 GMT

Hi Enrique,

I have a straight table chart with 5 Dimensions and 10 Metrics in a specific format on Qlikview document. Users want to use the button send to XL in that straight table as they do so, they want the data to be exported with the page set up to be in a printable format.

Thanks

Re: Send to XL with formatting.

alkesh_sharma — Sat, 06 Dec 2014 11:28:30 GMT

Not Possible. Send to excel creates reports in default format.

I may be achieved using macros. but I am not sure.

Re: Send to XL with formatting.

MarcoWedel — Sat, 06 Dec 2014 14:12:10 GMT

Maybe generating Excel reports using NPrinting (third party reporting solution for QlikView) could be a solution for you:

Export QlikView data to Excel without Macros - Vizubi: Office and HTML Report Creation and Distribution SoftwareCreate p…

Hope this helps

regards

Marco

Re: Send to XL with formatting.

amit_saini — Mon, 08 Dec 2014 06:41:14 GMT

Hi,

I would suggest two ways here:

Nprinting Tool
Second you do this by the help of macro and run that macro through export button.

Thanks,