I am trying to convert a large excel calculator into an online website for people to freely use.
I have been working on this project for a few months now, and the equations within the excel sheets that are used to derive the answers are too complicated for me to program it from the ground up.
Are there any easy ways to take an excel calculator (workbook with 5 sheets) and turn it into a web app? Any assistance or guidance would be appreciated.
I have also tried opening the document in python using OpenpyXL and manipulating it that way, but it doesn't work.
Web design is totally out of my area of expertise, but I told my employer I would try anyway. Again, I appreciate any assistance.
Does your work have office 365? You can host the excel file online for everyone to access. It works just like normal excel does but it is througt the online interface. Buttons and everything should work.
Math isn't hard to do with javascript and you can learn super quickly on codeacademy (it's the first thing they teach) and how to display those numbers. Including prompting users for input if you want to go that route.