topic Re: Excel Sheet - Adding Todays Date / Creating Excel Sheet in Qlik Automate

Excel Sheet - Adding Todays Date / Creating Excel Sheet

DataPrecision — Tue, 27 May 2025 19:21:19 GMT

Hello! I was hoping someone could give me some assistance on this. I have taken the template that helps export tables from Qlik into Excel. I had two questions -

Is there anyway to get the "Add Worksheet" block in Excel to add todays date to the sheet?

Current Example:
Sheet Name : Data Listing
Ideal Sheet Name : Data Listing 27May2025

Another question, is there anyway to have it create an excel sheet, rather than having to connect to an already existing one? I'd like to provide these reports monthly, with the excel sheet ALSO having the date of the run in it.

Workbook Name : Data Listing Output
Ideal : Data Listing Output 27May2025

Currently I have to go through, delete all 15 tables, then run my automations since the sheet names are the same and it fails, the date would help with this issue, but ideally it would be better to seperate each set on its own excel sheet.

Thanks

Re: Excel Sheet - Adding Todays Date / Creating Excel Sheet

Lisa_P — Wed, 28 May 2025 00:06:12 GMT

This use case may be better served using Tabular reporting from within an app.

Re: Excel Sheet - Adding Todays Date / Creating Excel Sheet

Sivalingam — Wed, 28 May 2025 06:01:46 GMT

in script you can use like this ----

LET vToday = Date(Today(), 'YYYYMMDD');
STORE "Your_table_name" [lib://dlpunsr002/"Your_table_name"_$(vToday).csv] (txt);

in Qlik Application Automation

you need to follow the below steps.

Start Block – Begin your automation.
Get Current Date and Time Block:
- Format: YYYYMMDD
- Store as variable vToday.
Run Qlik Script Block (if needed) – Optional, to prepare the table.
Export Table to Excel Block:
- Use the “Export Table to Excel” block (available in Qlik Cloud).
- Select your app and the table ("Your_table_name").
- Set the file name to:
```
"Your_table_name"_{{vToday}}.xlsx
```
- Choose the destination (e.g., Qlik Cloud Storage, S3, OneDrive, etc.).

I also not have any live example for you in Qlik Application Automation, but I hope this will work.