We need to show zeros as ‘-‘ rather than ‘0’ in our tables in NPrinting when presented in Powerpoint
I believe you can embed an excel table in Powerpoint so that you can then use excel functionalilty in powerpoint.
I’m just wondering how to do this in NPrinting
I can see you have the function InsertTable/Excel Spreadhseet
Id like to take an existing excel s/sheet and insert it so that I can use the excel formatting to keep the formula a little more simple. How do you do this?
I think your question is really just a Microsoft PowerPoint question, not an NPrinting one. "How do I embed a pre-existing Excel spreadsheet file in a PowerPoint slide?"
I don't believe it's possible to do that directly (in any PowerPoint file, nothing to do with NPrinting). However surely you can just embed a new Excel Spreadsheet using the button you've shown in your screenshot, and paste in the content from your pre-existing spreadsheet that exists separately?
One word of warning: at the time of writing I am attempting to embed Excel spreadsheets in a Qlik NPrinting PowerPoint report (just as you want to do) and am finding that PowerPoint (the instance 'within' Nprinting) crashes consistently whilst doing this. (Nprinting Nov 2017 version.) A standalone instance of PowerPoint (outside NPrinting) doesn't crash following the same steps. I found your question whilst searching to see if I'm the only person experiencing this: whether it's me or a software bug. I'd be really grateful, if you try this out, if you can reply back if you also get crashes!
Same problem here, Nprinting PP crashes every time trying to open Excel through that "Excel Spreadsheet" button! Does anyone know whether there is a fix or workaround for this? I would need to have an Excel Pivot table added to the PP presentation.
Good to know I'm not the only one. Do you still get this problem in the latest version of NPrinting? (April 2018 I believe, at time of writing.)
I'm still on NPrinting Nov 2017 and unable to upgrade to April (or Feb) 2018 for other, unrelated reasons, so I haven't tested this against the latest version. Consequently I haven't reported this formally to Qlik as a possible bug. (In any case, I worked around it by just using regular PowerPoint tables and accepting a slight loss of functionality.)
If you're still getting this problem with April 2018 release, I suggest it might be worth reporting to Qlik as a bug.
Please update to latest version (April 2019) and try with it.
@Ruggero_Piccoli Can you confirm that you can do this in your current version of NP? I have tested using June 2019 and am still unable to do this. I have not found much on this topic outside of this article. Qlik articles on embedding tables all reference using tables straight from Qlik or using PPT tables, but not Excel ones.
My expectation,based on this testing and some research leads me to believe that while PPT does allow this functionality OOB, NPrinting does not officially support it.
I asked to test with a recent version because the original post is very old and latest comment referred to a one-year-old version. Before to check with a recent version I want to be sure that it is not a solved issue.
I tested in my June 2019 installation and using Qlik NPrinting tags into an Excel worksheet in a PowerPoint report is not working. I think this need to be asked as a new feature.
You can only import tables as native PowerPoint tables.