Excel Add rows into multiple tables from Get Tables

(0) Share

Report

Posted on by almapete21

Hello.

I am creating a file based on an existing Excel file (contains Office Scripts) in SharePoint Document Library. I have to add rows on every table in the Excel Workbook but I don't know how to retrieve each table. My questions are:

1. How do I select a table from Get Tables (because the Excel file contains 4 tables) then add rows into each table?

2. Since I created a file based on an Excel file that has Office Scripts, will there be Office Scripts too in the newly created file?

I have screenshots for references that might hopefully help answer my questions/problems.

Will appreciate all the answers I can get to hopefully find a solution on these. I have tried searching different keywords that my questions will be answered but none matched.

Thanks in advance.

Categories:

Business Process Flows