community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Write a specific value to a specific cell in a specific sheet in excel

Highlighted
Alteryx
Alteryx

Hi @Dynamomo

 

I attached a solution to this, but I warn you it's a bit hack-y. The trick I used was to create 3 named ranges in the Excel file: headerCell (G9), dataCell (G10), rangeCells (G9:G10). Then, I read in the headerCell and used Dynamic Rename to make it the field name. Then, I set the data to whatever I wanted, and output the dataset to rangeCells. This left G9 intact to whatever it was previously and updated only G10.

 

There's probably a cleaner solution out there, but hope this works for you.

 

Edit: Come to think of it, the dataCell named range isn't necessary

Alteryx Certified Partner

Hi @DaveF,

While I appreciate the workaround, it doesn't work well because the fieldname does not remain intact but is written to the sheet as a text value.  so even if you read the row above into a named range and it is a number, it gets written back as text.

Are there any other options?

My client has many cells in a spreadsheet he wants to update this way.

Thanks

Make sure you checked "Skip Filed Names" on left configuration list.

Labels