ouput data into excel and keep original cell format

[187]

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?

[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 · Accepted solution]

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

[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?

[EW]

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.