Unable to load the data in excel

[#1]

Hi All,

Need a help!!!

I am trying to load an excel file which is been created using some other batch script....

When i load it in Qlikview i am seeing only one line of data but there is almost 500 lines of data.

After opening the file with ms excel and saving it. i was able to load the complete data in qlikview.....

Did any one face this issue before?

Thanks,

Sampath

[senpradip007]

Hi Sampath.

I've faced the similar problem. I think the file is saved with xml format.

you can achieve this using macro. First you save as the file using macro then load the file.

[rsdhavle]

You can use macro for getting data in excel but macro doesnt work in Ajax environment it will only work with IE plugin. Pls take a note of it

[#4]

Pradip ,

I am seeing the extension as .Xlsx....

[ashwanin]

Check the format of file or coding in script while loading the file directly from batch script. File format can be different

[senpradip007]

Can you upload your .xlsx file?

[#7]

Hey Sampath

You are using the Excel file with the extension .Xlsx which is  the version of 2007, I also had face the same problem.Then I have change the format as .xls which is the newly version of excel  and it is perfectly inserted in my QlikView.

Regards

Surbhi Sahu

Bisp Solutions Inc

http://bisptrainings.com