ouput data into excel and keep original cell format

Hi guys,

I wanna output some data into excel template with some columns has certain format like background color

i used append to existing sheet and ticked the Perserve formatting on Overwrite, while when the data is outputed, the cell lost the original background color, is there any way i can keep those while writing data into excel?

Help

Accepted answers

Qiu

@187
Based on my test, it works as you have expected.

1220-187.yxmd

All comments

Qiu

@187
Did you specify the range?

Like Sheet1$A1:F100

187

no i dont actually we have header like below and we append the data according to the map of the fields

we expected

but what we got is

Qiu

@187
Based on my test, it works as you have expected.

1220-187.yxmd

187

Thanks Qiu let me try this solution

187

@Qiu

Hi Qiu

I found one issue when using this approach, suppose it has many column and we have column J and K has formatting, i set the range A1: K100

while the formatting is overwritten

Qiu

@187
It still works on my end as attached.
Can you check the setting of output tool?

1220-187 - r1.yxzp

I think I might be having the same problem. I'm outputting to a range, overwrite sheet or range, and Preserve Formatting is selected but it's still eliminating my formatting.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703