Qlikview Data extraction Using Python

[soumyarani]

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.

[johnsonit]

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.