3 ms·
Spreadsheets traditionally don’t support iteration (loops) or recursion. In Excel you had to go the VBA route for actual programming.
by layer8 1y ago
Spreadsheets traditionally don’t support iteration (loops) or recursion. In Excel you had to go the VBA route for actual programming.
- airstrike 1y agoIn my hands they do
- johnisgood 1y agoThat is the spirit.
- accrual 1y agoIn the distant future: $ ./myapp.xlsx --port 8080 My App listening on port 8080 Loaded 1337 rows
- mryall 1y agoThe future is now with Microsoft Excel Web Services, which is part of SharePoint. https://learn.microsoft.com/en-us/sharepoint/dev/general-development/excel-services-overview https://learn.microsoft.com/en-us/sharepoint/dev/general-dev...
- aruggirello 1y agoIn other hands, I have seen Excel spreadsheet hundred-products pricelists become a freaking tangle of merged cells, multiple rows for products, spelling mistakes, multiple spaces everywhere, and price cells hand-formatted. And I had to export the contents to machine readable .csv...
- accrual 1y agoThat sounds like a nightmare to untangle. On the other hand, it would be very satisfying to go from the original pricelists to a new, cleaned format!