Revision history [back]

To retrieve the number of rows in a column using Office-JS, even if the column has no data, you can use the getRowCount() method of the Excel.Range object. Here's an example code snippet:

Excel.run(function(context) {
  var sheet = context.workbook.worksheets.getItem("Sheet1");
  var column = sheet.columns.getItem("A");
  var rowCount = column.getRange().getRowCount();
  console.log("Number of rows in column A: " + rowCount);
  return context.sync();
}).catch(function(error) {
  console.log(error);
});

In this example, we first get a reference to the worksheet and the column we're interested in by using the getItem() method. Then, we get a Excel.Range object that represents the entire column by using the getRange() method. Finally, we use the getRowCount() method to retrieve the number of rows in the column, even if it has no data.

Note that the getRowCount() method returns a Excel.Range object, which represents the range of cells that contain data in the specified column. To get the actual number of rows, you can use the rowCount property of the Excel.Range object.