search

a-marenkov / gsheets

A Dart library for working with Google Sheets API.
Other
78 stars 31 forks source link

Can we write a formula in Google Sheets using this library? #63

Closed ayush-mandowara-bst closed 2 years ago

ayush-mandowara-bst commented 2 years ago

Example: Sending the =ROW in cell should print the row number in the sheet.

image

ayush-mandowara-bst commented 2 years ago

Turns out you can just send the formula and it will work as expected.

Example:

    await suiteProgressSheet.values.appendRow(
      [
        '=ROW()',
        deviceId,
        featureFile,
        scenario,
        scenarioStartTime,
        scenarioEndTime,
        result,
      ],