none
How Can I programmitically compress files from XLSX in Excel's default compression? RRS feed

  • Question

  • I understand that XLSX format is just like zip format.

    rename it '*.zip' and decompress it.

    The other way,  compress it and rename it '*.xlsx'.

    it works.

    but file size is changed.

    when i resaved it, the file size returned as almost previous size.

    i think Excel's compression is different than other compression models.

    I dont't want to make this size changes.

    How can i compress extracted files in default compression level?

    or can i change Excel's compression settings?

    Monday, January 23, 2017 7:17 AM

All replies

  • Hi blacksmith01,

    you had mentioned that , you want to compress the file and make .zip files.

    but you don't want to decrease the file size when it get compressed.

    well, the word "compression" itself says that when you perform this operation it will decrease the file size.

    then also I try to test with different compression codes and find the similar results.

    so I think you can't make your desire changes , as you want by using compression.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, January 24, 2017 2:08 AM
    Moderator