Skip to main content
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

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