QlikView – Connecting to excel file

In QlikView you can connect to variety of datasources.

QlikView can connect to ODBC,OLEDB,XML datasources. You can also connect to cloud datasources like SalesForce.com.

In this excercise i want to show you how to connect to an excel file in QlikView.

To learn how to load excel file in QlikSense visit Creating first QlikSense application

Steps:

  • Create new Qlikview document or use existing document

SaveAs

  • click on edit script on the tool bar menu

EditScript

  • Inside the script editor choose option for Table files
Tablefiles

Use Table files to load excel files.Use Database drop down to select ODBC and OLE DB connections.

  • Browse to your file and open
  • Use file wizard if you want to make any changes to your file
excelfile

Excel file. Use “Labels” drop down to include “Embedded Labels” to get the header information. Use “Tables” drop down to load the specific tab in the excel file.

  • Give table name to your load script. Qlikview will use this table name to identify your table

excelfile2

  • Load data

dataload2

  • Verify by creating a sheet object
CreateListBox

Right click and select New Sheet object/List box

OrderIdField

Select OrderId field for your list box

Listbox

OrderId list box. Data in List box shows that data is loaded successfully.

Watch my video for more details

2 thoughts on “QlikView – Connecting to excel file

  1. What if I have an excel file that will be updated weekly and I need QlikView to update with it?

    • Chandraish says:

      Excel is your datasource so if your datasource is getting updated weekly then all you have to do is to refresh your dashboard i.e. reload the data.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.