Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Referencing a single static cell in Excel for variable in script load.

Is there any command or methodology to reference a single static cell in Excel for a variable in script load while loading a series of excel worksheets?  I can load all the files I want with whatever fields I want if it's in a "vertical" format with headings etc, but I need to pull down some info from individual cells above the headings specifically.

These excel files are locked and I'm not privy to the password to unlock them.  I am responsible for working with these numerous files and making changes elsewhere when these files are changed.  It would make the task much easier to pull all this data into one place and look at it there, but I need to bring some of the data above the headings (such as Ship Date and SDO#) down into the rest of the data.

Thanks in advance for the help,

Scott

2 Replies
micahsakata
Contributor III
Contributor III

if you haven't figured this out yet, see this post...

http://community.qlik.com/thread/49164

whiteline
Master II
Master II

Also, consider  using a transformation step (Button "Enable Transformation Step" on the second step of load wizard).

This can help you to neglect all the "humanities" of your excel fiels and keep only desired cells.