Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Ho Folks,
I'm having a straight table which contains lots of text data, when I'm exporting it to excel, the data which I'm getting looks like this "################################' . I know if I double click my sheet column I can see the complete data. Please see the attachment.
I want export data to be seen perfect not like this '###########'. Please help me how to achieve this through straight table export??????
Thanks,
AS
Hi Amit,
Have you tried using "Wrap Cell Text" option from Presentation tab?
This might be of help.
Hi Shyamal ,
Yes I tried it,still the same result.
Thanks,
AS
Can you attach your qvw file here?
Hi Shyamal,
Sorry it's not possible to attach qvw file as size is 345 MB f . But yes I tried this wrap text option with small data its working but I don't know why it is not working with my real application. It is having some 40-50 lines text data in single column which I can see in straight table but when I'm exporting it I'm getting these ####### kind of data.
Thanks,
AS
Have a look here : Preparing examples for Upload - Reduction and D... | Qlik Community
Hi Shyamal\Tresesco,
Please find the attachment of my qvw .
Thanks,
AS
Hi Amit,
Are you using that button to export the data or the normal export to excel icon on chart?
Beacause when I click on the export to excel icon on chart, I can see the data in excel and not ########. Please see the attached excel.
There is no problem in the QlikView report. i see this is coming correct.
Double click on the columns in excel report which you are getting might be there is some excel setting done on your system.
Hi Shyamal,
I'm using here button. Your attached sheet looks like this and you can see here ###########.....kind of data which on double click turn into perfect text data. Is there any way in qlikview to take automatic space as per the text lines while exporting even through button or Icon??????
Thanks,
AS