Loading Excel data into QlikView

[#1]

Hi,

I think I have a simple data loading problem. I have an .xls file exported from our bug tracking tool "Jira". You can find the file as attatchment.

Now I am trying to load all the data into my QlikView application, but I was not able to do this.

Details:

I don't need the first 3 rows from the .xls file. The 3 columnames should be "Issue Type", "Key", and "Issue Links"

And I also don't need the last row of the excel output but this is not so important.

I hope somebody could help me.

Thanks.

Regards,

Herbert

[raviityou]

i have excel file which is abnormal (Data is not it proper manner)

it has empty cell, marge,... etc

the how to get data from it.

[#3]

Hello Janaki,

You may try to use QlikView API Connector for Jira

Best regards,

Roman.