Create your own Excel

[#1]

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

[#2]

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

[#3]

Hi

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

[#4]

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

[chrisbrain]

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.