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

Question

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

Mukeshy12390 · Answer

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

Thanks,

Mukesh Y

Mukeshy12390 · Answer

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?

dougperez · Answer

Hello @Mukeshy12390

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