Export to excel using script

[#1]

Hi folks,

i have a script that exports an object to excel.

i want to extend the script functionality to export only first 1000 records from the object.

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.

Thanks in advance.

regards,

Dathu

[Anonymous]

try this p.GetContent.String < 50 like wise

[luciancotea]

Limit the rows inside the chart using a condition in your expressions or using the new "Dimension Limits" chart tab in QlikView 11.

Then the "Chart.SendToExcel" function will send only available rows to Excel.

[#4]

Hi Lucian, Thanks for your reply.

How to achive this in QV10. I am using QV10 version.

Please suggest me.

Thanks in Advance......

Regards,

Siri

[luciancotea]

Use RowNo() to count rows.

[#6]

Hi All,

thanks for your valuable suggestions. Unfortunately i couldn't limit the export.

Alternatively, i tried to show only 1000 rows in the straight table any time. but the option 'Max Number(1-100)'

showing upto 100 rows only. i need more than 100 rows.

please suggest me how do i can achieve this.

thank you,

Siri.

[luciancotea]

Here's an example:

[#8]

Hi Lucian,

Thanks for ur reply. If i am using more than one expression, the above logic didn't work.

Please suggest me how can achvive this?

Regards,

Siri

[luciancotea]

Of course it does not work if you change the problem. Ask the right question from the beginning.

[#10]

Hi Lucian,

Sorry for late reply.

Requirement: I need to use button to export to excel sheet the first 1000 rows in the straight table and stright table having multiple expressions. For this, I wrote one macro, but I stucked to limit the 1000 rows.

Script:

SUB SendToExcel

SET chart = ActiveDocument.GetSheetObject("CH01")

SET p = chart.GetProperties

chart.SendToExcel

END SUB

Ths is my problem.

Please suggest me.