4 ms·
Any reason you can’t just use TS and compile to JS?
by chatmasta 9y ago
Any reason you can’t just use TS and compile to JS?
- chaostheory 9y agoThat's not realistic unless you don't plan on maintaining the code. Even if you do have a process to constantly move compiled Javascript into Excel, let's say you lose a minute each time (which is really generous as the code grows). Assuming you make 60 changes a month, you could lose 12 hours of time per year just because TS support isn't built into Excel.
- fiatjaf 9y agoI think there's also a case for supporting every other language that compiles to JavaScript, since users of these languages will also lose 12 hours per year. Actually, every other language in the world besides JavaScript should be supported.
- sheetjs 9y agoIf you look at their example, the "type information" is actually encoded in an ancillary JSON file: https://github.com/OfficeDev/Excel-Custom-Functions/blob/master/customfunctions.json https://github.com/OfficeDev/Excel-Custom-Functions/blob/mas... In theory, you could embed all of the metadata in JSDoc + TS annotations.