使用 Microsoft Graph,我可以像这样访问工作表中的所有行和列。
GET https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/worksheets/{id|name}/usedRange
这为我提供了工作表的全部数据。但我只想要像这样的总行数和总列数,
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#workbookRange",
"@odata.type": "#microsoft.graph.workbookRange",
"@odata.id": "/workbook/worksheets(%27%7B00000000-0001-0000-0000-000000000000%7D%27)/usedRange",
"address": "Sheet1!A1:CE6",
"addressLocal": "Sheet1!A1:CE6",
"columnCount": 83,
"cellCount": 498,
"rowCount": 6,
"rowIndex": 0
}
我怎样才能做到这一点?
最佳答案
您可以尝试以下 vba 脚本:
Sub TotalRows()
Dim TotalRow As Integer
TotalRow = ActiveSheet.UsedRange.Rows.Count
End Sub
https://stackoverflow.com/questions/59948070/