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?
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 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
So then you can extract a specific cell using this kind of recording:
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.
Have you managed to extract the required cell or sheet? Are there any more questions?