topic Re: Update Rows in worksheet (Microsoft Excel) in Qlik Automate

Update Rows in worksheet (Microsoft Excel)

Dat — Tue, 06 Jun 2023 16:19:28 GMT

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 :

In the automation, everything seems good :

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!

@AfeefaTk

@MarkGeurtsen

@PietMichielRappelet

Re: Update Rows in worksheet (Microsoft Excel)

AfeefaTk — Thu, 08 Jun 2023 05:05:39 GMT

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:

Thanks!

Re: Update Rows in worksheet (Microsoft Excel)

Dat — Fri, 09 Jun 2023 09:02:47 GMT

Hi @AfeefaTk ,

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

Re: Update Rows in worksheet (Microsoft Excel)

AfeefaTk — Fri, 09 Jun 2023 09:09:41 GMT

Hi @Dat

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

Thanks

Re: Update Rows in worksheet (Microsoft Excel)

Dat — Fri, 09 Jun 2023 09:16:00 GMT

Hi @AfeefaTk

Here they are!
Thanks for helping!

Re: Update Rows in worksheet (Microsoft Excel)

AfeefaTk — Fri, 09 Jun 2023 09:35:26 GMT

Hi @Dat

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

Thanks

Re: Update Rows in worksheet (Microsoft Excel)

Dat — Fri, 09 Jun 2023 09:40:18 GMT

Hi @AfeefaTk ,

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

Re: Update Rows in worksheet (Microsoft Excel)

AfeefaTk — Fri, 09 Jun 2023 09:51:33 GMT

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

Re: Update Rows in worksheet (Microsoft Excel)

Dat — Fri, 09 Jun 2023 09:56:29 GMT

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

Re: Update Rows in worksheet (Microsoft Excel)

AfeefaTk — Fri, 09 Jun 2023 10:04:29 GMT

Hi @Dat

Please share your email address.

Let's have a call today.

Thanks

Re: Update Rows in worksheet (Microsoft Excel)

Dat — Fri, 09 Jun 2023 14:12:11 GMT

Actually I had the wrong file in my automation.

That's why I couldn't see the updates. So the automation I shared

Thanks a lot @AfeefaTk for your help!

Re: Update Rows in worksheet (Microsoft Excel)

Tanvi_Madan — Thu, 24 Aug 2023 11:26:28 GMT

Hi @Dat,

Is this issue resolved. Even i am facing the same issue .can you help me with it.