To get Column Data from workbook by giving column name or column number as a parameter

[duvemula]

Hi @dtjohnson,

I have to verify the particular column data in workbook. I am using range() method to get the range but it seems we need to give parameters statically . Can we have getColumnData() method by passing column name or column number as a parameter ?.

Thanks, Durga Prasad

[dtjohnson]

Not sure I know what you mean. Sheet.range is heavily overloaded. You can use whatever arguments are convenient:

// All of these are equivalent ways to get the values in the range A1:B3
sheet.range("A1:B3").values();
sheet.range("A1", "B3").values();
sheet.range(sheet.cell("A1"), "B3").values();
sheet.range("A1", sheet.cell("B3")).values();
sheet.range(sheet.cell("A1"), sheet.cell("B3")).values();
sheet.range(1, 1, 3, 2).values();
sheet.range(1, "A", 3, "B").values();
sheet.range(1, 1, 3, "B").values();
sheet.range(1, "A", 3, 2).values();

[duvemula]

Hi @dtjohnson,

is there any way to click on buttons in workbook? i. e. expand/collapse buttons

Regards, Durga Prasad

[dtjohnson]

I'm guessing those buttons are calling VBA? If so, then no. That's most definitely not possible.

However, if you want to manipulate outline levels, that should be feasible but there is no support in the library at the moment.