topic Create your own Excel in QlikView

Create your own Excel

Fri, 06 Aug 2010 11:43:01 GMT

Hi to all,

I've my QV report with different tables, then I want to extract data to create an excel template that retrieve data from different tables and formatted as I want. And for sure it need to be automated from a Macro (fixed layout already decided)

I saw the Nprinting (http://www.nprinting.com/nprinting/download_nprinting_free.php) solution, but any other way that someone have done it through macro by himself ?

At the moment I'm just able to extract single table into excel from a macro

Thanks

Sergio

Create your own Excel

Mon, 16 Aug 2010 21:46:04 GMT

Hi All,

Anyone has the same problem ?

Still I'm working to find out the best solution but I'm not still satisfied with what above.

Sergio

Create your own Excel

Tue, 17 Aug 2010 05:20:06 GMT

Can you just post a sample file of what you need to get, may be i can help you.

Create your own Excel

Wed, 18 Aug 2010 15:37:18 GMT

Hi,

I just want to know which is the best way to extract automatically (trough a Macro or addin) all tables in a sheet in a formatted excel (so to create the excel layout as I want).

What's your suggestion ?

Thanks

Sergio

Create your own Excel

chrisbrain — Thu, 04 Nov 2010 16:57:10 GMT

QVExcel (http://www.QVExcel.com) is an Excel Add-in which provides a number of methods for extracting data from your QlikView objects and fields directly into Excel.