Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
senpradip007
Specialist III
Specialist III

QV Expressor

Hello Everybody,

I'm new in QlikView Expressor, asking your help.

Can we extract data from Excel file?

Thanks in advance..

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I'm sure you can. See for example this discussion: Not able to read .xlsm files. It mentions an Excel Schema Wizard and a Read Excel Operator. But try asking here instead: QlikView Expressor Desktop & Server


talk is cheap, supply exceeds demand
senpradip007
Specialist III
Specialist III
Author

Hi GW,

Thanks for the response.

I have created the "Read Table" and "Write Table" Operator and link them up.

Now the problem is i can't run the template.

Warm Regards.

VishalWaghole
Specialist II
Specialist II

Hi Pradip,

Please go through with this link,

http://documentation.qlik.com/expressor/3.7/Excel_Extension/Create_an_Excel_Schema.htm

Hope it will help you.

- Regards,

Vishal Waghole

VishalWaghole
Specialist II
Specialist II

Hi Pradip,

You need to apply all valid properties

for Read Table and Write Table.

If you set the right properties then both Read and Write operator will be green in color.

Then you can run Template.

- Regards,

Vishal Waghole