Integration service Specific range

Help Activities
1

Hello everyone. I would like to write a datatable in an Excel sheet using the “Write range” from the service integration. However, I would like to write this range starting from cell “A6”. Do you know how I can proceed?

image

2

A few details we cannot inspect.

In the newer versions we are usually working like this:

Synthesis.Sheet("MySheetName").Range("A6")
1 Like
3

“Synthesis” is my sheet name. Doesn’t works with your proposal.

4

Maybe you can share some more details from your modelling

When Synthesis is your Sheetname did you try appending

.Range("A6")
5

Hi @DimitriLYR ,
You can try

Excel.Sheet(“your sheet name”).Range(“A6”)

regards,

6

Yes, but i have this error message :

image

Source: write range. Message: Global object named "Synthesis.Range(“A6”) not found

7

I use service integration. Not the classic activities.

8

@DimitriLYR

Synthesis.Sheet("Sheet Name").Range("A6")
1 Like
9

Source: write range. Message: Global object named "Synthesis.Range(“A6”) not found

10

@DimitriLYR

write sheet name

11

we encountered two modes:

  • descriptive using advanced editor
  • wizard guided

currently we cannot fully derive

  • the details to Synthesis
  • the details to WorkBookFile

but know about the usage of Range(“A6”)

We would suggest to get familliar with the new approach Sheet(“XX”).Range(“A6”) syntax (e.g. explore also on newer Classic)

12

as the field is expecting a string we would also not be surprised when

"YourSheetName!A6"

would be accepted and work

However we recommend to get familar with the offered approaches / wizards from the ground

1 Like
13

it’s work with :
image

Thanks !

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.