topic Unable to load the data in excel in QlikView

Unable to load the data in excel

Wed, 05 Feb 2014 06:59:36 GMT

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

Re: Unable to load the data in excel

senpradip007 — Wed, 05 Feb 2014 07:11:32 GMT

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.

Re: Unable to load the data in excel

rsdhavle — Wed, 05 Feb 2014 07:16:31 GMT

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

Re: Unable to load the data in excel

Wed, 05 Feb 2014 07:23:29 GMT

Pradip ,

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

Re: Unable to load the data in excel

ashwanin — Wed, 05 Feb 2014 07:27:27 GMT

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

Re: Unable to load the data in excel

senpradip007 — Wed, 05 Feb 2014 07:30:41 GMT

Can you upload your .xlsx file?

Re: Unable to load the data in excel

Wed, 05 Feb 2014 07:52:28 GMT

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