Unanswered

Create copy of and Excel and update a table

(0) Share

Report

Posted on by cdmcali

I am trying to create a copy of an excel file and populate a set of tables I have in the excel file. I am able to add rows to the existing file just fine but need to make a new copy of the file each time a form is submitted and add information from the form into the tables to populate a bunch of cells within the Excel. Is there a way to do this?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @cdmcali if you want to fill an specific cell like A1:B2 unfortunally it's not possible.

A requirement to add information in excel is have a table inside.

Was this reply helpful? Yes No
cdmcali 64 on at

Like (0)

Report

Hi Christian, I figured out a way to fill in a specific cell but that is not my question. I am trying to create a copy of the spreadsheet before filling out the table in the spreadsheet using flow. Any ideas how to do that?

Was this reply helpful? Yes No
cdmcali 64 on at

Like (1)

Report

I figured out what to do. I have the flow take the form data and add it to different tables within the spreadsheet. The tables are on different sheets. The cells within the table are linked to the cells on the first page of the spreadsheet. So once the tables are filled, in all the cells that are linked on the first sheet are populated. I then use the get file content module and the create file module to create a copy of the spreadsheet with the data all filled in. Then I run a delete rows module to clear the table and the spreadsheet is ready for a new set of data.

Was this reply helpful? Yes No
MalcolmBean 6 on at

Like (0)

Report

Genius, I can't believe I didn't think to just empty the table once I was done. Saved me so much brainache.

Was this reply helpful? Yes No