I'm trying to automatically get QlikView data into Excel. I've come across an old third party Excel plugin which could connect and import a QlikView website, but that has seems to have been snuffed by QlikView.
So my next attempt would be to automatically export an Excel file through the webview. I've automated plenty of web actions, either through direct GET/POST request or by using IE's COM when there's too much javascript to get around. But here I'm getting stuck even when just trying things in Chrome's browser's console.
As far as I can tell, regardless of where I click, the coordinates are sent to the dashboard. And the export button doesn't have an event handler linked to it. So I assume the event bubbles up and the dashboard determines the target based on the coordinates. However, even when I send a click event with coordinates like: $('div[title="Send to Excel"]')[0].dispatchEvent(new MouseEvent('click',{'view': window, 'bubbles': true, 'cancelable': true, 'screenX': 1539, 'screenY': 328, 'clientX': 1539, 'clientY': 257})), the dash doesn't trigger anything. When I attach an event listener, I see the simulated event differs in a few parameters from a real one, such as composed and isTrusted, which are read only and indicate it's a simulated event. I'm not sure if the dash check for that. My sub-par Javascript understanding combined with the amount of what it executes, doesn't help in figuring out how to fix this.
Using SendClick doesn't work either. Send {Click} does, but that would require me to keep the browser window visible, which I would rather not have.
Does anybody have a any experience or tips regarding QlikView or handling stuborn websites?
- Home Board index AutoHotkey (v1.1 and older) Ask for Help (v1)
- Search
-
- It is currently 09 May 2024, 19:32
- All times are UTC-05:00
Automate QlikView Webview
Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
Jump to
- AutoHotkey Foundation
- About This Community
- Forum Issues
- AutoHotkey (v2, current version)
- Ask for Help (v2)
- Gaming
- Scripts and Functions (v2)
- Gaming
- Tutorials (v2)
- Tips and Tricks
- Wish List
- Suggestions on Documentation Improvements
- Bug Reports
- AutoHotkey Development
- AutoHotkey_H
- Ask for Help
- Development
- Editors
- Adventure IDE
- Old Topics
- AHK Studio
- Notepad++
- Pulovers Macro Creator
- SciTE4AutoHotkey
- Visual Studio Code
- Announcements
- General Discussion
- AutoHotkey (v1.1 and older)
- Ask for Help (v1)
- Gaming Help (v1)
- Scripts and Functions (v1)
- Gaming Scripts (v1)
- Tutorials (v1)
- Tips and Tricks (v1)
- General
- Other Utilities & Resources
- Other Programming Languages
- C/C++
- ASM
- C#
- KeySharp
- Off-topic Discussion
- RPA
- Other languages
- Looking for Volunteers in other languages
- Deutsch (German)
- Ich brauche Hilfe
- Spiele
- Skripte und Funktionen
- Tutorials
- Tooltime
- Allgemeines
- 中文 (Chinese)
- 请求帮助
- 脚本函数
- 教程资料
- 相关工具
- 其他
- Español (Spanish)
- Pedir Ayuda
- Automatización de Juegos
- Scripts y Funciones
- Tutoriales
- Otras Utilidades y Recursos
- General
- Русский (Russian)
- Помощь
- Скрипты для Игр
- Скрипты и библиотеки
- Статьи и руководства
- Прочие ресурсы и ПО.
- Свободное общение
- Français (French)
- J'ai besoin d'aide
- Scripts et Fonctions
- Tutoriels
- Autres Utilitaires et Ressources
- Hors Sujet
- Português (Portuguese)
- Ajuda e Suporte Geral
- Scripts e Funções
- Tutoriais
- Outras Ferramentas e Recursos
- Outros Assuntos
- 한국어 (Korean)
Who is online
Users browsing this forum: Archimede, Google [Bot] and 111 guests