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

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

New Workflow5.yxmd

Nordic23 - Copy.xlsx

wo borders.png

Workflow

Custom Tools

Accepted answers

alexnajm

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

All comments

alexnajm

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

Nordic23 - Copy.xlsx

New Workflow5.yxmd

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)

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703