Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mnobile77
Contributor
Contributor

Conectar Excel a QVD

Dear good morning, I would like to know if there is a way to connect data from a QVD to an Excel?

4 Replies
marcus_sommer

No, at least not directly. More easier as looking for such an approach would be to store the qvd-data not only as qvd else also as csv which could be easily opened with Excel and/or used as an external source.

- Marcus

rbartley
Specialist II
Specialist II

Hi,

I think that there might be an add-in, but the simplest thing would be to include an additional store command in the app that generates your QVD and specify the format as txt, e.g:-

Store [tablename] into [lib://...../filename.csv](txt);

You can specify the delimiter by adding a second argument e.g. (txt, delimiter is '\t');

You can then use this csv file directly in Excel.

rbartley
Specialist II
Specialist II

Sorry  Marcus,  we must have been writing our replies at the same time.

mnobile77
Contributor
Contributor
Author

Muchísimas gracias!!