How to update specific range in Excel (file type xls )

[Mukeshy12390]

Hi Everyone,

I have been trying to build a solution where I could update a specific range in Excel and also maintains excel format at the same time.

File Type: Xls only

Alteryx version : 2019.4

I want to update a specific range, not "NameRange". I have a situation in which I can't define the range every day.

so looking for an Absolute address like a sheet!A5:A10.

my finding so far:

by using Name range it works I am able to update the range. Since every day I will be downloading data from the system it is a good idea to update every day.

Xls: keeps the current format for that particular range.

Xlsx:  it removes all current excel formats from that particular range.

Any help would be appreciated.

Thanks,

Mukesh Y

[dougperez]

Try to use Dynamic Input to update the range every run

[Mukeshy12390]

thanks for the quick reply.

Is that possible for you to share a small sample?

also, would it keep the existing excel format like fill , font, etc. ? 

[Mukeshy12390]

any comment?

[dougperez]

Hello @Mukeshy12390 

If you don't overwrite the file/sheet it will keep the format

[Mukeshy12390]

I'm just an amateur in Alteryx. I have been trying to do it but have not been able to solve this.

if possible could you show one small example, please? 

[Mukeshy12390]

I don't want to push anything....just wanted to know whether is it possible you to show me one example?

Thanks,

Mukesh Y