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

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.