We have the following requirements:
An Excel-document should be filled in with calculated values on the server, and sent to the client. (ASP.NET).
The user opens the document, and make adjustments/additions to the data in the Excel-document. The user then "sends" the data back to the server application. The application validates that the filled in data is correct, and stores it in SQL. If the user has filled in invalid data (such as invalid date-time format), the user should be informed about the error, and in which cell.
We have the most things working, but there are two things we still need to solve.
First of all, how should we implement "sending" the data to the server application? Since Aspose.Cells works on workbooks, one option would be to have a VBA script in the document which "SavesAs" the document to a location on the server. Through file-notifications, the server application could be made aware of that there is a new file to process.
Secondly, once the document has been transferred to the server (or a copy of the document), the server app needs a way to signal validation errors and other messages back to the user. I guess the "SaveAs"-method in VBA doesn't support sending back any error messages except Directory not found, etc. we need to different way to do this. One way we have been thinking about is to perform a web-query to the server app, after the SaveAs operation has completed. The web-query could return the error message, and other information, such as which cell contains the error.
Although both these solutions are possible (I think), they feel a little awkward. Could anyone come back with better solutions?