How can I get group size or group range in Excel with JS / VBA

See more:

Javascript

MS-Excel

group

I was writing a small tool (HTA) with Javascript for reading data from Excel, showing in an HTML table.

The Excel data may be grouped, and more than 10,000 rows.

When reading all data row by row, it will be extremely slow, so better to hide all grouped rows when "open" the file and expand when clicked. Like a tree control more or less.

While the only relative method I found is Range.OutlineLevel, still need to iterate all rows.

I wander if there is method such as Outline.Count or Outline.End to skip leaf rows.

Really appreciate for your comments.