/autoGetTables

自動で特定のwebサイトから表をスプレッドシートにコピペするコード．

Primary LanguageJavaScriptMIT LicenseMIT

autoGetTables

Scraping websites that publish stock prices and obtain the M.O. information.

How to use

  1. Create a new spreadsheet file in Google Drive.
  2. Select Extensions -> Google Apps Script
  3. Paste the .gs code into the Google Apps Script editor.
  4. Save the file and rename it "autoGetTables".
  5. To run the code automatically and daily, set the trigger of your choice.

Debug

If you wish to debug your code, follow these steps.

  1. Paste the .gs code into the Google Apps Script editor.
  2. After setting the function to be executed as the main function, press the "Execute" button.

Troubleshooting

If #N/A appears in cell A1 after executing the code, make sure the file name is autoGetTables.

References

https://qiita.com/ik-fib/items/6c35640954c2b04a9287
https://affikoro.com/gas-rightsheet-activate/