exel macro data to qlikview

[#1]

Hi!    I have a question.  How to load results(sums,ext.) of exel macro in Qlikview ? I only need results (otherwise it would take a long time to just load whole exel table over and over)

[deepakk]

Hi,

If possible,I would suggest you to store the excel data in QVD and then pull the data into application.

So loading data again and again would be faster...!!!

Deepak

[#3]

Unfortunately , there are too many exel tables , data in them will be changed often and also exel macros will be used often...     Macro generates some numbers in exel , generated numbers (results) are imported in qlikview.            Any idea how to do that?

[nagaiank]

Is it possible to define the Excel macros so that all the data to be loaded in Qlikview are in one sheet (say Sheet1)? If there are multiple Excel sheets, you can have script to load Sheet1 of each Excel file into Qlikview.

[Anonymous]

Are the "result" cells identified somehow in Excel?
For example, if there is a row identified as "Result" in column A, you can load like this:

LOAD
B as [Total Sum],
C as [Total Avg.],
D as [Result ...],
...
WHERE A = 'Result';

Regards,
Michael

[#6]

I have attached part of macro file in my original post to make it easier to see my problem...                           @Michael Solomovich -  I've tried but with no luck.