クラシックファイルタイプは2021年1月をもって使用できなくなりました。クラシックファイルを移行することも、PDFをダウンロードすることもできます。詳細はこちら

How do I write formulas into a Sheet?

回答済み
デモをリクエスト

How can I write formulas into a WDesk sheet from a Chain?  the "Write Sheet Data" command does not seem to support anything other than data.  I want to be able to add a totals row after I imported some data into a sheet.

0

コメント

1件のコメント

日付 投票
  • Jeff Hickey

    Hi Waldo, good question. I ran some tests and I was not able to do it with the 'Write sheet data' command either. However, I was able to using the Spreadsheet API. You can use the HTTP Requests commands to use the Spreadsheet API directly. This method is more advanced, but at minimum is only two steps. The first step is to use a Post command to retrieve a bearer token. The second step is to use the Put command to write the formula to the Sheet. I successfully tested this method with the formula "=SUM(1,1)".

    0

サインインしてコメントを残してください。