Qlik Automation Writeback

[rajatdhera]

I am facing issues when I am trying automation Writeback in an excel file
I am unable to fetch the file using 'List File' or any other block
the file is stored in sharepoint/onedrive

[anychart · Accepted solution]

Just in case: you can open Excel files right inside a Qlik app 😉
👉 Excel-Style Spreadsheets Extension for Qlik
🎥 How to Import Excel Templates into Qlik

Demo:

[NS_Qlikupdates]

It looks like the issue is occurring before the writeback process itself, as the automation is unable to access the Excel file stored in SharePoint/OneDrive using blocks like “List File.”

This is commonly caused by connector configuration, permissions, authentication, or incorrect file path setup.

Instead of depending on external file connectors, you can consider a more direct writeback approach. Tools like SenseOps Writeback allow users to write data directly from the Qlik app to a database, which helps avoid SharePoint/OneDrive file access issues and provides a more reliable solution. Know More about SenseOps Writeback Here