This is Season 1, Episode 3 of the Sisyphean conversion of workbook functions to Apps Script.
This article will cover the translation of the Sheets workbook database type functions for Apps Script. All of them will be covered.
For some general introduction on implementation see (Sheets Workbook functions – converted to Apps Script) I must admit that after many, many years of using both Excel and Sheets heavily, I’ve never had cause to use any of these functions, which are some of the less used. Before converting them, I first had to figure out what they were for and how to use them! Actually they are pretty useful in this JavaScript incarnation
This is Season 1, Episode 3 of the Sisyphean conversion of workbook functions to Apps Script.
This article will cover the translation of the Sheets workbook database type functions for Apps Script. All of them will be covered.
For some general introduction on implementation see (Sheets Workbook functions – converted to Apps Script) I must admit that after many, many years of using both Excel and Sheets heavily, I’ve never had cause to use any of these functions, which are some of the less used. Before converting them, I first had to figure out what they were for and how to use them! Actually they are pretty useful in this JavaScript incarnation
https://ramblings.mcpher.com/apps-script/sheets-functions/database/