Replacing certain data in Excel

[Kallis]

Hi

I have an unique requirement. There is already one Excel sheet with data which comes from various sources. The requirement is that certain cells in the Excel must be changed through Alteryx.

Will this be possible?

Regards

Bobji

[Raj]

@Kallis 
this can be done
you need to specify the range you want to update and this can be done

[output file path]+"|||"+[sheet name]+"$"+[range]
Eg -[output file path]+"|||sheet1$A2:C5"

use output tool to overwrite sheet or range.

hope this helps you
mark done if solved.

[Kallis]

Thanks @Raj 

Let me try this. If it helps, I will certainly mark it as Accept as Solution

[DanielG]

@Kallis 

If it is a highly formatted Excel file, I have always found it easier to drop it into a temporary tab that Alteryx creates, then have an "On Open" event in VBA that grabs the data from the tab and places it in those cells, then deletes the temp tab.  VBA will not impact the formatting, unless you could it to impact the formatting.

I make The "On Open" event an IF statement saying if the temporary tab is present, do the work, otherwise do nothing.  That way it doesnt error when the temp tab is not there.  Pretty simple VBA that can be written in a few minutes.

It does require it to be an XLSM file, but at least that way you don't have to try to deal with formatting via Alteryx which I have found to be highly aggravating in the past.

Disclaimer: I am currently on an older version of Alteryx 2022.1, so if there have been advancements in this area since, please disregard my notes.  😁 

Good Luck