topic Importing from an Excel Spreadsheet in QlikView

Importing from an Excel Spreadsheet

Tue, 18 Sep 2012 08:30:59 GMT

I'm looking to export data from an Excel spreadsheet into QlikView, but the import process doesn't seem to read a formula as a value. For example, I've got a formula =A1+B1+C1+D1 which is read in as blank.

Is there a way to inform the script to read the value of the column rather than the formula? (which is what I assume it's doing)

Thanks

Re: Importing from an Excel Spreadsheet

Anonymous — Tue, 18 Sep 2012 09:14:57 GMT

It should read the value (i.e. not the expression) by default.

Maybe you can attach a subset of the Excel file to the thread?

Re: Importing from an Excel Spreadsheet

Tue, 18 Sep 2012 09:29:16 GMT

I just tried to replicate the spreadsheet in excel and it worked fine. The spreadsheet I have to use is protected; does that have any effect on QlikView reading the value of the column that is a formula?

EDIT: When testing the value with IsNull, I get a -1 for each field suggesting that I can't use formula results from a protected sheet.

Re: Importing from an Excel Spreadsheet

Tue, 18 Sep 2012 10:49:20 GMT

I've resolved the issue: turns out the version of the spreadsheet I had was out of date, and the current version has referencing issues all over the place. Thanks anyway Johannes.

Re: Importing from an Excel Spreadsheet

Tue, 18 Sep 2012 11:30:00 GMT

Dear All,

I have question, can i make import for excel file from end users (from web browser).

Thanks.