brizzio

JSON Puller - Google Apps Script

Transforms the data of a given Spreadsheet Sheet to JSON.

The frozen rows are taken as keys for the JSON.
The data taken for the values is only that after the frozen rows

Set up:

exportJSON(Spreadsheet) - transforms the data in the given sheet to JSON.

📅 Excel Date Picker (VBA)

Um seletor de datas simples e funcional feito 100% em VBA, sem controles ActiveX nem suplementos externos. Ao clicar (ou dar duplo-clique) em células de data, um calendário é exibido para escolher o dia. Compatível com todas as versões do Excel para Windows e Mac.

🧩 Estrutura do projeto

	class DynamicForm {
	constructor(keys, saveFunction) {
	this.keys = keys;
	this.saveFunction = saveFunction;
	}

	render() {
	const overlay = document.createElement('div');
	overlay.id = 'overlay';
	overlay.className = 'fixed inset-0 bg-gray-800 bg-opacity-75 flex justify-center items-center';


	//Explanation:
	//Constructor: Accepts an initialValue parameter to set the initial data structure (empty array or object). If the key doesn't exist in local storage, it initializes it with this value.
	//getStoredData: Returns the stored data or the initialValue if the key doesn't exist.
	//addItem, updateItem, deleteItem: Methods are updated to handle the initial data structure correctly.
	//Example usage: Demonstrates the usage of the class with both array and object initial values.

	class LocalStorageManager {
	constructor(storageKey, initialValue = {}) {
	this.storageKey = storageKey;