Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Dat
Partner - Contributor III
Partner - Contributor III

Update Rows in worksheet (Microsoft Excel)

Hi all,

following this White back exemple : https://www.youtube.com/watch?v=hYER2nGKctM&ab_channel=Qlik, I'm trying to update an Excel cell from a Straight Table. The automation runs correctly, but the row is not updating in my excel file.

I'm trying to update this value from my app :

Dat_0-1686066759591.png

In the automation, everything seems good :

Dat_1-1686067264271.png    Dat_2-1686068218664.png

 

But when load my data and check my excel file, nothing change. I can't figure out where I'm wrong in my process.

Any clue ?

My app and my automation are attached.

Thanks in advance for your help!

 

 

 

Qlik Application Automation 

@AfeefaTk  

@MarkGeurtsen 

@PietMichielRappelet 

 

Labels (5)
1 Solution

Accepted Solutions
AfeefaTk
Support
Support

Hi @Dat 

Are you sure that the definition field is not filled in with expressions for the variables?

I have tested it from my end and it works for me.

Sharing my automation and app for your reference.

This is how my Excel file looks like:

write-back-excel-file.png

Thanks!

 

View solution in original post

11 Replies
AfeefaTk
Support
Support

Hi @Dat 

Are you sure that the definition field is not filled in with expressions for the variables?

I have tested it from my end and it works for me.

Sharing my automation and app for your reference.

This is how my Excel file looks like:

write-back-excel-file.png

Thanks!

 

Dat
Partner - Contributor III
Partner - Contributor III
Author

Hi  @AfeefaTk ,

I did everything exactly like in your example, but my excel file is not updating.

AfeefaTk
Support
Support

Hi @Dat 

Could you please share the automation workspace and automation run log file to further investigate the issue?

Thanks

Dat
Partner - Contributor III
Partner - Contributor III
Author

Hi @AfeefaTk 

Here they are!
Thanks for helping!

AfeefaTk
Support
Support

Hi @Dat 

Did you try the automation and app I have shared just for testing if that works for you?

Thanks

Dat
Partner - Contributor III
Partner - Contributor III
Author

Hi @AfeefaTk ,

I've tried with my own data. And it's not working

AfeefaTk
Support
Support

Hi @Dat 

I think it's best to go over a call and do a screen share to troubleshoot the issue further.

Please let me know your availability. I will schedule a meeting accordingly.

Thanks

Dat
Partner - Contributor III
Partner - Contributor III
Author

Thank you @AfeefaTk !

If it is possible for you, you can call me today from now until 8PM (France time).

Tomorrow or Monday until 1 PM.

Thanks again for helping

 

AfeefaTk
Support
Support

Hi @Dat 

Please share your email address.

Let's have a call today.

Thanks