Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
I have a need to load lots of 97 / 95 (xls) backward compatible files from a folder.
My script is ready to load the files however due to the format of the XLS files Qlik doesn't recognise them. I've been told by my IT Deparment that they are 97 / 95 (xls) backward compatible files which have been created by Visual Fox Pro.
Does anyone know what I can do in order to make Qlik recognise what these files are?
Best regards,
Drew
Hi,
Export to CSV format from Visual Fox Pro.
qlikview can read xls files.
can you provide sample file.
Regards
Please find example file attached.
Hi,
Unfortunately this isn't an option & I want to analyse the historic files - trying to avoid change to the current process as I know it would take a long time to get the changes put in place
This excel-file is not in a current biff-format else another binary-format and therefore you couldn't load them directly. I think you will need excel to open and save it with a different file-format or to copy these data to another excel-file. If you many of these files you should look for macro-automation of this task.
- Marcus
Hi Marcus,
Thank you for your help - is the macro something I can run in the Qlik globe script or does it need to be done outside the Qlik software?
Best regards,
Drew
You could do it with qlikview vbs-macros but not during the load-execution (in this case you would need to trigger an external vbs-batch or excel-file with an EXECUTE statement).
Easier would be to do it from excel-side (you will find plenty of examples within the various office- and vba-sites) then the syntax-higlightning, code completion and the debugging-features there will be very useful - and if it's then working you could convert it into vbs again (by larger and/or complex code is this approach very probably faster then manual writing in vbs).
- Marcus
I think you can use file converter to convert into 2010 excel format before load into Qlik. I find one for your ref:Apache OpenOffice - Official Site - The Free and Open Productivity Suite Hope it works!