Okay, so I've been searching the internet for hours trying to find the solution to my problem. Many came close, but didn't describe exactly what I want to do.
I have an excel file that displays the names, locations and other information about certain servers for work. I want to query the database (easy), but I also want to be able to go in and remove, add and move information in the spreadsheet.
This would be easy to just export it as a csv file and then work with that, but many of the cells have specific formatting (fill color, bold, font size...). How should I go about this? I have Visual Studio, and am fairly well versed in C++, Python and a bit of Java.