# questions

{% tabs %}
{% tab title="❓ 問題" %}
{% hint style="warning" %}
問：「如何找到 [Sheet](https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=en) 裡面第一個(最左上角)<mark style="color:yellow;">**有值的儲存格**</mark>」❓
{% endhint %}
{% endtab %}

{% tab title="📘 手冊" %}
* [Sheet](https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=en) ⟩
  * [getDataRange()](https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=en#getdatarange) - from <mark style="color:yellow;">**A1**</mark> to the last cell with value.
  * [getLastRow()](https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=en#getlastrow) - index of the last row that <mark style="color:yellow;">**has content**</mark>.
{% endtab %}
{% endtabs %}
