Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a qlikview report pega which is web based.I need to download data daily from that Web based Qlikview report.Normally its download in excel
is there any way i could download same report in Excel using Python.i want to automate my task using python.
Hello Friend,
it's possible to automate the task of downloading data from a web-based QlikView report using Python. You can achieve this by using libraries like requests
for making HTTP requests and beautifulsoup
or lxml
for parsing HTML content.
Write a Python script using the requests
library to send HTTP requests to the QlikView server. You might need to include authentication (if required) and navigate to the page containing the report.
Use the below code
import requests
# Replace these placeholders with the actual login credentials and report URL
login_url = 'https://your-qlikview.com/login'
report_url = 'https://your-qlikview.com/report'
username = 'your_username'
password = 'your_password'
# Start a session and perform login
session = requests.Session()
login_data = {
'username': username,
'password': password
}
session.post(login_url, data=login_data)
# Retrieve the report data (replace this with your report download logic)
report_response = session.get(report_url)
# Save the downloaded Excel file
with open('report.xlsx', 'wb') as f:
f.write(report_response.content)
Hope this may helps.