Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how can I send different objects to Excel in the same page

how can I send different objects  to Excel in the same page,

for example if I got a 3 tables  I need to send all to excel at the same time.

best regards.

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

11 Replies
ecolomer
Master II
Master II

Can you try this

Script:

SUB SendToExcel

SET chart = ActiveDocument.GetSheetObject("CH01")

SET p = chart.GetProperties

chart.SendToExcel

END SUB

Please advise me how do i can limit the export to 'n' no. of rows.

ecolomer
Master II
Master II

Also you can use:

macro.png

Not applicable

thanks a lot but, can I send this since a button?

ecolomer
Master II
Master II

yes indeed

must create a macro with the editor and put on a button and run

Can help you?

Not applicable

you help me very much, thanks  .

it Works but ,send the tables to a diferent sheet.

can I do at the same sheet?

ecolomer
Master II
Master II

You can put the same name of sheet

ecolomer
Master II
Master II

I send you attached and example ...

Not applicable

Enrique Thanks a lot , but the button appears like an text object

ecolomer
Master II
Master II

No,

The button are active and send two tables in two excel pages in the same file