Could you please tell me how do I select some values from the entire Excel file? How do you get a specific cell, for example?

Hello, @Anil!

Of course, you can extract all the elements from a certain sheet. Itâ€™s convenient to work with the resulting array. You can do it using the entry in the â€śCalculate a valueâ€ť form:

`excel_content["Sheet 2"]`

,

where:

`excel_content`

is the name of variable where the whole Excel file is stored,

`Sheet 2`

is the name of necessary page.

Letâ€™s assume that we have saved a new sheet in the `newSheet`

variable

So then you can extract a specific cell using this kind of recording:

`newSheet[3].C`

,

where:

`3`

is the line number +1 (since the array starts from zero),

`C`

is the column number.

Tell me if thereâ€™s anything else I can tell you about this.

1 Like