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
585
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?