QAA to create and distribute Excel reports in Office 365 - no rows data

[agigliotti]

Hi,

I followed every step to test the Example 1 - Scheduled Reports.

Unfortunately the table rows from Qlik Sense straight table have not been added to the excel table.

It seems the block "Microsoft Excel - Add Rows to Table (Batch)" does not works as expected.

I get the below table with only headers!!!

Maybe there is something wrong in block configuration? Running  the automation I get no errors!

Could someone help me to fix it?
Many thanks in advance for your collaboration.

@Sonja_Bauernfeind @MattGrayndler @Andre_Sostizzo @MarkGeurtsen @MLaverick @jheasley 

Best Regards

[MattGrayndler]

Hi @agigliotti - 

Since your question relates to a specific example automation shared in the knowledgebase, I have responded to you within that thread. 

https://community.qlik.com/t5/Knowledge/Using-Qlik-Application-Automation-to-create-and-distribute-E... 

I've also sent you a private message to see if I can help further. 

Thanks!

[sudhirkuwarpwc]

Hi 

Can you guide me the process to configure the Create Workbook Session. I am facing issue while setting it up.

Thanks in advance.

Regards,

Sudhir

[Emile_Koslowski]

Hi @sudhirkuwarpwc , did you take a look already at these articles? They contain examples that use the Create Workbook Session block.

• https://community.qlik.com/t5/Knowledge/How-to-import-and-export-master-items-using-Microsoft-Excel-...
• https://community.qlik.com/t5/Knowledge/Qlik-Application-Automation-Copy-data-to-Microsoft-excel-she...

Kind regards,

Emile