Show HN: Turn an Excel file into a web application
So the admin lady sent me her Buy-Currency Excel file: on the first screen, she expects to see a selected list of countries and their currency, and the currency data should be populated automatically. Also, to let her concentrate on the application, I decided to show a proper area instead of showing her the whole sheet (16,384 columns and 1,048,576 rows) so the lady won’t scroll to the end of the world (sheet):
But hiding toolbar and the context menu is not enough because users can still edit cells arbitrarily. After the lady places an order for many times, she may wish to filter some rows according to the criteria, e.g. list only the EUR to USD transactions:
Even if a filter was not enabled in the Excel file, I can enable the filter programmatically through Keikai API: setAutoFilter()
The whole usage is like:
I hope she will appreciate this little arrangement I made.
Source: keikai.io