Vizlib Home Try Vizlib
Welcome
Login
Answered

Why the file size is huge between Normal export and formatted export to Excel in Vizlib

Hi all

When I export vizlib pivot table as formatted data to excel the data size is about 151 mb

The same pivot table when I do "Fast export pivot table to excel" the size is 1.9 mb

please can anyone help me to understand why the size difference is huge

Secondly, when I open 151mb formatted file and save as different name the file size becomes 2.3 mb, the size reduces drastically also there is no difference in table appearance

Thanks

 

 

 

 

 

  • Hi Taj,

    I do hope you're well, safe and having a wonderful week.

    Thank you for contacting us, and I'll be happy to answer your query. 

    The formatted Data to Excel doesn't just export the Data but includes any formats in the Pivot Table. This results in a more significant export. You can also see that the values (hover on the excel cell, see that there are values and text) are also exported.

    While I'm unsure as to why renaming it changes the size, the team has mentioned it's possible the formatting is changed along with the name.
    We will now mark this ticket as "Resolved", as we believe we have provided a solution to the query you have raised with us. If it is not to your satisfaction, please reply to this email within 5 days before it moves to a "Closed" state. 

    Please note your unique ticket reference (#36764) and URL https://community.vizlib.com/helpdesk/tickets/36764

    Daniel Adesanya
    Technical Support Engineer
    Vizlib

    Why not visit our Community and take a read of our Knowledge Base? You can also follow products, latest releases and updates and find answers at Vizlib FAQ. Not sure where to begin? Try these links to kick-start your journey with Vizlib. If you need support, the most efficient way is to open a support ticket via our portal or even submit ideas as a Feature Request.

    Our learning platform is out! Register to the Viz Lab to get your badges! 
Login to post a comment