topic Re: exporting text column to excel reports in Qlik NPrinting

exporting text column to excel reports

ronaldwang — Sat, 05 Aug 2017 03:32:25 GMT

Hi, i have tried to export text column to excel reports, as the length of the text content i have to merge cells so that can display the information properly. but the result is always in not merged cells ( same single cell format as the original cell format). is there any thing i need to pay attention to when exporting cell or column or table to merged cells? thanks

Re: exporting text column to excel reports

devarasu07 — Sat, 05 Aug 2017 16:13:28 GMT

Hi,

Enable word wrap cell text object - qlik chart presentation side then it should work in N printing (in excel nprint make sure that keep source format & wrap text check box enabled). thanks

Re: exporting text column to excel reports

ronaldwang — Sun, 06 Aug 2017 23:52:49 GMT

Hi Devarasu,

My issue is that I want to merged my cells, but in the Nprint process, my excel template has been un-merged.

Re: exporting text column to excel reports

devarasu07 — Mon, 07 Aug 2017 01:47:17 GMT

Hi Ronald,

Table / table image excel report - Merge cell its not possible, you can merge cell by using pivot table option

How to Create an Excel PivotTable Report

Thanks,Deva

Re: exporting text column to excel reports

ronaldwang — Mon, 07 Aug 2017 04:08:06 GMT

to make it more clearly,

the template is as below

and my expectation is

but the actual result is

Re: exporting text column to excel reports

Ruggero_Piccoli — Mon, 07 Aug 2017 10:05:28 GMT

Hi Ronald,

Merged cells in Excel templates are not keept merged in the produced report.

Could you enlarge the columns instead?

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: exporting text column to excel reports

ronaldwang — Tue, 08 Aug 2017 01:36:30 GMT

Thanks Piccoli,

I think I reached the same conclusion after a few attempts. I won't be able to wider the column as the formatting issue. but I manage to use variable to display the information instead. thanks