Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Extracting the table chart to excel

Hi Frnds,

        I want to export the table chart to excel which is size of 300 mb. I am doing this by button using macro. But our platform team have policy like u can't extract the file which is more than 32 mb so not geting approval from our platform team. But they are okay while reloading itself if we extract and save that file in shared path  so tried with post reload option but in the qmc it will not work. So need your suggestion to resolve this issue.

5 Replies
jpe
Not applicable

Re: Extracting the table chart to excel

Its not the same thing but you can dump any table in the data model (not a UI chart) to TXT format (not excel) using the STORE command

store mytable into myfile.txt (txt);

Then the TXT is re(generated) every time the QVW executes.

Could that work or do you need those table chart functions ?

Not applicable

Re: Extracting the table chart to excel

Hi Jonathan,

     Sorry i want to extract straight table and it has 20 expressions.

Regards,

sushil

ashfaq_haseeb
Not applicable

Re: Re: Extracting the table chart to excel

Hi,

I think this macro will do the job. It will store your table to qvd.

sub MyMacro

set obj = ActiveDocument.GetSheetObject("CH02")

obj.ExportEx "C:\test.qvd", 4

end sub    

Store in the path you like.

Let me know if that worked.

Regards

ASHFAQ

Not applicable

Re: Extracting the table chart to excel

Hi Ashfaq,

  I want excel not qvd.

Regards,

sushil

ashfaq_haseeb
Not applicable

Re: Extracting the table chart to excel

try this

sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH02")

obj.ExportBiff "C:\test.xls"

end sub

Regards

ASHFAQ