2 ms·
For me the ultimate enhancement to excel would be to directly integrate some SQL dialect into the application. Assume you had a few worksheets and you want to
by bob1029 5y ago
For me the ultimate enhancement to excel would be to directly integrate some SQL dialect into the application.
Assume you had a few worksheets and you want to produce a new one based on some projection of those. You could press some hotkey "New Worksheet from Query..." and then type in the SELECT you want to use for the projection. The column headings could be optionally specified with the appropriate SQL syntax. The schema for the internal SQL dialect could be dynamically generated by inferring table name from sheet name, and column name from the first row in each. You could even have this re-evaluate in real-time, so any changes to base sheets would instantly update the projected sheets.