topic Re: Export straight table to excel in a compressed form in QlikView

Export straight table to excel in a compressed form

ashish_2511 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Community -

I've a huge straight table. I want to export it to excel in a compressed format. is there any direct way to do it from qlikview desktop?

If not please suggest a way (may be using macro on button click).

Thanks!

Sneh

Re: Export straight table to excel in a compressed form

sarvesh — Wed, 22 Feb 2017 06:13:53 GMT

Hi..Sneh,

Please refer below mentioned URL which will help you to short out your problem.

Please remember to mark this as "helpful" & "correct answer" if your problem is solved.

This will help users identify the answers should they come across this thread in the future.

Regard's

Sarvesh Srivastava

Re: Export straight table to excel in a compressed form

sarvesh — Wed, 22 Feb 2017 06:14:33 GMT

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

Re: Export straight table to excel in a compressed form

Anil_Babu_Samineni — Wed, 22 Feb 2017 06:20:29 GMT

There is no direct way to do this?

By using Macro you would go like below and CSV limit has 1 Million Rows.

Macro Should like below

SUB ExportToCsv // ExportToCsv This is Function Name

set MyObj = ActiveDocument.GetSheetObject("MySheetLastObject") //MySheetLastObject is the Object ID(CH01)

MyObj.Export "C:\Users\AnilBabuSamineni\Qlikview\Macrostore\1217815.csv", "," //Path here

end sub

Re: Export straight table to excel in a compressed form

ashish_2511 — Wed, 22 Feb 2017 06:59:07 GMT

Hi Anil

Thanks for your reply ‌

So do you mean exporting it to CSV would be a more compressed form than exporting it to excel (right click -> send to excel)?

Even if that be the case, why a macro? can't we just right click -> Export ->save with CSV extension?

Re: Export straight table to excel in a compressed form

Anil_Babu_Samineni — Wed, 22 Feb 2017 09:58:09 GMT

I am not sure about Compress. I would suggest you to store the CSV while hitting the Button.

Yes, We can store this Save as CSV but what if user has this control whey they are going to have this(I mean storage). That is case we follow macro for this Scenario

Re: Export straight table to excel in a compressed form

ashish_2511 — Wed, 22 Feb 2017 10:11:12 GMT

I've tested this. csv export does compress a lot more than that of excel export and you're right about the potential security issue you said earlier about -> right click ->export ->Save as .csv

Thanks Again Anil.

Re: Export straight table to excel in a compressed form

Anil_Babu_Samineni — Wed, 22 Feb 2017 10:20:33 GMT

Hahaha, Is it may be qlikview favor for us at this case. The reason i could found is Excel has low limit of rows and CSV has 1 Million rows can store. Could be the reason to elapse the Performance.

Anyway, Some what you got which i refer