Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

s_santalucia
Contributor

Rename sheet excel from export QLIK SENSE

Hello

when I do the export of table (right click--> export data) , is it possible to rename the sheet in the excel file, automatically?

Thanks

4 Replies
andrespa
Valued Contributor

Re: Rename sheet excel from export QLIK SENSE

Hi, as far as I know you can't. But why you don't change it in the source file itself?

s_santalucia
Contributor

Re: Rename sheet excel from export QLIK SENSE

Can you give me an example?

Employee
Employee

Re: Rename sheet excel from export QLIK SENSE

Generally all interactions in Qlik Sense are driven through the open Qlik Sense APIs. For export I looked at Export the data of a generic object ‒ Qlik Sense Developers‌, which shows that you can not control the sheet name. The conclusion from that is that you also wont be able to alter the name from the within Qlik Sense.

If you for some reason need a static sheet name, keep in mind that the export will always be the only sheet in the exported workbook. This sheet will always have the default Excel sheet name when opened.

For more advanced export and formatting, you might want to take a look at Qlik NPrinting.

s_santalucia
Contributor

Re: Rename sheet excel from export QLIK SENSE

Thank you!

Community Browser