Inserting data to certain cells in excel by saving structure of Excel file

[KarlygashM]

Hello Dear Alteryx users, 

I am trying to insert specific values to certain cells of the excel file. The problem is that when I am inserting, it does not save initial structure. For example I have row borders and row styles, when I am writing data to excel to fills data, but borders are invisible.

 

__PRESENT

[alexnajm · Accepted solution]

You need to select Option #6 "Preserve Formatting on Overwrite (Range Required)"!

[KarlygashM]

Thanks for quick response

I did it, but it is not working

__PRESENT

[alexnajm]

Can you send over the new workflow with the template file include?

[KarlygashM]

Definitely! 

I am just putting sample numbers there

Nordic12 - Copy is the output file where i have to insert value to column J and workflow as well

Thanks

__PRESENT

[alexnajm]

It is working on my end and preserving MOST of the formatting - the only thing it is not preserving is the borders around the cells that don't have data. Is this the concern or are you noticing other formatting getting overwritten?

[KarlygashM]

@alexnajm thanks a lot! it worked 😀 sorry for late response)