Libraries & code
Premium Library ID- 1uFd64_hFsTT7cD1TiL8HthnBKd8pn1G8wz6VWpXtPiX5rt97213NePwI
/**
* Fetches and parses CSV data from a given URL.
* @param {string} url The URL of the CSV file.
* @return {Array} Parsed CSV data as an array of arrays.
* @customfunction
*/
function getcsvdata(url) {
return premiumFunction.getcsvdata(url);
}
/**
* Fetches a ZIP file from a given URL, extracts a specific CSV file from it,
* and parses the CSV data.
* @param {string} url The URL of the ZIP file.
* @param {number} zipFileNumber The index of the CSV file within the ZIP (e.g., 0 for the first file).
* @return {Array} Parsed CSV data as an array of arrays.
* @customfunction
*/
function getzipcsvdata(url, zipFileNumber) {
return premiumFunction.getzipcsvdata(url, zipFileNumber);
}
/**
* Fetches data from a website table and returns it as a 2D array.
* @param {string} url The URL of the website containing the table.
* @param {number} lenthofcolumn The expected length of each row (number of columns).
* @return {Array} Parsed table data as a 2D array.
* @customfunction
*/
function getwebdata(url, lenthofcolumn) {
return premiumFunction.getwebdata(url, lenthofcolumn);
}