topic Export to excel using script in QlikView

Export to excel using script

Sat, 17 Dec 2011 19:43:18 GMT

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

Export to excel using script

Anonymous — Sun, 18 Dec 2011 04:48:27 GMT

try this p.GetContent.String < 50 like wise

Re: Export to excel using script

luciancotea — Sun, 18 Dec 2011 11:36:47 GMT

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.

Export to excel using script

Sun, 18 Dec 2011 13:20:04 GMT

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

Export to excel using script

luciancotea — Sun, 18 Dec 2011 13:53:00 GMT

Use RowNo() to count rows.

Export to excel using script

Sun, 18 Dec 2011 21:43:20 GMT

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.

Re: Export to excel using script

luciancotea — Sun, 18 Dec 2011 22:55:01 GMT

Here's an example:

Export to excel using script

Tue, 20 Dec 2011 13:27:21 GMT

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

Re: Export to excel using script

luciancotea — Tue, 20 Dec 2011 14:32:01 GMT

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

Export to excel using script

Wed, 21 Dec 2011 16:31:17 GMT

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.

Export to excel using script

luciancotea — Wed, 21 Dec 2011 16:36:02 GMT

As I said: because the SendToExcel function cant limit the no of rows, you have to tweak your expressions to show only 1000 rows.

Export to excel using script

Anonymous — Wed, 21 Dec 2011 18:07:49 GMT

sub limitRow

set chart = ActiveDocument.GetSheetObject("CH02")

'set chart = ActiveDocument.Activesheet.CreateStraightTable

'tb.AddField "Member"

set cp = chart.GetProperties

cp.TableProperties.MaxNumShown.v = 1000

chart.SetProperties cp

SET p = chart.GetProperties

chart.SendToExcel

end sub

Export to excel using script

Wed, 21 Dec 2011 18:22:59 GMT

Hi Sarathi,

Thanks for your reply. I got only 100 rows when i am using above script in the Macro.

I think, in the straight table the max number is limited to 1-100 in the presentaion tab. I am using QV10.

Please suggest me how to overcome this.

Thanks in advance.......

Regards,

Siri

Re: Export to excel using script

Thu, 22 Dec 2011 15:01:50 GMT

Using this script we can export only first 1000 rows from a chart even the chart displaying more than 1000.

Export to excel using script

udaya_kumar — Mon, 26 Dec 2011 14:23:54 GMT

hi,

i want to export qlikview charts as an image to excel, not as a data in excel.

how we can do that?

Export to excel using script

Anonymous — Mon, 26 Dec 2011 15:27:56 GMT

copy to clipboard then paste ..it act as a object

Export to excel using script

udaya_kumar — Mon, 26 Dec 2011 15:31:01 GMT

but i want to export chart on button click in qlikview

Re: Export to excel using script

Anonymous — Mon, 26 Dec 2011 15:44:09 GMT

ActiveDocument.Sheets("Main").ExportBitmapToFile "C:\MyImage.bmp"

ActiveDocument.GetSheetObject("LB02").ExportBitmapToFile "C:\MyImage.bmp"

Export to excel using script

udaya_kumar — Tue, 27 Dec 2011 12:15:05 GMT

thanks for reply sarathi,

but i want to export that chart to powerpoint from qlikview on button click.

Export to excel using script

udaya_kumar — Tue, 27 Dec 2011 12:18:22 GMT

sorry i want to export to excel from qlikview on button click as an image.