Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amit_saini
Honored Contributor III

Straight Table Export help???

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

17 Replies
Not applicable

Re: Straight Table Export help???

Hi Amit,

Have you tried using "Wrap Cell Text" option from Presentation tab?

wrap_cell_text.bmp

This might be of help.

amit_saini
Honored Contributor III

Re: Straight Table Export help???

Hi Shyamal ,

Yes I tried it,still the same result.

Thanks,

AS

Not applicable

Re: Straight Table Export help???

Can you attach your qvw file here?

amit_saini
Honored Contributor III

Re: Straight Table Export help???

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

MVP
MVP

Re: Straight Table Export help???

amit_saini
Honored Contributor III

Re: Re: Straight Table Export help???

Hi Shyamal\Tresesco,

Please find the attachment of my qvw .

Thanks,

AS

Not applicable

Re: Re: Re: Straight Table Export help???

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.

ashwanin
Valued Contributor

Re: Straight Table Export help???

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.

amit_saini
Honored Contributor III

Re: Straight Table Export help???

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

Community Browser