Writing to a specific cell in Excel

Please help.

I'm outputting a list of information to excel. I want to add a total to a couple of column in the Excel Spreadsheet.

What I thought I would need to do is output the data and then add the Totals (or a formula) to the appropriate specific cell in the Excel spreadsheet

I've researched referencing a specific cell but what I see isn't working for me.

Example = I have a field with the file name "C:\Users\name\Documents\test.xlsx|||Sheet 1" and I "Change Entire File Path" with this field. It writes this out correctly.

But when I add the cell ref to it like this "C:\Users\name\Documents\test.xlsx|||Sheet 1$B2:B3" like I see in all the examples.....I just get another tab in the spreadsheet name "Sheet 1$B2:B3" instead of B2:B3 being updated on Sheet 1.

What do I have wrong?

Output

Accepted answers

rarmstrong

Use the formula tool to create a field with your filepath. The formula should be: "C:\Users\name\Documents\test.xlsx|||'Sheet1$B2:B3'"

In the output, select 'Take File/Table Name From Field' and select 'Change Entire File Path'. Select the new field you created with your filepath in the dropdown

All comments

rarmstrong

Use the formula tool to create a field with your filepath. The formula should be: "C:\Users\name\Documents\test.xlsx|||'Sheet1$B2:B3'"

In the output, select 'Take File/Table Name From Field' and select 'Change Entire File Path'. Select the new field you created with your filepath in the dropdown

MarshaThompson

Thanks.....my whole problem was I was missing the last single quote. I already had that configuration but that missing single quote kept causing my excel spreadsheet to corrupt. I really examined your response and saw the missing quote.

Thanks

tk123

I am trying to output to a specific cell, but the document keep throwing this exception:

If I click yes, the value is not output to the specified cell (A2 rather than A3):

Here is the actual workflow and specified properties:

Chawnan

I have same concern. Have you got a resolution?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703