Output to specific (dynamic) cells

Question

Hi

This is linked to an earlier request, but a different problem...I have this formula linked to a path to write to

"\Stage 1 - CbCR - "+[Region]+".xlsx|||'CbCR FY21 Table 1$B13:$L"+tostring(12+[Range])+"'"

Which results in various paths, with the last row count varying based on the region...

C:\Users\c06280a\CBCR Local File FY21 - General\Stage 1 - CbCR - APAC.xlsx|||'CbCR FY21 Table 1$B13:$L27'

However, when I output to Excel referencing this path I get an error message..

"Error: Output Data (86): 'CbCR FY21 Table 1$B13:$L27' is an invalid Sheet/Range specification for Excel"

Can you help me see what the issue is?

As I understand it, I need the single quotes when trying to output to a range within the sheet - I've attached a screen grab of my output config in case I am doing something wrong there too...

The alternative is to write to a separate sheet but then I am going ot have to create the formulae in the tab that i want to out put into and i wanted to avoid that if possible...

Thanks

Cass

screenshot.png

DawnDuong · Answer

Hi @ck2024

The reason why you had the earlier error was because the syntax is wrong.

as to why nothing is written, i cannot tell without knowing what your workflows looklike.

like someone has mentioned earlier in this thread, if you can upload the workflow (a sanitised version of it) someone in the community can probably help you solve the issue.

dawn

ck2024 · Answer

Hi @DawnDuong

That did the trick, although for some reason it didn't actually write anything to the file so not sure what the deal is there and there are no error messages either...any further suggestions?

apathetichell · Answer

Can you confirm that this file/sheet/range already exist (you have output data set to overwrite - not create) - and if so, can you post a screengrab of the exact error message?