2 ms·
Is there a tool to transpile an Excel workbook to R source code? It seems like a plausible-enough thing to do. • Put all the static data first in one section,
by derefr 5y ago
Is there a tool to transpile an Excel workbook to R source code? It seems like a plausible-enough thing to do.
• Put all the static data first in one section, broken into tables with PDF’s word-boundary logic (the one that allows you to highlight text, despite it being a bunch of individually laid-out graphemes)
• reverse-postorder (topological sort) the formula cells’ definitions, grouping them into “stanzas” by which “tables” of static data they’re transitively touching.
The result would read a lot like the definition of an expert system in Prolog. Facts, then predicates.