Remove records from excel sheet and write it back with new records in same workflow

Question

Hi,

I have a use case where I want to remove all old records excluding headers from earlier saved excel sheet and then write new records into it under the existing headers. I checked with sheet replace but that will not retain my name range formulas in the sheet.

You can use any 4 headers in the first row and sample data from rows 2-10.

I want to remove rows 2-10 and add new records from 2-10 in the same workflow.

Thanks!

binu_acs · Answer

@TdAlteryx Another option to use is the blob tool. you can find more details on the below post

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280

Blob_0907.yxzp

Christine_Assaad · Answer

Hello @TdAlteryx

In Alteryx output tool, you can write the data to specific range while keeping the format.

You will need to specify the range at the top, select Output Options: Overwrite sheet or Range as well as checking the box of preserving format, See below.

In your case you can start from A2 till D10

Hope that helps. Cheers!

Emmanuel_G · Answer

Hi @TdAlteryx ,

Can you please provide some samples to test please ?