Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Can QV's data be exported to excel in "read only mode" ?

Hi,

Is it possible to restrict the "export to excel " data in read only mode ?

End user should not be able to edit the data in excel after exporting it from QV

Thanks & Regards,

Tags (2)
Labels (2)
8 Replies
Not applicable

Re: Can QV's data be exported to excel in "read only mode" ?

Not that I am aware of using the Export in-built facility of Qlikview.

I believe we can try creating a macro(though not recommended) and then add functionality in their.

Thanks,

Singh

Not applicable

Re: Can QV's data be exported to excel in "read only mode" ?

Hi Angad,

Ya , we can try that but it's like inviting a trouble.

So don't want to do that.

Regards,

Sarang M. Mehta

Regards,

Sarang M. Mehta

Sent from Samsung Mobile

Please excuse the brevity of the message

Re: Can QV's data be exported to excel in "read only mode" ?

You could use a master-file with appropriate security and copy+paste instead of export the data.

- Marcus

sebastiandperei
Valued Contributor

Re: Can QV's data be exported to excel in "read only mode" ?

I think you are trying to "send results from a table" to another person (i don't think another reason to export to read only)

Did you try using "send bookmark by email"? It is in the Access Point interface, in "More" label...

Not applicable

Re: Can QV's data be exported to excel in "read only mode" ?

Hi Marcus,

The query is related to "Export to Excel" from accesspoint. Hence there will be no manual intervention.

As soon as the user exports data to excel from Access point, the generated excel should be in read only mode.

Any ways to achieve this ?

Thanks & Regards,

Not applicable

Re: Can QV's data be exported to excel in "read only mode" ?

Hi Sebastian,

No, it isn't for the transferring data from a table to another form.

As described in the above post, it is for end users who want to export data into excel from QV Access point directly.

Client wants it to be in read mode only.

Thanks & Regards,

Not applicable

Re: Can QV's data be exported to excel in "read only mode" ?

But if you really wish to have that functionality.

Then a macro is required.

1) Either create a export button separate with read only functionality.

2) For a chart, Copy the Image of the data and then paste it in excel file.

this can help:

community.qlik.com/docs/DOC-4315

community.qlik.com/thread/91136

qlikviewtips.wordpress.com/2011/10/17/is-possible-make-macros-that-run-server-side/

Thanks,

Angad

Re: Can QV's data be exported to excel in "read only mode" ?

I would rather suggest to deny these export-functionality then you couldn't control it. Even if you have a write-protected file a user could copy+paste this content in a new file and throw the old one away.

- Marcus