Update a single cell dynamically while maintaining excel formatting above it

[sammyb84]

I am trying to update a Vendor name and create an output xlsx file for each vendor.  Below is a snapshot of what it should look like, and I want to create a new file for each vendor while preserving the formatting above the updated value.

I must not be using Preserve Formatting on Overwrite properly as this doesn't seem to be working for me

Trying to keep A1:J2, only update a3 value

I think the problem is while I'm specifying what to overwrite, it isn't able to use that to create a new file name and is creating sheets instead in the same file.

I would like to avoid using multiple basic tables to merge columns if possible so any workaround is greatly appreciated.

[gabrielvilella]

In order to create a new file you need to created the full path for the file on the table itself and then use the option to replace entire file path on the output tool.

[acarter881]

Hello @sammyb84. I believe you are very close. I created an Excel workbook with a single sheet named Sheet1 with the following data and format:

These were my settings. Fullpath includes the path to the Excel workbook, the sheet name, and the data range. You may have to edit accordingly, and it can be made to be more dynamic, but it should preserve the formatting.

[sammyb84]

@gabrielvilella then I get error that I need to specify a sheet name.

[gabrielvilella]

Include the sheet name on the path, example: C:\Folder\File.xlsx|||Sheet1

[sammyb84]

@acarter881 sorry for being dense here but i'm not following f2 = 3 is that being used somewhere?

You did solve for me to save down as its each file but it still is overwriting the first 2 rows that I'm trying to preserve.

Thanks for your help so far!

[gabrielvilella]

Try including the range on the full path: C:\Folder\File.xlsx|||Sheet1$A3:J3

[acarter881]

@sammyb84 No, I just did that to update the Excel workbook in some form or fashion. Perhaps you can send an example file? I may be able to preserve those rows.

[binuacs]

@sammyb84 One way of doing this with the blob tools

[sammyb84]

I've attached the file i'm using.  Need to preserve the first 2 rows.  Thank you sir!