topic Re: Export von Daten in Excel Version QlikView 12.6 - Beschädigte Datei - Makro in QlikView

Export von Daten in Excel Version QlikView 12.6 - Beschädigte Datei - Makro

qlikview2015 — Tue, 09 Aug 2022 14:22:57 GMT

Hi zusammen,

seit dem Update auf QlikView Version 12.6 klappt der Export an Excel nicht mehr per Makro.

Es wird zwar exportiert und die Datei erstellt. Beim öffnen bekomme ich allerdings die Meldung das diese beschädigt ist.

Jemand eine Idee oder sogar ene Lösung?

Besten Dank.

Mike

--------------------------------------------------------------------------------------------------------------------------------

Hi all,

since the update to QlikView version 12.6 the export to Excel does not work anymore via macro.

It is exported and the file is created. But when I open it, I get the message that it is corrupted.

Does anyone have an idea or even a solution?

Thanks a lot.

Mike

Re: Export von Daten in Excel Version QlikView 12.6 - Beschädigte Datei - Makro

marcus_sommer — Tue, 09 Aug 2022 14:54:36 GMT

Please share some more details, like the release changed from x to 12.6 SR x and if there were any other changes to the OS and/or MS office, too or not? Which Excel release is in use? Happens it for all users/application/objects - even very simple ones? How is the macro executed - manually or per batch? How does the macro and the Excel file look like?

- Marcus

Re: Export von Daten in Excel Version QlikView 12.6 - Beschädigte Datei - Makro

marcus_sommer — Tue, 09 Aug 2022 15:17:01 GMT

Just seeing this elder posting with the new bump: ExportBiff saving corrupt xls from QV Plugin, but ... - Qlik Community - 1875544.

If it's related to the IE plugin - was it also updated to 12.6 ? If yes you may try to revers it to see if it worked then and if not you should upgrade the plugin, too.

- Marcus

Re: Export von Daten in Excel Version QlikView 12.6 - Beschädigte Datei - Makro

qlikview2015 — Wed, 10 Aug 2022 08:45:18 GMT

Hi!

Seit dem Update ist QlikView May 2021 SR1 Version 12.60.20100.0 im Einsatz. Das IE-Plugin ist auch das neuste (Version 12.60.20000.0).

Die Office Version ist von 2016. Das Macro wird manuell ausgeführt. Alle User haben das selbe Ergebnis.

Viele Grüsse

Mike

--------------------------------------------------------------------------------------------------------------

Hi!

Since the update QlikView May 2021 SR1 version 12.60.20100.0 is in use. The IE plugin is also the latest (version 12.60.20000.0).

The Office version is from 2016 and the macro is run manually. All users have the same result.

Many greetings

Mike

Re: Export von Daten in Excel Version QlikView 12.6 - Beschädigte Datei - Makro

marcus_sommer — Wed, 10 Aug 2022 09:00:21 GMT

What happens by reverting the plugin release to the elder ones?

Does a manually export from an object work? And if yes how does the working and not working files differ from each other?

- Marcus

Re: Export von Daten in Excel Version QlikView 12.6 - Beschädigte Datei - Makro

qlikview2015 — Wed, 10 Aug 2022 09:24:58 GMT

Hi!

ich habe das PlugIn auf die neuste Version geupdatet. Nun scheint es zu funktionieren.

Vielen Dank fürs gedanken machen :-).

Viele Grüsse

Mike

----------------------------------------------------------------------------------

Hi!

I have updated the PlugIn to the latest version. Now it seems to work.

Thanks for your thoughts :-).

Many greetings

Mike