GDXXRW is a flexible GAMS tool to read and write Excel files. Here is an example output sheet:
As these tables will be generated by a Web based front-end, the whole thing should run automatically and without user intervention.
Note: the warning about numbers being formatted as strings is related to set elements (years in this case) that look like numbers. This warning can be disabled with an Excel option.