Export to update one sheet of XLSX workbook

Altair Forum User
Altair Forum User
Altair Employee
edited October 2017 in Community Q&A

I have a multiple sheet XLSX workbook within which I'd like to have the data in a particular sheet overwritten without disrupting the other sheets.

 

Is this possible? 

Thanks-

Tagged:

Answers

  • Altair Forum User
    Altair Forum User
    Altair Employee
    edited November 2017

    Hi Craig,

    In the Export Wizard, choose 'Add data to file' under When output file exists.

    1 Export wizard - output file.png

     

    For Table Info, choose the table you are updating then under When output table exists, choose 'Overwrite existing table'.

    2 Export wizard - table info.png

     

    Hope that works!

     

    Marianna

Categories