topic Re: generate several files to excel in QlikView

generate several files to excel

Mon, 10 Oct 2011 17:43:21 GMT

Hello,

need to generate several files to Excel.

Let me explain: I have a file with the customers A, B, C and D.

so I want to create an excel file for each client.

You can do this via QlikView?

Sincerely,

Gleybson Fernandes

generate several files to excel

swuehl — Mon, 10 Oct 2011 19:29:17 GMT

Gleybson,

I assume you want to call the export from your front end and not from the script, right?

You would probably need a macro for that to automate the export (you probably know how to select and export a table manually), maybe like described in this post:

http://community.qlik.com/message/59750

Hope this helps,

Stefan

Re: generate several files to excel

Mon, 10 Oct 2011 19:34:32 GMT

Hello Stefan,

I'm right with this post.

but I am having problem in 'Excel.Application'.

I have already put the option to allow access to the system but not resolved.

Re: generate several files to excel

swuehl — Mon, 10 Oct 2011 19:43:31 GMT

You have Excel installed on your system, right?

If you export to Excel manually, e.g. by clicking on the caption icon on a table chart, does this work?

Do you get any error message or similar?

Re: generate several files to excel

Mon, 10 Oct 2011 19:49:00 GMT

Oh yes,

excel 2010

I am attaching the file.

is very simple.

generate several files to excel

swuehl — Mon, 10 Oct 2011 20:05:01 GMT

It worked on my site.

On opening of the application, I was asked to grant security access and selected the least strict level.

Then I ran Test in Module editor. I found four excel files a.xls,b.xls,c.xls,d.xls with restricted data to the selected cod.

Maybe try to enable appropriate security settings in user settings - security (CreateObject).

Regards,

Stefan

Re: generate several files to excel

Mon, 10 Oct 2011 20:58:55 GMT

Stefan,

you know where I mean to change it to generate CSV?

that way I solve this problem.

generate several files to excel

swuehl — Mon, 10 Oct 2011 21:33:44 GMT

Sorry, you want to know how to export to csv or you already have done this and this solved your problem?

If first, I think you could do this with a code like

sub test

set Obj = ActiveDocument.GetSheetObject("304")

obj.Export "c:\Test.CSV",","

end sub

Regards,

Stefan

Re: generate several files to excel

Tue, 11 Oct 2011 09:32:41 GMT

Hi,

Please see the attached sample enhanced to export to CSV.

Cheers.

Re: generate several files to excel

Tue, 11 Oct 2011 11:54:01 GMT

Good morning,

thank you all for your help, I solved the problem by reinstalling office.

Thanks,

Gleybson Fernandes