topic Re: Re: Straight Table Export help??? in QlikView

Straight Table Export help???

amit_saini — Mon, 10 Mar 2014 04:31:28 GMT

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,

Re: Straight Table Export help???

Mon, 10 Mar 2014 05:41:39 GMT

Hi Amit,

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

This might be of help.

Re: Straight Table Export help???

amit_saini — Mon, 10 Mar 2014 05:48:13 GMT

Hi Shyamal ,

Yes I tried it,still the same result.

Thanks,

Re: Straight Table Export help???

Mon, 10 Mar 2014 05:49:52 GMT

Can you attach your qvw file here?

Re: Straight Table Export help???

amit_saini — Mon, 10 Mar 2014 06:08:48 GMT

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,

Re: Straight Table Export help???

tresB — Mon, 10 Mar 2014 06:11:45 GMT

Have a look here : Preparing examples for Upload - Reduction and D... | Qlik Community

Re: Re: Straight Table Export help???

amit_saini — Mon, 10 Mar 2014 06:34:24 GMT

Hi Shyamal\Tresesco,

Please find the attachment of my qvw .

Thanks,

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

Mon, 10 Mar 2014 07:04:45 GMT

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.

Re: Straight Table Export help???

ashwanin — Mon, 10 Mar 2014 07:10:29 GMT

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.

Re: Straight Table Export help???

amit_saini — Mon, 10 Mar 2014 07:16:04 GMT

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,

Re: Straight Table Export help???

jsingh71 — Mon, 10 Mar 2014 07:20:25 GMT

amit, increase the size of row in excel after that definately you will get the values.

Re: Straight Table Export help???

amit_saini — Mon, 10 Mar 2014 07:25:05 GMT

Hi Jsingh,

Brother I can't do this as further i need the link these column values into some other template. I want this to be work in automated fashion .

Thanks,

Re: Straight Table Export help???

ashwanin — Mon, 10 Mar 2014 07:39:30 GMT

I know its really hit and trial.

Adjust the Chart i.e increase the size of columns in Chart and then take output.

Re: Straight Table Export help???

Mon, 10 Mar 2014 07:44:03 GMT

Hi Amit,

The button is not working for me and when I click on export to excel icon, this is what I can see in excel without double clicking on any of the columns:

Looks like some excel settings need to be done in your machine.

Re: Straight Table Export help???

amit_saini — Mon, 10 Mar 2014 07:56:47 GMT

Hi Shyamal,

Please change link here in macro code you need to give a link where you want this export to be present in your machine and second create a varible by name of vFile with value as =Test and then check this button you will be having result export shhet bythe name of Test.xls

obj.ExportEx "Give You own path here \"& vFile &".xls",5

Thanks,

Re: Straight Table Export help???

Mon, 10 Mar 2014 08:01:21 GMT

If you write a macro to export you can adjust the width of the columns.

Set objXLWs = objExcelWorkbook.Sheets("Resume")

objXLWS.Columns(1).ColumnWidth = 25

Re: Straight Table Export help???

Mon, 10 Mar 2014 08:34:41 GMT

Hi Amit,

I exported using the macro and yet I am getting the above output only.

You can set the excel column width in macro, something like:

set XLSheet = XLDoc.Worksheets(1) 'your Excel sheet number with XLSheet

XLSheet.Range("A1:A60000").ColumnWidth = 10

and you can use the above line multiple times to set the width for different range of columns.