Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
815
Modify an Existing Table
posted

I currently have an excel that has a defined Table "Employees" that contains 50 employees.  I can get that data easily and process it but after that I want to update the table with additional employees.  I can write the data to the correct rows and cells using Document.Excel library but I cannot figure out how to tell the Table to now include the added rows so that when the Excel file is opened again formulas know to include the added rows.

Is there a way to redefine the Named Table using the Document.Excel library?

Is there a way to delete the Named Table then re-add it with the correct defined range without destroying existing references to other formulas?

Parents
  • 48586
    posted

    Hello,

     

    Is it possible to post a small sample with dummy data, which demonstrate your issue in order to be able to investigate this further for you. Also please point which exactly cell of the excel file should update its formula.

     

    I am waiting for your details.

Reply Children