I am currently a senior attending college and I have a software engineering project where I must take an Excel file as input and essentially grade it according to a specified answer key file.
My problem is I can't seem to find a way to read an Excel file and look at information such as what cells are filled with info and what values are in them. In addition, I need to be able to see any formulas for any cells as well as formatting options such as text color or background color.
Is any of this possible? If so, what language(s) do I need and what software?
Any help would be greatly appreciated as I have absolutely no idea how to do this. The only thing I know I can figure out is how to compare the user's information with the answer key. The rest (e.g. how to read the formula) leaves me with a blank expression on my face.
My problem is I can't seem to find a way to read an Excel file and look at information such as what cells are filled with info and what values are in them. In addition, I need to be able to see any formulas for any cells as well as formatting options such as text color or background color.
Is any of this possible? If so, what language(s) do I need and what software?
Any help would be greatly appreciated as I have absolutely no idea how to do this. The only thing I know I can figure out is how to compare the user's information with the answer key. The rest (e.g. how to read the formula) leaves me with a blank expression on my face.
Comment