if yo know the object id, you could you pywinauto, pandas libs. i dont have the excat script right now but you could give it a sot and let me know how that goes. somehting like below should be able to export the data
To export data from a QlikView/Qlik Sense straight table to Excel using Python,
you can use the Qv/QS API along with Python packages like pandas and xlrd or openpyxl.
import pandas as pd
import xlrd
import openpyxl
from qlikview import QlikViewApp # Hypothetical package; replace with actual if available
# Initialize QlikView application connection (replace with actual connection code)
app = QlikViewApp(app_path="path/to/your/app.qvw")
# Hypothetically pull the table data, assuming `get_table_data()` method exists
data = app.get_table_data("YourStraightTableID") # Replace with the correct table identifier
# Load data into a DataFrame
df = pd.DataFrame(data)
output_path = 'straight_table_data.xlsx'
df.to_excel(output_path, index=False)
print(f"Data exported to {output_path}")
https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-call-Qlik-Sense-Engine-API-with-P...
