4 Replies Latest reply: Sep 18, 2012 7:30 AM by Imad Arikat RSS

    Importing from an Excel Spreadsheet

      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