Problem with export excel from Qlikvie

[#1]

Hi all

I link my report excel from qlikview but i can see the right way if anyone can help me.

The file executes like this when downloading the excel from the Qlikview

[prieper]

Read the table with header line, first row as embedded labels:

Peter

[#3]

this is option in qlik or in excel?

[el_aprendiz111]

Hi:

• Fron Excel
• Text To Columns
• Deliminted
• semicolon

Are many rows and generates it as CSV

[prieper]

Sorry,

misunderstood your question. My suggestion was basing on Import to QlikView (with settings in QV-wizard).

Think that Fer Fer is correct. This is an export as csv.

Is there a chance to change the header-names without using two rows?

[#6]

Still got  the same problem when im download my report from QlikView to excel still open the same in picture when was to  so small im got this problem like few days ago

[el_aprendiz111]

Hi Jose

You can send a sample of your App

[kamal_sanguri]

Can you try below method.

Step 1:

Qlikview

Right click on table -> Copy table to clipboard -> Full table

Step 2:

Excel

Right click ->Paste Special -> Text

[#9]

sample are in the first post

[kamal_sanguri]

I strongly advise you to revisit your data, The problem is with your data.

In case of delimited data when open in Excel all the data must be there in First column. However, I see that there is data in Second Column (Starting from Line No. 20), Third Column (Starting from Line No. 30), Forth, Fifth, Sixth & Seventh Column (at Line No. 518).