Very slow to retrieve only 1st row

[bricemaurin]

Hi 👋
I'm trying to get the first row of each individual worksheet in a sheet.

My test file includes:

• ws 1: 2501 rows, 11 cols
• ws 2: 2446 rows, 29 cols

To load the header (1st row) of those 2 wsheets, it takes approx. 31 seconds.

Is there a method to specifically retrieve only the first row ? or ay other faster method ?

here's what i do right now:

@sheet = @session.spreadsheet_by_key(id)
@worksheets = @sheet.worksheets
data = []

@worksheets.each_with_index do |ws,i|
data << {
  title: ws.title,
  index: i,
  headers: ws.rows[0],
  num_rows: ws.num_rows,
  num_cols: ws.num_cols
}
end

Thanks in advance !