Hey guys I have a really big question:
I want to build an application that hooks into an excel spreadsheet and can make changes to it. I know exactly what I want it to do, I just have an issue with the "how" because I am just starting out in programming - especially with databases and backend work.
There is a lot of inventory that we keep track of at my school and it changes from room to room like a gypsy sometimes. Every time we have any equipment move from one room to the next an entire ticket has to be filled out and it....really sucks to do it.
I want to be able to either scan in using a phone or type in a 6 digit serial number that's on every piece of equipment, then be able to have the program hop into the excel spread sheet and then make sure there is already pre existing data on it.
Then, if there isn't, give a table to fill out with things like "User, serial number, etc"
After data is filled out, or if there is already info, I want to be able to swap the room numbers and users that are assigned to that 6 digit number.
What programming language would be best for this kind of thing? Where would I even go for help on this one? I wish I could "just google it" but I don't even know the search terms to type in.
Any thoughts on a language to use? Is this insanely involved and will take me months to do?
Any advice would be very welcome. Thanks!