Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview2015
Creator II
Creator II

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

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

Labels (1)
  • Other

1 Solution

Accepted Solutions
marcus_sommer

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

View solution in original post

5 Replies
marcus_sommer

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

marcus_sommer

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

qlikview2015
Creator II
Creator II
Author

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

marcus_sommer

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

qlikview2015
Creator II
Creator II
Author

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