topic Re: Conectar Excel a QVD in Connectivity & Data Prep

Conectar Excel a QVD

mnobile77 — Tue, 16 Mar 2021 13:40:39 GMT

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

Re: Conectar Excel a QVD

marcus_sommer — Tue, 16 Mar 2021 14:10:02 GMT

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

Re: Conectar Excel a QVD

rbartley — Tue, 16 Mar 2021 14:15:05 GMT

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.

Re: Conectar Excel a QVD

rbartley — Tue, 16 Mar 2021 14:47:41 GMT

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

Re: Conectar Excel a QVD

mnobile77 — Tue, 16 Mar 2021 18:57:00 GMT

Muchísimas gracias!!