Re: Can we distribute Excel files via Qlikview Pub... - Qlik Community

scotthan · ‎2012-02-11

I noticed that this question had been asked before but didn't see a great response. Is it possible to have Publisher distribute reports in an Excel spreadsheet rather than PDF? If so, someone must have some macro code to help out - is anyone willing to share that and the technique? Thanks!

Report Inappropriate Content · ‎2012-02-11

hi, i am not sure about publisher.. but u can write macros in the script by configuring the mail box and therby distributing reports to any recipients ..let me know if u need the code.. will share it.. thanks .. ashwin

scotthan · ‎2012-02-12

Would love to see that code, thanks. How about at a general level - any other ideas on the best way to automatically send out Excel files with data from Qlikview tables?

It sounds like one option would be to have some macro to open the Qlikview doc on the server, have an OnOpen action where you put a macro to send a chart to Excel and having configured the mailbox somehow send it as an attachment to users. Is that all feasible? I have no experience in macros.

I see that there is a product that does this smoothly. http://www.nprinting.com/qlikview-excel-report/ .. cool stuff but I'm wondering if we can do it without an additional product.

Qvmaster2019 · ‎2012-02-12

Yes, please share the code.

scotthan · ‎2012-02-16

ashwin?

AlexOmetis · ‎2012-08-01

Don't know if you already found a way around this, but there's a product called NPrinting (www.nprinting.com) that has capabilities to schedule reports / charts to export to Excel & PDF and apply filters etc. Might be worth a look.

Qlik Partner Ambassador 2024

scotthan · ‎2012-08-01

Looks neat, thanks Alex.

sunshineli · ‎2012-12-06

Hi, Publisher itself can't distribute reports, it needs a PDF generator to distribute reports but only in PDF format and it is quite expensive. As far as I know, NPrinting is the only product on the market which can generate and distribute Excel and other formats (PowerPoint, Word, HTML) reports and it is cheap compared to the PDF generator. Whether you have Publisher or not, it is better for you to use NPrinting than a PDF generator.

Can we distribute Excel files via Qlikview Publisher?