Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master 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

Hi Amit,

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

wrap_cell_text.bmp

This might be of help.

amit_saini
Master III
Master III
Author

Hi Shyamal ,

Yes I tried it,still the same result.

Thanks,

AS

Not applicable

Can you attach your qvw file here?

amit_saini
Master III
Master III
Author

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

amit_saini
Master III
Master III
Author

Hi Shyamal\Tresesco,

Please find the attachment of my qvw .

Thanks,

AS

Not applicable

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
Specialist
Specialist

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
Master III
Master III
Author

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