Overview This is a script for converting strings from NFD (Normalization Form Decomposition) to NFC (Normalization Form Composition) using Google Apps Script. Description Here, I would like to introduce a script for the unicode normalization using Google Apps Script. There are the characters with ゙ which is the voiced dot and the characters with ゚ which is the semi-voiced dot in Japanese language. When these are used for some applications,
Gists When I launched Sublime Text, I noticed that the error occurred. The error is as follows. ImportError: No module named 'yaml' I confirmed that this error occurs when the plugin of Material Theme is read. And the error started to occur after Material Theme was updated, recently. In this report, I would like to introduce the method for removing this error. The flow is as follows. Download a file including library for yaml (PyYAML) from https://pypi.
RearrangeScripts was updated to v2.1.1 v2.1.1 (Match 2, 2018) Added a notification to turn on the switch for using Google Apps Script API. This was reported to issuetracker. https://issuetracker.google.com/issues/74048155 Acknowledgements: Alan Wells Add-on GitHub
Overview This is a CLI tool to retrieve data from a personal weather station of Netatmo. Description I have a personal weather station of Netatmo. I check the data of my local environment using it. In most case, I have used my browser to retrieve the data so far. About retrieving data using curl, I have created it before. Recently, I thought that I wanted to create this as a CLI too.
Gists In the case appending values to cell by inserting rows, when sheets.spreadsheets.values.append is used, the values are appended to the next empty row of the last row. If you want to append values to between cells with values by inserting row, you can achieve it using sheets.spreadsheets.batchUpdate. When you use this, please use your access token. Endpoint : POST https://sheets.googleapis.com/v4/spreadsheets/### spreadsheet ID ###:batchUpdate Request body : In this request body, it appends the data of “sample1, sample2, sample3” to “A1:A3” of the sheetId of “1234567890”.